Open topic with navigation
Database Setup Dialog (Integration Builder)
Use the Database Setup dialog to set up a database connection that the Integration Service reads from when the integration is run.
If you have not previously connected to a database, you must complete the Database Setup wizard to open the Database Setup dialog. The Database Setup wizard starts when you click Database Connection Setup.
The connected database appears in the left navigation pane of the Database Setup dialog. Beneath the database name are properties that are specific to the database connection, such as tables and fields, custom Structured Query Language (SQL) statements, filter criteria, and so on. The following property pages may be available.
The Database Setup dialog toolbar is at the bottom of the left navigation pane and includes the following icons:
Opens the Database Setup wizard, which you use to create a new database connection or connect to a database by using an existing named database connection. This option is unavailable when you have already created a database connection in Integration Builder, because multiple database joins and connections are not supported. This option becomes available when you delete the current database connection.
Deletes the database connection. When you click this icon, the No Record Sets page of the Database Setup dialog appears. Click or Add a new record set to create a new database connection or to connect to a database by using an existing named database connection.
Refreshes the records that are listed in the Record Browser.
Opens the Save File dialog so that you can export the database connection configuration to an XML file. Exported files contain all the configuration information, including filters, sort order, records-per-item data, and database joins. Query prompts, named data sources, and global data fields are not exported.
Opens the Open File dialog so that you can import a saved database connection configuration file. When you use this option, existing configuration settings are replaced by the settings in the imported file. Not available for actions or other features that support only limited database connections.
For more information about how to create and use database connection configuration files, refer to