This page lists the new features or enhancements per Data Integration update.
2025.4.0
June 2025
This update introduces several enhancements to improve the reliability and usability of Drill Across and Custom Query operations. These changes are designed to reduce confusion, improve error transparency, and streamline the setup process when working with external data sources such as Sage.
Automatic column detection in Sage queries
When using Drill Across or Custom Query operations, Data Integration now automatically retrieves metadata from Sage. This means that even if column names are not specified in the query, Data Integration includes a predefined set of columns based on the Sage instance being used.
Improved handling of empty query results
If a Drill Across or Custom Query returns no data, Data Integration now returns an empty column with a blank runtime value.
Improved error messages for table mismatches
In some cases, users encountered errors when table columns were not aligned with expected configurations; for example, when the column order in a source table did not match what was required by a named set. Data Integration now detects this issue and provides a clear, user-friendly error message to help you correct the problem.
Access HTTP response headers
Integration experts can now access HTTP response headers directly with JavaScript, from within the Script agent.
Response headers provide greater control and visibility when working with external APIs, and support advanced use cases such as authentication, caching strategies, and performance monitoring.
Note: Previously, users relied on the XMLHttpRequest method to retrieve headers. As Prophix transitions to a more secure and efficient built-in HTTP service, direct access to headers was no longer available—until now. This update restores that capability, ensuring that your scripts can continue to inspect and act on header data as needed.
2025.1.0 Update
June 2025
Netsuite agent
The Netsuite agent is a script agent for retrieving General Ledger data from Oracle Netsuite.
May 2025
New Acumatica agent
The new Acumatica agent is a script agent for retrieving General Ledger data from Acumatica.
2025.1.0
March 2025
New script agents
New agents in this release are Script agents with predefined parameters and queries:
File Writer agent
File Writer is a new script agent for exporting data from a Prophix source table to other systems, through an export file.
Sage Intacct agent
The new Sage Intacct agent securely connects to your account and retrieves General Ledger data for reporting and analysis, and is able to adapt quickly to changes in the the Sage Intacct API.
Note: The existing Sage Intacct agent has been renamed Sage Intacct (Legacy) and is available for purposes of backwards compatibility; however, the new Sage Intacct agent should now be used.
Re-use existing jobs, steps, and tasks
You can now define jobs faster by copying and pasting existing jobs, steps, and tasks and editing the copies.
2024.5.0
January 2025
FC Agent
You can use the Financial Consolidation agent as a source to pull complete tables from Prophix One Financial Consolidation into any other Data Integration destination (except Power BI).
2024.4.0
December 2024
At this time Data Integration has no user-interface enhancements to report.
2024.3.1
November 2024
At this time Data Integration has no user-interface enhancements to report.
2024.3.0
October 2024
Redesigned navigation panel
The panel on the left-side has a new look:
The Information icon has moved
The icon previously located at the bottom left has moved to the top right (but functions the same as before):
2024.2.0
July 2024
Text agent can process multiple files
With a text agent, when MySQL is the destination, you now have the option to load multiple files in a single task by using wildcard notation in the file search.
2024.1.0
June 2024
Release 2024.1.0 contains resolved issues only.
2023
2023.2.2
November 2023
Release 2023.2.2 contains resolved issues only.
2023.2.1
September 2023
Move consolidated data to Prophix Cloud
Consolidated data can be moved from Financial Consolidation to the Prophix Cloud from where it is available for import into Financial Planning & Analysis (FP&A). The ability to move data around among the various applications is a key target for the Prophix Financial Platform, and it is now achieved by using Data Integration to retrieve the Consolidation data and move it to Staging DB in the Prophix Cloud from where the users of FP&A can import it.
Beginning with the 2023.3.0 Financial Consolidation release, this feature is exclusively accessible to customers who use both our Financial Consolidation and Financial Planning & Analysis (FP&A) applications.
Note: For more information, please see the Financial Consolidation help.
2023.1.0
March 2023
Jobs now have steps
- The job definition hierarchy now includes a new level: steps.
-
A step is a container for one or more tasks; the new hierarchy appears as follows:
- The main benefit of steps is that they run serially, and thus allow you to control the running order of your tasks.
- Steps also offer better control of dependencies: if a step fails, the subsequent steps are automatically canceled.
Query code editor
- A code editor now replaces the text editor In the Query tab of the following agents:
- MySQL
- ODBC
- Script
- SQL Server
2022
2022.4.0
November 2022
Microsoft Dynamics 365 Finance and Operations agent
- A source-only agent that allows users to transfer their data to any other destination.
2022.3.0
October 2022
Script agent
- Using the new Script agent, you can add Javascripts to connect and retrieve data.
- The Script agent serves ERP systems that currently do not have dedicated agents.
- The Script agent is a source-only agent.
2022.2.0
September 2022
Enhanced file transfer control
-
In a job definition, when using SFTP or AWS S3 file movers as a Source, you now have the option to automatically delete the source files after the transfer:
- When using this option with SFTP, the following additional options are available through File path:
- To delete only the contents of the folder, add a forward slash (/) to the end of the file name.
- To delete both the contents and the folder, omit the forward slash (/).
Enhanced "add" options
- In the Admin Setup and Job Definition pages, the context menus and buttons now restrict the "add" option to a peer item and a child one level below (previously all levels were available regardless of the current level). Two examples:
On the Admin Setup page, if you select an agent, now your only options are Add Agent or Add Connection:
On the Job Definitions page, if you select a task, now only the Add Task option appears:
Sage enhancements
- You can now call a custom object in Sage.
- Select a Sage connection and on its Query page, from Object select Custom; Custom Name appears.
In Custom Name type the name of the object that you want to execute:
- In queries that use the get_accountbalancesbydimensions object, the filters grid now includes the locationid parameter. This is a required parameter and is for use in multi-entity setups (for example, when your company has both a US and a European entity).