Choosing the primary connection or outer query

If you have set up multiple connections on Step 1 of the Database Integration Wizard, you must specify which connection will guide the template through data entry.

The connection you choose will provide the primary SELECT query for using the template to enter data into GainSeeker. After the template has processed the last row of the result set from this primary connection, the template will terminate or restart the data entry session.

To view the first few lines of the query result set for the selected connection, click Execute query.

Note: Use caution when testing an INSERT, UPDATE, or DELETE query. If the query can be processed without errors, it will modify the contents of the specified table. One good precaution is to back up the table contents just before testing the query.

Choosing the GainSeeker system(s)

Database Integration Wizard: Step 3