New Connection Information
When you click the browse button next to the Connection Reference field, the Adapter for Database Connection Configuration window opens. You can click New to open the New Connection Information window. To add a database connection resource, you have to specify values for the fields in the New Connection Information window.
The following table lists and describes the fields for creating a database connection resource.
Name | Description |
---|---|
Connection Resource | Name of the database connection resource. |
JDBC Driver | Name and URL of the JDBC driver used for the design-time configuration. For the list of supported JDBC drivers and their URLs, see Using Connection Settings Templates. For detailed parameter descriptions, see your JDBC driver documentation. |
JDBC URL | |
User Name | User name that the adapter uses to connect to the database. |
Password | Password that the adapter uses to connect to the database. |
Default Schema | Schema name used for the current user. Usually the schema name is the same as the database name. But for some specific databases, the schema name and the database name are different.
For example, when using a Microsoft SQL Server database, the default schema name is DBO. When using a PostgreSQL database, the default schema name is Public. When using a MySQL database, the Default Schema field must be empty. For more information about the default schema, see Default Schema. |
Test Connection | Click this button to verify whether the connection fields are specified correctly. A message is displayed to indicate whether the connection succeeds or not. |
Using Connection Settings Templates
TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) provides connection settings templates with JDBC driver information for each supported database vendor. The templates populate the JDBC Driver and JDBC URL fields with the default settings as shown in the following table, and you can replace the variables with values appropriate for your configuration.