Docs Category: Datasources
Datasources
Datasources Overview
Last Updated: March 9, 2026A Reportworq Datasource is a set of connection credentials that provide access to a data source. When a Distribution Job runs or Contribution input forms are generated, Reportworq uses Datasource credentials to retrieve fresh report data as required. Data originates from an SQL database or from a supported forecasting and reporting system that generates reports...
Anaplan
Last Updated: March 9, 2026Overview Reportworq supports the refresh of Excel-based reports created using the Anaplan Excel add-in. These reports use specifications that are embedded into hidden properties on each worksheet. Reportworq understands these report specifications and can use them to dynamically query data from Anaplan to update Excel worksheets. Reportworq refreshes data using the Anaplan REST API. Reportworq...
IBM Planning Analytics
Last Updated: March 11, 2026Datasources: Overview Reportworq supports the refresh of Excel-based reports created using the IBM Planning Analytics Perspectives and Planning Analytics for Excel (PAfE) Excel add-ins. These reports use proprietary custom Excel formulas and other Excel settings to help define how to extract data, attributes, and metadata from IBM Planning Analytics (TM1) Server instances. Reportworq reads and...
Oracle EPM Cloud
Last Updated: March 9, 2026Overview Reportworq supports the refresh of Excel-based reports that have been created using the Oracle Smart View Excel add-in using data in Oracle EPM Cloud. These reports use specifications that are embedded into hidden properties on each worksheet. Reportworq understands these report specifications and can use them to dynamically query data from Oracle EPM Cloud...
SQL Sources
Last Updated: March 9, 2026Overview Microsoft Excel supports several different types of data connections, data models, and power query modeling features. These data connections are often used to load relational database data into an Excel Table (List Object), Pivot Table, or Pivot Chart. Reportworq is not currently able to reuse these Excel-defined data connections, but Reportworq does support loading...
Workday Adaptive Planning
Last Updated: March 9, 2026Overview Reportworq supports the refresh of Excel-based reports created using the Workday Adaptive Planning OfficeConnect Excel add-in. These reports use specifications that are embedded into hidden properties on each worksheet. Reportworq understands these report specifications and can use them to dynamically query data from Workday Adaptive Planning to update Excel worksheets. Reportworq helps you automate...