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. 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.
Used for Hadoop	Configures the connection properties based on how you want to use the connection. To use the connection in a non-Hadoop plan, choose No .
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 PostgreSQL Teradata Default is MySQL.
Driver Name	Indicates the JDBC driver name to interact with the database. Default values: MySQL. com.mysql.jdbc.Driver Oracle. com.informatica.jdbc.oracle.OracleDriver Microsoft SQL Server. com.informatica.jdbc.sqlserver.SQLServerDriver DB2 for Linux, UNIX, and Windows. com.informatica.jdbc.db2.DB2Driver PostgreSQL. org.postgresql.Driver . Teradata. com.teradata.jdbc.TeraDriver .
JDBC 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> PostgreSQL: jdbc:postgresql://<hostname>:5432/<dbname> Teradata: jdbc:teradata://ServerHost/database=MyDatabaseName,tmode=ANSI,charset=UTF8
Data Access Connection String	The connection string used to access data from the database. Enter <database name>.
Environment SQL	SQL commands to set the database environment when you connect to the database. The Data Integration Service runs the connection environment SQL each time it connects to the database. Used for all operations.
Transaction SQL	SQL commands to set the database environment when you connect to the database. The Data Integration Service runs the transaction environment SQL at the beginning of each transaction. Used for all operations.
SQL Identifier Character To Use	Required. The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property. Select one of the following characters based on the database in the connection: Double quotes " " Single quotes ' ' Back quotes ` ` Brackets [ ] Used for data discovery operations.
Support Mixed Case Identifiers	When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing an SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is not selected. Used for data discovery operations.