JDBC Connector Guide > JDBC Connections > JDBC Connection Properties
  

JDBC Connection Properties

When you set up a JDBC connection, you must configure the connection properties.
The following table describes JDBC connection properties:
Connection Property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
JDBC Connection URL
URL schema for the database. Use the corresponding schema for the following databases:
  • - Microsoft SQL Server. jdbc:sqlserver://<Host>\<Instance>:<Port>;databaseName=<Database>
  • - MySQL. jdbc:mysql://<Host>:<Port>/<Database>
  • - Oracle. jdbc:oracle:thin:@//<Host>:<Port>/<Service>
  • - PostgreSQL. jdbc:postgresql://<Host>:<Port>/<Database>
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.
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. Use the following guidelines for the schema name:
  • - Microsoft SQL Server. Use the schema name to specify the correct object.
  • - MySQL. Optional. The schema name is the database name.
  • - Oracle. Optional. The schema name is the user name.
  • - PostgreSQL. Use the schema name to specify the correct object.
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.