Database adapters

Database source adapters enable you to query a database and use the results of that query as input data. Target adapters enable you to insert or update data to a database. Connections to a particular database are generally made once for each map instance. However, if one database resource uses a rollback option and another does not, the database adapter will use a separate connection for the rollback option.

Before you specify the database to be used by the Launcher, you must first define and configure connections to the selected database. For example, before you specify the Oracle Connect String (in the Database Interface Designer) to be used by the Launcher on a computer installed with Oracle client, you must ensure that the value you provide for the Connect String matches the Oracle service name definition on that client.