Design-time Connection Tab

You must define the JDBC information and database account options on the Design-time Connection tab before you design the adapter instance. See the following figure:

Figure 59: Adapter Instance: Design-time Connection Tab

The following table lists and explains the fields on the Design-time Connection tab, many of which can be set as global variables. Click the Global Variables panel to add or modify a global variable.

Adapter Instance: Design-time Connection Tab

Field

Description

JDBC Driver

The name and URL of the JDBC driver used during design-time configuration. JDBC Drivers and URLs lists all the supported JDBC drivers and the associated URLs. For detailed parameter descriptions, see your JDBC driver documentation.

JDBC URL

User Name

The database user that the design-time adapter uses to connect to the database.

Password

The password for the database user.

Remember Password

If this check box is selected, the password will be stored in the project repository. The next time you open this project, the masked password is displayed in the Password field, and the adapter will connect to the database without the user entering the password.

If this check box is not selected, the password must be entered each time the project is opened. The password is saved in the project file as the global variable %%adb.password%%.

Use Design-time Connection For Run-time

If this check box is selected, the values you entered in the JDBC Driver, JDBC URL, User Name, and Password fields in the Design-time Connection tab are copied to the same fields in the Run-time Connection tab. These fields are disabled in the Run-time Connection tab, and you cannot modify these values.

If this check box is not selected, you can override the values in the JDBC Driver, JDBC URL, User Name, and Password fields in the Run-time Connection tab. During run time, these values can be replaced with your input values.

Test Connection

Click this button to verify the connection specified parameters.

Test Connection

Click Test Connection to verify the specified connection parameters.

If connectivity is available, a successful message dialog is displayed. See the following dialog as an example:

If connectivity is not available, an error message with details of the error is displayed. See the following figure as an example:

Using Connection Settings Templates

TIBCO ActiveMatrix Adapter for Database 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.

JDBC Drivers and URLs

Database Vendor

Supported JDBC Driver and URL

Oracle

JDBC Driver: tibcosoftwareinc.jdbc.oracle.OracleDriver

JDBC URL: jdbc:tibcosoftwareinc:oracle://server_name: 1521;databaseName=database_name

Note: When you configure the adapter to connect to an Oracle database, if you want to insert data with the TIMESTAMP with Time Zone data type to the database, configuration of the JDBC URL field affects the data type of the data to be inserted in the database:

If you set the FetchTSWTZasTimestamp=true property in the JDBC URL field, the inserted data with a certain format is parsed into the JDBC TIMESTAMP data type. You can use the adb.timestampPattern property to set a format for the data to be inserted.
If you set the FetchTSWTZasTimestamp=false property or do not add this property in the JDBC URL field, the inserted data is processed in the JDBC VARCHAR data type. Therefore, you must set the data in a format complying with the Oracle database rules before inserting. For supported data formats, see Oracle websites.

Microsoft SQL Server

JDBC Driver: tibcosoftwareinc.jdbc.sqlserver.
SQLServerDriver

JDBC URL: jdbc:tibcosoftwareinc:sqlserver://
server_name:1433;databaseName=database_name

Note: The default port number is 1433.

Sybase

JDBC Driver: tibcosoftwareinc.jdbc.sybase.SybaseDriver

JDBC URL: jdbc:tibcosoftwareinc:sybase://server_name:
5000

Note: Specify a database_name parameter (as shown in the SQL Server description) if connecting to a database that is not the default database.

DB2 OS390

JDBC Driver: tibcosoftwareinc.jdbc.db2.DB2Driver

JDBC URL: jdbc:tibcosoftwareinc:db2://server_name:port;
locationName=location_name;packageName=packageName

DB2 AS400

JDBC Drivertibcosoftwareinc.jdbc.db2.DB2Driver

JDBC URLjdbc:tibcosoftwareinc:db2://server_name:port;
locationName=location_name;AlternateID=library

Note: The publishing table cannot be created if AlternateID=library is not in JDBC URL.

DB2 UDB

JDBC Driver (DataDirect Driver): tibcosoftwareinc.jdbc.db2.DB2Driver

JDBC URL (DataDirect Driver): jdbc:tibcosoftwareinc:db2://server_name:
50000;databaseName=
database_name;packageName=DEF00

MySQL

User the following configuration for MySQL Enterprise Server:
JDBC Driver: tibcosoftwareinc.jdbc.mysql.MySQLDriver

JDBC URL: jdbc:tibcosoftwareinc:mysql://server_name:3306/

DatabaseName=database_name

Use the following configuration for MySQL Community Server:

JDBC Driver: jdbc.mysql.jdbc.Driver

JDBC URL: jdbc:mysql://server_name:3306/database_name

Use the following configuration for Amazon Aurora (MySQL):

JDBC Driver: com.mysql.jdbc.Driver

JDBC URL: jdbc:mysql://amazon server
name.rds.amazonaws.com:3306/database_name

Note: Regardless of MySQL or MySQL Community Server, if you create different services of Publication Service and configure these services to load the same source table, a java.sql.SQLException error is thrown when you save the project. This is the limitation of a MySQL database.

Teradata

JDBC Driver: com.teradata.jdbc.TeraDriver

JDBC URL: jdbc:teradata://server_name/database=database_name

PostgreSQL

JDBC Driver: org.postgresql.Driver

JDBC URL: jdbc:postgresql://server_name:port/database_name

Microsoft Azure

JDBC Driver: tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver

JDBC URL: jdbc:tibcosoftwareinc:sqlserver://server_name:1433;databaseName=database_name

Amazon RDS (Oracle)

JDBC Driver: tibcosoftwareinc.jdbc.oracle.OracleDriver

JDBC URL: jdbc:tibcosoftwareinc:oracle://amazon server name.rds.amazonaws.com:1521;databaseName=database_name

Amazon RDS (Microsoft SQL Server)

JDBC Driver: tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver

JDBC URL: jdbc:tibcosoftwareinc:sqlserver://amazon server name.rds.amazonaws.com:1433;databaseName=database_name

Amazon RDS (MySQL)

JDBC Driver: com.mysql.jdbc.Driver

JDBC URL: jdbc:mysql://amazon server name.rds.amazonaws.com:3306/database_name

To populate the fields with default values, select ActiveDatabase > Connection templates from the menu, then select your database type from the submenu. See the following figure:

Figure 60: Connection Templates

Saving Connection Settings for Reuse

After you have customized the connection settings for your configuration, you can save them for use in another adapter. You can save as many sets of customized connection parameters if you want. The parameter sets can include the user name and password.

To save a set of connection parameters, perform the following steps:

Procedure 

1. Fill in the connection parameters for the adapter.
2. Click ActiveDatabase > Save Connection Settings from the Menu, and the Input dialog is displayed.

Figure 61: Input Dialog

3. Type a name and click OK. The Connection Settings Manager dialog is displayed.
4. Click either Yes or No:
Yes saves the password in the parameter set. (If the Password field is empty, no password is saved.) When the user selects the parameter set, the Password field will be populated with the current password in masked text, even if the password is not saved in the project file or if it has been obfuscated in the project file.
No does not save the current password in the parameter set. The user will have to enter it manually.

Using Saved Connection Parameters

To use a saved set of connection parameters, click ActiveDatabase > User connections from the Menu, and then select a parameter set from the submenu.

Figure 62: Use a Saved Set of Connection Parameters

The fields on the Configuration and Design-time Connection tabs are populated with the values stored in the parameter set.