4.6 Setting a Run-Time Database Connection

The database information set for the run-time adapter could be different from the database schema used to create this adapter definition. Because the Data Integrator tool is a development tool, it is likely that a development database is used to set up all definitions for the adapter. But, for run-time adapters, point users to a production database (of the same database type with the same set of tables). Specify database settings as visible or hidden to the user.

The Data Integrator never writes to the database. It sets a read-only JDBC connection and performs SQL select statements.

WARNING:The run-time database must be the same type and have the same schema as the development data source.

To set up run-time database information:

  1. Select the root element in the Definition Navigator pane.

    If the adapter was just created, it is already selected.

  2. Click the Database icon:

  3. Define database values for the deployed adapter at run-time:

    Hostname: The database server name.

    Port: The port number where the database listens for communications.

    Database: The database name (when defining a SQL Server, Sybase, or DB2 database connection).

    Server ID: The database name (when defining an Oracle database connection).

    User Name: The name of the user account.

    Password: The password associated with the user name.

    Windows Domain: The name of the Windows domain to use for Windows native authentication. Applies to JTDS and SQL Server connections only.

    Database Type: The type of database (Oracle, SQL Server, Sybase, and so on).