Skip to main content
Ask ChatGPT

Overview Of External Reporting Tools

Using External Reporting Tools​

Many Aprimo customers use external reporting tools like Crystal Reports, Business Objects, Power BI, Tableau, SSRS, and Cognos to analyze Aprimo data.

Approaches to External Reporting​

  1. Reporting API

    • The Reporting API exposes Aprimo report data via a web service, which can be consumed by external tools.
    • Some tools (e.g., Crystal Reports, Power BI) can connect directly to the API.
    • Others (e.g., Tableau) may require data transformation through an adapter (not provided by Aprimo).
      • Example: Tableau requires a Web Data Connector using its JavaScript library before the data can be consumed in Tableau Desktop.
    • For detailed guidance, refer to the Reporting API article.

  2. Report Distribution

    • Schedule regular exports of Aprimo report data to an SFTP site.
    • Retrieve the data files from the SFTP site, load them into your database or data warehouse, and report on them using your chosen tool.
    • This method is especially useful for combining Aprimo data with data from other sources.

These approaches allow you to integrate Aprimo data seamlessly into your external reporting workflows.