6.7 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

To use a JDBC driver that is not bundled with Veridata product, refer to the Veridata 23c Certification Matrix. Open the Veridata Drivers tab, download the certified version of JDBC driver and add to this location.

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.7.1 IBM Db2 for i

Db2 i sample database connection URL

LocationName is usually the i server name.

database.url=jdbc:veridata:db2://DB2HOST:446;LocationName=<DATABASE_NAME>
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

Parent topic: Agent Parameters - Connections

6.7.2 IBM Db2 for LUW

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.7.3 IBM Db2 for z/OS

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.7.4 Apache 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.7.5 MariaDB

MariaDB sample JDBC URL with SSL

database.url=jdbc:mariadb://localhost:3306/
database?sslMode=verify-full&serverSslCert=/path/to/cert.pem
server.jdbcDriver=mariadb-java-client-3.5.2.jar

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.7.6 Microsoft SQL Server

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.7.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.7.8 Oracle Database

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.9.0.25.07.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:@FREE
server.jdbcDriver=ojdbc11-23.9.0.25.07.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-ojdbc11-23.9.0.25.07.jar

Parent topic: Agent Parameters - Connections

6.7.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.7.10 Snowflake

Prerequisite to start the Snowflake agent

Add the following line in $VERIDATA_HOME/agent/agent_int.sh: 
JAVA_OPTS="$JAVA_OPTS --add-opens=java.base/java.nio=snowflake.jdbc,ALL-UNNAMED

Add this right after the other JAVA_OPTS inside the file.

Snowflake database connection URL

database.url=jdbc:snowflake://hostname?db=db_name&warehouse=sf_basic_dt_wh&role=accountadmin
server.jdbcDriver=snowflake-jdbc-3.22.0.jar

Parent topic: Agent Parameters - Connections

6.7.11 Sybase Adaptive Server Enterprise

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.7.12 Teradata Vantage

Teradata database connection URL

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

Parent topic: Agent Parameters - Connections