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.

Note: When you use a MySQL database, if you enter a name for the default schema, a publishing table cannot be created for Publication Service.

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.

Database JDBC Driver JDBC URL
Oracle tibcosoftwareinc.jdbc.oracle.OracleDriver jdbc:tibcosoftwareinc:oracle://server_name: 1521;databaseName=database_name
Note: The default port number is 1521.

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, configuration of the JDBC URL field affects the data type of the data to be inserted:

  • 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 tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver jdbc:tibcosoftwareinc:sqlserver://server_name:1433;databaseName=database_name
Note: The default port number is 1433.
Sybase tibcosoftwareinc.jdbc.sybase.SybaseDriver jdbc:tibcosoftwareinc:sybase://server_name: 5000;DatabaseName=database_name
DB2 OS390 tibcosoftwareinc.jdbc.db2.DB2Driver jdbc:tibcosoftwareinc:db2://server_name:port;

locationName=location_name;packageName=packageName

DB2 AS400 tibcosoftwareinc.jdbc.db2.DB2Driver jdbc:tibcosoftwareinc:db2://server_name:port;locationName=location_name;AlternateID=library
Note: The publishing table cannot be created if the AlternateID=library property is not in the JDBC URL.
DB2 UDB tibcosoftwareinc.jdbc.db2.DB2Driver jdbc:tibcosoftwareinc:db2://server_name:50000;databaseName=database_name;packageName=DEF00
MySQL tibcosoftwareinc.jdbc.mysql.MySQLDriver jdbc:tibcosoftwareinc:mysql://server_name:3306/DatabaseName=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 a limitation of the MySQL database.
Teradata com.teradata.jdbc.TeraDriver jdbc:teradata://server_name/database=database_name
PostgreSQL org.postgresql.Driver jdbc:postgresql://server_name:port/database_name
Microsoft Azure tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver jdbc:tibcosoftwareinc:sqlserver://server_name:1433;databaseName=database_name
Redshift org.postgresql.Driver jdbc:postgresql://server_name:port/database_name
Amazon RDS (Oracle) tibcosoftwareinc.jdbc.oracle.OracleDriver jdbc:tibcosoftwareinc:oracle://amazon_server_name.rds.amazonaws.com:1521;databaseName=database_name
Amazon RDS (Microsoft SQL Server) tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver jdbc:tibcosoftwareinc:sqlserver://amazon_server_name.rds.amazonaws.com:1433;databaseName=database_name
Amazon RDS (MYSQL) com.mysql.jdbc.Driver jdbc:mysql://amazon_server_name.rds.amazonaws.com:3306/database_name