Configuration Tab
You can use the Configuration tab to specify the general information and crucial options for an adapter configuration. The information is grouped in panels, including Adapter for Database Configuration, Database Configuration, and Getting Started.
Adapter for Database Configuration Panel
In the Adapter for Database Configuration panel, you can specify the general information, including the name and description, for an adapter configuration.
The following table lists the general information of an adapter configuration.
| Name | Description |
|---|---|
| Adapter Name | Type of the adapter configuration. The default value is ADBAdapter. |
| Instance Id | Name of an adapter configuration.
For more information, see Guidelines for Choosing an Instance ID. |
| Description | (Optional) Description of the adapter configuration. |
| Message Filter | Not used. |
Database Configuration Panel
In the Database Configuration panel, you can set a database connection.
The following table lists the fields and check boxes for the configuration.
| Name | Description |
|---|---|
| Vendor | You can select a database vendor to which the adapter connects. In the Vendor list, vendor names enclosed in parenthesis, such as (Informix) and (INGRES), are not supported. |
| DB2 AS400 Library | This field is displayed if DB2 AS400 is selected in the Vendor list. A DB2 AS400 library name is required. The default library name is the same as the AlternateID specified in the JDBC URL field in the Adapter for Database Connection Configuration panel. Other database libraries are also supported. |
| Convert Number Datatype to String | This check box is displayed if Oracle is selected in the Vendor list. If this option is selected, the adapter uses the String data type to represent the Number data type at run time. |
| Write to Database on Save | You can use this check box if you want to write configuration information to the database when you save a project.
By default, this check box is selected. |
| Connection Reference | Specifies a database connection resource to be used by the adapter configuration.
To specify a database connection reference, click the browse button next to the Connection Reference field and select a reference from the displayed connection configuration list. If the list does not include the database connection reference you want to use, click New to open the New Connection Information window and add one. For details about how to add a connection, see Adding a Database Connection. For details about the fields in the New Connection Information window, see New Connection Information. |
| Link Connection To Schema Browser | Click this link, and a new destination is created in the
Schema Browser view. The name and database connection information of the new destination is the same as the specified connection reference.
The generated connection name in the Schema Browser view is the same as the configuration file name. |
Getting Started Panel
The Getting Started panel lists the Configure Adapter Services link. Click this link, and you are directed to the Adapter Services tab. For details, see Adapter Service Reference.