Specifying connection information

This section describes the connection parameters that must be specified for a SQL Query node.
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.

Verifying external .jar files

Before you begin working with the SQL Query activity node for the first time, make sure the appropriate .jar files from your JDBC vendor are on your classpath.

Specifying the configuration to connect to JDBC

  1. Place the SQL Query node on the designer window and select it. You will be on the General tab.

  2. Select the "Configuration name" from the dropdown list.

    When you select this option, you are using a pre-specified configuration, either a custom connection that was specified at your site, or a configuration that was delivered by Lawson. If you need more information about configuration sets, contact your system administrator.

    Or

    Select "Override connection" and make selections for the JDBC connection.

    Information about how to specify connections is in another section.