Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Dictionaries
  9. User-Defined Datatypes

JDBC Connections

JDBC Connections

Create a JDBC connection to perform TDM operations if the target ODBC connection requires a JDBC connection string.
For example, to create a connection for a MySQL database, you use the ODBC connection type. If you use the connection as a target in a plan in which you disable the indexes and constraints, you must enter a target JDBC connection. You enter a target JDBC connection in the
Target JDBC Connection
field in the plan to provide a JDBC connection string.
Use the JDBC connection type to create a MySQL database connection to use as the target JDBC connection. You cannot use a JDBC connection type as a source or target connection in a plan.
The following table describes the database connection properties for a JDBC database:
Property
Description
Name
Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
Connection Type
Required. The connection type. Select JDBC.
Description
The description of the connection. The description cannot exceed 255 characters.
User Name
Required. The database user name.
Password
Required. The password for the database user name.
Owner
The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.
Metadata Connection String
Required. The JDBC connection URL used to access metadata from the database. Enter the correct connection string for the database:
  • MySQL: jdbc:mysql://<hostname>:<port>/<dbname>
  • Oracle: jdbc:informatica:oracle://<hostname>:<port>;SID=<sid>
  • Microsoft SQL Server: jdbc:informatica:sqlserver://<hostname>:1433;SelectMethod=cursor;databaseName=<dbname>
  • DB2 for Linux, UNIX, and Windows: jdbc:informatica:db2://<hostname>:50000;databaseName=<dbname>
  • Sybase: jdbc:informatica:sybase://<hostname>:5000;DatabaseName=<databasename>
  • Teradata: jdbc:teradata://ServerHost/database=MyDatabaseName,tmode=ANSI,charset=UTF8
Database Type
Required. The type of database to which JDBC connects. The options are:
  • MySQL
  • Oracle
  • Microsoft SQL Server
  • DB2 for Linux, UNIX, and Windows
  • Sybase
  • Teradata
Default is MySQL.
Data Access Connection String
The connection string used to access data from the database. Enter <database name>.