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:

~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /

Required. The connection type. Select JDBC.

The description of the connection. The description cannot exceed 255 characters.

Required. The database user name.

Required. The password for the database user name.

The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.

Configures the connection properties based on how you want to use the connection. To use the connection in a Hadoop plan, choose

Yes

.

Indicates the JDBC driver name to interact with the database.

Required. The JDBC connection URL used to access metadata from the database. Enter the appropriate connection string for the database:

DB2 for Linux, UNIX, and Windows:
jdbc:informatica:db2://<hostname>:<port number>/<dbname>
MySQL:
jdbc:informatic​a:sqlserver://<hostname>:<port number>;SelectMeth​od=cursor;<dbname>
Oracle:
jdbc:informatica:oracle://<hostname>:<port number>/<dbname>
Sybase:
jdbc:informatica:sybase://<hostname>:<port number>/<dbname>

Select the version of Sqoop Connector that you want to use to connect to the database.

Enabled when you choose to use Sqoop Connector. Enter the appropriate Sqoop arguments that you want to use to connect to the database and process data:

DB2 for Linux, UNIX, and Windows:
--connect jdbc:db2://<hostname>:<port number>/<dbname> --verbose
MySQL:
--connect jdbc:sqlserver://<hostname>:<port number>/<dbname> --verbose
Oracle:
--connect jdbc:oracle:thin:@<hostname>:<port number>/<dbname> --verbose
Sybase:
--connect jdbc:sybase:Tds:<hostname>:<port number>/<dbname> --verbose

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.

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.

Required. The type of character used to identify special characters and reserved SQL keywords, such as WHERE.

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.