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. Refer to KB3522595 for details.

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.