Maximize other tools when extracting from a database to a file
Using an IPA process to extract records from a database to a file is very
common. Most designer processes would use a SQL query node, then a Message Builder node, then
a File Access node. This configuration is acceptable however, you can use other tools to
maximize the performance of IPA.
Note: Starting with the
2024.10 release, the SQL Query activity node will be deprecated and removed from the Infor
Process Designer (IPD) tool, Infor Process Designer for the Web (IPD Web), and runtime
server. Additionally, this node is no longer supported in multi-tenant environments and will
be removed on a later date. See KB3522595.
For example, you can use the source application's built-in export tools that export to a CSV or XML file, which is much faster than making web call. You can also use SQL tools such as stored procedures and SQL Command (SQLCMD) as other options to export data in bulk very quickly. Another example would be to use SQL language techniques to extract full rows of data as one record, which can be stored as one variable (instead of several) in IPA.