Skip to content
CA Test Data Manager - 4.2
Documentation powered by DocOps

Supported Data Sources

Last update April 6, 2018

CA Test Data Manager supports a wide variety of data sources, both relational and non-relational, for each of its capabilities. This topic summarizes certified and supported data sources by type and capability. 

Certified

Indicates that the data source has been fully tested and validated to work.

Supported

Indicates that the data source is expected to work but has not been through a full testing cycle. CA support will strive to resolve any issues which may arise with this data source, but cannot guarantee resolution of issues found.

Relational Data Sources

Notes: 

  • All database access permissions must be controlled on the DBMS server itself.
  • Test Data on Demand (TDoD) only supports DSN-less connection profiles.
  • Javelin does not support DB2 drivers on IBM AS-400 and z/OS.

  • For more information about supported data types for Dynamic Test Data Reservation, see Configure Dynamic Test Data Reservation Service - Considerations.

Database

Dynamic Test Data Reservation - TDM Portal

Data Generation - TDM Portal

Data Generation - Datamaker

Data Masking

Data Subsetting

Test Match

Distributed with Driver?

Microsoft SQL Server 2008

Certified

Certified

Certified

Certified

Certified

Certified

Yes

Microsoft SQL Server 2012

Certified

Certified

Certified

Certified

Certified

Certified

Yes

Microsoft SQL Server 2014

Certified

Certified

Certified

Certified

Certified

Certified

Yes

Microsoft SQL Server 2014 Express Edition Certified Certified Certified Certified Certified Certified Yes

Microsoft SQL Server 2016

Certified

Certified

Certified

Certified

Certified

Certified

Yes

Microsoft SQL Server 2016 Express Edition Certified Certified Certified Certified Certified Certified Yes

Oracle 11g

Certified

Certified

Certified

Certified

Certified

Certified

Yes

Oracle XE

Certified

Certified

Certified

Not Supported

Not Supported

Certified

Yes

Oracle 12c

Certified

Certified

Certified

Certified

Certified

Certified

Yes

Oracle RAC 11g

Certified

Supported

Supported

Supported

Supported

Not Supported

No

Oracle RAC 12c Certified Supported Supported Supported Supported Not Supported No

IBM DB2400 iSeries V7R1

Certified

Certified

Certified

Certified

Certified

Certified

No

For masking, ensure that the jt400.jar file is available at the following location:

  • C:\Program Files\Grid-Tools\FastDataMasker\lib\

IBM DB2 11 for z/OS

Not Supported

Supported

Supported

Supported

Supported

Not Supported

No

Download the file Common.jar from the vendor and place it in the following folders:

  • CA TDM Datamaker: C:\Program Files (x86)\Grid-Tools\GTDatamaker\dplib\
  • CA TDM Portal:  C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

If you are using JRE 1.7 or earlier, ensure db2jcc.jar file is available at the below path:

  • CA TDM Datamaker: C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
  • CA TDM Portal:  C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

If you are using JRE 1.8 or later, replace db2jcc.jar file with db2jcc4.jar file.

  • If both db2jcc.jar and db2jcc4.jar files are present, DB2 will default to the older db2jcc.jar.
  • The older driver only works with Java 1.7 and below.

For masking, ensure that the db2jcc4.jar, db2jcc4_license_cu.jar, and db2jcc4_license_cisuz.jar files are available at the following location:

  • C:\Program Files\Grid-Tools\FastDataMasker\lib\

IBM DB2 UDB 11.1

Supported

Supported

Supported

Supported

Supported

Not Supported

No

Sybase-IQ 16.0

Not Supported

Certified

Certified

Certified

Not Supported

Not Supported

Yes

Sybase ASE (SAP ASE) Not Supported Not Supported Supported Supported Supported Not Supported

No

Download the driver from https://support.sap.com/en/my-support/software-downloads.html

Note: Sybase ASE support is based on the Proof of Concept (PoC) executed with customers and supports limited use cases only.

Teradata 15.10

Not Supported

Certified

Certified

Certified*

Certified

Not Supported

No

If you create a Teradata connection profile in CA TDM Portal, and you publish from Datamaker using this connection profile (the Enterprise or Remote Enterprise publish option), then only the Teradata ODBC driver is supported.

Download the files terajdbc4.jar and tdgssconfig.jar from the vendor and place it in the following folder:

  • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\

When using the JDBC driver to create a connection profile in the CA TDM Portal, grant the Teradata user the following additional permissions:

GRANT Select ON "UDTInfo" TO "<username>";

* For all Teradata databases, we do not support masking using Fast Data Masker (FDM). Instead, you can mask data using GT Subset scripts. You can connect to Teradata database in FDM to use seed data from a Teradata seed data table.

CA IDMS 19.0

Not Supported

Supported

Supported

Supported

Supported

Not Supported

No

Adabas 8.2 Not Supported Not Supported Supported* Supported* Not Supported Not Supported

No

 * For Data Generation in Datamaker and Data Masking, we support use cases on a per Proof of Concept (POC) basis.

Informix 12.1

Not Supported

Not Supported

Supported

Supported

Supported

Not Supported

No

For Informix to work, you must set the following environment variable on the system where Datamaker is installed: DELIMIDENT=y. This setting causes the Informix driver to properly interpret double quotes as delimiters.

Ingres 10.2

Not Supported

Not Supported

Supported

Supported

Supported

Not Supported

No

Download the file edbc.jar from http://esd.actian.com and place it in the following folder:

  • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\

PostgreSQL 9.5.4

Not Supported

Not Supported

Supported

Supported

Not Supported

Not Supported

No

Download the driver from https://jdbc.postgresql.org/ and https://oss.sonatype.org/ (9.4-1201-SNAPSHOT) 

MySQL 5.6

Not Supported

Supported

Supported

Supported

Supported

Not Supported

No

For CA TDM Portal, download the driver from http://dev.mysql.com and place it in the following folder:

  •  C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

IMS 14

Not Supported

Not Supported

Supported

Supported

Supported

Not Supported

No

Netezza 7.2

Not Supported

Not Supported

Not Supported

Supported

Not Supported

Not Supported

No

Download the driver from http://dbfit.github.io

DataDirect Shadow 7.3

Not Supported

Not Supported

Not Supported

Supported

Supported

Not Supported

No

Download the file base.jar from https://www.progress.com and place it in the following folders:

  • C:\Program Files (x86)\Grid-Tools\GTDatamaker\dplib\
  • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
  • C:\Program Files\Grid-Tools\FastDataMasker\lib\

SQL Anywhere 17

Not Supported

Not Supported

Not Supported

Supported

Supported

Not Supported

No

Download the driver from http://scn.sap.com

Derby 10.12.1.1 Not Supported Not Supported Not Supported Supported Not Supported Not Supported No

Non-Relational Data Sources

Data Source Dynamic Test Data Reservation - TDM Portal Data Generation -
TDM Portal
Data Generation -
Datamaker
Data Masking Data Subsetting Test Match
SQL Files Not Supported Certified Certified Not Supported Not Supported Not Supported
CSV Files Not Supported Certified Certified Certified Certified Not Supported
Fixed Definition Files Not Supported Certified Certified Certified Certified Not Supported
XML Files Not Supported Certified Certified Certified Not Supported Not Supported
Excel Files Not Supported Supported Supported Supported Supported Not Supported
HTML Files Not Supported Not Supported Supported Not Supported Not Supported Not Supported
TXT Files Not Supported Supported Supported Supported Supported Not Supported
VSAM/ISAM Not Supported Not Supported Supported Supported Supported Supported
JSON Files Not Supported Supported Supported Supported Not Supported Not Supported
Hadoop (Hive) Not Supported Not Supported Not Supported

Certified

Not Supported Not Supported

Note: For more information about what is supported in masking for Hadoop, see Mask Data Stored in Hadoop.

Was this helpful?

Please log in to post comments.

  1. Abderrahmane Zahrir
    2017-07-01 06:52

    for IBM DB2400 iSeries V7R1, the doc says unsupported for TDMPortal when it is supported

    1. Gupta, Vishal
      2017-07-06 03:35

      Thanks, Dahman!

      Updated the entry for IBM DB2400 iSeries V7R1.

  2. Prashant Pandey
    2017-07-12 02:50

    Should Hadoop Hive be added as a supported/certified target for masking?

    1. Gupta, Vishal
      2017-07-14 01:41

      Thanks, Prashant!

      We are looking into this.

    1. Gupta, Vishal
      2017-07-14 02:17

      After discussing with the development team, added the Hadoop (Hive) entry to the page.