Connections > JDBC connection properties
  

JDBC connection properties

When you set up a JDBC connection, you must configure the connection properties.
Important: JDBC Connector is deprecated and has been moved to maintenance mode. Informatica intends to drop support in a future release. Informatica recommends that you use JDBC V2 Connector to access data from a database with a JDBC type 4 driver.
The following table describes JDBC connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent, Hosted Agent, or serverless runtime environment.
JDBC Connection URL
The JDBC URL string to connect to the database.
The format of the JDBC URL is: jdbc:<subprotocol>:<subname>,
where subprotocol defines the database connectivity mechanism that one or more drivers might support. The contents and syntax of the subname depends on the subprotocol.
For information about the formatting requirements for the JDBC URL connection string, see the JDBC driver vendor specific documentation.
JDBC Jar Directory
Optional. The path to the JDBC driver jar file. For example, you can enter the following directory: C:/jdbc. When you do not specify a directory path, the Secure Agent obtains the jar file from the directory that is specified in the CLASSPATH system variable.
To use the serverless runtime environment for the JDBC connection, specify the following location: /home/cldagnt/SystemAgent/serverless/configurations/jdbc
JDBC Driver Class Name
Optional. Specify the JDBC driver class name if you are using a JDBC driver without auto class load feature. If you do not specify this property, the Secure Agent loads the driver class name from the JDBC jar file.
Schema
Schema name, which varies by database. For example,
  • - Informix. Optional. The schema name is the database name.
You must enter a schema name to fetch metadata if the JDBC connection URL does not provide enough context.
Username
User name to connect to the database.
Password
Password to connect to the database.