Skip to main content
Delphix

Masking Connectors - JDBC Drivers and JDBC Syntax (KBA5558)

 

KBA

KBA# 5558

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.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

At a Glance

Summary: This page provides the JDBC drivers used on the Masking Engine and their settings.  
JDBC driver details:  From version 6.0.1, all driver details are visible in the Masking 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).
  • 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 engine related to a bug - this should be raised with support. 

From version 6.0.6 and up

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

For details please see this page in the Masking Docs: 

From version 6.0.1 and up

From version 6.0.1, all drivers and their versions can be accessed from the Masking 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 - 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 Masking Docs: 

Older versions

Older versions (pre 5.3.9 and older) of 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 7
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, there are some points to consider: 

  • These details are not required if the Basic Standard Connector is used. 
  • When using an Advanced or Extended Connector, some Masking Engine features might not be available.
  • Advanced or Extended Connector does 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.
  • Configuration can be set on the database side (for example port). 
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 package

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>)))

JDBC JAR files

ojdbc8.jar

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;
jdbc:sqlserver://xyz.xyz.xyz.xyz.xyz.xyz.xyz.xyz.xyz;databaseName=<dbname>;
## xyz indicates a word in a very long hostnames

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

 

 

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

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.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