Skip to main content
Delphix

Masking Connectors - JDBC Drivers and JDBC Syntax (KBA5558)

  1. Last updated
  2. Save as PDF
 

 

KBA

KBA# 5558

At a Glance

Summary: This page provides the JDBC drivers and driver settings used on the Continuous Compliance Engine.  
JDBC driver details:  From version 6.0.1, all driver details are visible in the Continuous Compliance Engine UI: 
  • UI: Home > Settings > JDBC Drivers
  • API: jdbcDriver
Extensible Connectors: From version 6.0.1, it is possible to load custom drivers (called Extensible Connectors/Extended Drivers).
  • UI: Home > Settings > JDBC Drivers
  • API: jdbcDriver
Connection Properties: From 6.0.6, it is possible to pass Custom Connection Properties in the Basic Connector. 
  • UI: Home > Environments > Connector
  • API: database-connector
Support note: The functionality of Extended Drivers is not supported by Delphix Support. Issues with the tools should be directed to the respective channel. 

Should there be an error on the Continuous Compliance Engine related to a bug - this should be raised with support. 

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0

6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0, 6.0.16.0, 6.0.17.0, 6.0.17.1, 6.0.17.2

5.3

 5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

From version 6.0.6 and later

From version 6.0.6, all Basic connectors can have Custom Properties uploaded. This can be done through the UI and the API.

For more information, see the following page in the Continuous Compliance Engine documentation: 

From version 6.0.1 and later

From version 6.0.1, all drivers and their versions can be accessed from the Continuous Compliance Engine UI and the API.

Drivers are updated frequently. 

List of Standard Drivers

For a current listing go to: Home > Settings > JDBC Drivers.

Note

Note:

It is not possible to modify a standard driver. Edit will only view related details. 

Masking UI - KBA5558 - JDBC Drivers.png

Extended Drivers

From version 6.0.1, it is also possible to upload custom drivers. These are referred to as Extended Drivers. 

For more information, see the following page in the Continuous Compliance Engine documentation: 

Older versions

Older versions (pre 5.3.9 and older) of the Continuous Compliance Engine, referred to as the Masking Engine, had the following drivers:

Database Driver Version
DB2 (IBM Data Server Driver)  com.ibm.db2.jcc.DB2Driver 4.18.60
DB2 (JTOpen)  com.ibm.as400.access.AS400JDBCDriver 9.0
MS SQL Server net.sourceforge.jtds.jdbc.Driver 1.3.1
MS SQL Server (alt) com.microsoft.sqlserver.jdbc.SQLServerDriver 6.2.1
MySQL org.mariadb.jdbc.Driver 2.2.0
MariaDB org.mariadb.jdbc.Driver 2.2.0
Oracle oracle.jdbc.driver.OracleDriver 12.1.0.2.0
SAP ASE (Sybase) com.sybase.jdbc4.jdbc.SybDriver 7.4.4
PostgreSQL org.postgresql.Driver 42.2.5

Drivers and Syntax

The driver details and syntax are only needed if the JDBC string needs to be specified in an Advanced or Extended Connector.

In these cases, consider the following points: 

  • These details are not required if the Basic Standard Connector is used. 
  • When using an Advanced or Extended Connector, some Continuous Compliance Engine features might not be available.
  • Advanced or Extended Connectors do not work with Masked vDBs.
  • The list below is from version 6.0.0.

For more details:  Database Connector Features and Support Page.

DB2 Drivers 

On older versions of the Masking Engine, there were two different DB2 drivers. 

  • IBM Data Server and JTOpen. 
  • Default port: 50000 or 50001.
    In some configurations the port number may not be required. 
IBM Data Server driver

JDBC Driver Name

com.ibm.db2.jcc.DB2Driver

JDBC URL Syntax

jdbc:db2://host[:50001][/schema][:name=value[;name=value ...]]

JDBC JAR files

db2jcc.jar
db2jcc4.jar

https://www.ibm.com/support/knowledgecenter/SSCRJT_5.0.0/com.ibm.swg.im.infosphere.biginsights.admin.doc/doc/bsql_jdbc.html

Example:

jdbc:db2://<host ip>:<port>/<dbname>

Example of Property parameters known to have been used with Masking (name=value):

  • For details, search IBM Support documentation "IBM Data Server Driver for JDBC and SQLJ properties for Db2".
db2.jcc.sendCharInputsUTF8=true
retrieveMessagesFromServerOnGetMessage=true
emulateParameterMetaDataForZCalls=1
securityMechanism=4
translate binary=true
ccsid=870
useJDBC4ColumnNameAndLabelSemantics=2

traceDirectory=/path/
traceFile=jcctrace.log
traceFileCount=5
traceFileSize=20971520
traceLevel=-1
JTOpen driver

JDBC Driver Name

com.ibm.as400.access.AS400JDBCDriver

JDBC URL Syntax

jdbc:as400://hostname/default-schema

JDBC JAR files

jt400.jar

https://www.ibm.com/support/pages/using-jdbc-connector-connect-db2-iseries-as400 

Example:

jdbc:as400://<host ip>
jdbc:as400://<host ip>/<dbname>

Example of Property parameters known to have been used with Masking (name=value):

naming=SYSTEM
access=all
date format=iso
libraries=DELPHIX
block size=512
package cache=true
trace=true

Oracle

Default port: 1521

JDBC Driver Name

oracle.jdbc.OracleDriver

JDBC URL Syntax

jdbc:oracle:thin:@(description=(address=(host=<hostname/IP_addr>)(protocol=tcp)(port=<port>))(connect_data=(sid=<ORACLE_SID>)))

Short version:

jdbc:oracle:thin:@<hostname/IP_addr>:<port>:<ORACLE_SID>
jdbc:oracle:thin:@<hostname/IP_addr>:<port>/<service_name>

JDBC JAR files

ojdbc8-19.3.0.0.jar

Examples:

jdbc:oracle:thin:@<host ip>:<port>:<SID>
jdbc:oracle:thin:@<host ip>:<port>/<service>

 

MS SQL Server

SQLServerDriver

Default port: 1433

JDBC Driver Name

com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL Syntax

jdbc:sqlserver://serverName\instanceName:portNumber][;property=value[;property=value]

JDBC JAR files

mssql-jdbc-6.2.1.jre8.jar

Example:

jdbc:sqlserver://<host ip>;databaseName=<dbname>;
jdbc:sqlserver://<host ip>:<port>;databaseName=<dbname>
jdbc:sqlserver://<host ip>\InstanceName;

Example of Property parameters known to have been used with Masking (name=value):

trustServerCertificate=true
trustServerCertificate=false
trustStore=storeName
trustStorePassword=storePassword
hostNameInCertificate=hostName
encrypt=true
integratedSecurity=true
domain=DOMAIN.com
authenticationScheme=NTLM
jTDS (MS SQL Server - old driver)

Default port: 1433

JDBC Driver Name

net.sourceforge.jtds.jdbc.Driver

JDBC URL Syntax

jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

JDBC JAR files

jtds-1.3.1.jar

SAP ASE (Sybase)

Default port: 5000

JDBC Driver Name

com.sybase.jdbc4.jdbc.SybDriver

JDBC URL Syntax

jdbc:sybase:Tds:<ASE_HOST_OR_IP>:<ASE_LISTENER_PORT>/<DATABASE_NAME>[?<connection_property>=<value>[&...]]

JDBC JAR files

jconn4.jar

Example:

jdbc:sybase:Tds:<host ip>:<port>/<dbname>

Example of Property parameters known to have been used with Masking (name=value):

DYNAMIC_PREPARE=true
PACKETSIZE=512
PACKETSIZE=4096
HOMOGENEOUS_BATCH=false
ENCRYPT_PASSWORD=true
charset=utf8
charset=Roman8
CHARSET=cp850
CHARSET=iso_1
RETRY_WITH_NO_ENCRYPTION=true
PROTOCOL_CAPTURE=delphix_tds

Postgres

Default port: 5432

JDBC Driver Name

org.postgresql.Driver

JDBC URL Syntax

jdbc:postgresql:[//host[:port]/][database][?property1=value1[&property2=value2]...]

JDBC JAR files

postgresql-42.2.5.jar

https://github.com/pgjdbc/pgjdbc

 

 

Privacy Policy Terms of Use Legal About
© 2024 Delphix Corp