Data can be retrieved from other systems via database or web service connections.  

To configure a new database connection, navigate to the Integration > Connections page and select Actions > Create. 

A pop-up window is displayed for configuration. Provide a connection name. Provide the database connection string with the attributes as seen here. Click the “Test” button to validate the connection information. Click the “Create” button to create this new database connection. 

Alternatively, use the connection string builder to generate it. Select the SQL Server or Windows authentication method. Enter the connection name, SQL Server name, database name, SQL user ID, and password. Click the Test button to validate the connection information. Click the Generate button to copy and paste this information as a connection string in the text below.  

The new connection is listed in the table below on the Manage Database Connection page. 

Navigate to the Form > Definitions page. Click Actions > Create. Enter a name for the new form definition. Click the “Create” button to open the form designer page. 

Drag a few Textbox controls and the Lookup control onto the designer canvas. 

Double-click the Lookup control to open the Settings tab. Provide a name for the control.

Double-click the Lookup control to open the Conditions tab. Select the DB connection from the drop-down list. Enter the SQL SELECT query. As shown below, map SQL columns to form fields. Click the “Save” button to confirm the changes. 

Scroll down in the dialog, then map the database to the form fields. Let’s save the form and navigate to the form instances tab. Select the Form Instance, then click the “Edit” button to modify the form design.  

The form instance should render as shown below. 

Click the “Lookup” button to open the pop-up window displaying the result set from the SQL query. Select a row from the table, then click the “OK” button. 

The values of the selected row are mapped to the form fields below.