6.6 Agent Parameters - Connections

Note:

For all the connections, the downloaded Driver can be added to the default location: server.driversLocation=$ORACLE_HOME/agent/drivers

Or to a custom location that you have to specify in agent.properties. Example:

server.driversLocation=/custom/driver/directory

This information is also available in the agent.properties.sample. 

# The server.driversLocation property is the directory # containing the JDBC driver jar file(s). The JDBC drivers # included with the Veridata agent will be retrieved from the # standard locations. # The path is relative to the Veridata agent # deployment directory. OR An absolute path to the directory containing # drivers can be specified. server.driversLocation=/scratch/nextgen/vdt23c/agent/drivers

Parent topic: Administer

6.6.1 DB2iseries

DB2 i sample database connection URL

LocationName is usually the i server name.

database.url=jdbc:veridata:db2://DB2HOST:446;LocationName=DB2HOST server.jdbcDriver=vddb2-5.1.4.jar

Settings for using the JTOpen driver for DB2 i

database.url=jdbc:as400:DB2HOST server.jdbcDriver=jt400Native.jar
Settings for using the IBM Native driver for DB2 i
database.url=jdbc:db2i:DB2HOST:portNumber=446;preFetch=true server.jdbcDriver=db2_classes.jar

Parent topic: Agent Parameters - Connections

6.6.2 DB2luw

DB2 LUW sample database connection URL

database.url=jdbc:veridata:db2://localhost:50000;DatabaseName=sample server.jdbcDriver=vddb2-5.1.4.jar

Parent topic: Agent Parameters - Connections

6.6.3 DB2zos

DB2 z/OS sample database connection URL

database.url=jdbc:veridata:db2://localhost:447;LocationName=DB2 server.jdbcDriver=vddb2-5.1.4.jar

Parent topic: Agent Parameters - Connections

6.6.4 Hive

Hive sample database connection URL for Apache Hive2 JDBC Driver

database.url=jdbc:hive2://localhost:10000 server.jdbcDriver=hive-jdbc-3.1.2-standalone.jar

Parent topic: Agent Parameters - Connections

6.6.5 MariaDB

MariaDB sample JDBC URL with SSL

database.url=jdbc:mariadb://localhost:3306/ database?sslMode=verify-full&serverSslCert=/path/to/cert.pem

MariaDB sample JDBC URL without SSL

database.url=jdbc:mariadb://localhost:3306/database server.jdbcDriver=mariadb-java-client-3.5.2.jar

You can download the Driver from https://mariadb.com/kb/en/installing-mariadb-connectorj/.

Parent topic: Agent Parameters - Connections

6.6.6 MSSQL

SQL Server sample database connection URL for SSL/TLS

database.url=jdbc:sqlserver://localhost:1443;databaseName=<dbName>;encrypt=false;trustServerCertificate=false; server.jdbcDriver=mssql-jdbc-11.2.0.jre17.jar

SQL Server database connection URL 

database.url=jdbc:veridata:sqlserver://localhost:1433 server.jdbcDriver=vdsqlserver-6.0.0.jar

Parent topic: Agent Parameters - Connections

6.6.7 MySQL

MySQL sample database connection URL

database.url=jdbc:mysql://localhost:3306/<db_name>?serverTimezone=UTC& zeroDateTimeBehavior=CONVERT_TO_NULL&sessionVariables=sql_mode='PAD_CHAR_TO_FULL_LENGTH' server.jdbcDriver=mysql-connector-j-8.3.0.jar

MySQL sample JDBC URL for MySQL Server Authentication via server certificate

(For MySQL version 8.0.12 and earlier):

database.url=jdbc:mysql://localhost:3306?useSSL=true&verifyServerCertificate=true server.jdbcDriver=mysql-connector-j-8.3.0.jar

For MySQL version 8.0.13 and later:

database.url=jdbc:mysql://localhost:3306?sslMode=<VERIFY_CA or VERIFY_IDENTITY> server.jdbcDriver=mysql-connector-j-8.3.0.jar

Parent topic: Agent Parameters - Connections

6.6.8 Oracle

Oracle sample database connection URL

database.url=jdbc:oracle:thin:@localhost:1521:orcl database.url=jdbc:oracle:thin:@localhost:1521/PDB_service_name server.jdbcDriver=ojdbc11-23.2.0.0.jar

Oracle OCI bequeath database connection URL

The OCI libraries must be available and the JDBC driver must match the OCI libraries. 

database.url=jdbc:oracle:oci:@ server.jdbcDriver=ojdbc11-23.2.0.0.jar

Oracle sample database connection URL for SSL/TLS

database.url=jdbc:oracle:thin:@tcps://<host>:<port>/<service name>?wallet_location=<wallet directory path> database.url=jdbc:oracle:thin:@tcps://localhost:2484/service_name?wallet_location=/path/WALLET server.jdbcDriver=ojdbc11-23.2.0.0.jar

Parent topic: Agent Parameters - Connections

6.6.9 PostgreSQL

Postgresql sample database connection URL for native driver

database.url=jdbc:postgresql://localhost:5432/target server.jdbcDriver=postgresql-42.7.4.jar

Postgresql sample database connection URL for SSL/TLS 

database.url=jdbc:postgresql://<host>:5432/postgres?sslmode=verify-ca&sslrootcert=<crt_path>/<crt_filename> server.jdbcDriver=postgresql-42.7.4.jar

Parent topic: Agent Parameters - Connections

6.6.10 Sybase

Sybase database connection URL

JDBCBehavior=0 is required to repair Sybase UNITEXT columns. 

database.url=jdbc:veridata:sybase://localhost:5000;ApplicationName=VeriAgent;MaxPooledStatements=20; JDBCBehavior=0 server.jdbcDriver=vdsybase-5.1.4.jar

Parent topic: Agent Parameters - Connections

6.6.11 Teradata

Teradata database connection URL

database.url=jdbc:teradata://localhost/DBS_PORT=1025,CHARSET=UTF8 server.jdbcDriver=terajdbc4.jar

Parent topic: Agent Parameters - Connections