Docs Category: Datasources
Datasources
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...
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...
IBM Planning Analytics
Last Updated: March 9, 2026Report Providers: Overview The IBM Planning Analytics Report Provider enables users to select source reports from the Application Folders section of any available Planning Analytics connection. Configuration To add an IBM Planning Analytics Report Provider to the list of available providers, ReportWORQ administrators open the Administration screen then click the ‘+’ button beside Report Providers,...
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...