JDBC Data Source Configuration

Select the appropriate values or enter the appropriate configuration data to create a CIC data source for a JDBC compliant data repository.

Subtype

This is a JDBC data source. Subtype is one of the listed ODBC compliant relational databases, or another database that can be accessed by a JDBC driver. The default setting is "DB2 Family", and other options are "Informix", "Ingres", "Oracle", "MS Access", "MS SQL Server", "Sybase", and "Other".

Read Only

Select this check box if CIC client users cannot update this data source. Clear the check box if CIC client users will be able to add, modify, or delete entries in this data source.

User ID

Type a user ID if one is required to connect to the data source.

The user ID is determined by the administrator and the database tool used to create the data source.

Password

Type a password if one is required to connect to the data source.

The password is determined by the administrator and the database tool used to create the data.

Qualifier

If one is required, type the table qualifier used to access the tables in this data source. The qualifier may be the owner or creator of the table, or it may be the path to the table, depending on the database.

Driver

Type the name of the JDBC driver (you may have to ask the vendor for your driver name).

URL

Type the URL used to connect to this JDBC data source. This uses the Qualifier entered above, if any.

Additional Information

Some CIC data sources may need to specify additional information or need a way to temporarily override the default behavior. Values in this field could include the Catalog= and Schema= statements, as illustrated in the IC Report Logs CIC data source.

For example:

DATABASE=i3_eic;SERVER=(local)