Notes on Implementation with Specific Data Sources

This page details important notes on the implementation of CA Test Data Manager with the specified data sources.
tdm47
This page details important notes on the implementation of CA Test Data Manager with the specified data sources.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 support is based on the Proof of Concept (PoC) executed with customers and supports limited use cases only.
Microsoft SQL Server Express 2014/2016
TCP/IP is
not
enabled in Microsoft SQL Server Express (2014 and 2016) by default.
Ensure that you use the SQL Server Configuration Manager to enable the TCP/IP protocol before use with CA TDM. You should use a known port for connection - if you do not have another installation of SQL Server on your machine, use
1433
(default SQL Server port for many applications).
Oracle 12c
vTDM supports the following Oracle 12c databases for automatic attachment of clones:
  • Non-Container Database (CDB)
    Supported same as Oracle 11g (Linux) Enterprise edition.
  • Single tenant CDB configuration
    For a container database with a single pluggable database, you can create clones in the pluggable database (PDB) only.
  • Multitenant CDB configuration
    For a container database with multiple pluggable databases, you can create clones in the pluggable databases (PDBs) only.
Creating clones in system database and root container is not supported.
IBM DB2400 iSeries V7R1
For masking, ensure that the
jt400.jar
file is available at the following location:
  • C:\Program Files\Grid-Tools\FastDataMasker\lib\
For subsetting, ensure that the
jt400.jar
file is available at the following location:
  • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
For CA TDM Portal, ensure that the
jt400.jar
file is available at the following location:
  • C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers
IBM DB2 11 for z/OS
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
CA TDM version 3.2.1
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.
If you are using
CA
TDM version 3.2
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
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\
For subsetting, ensure that the
db2jcc4.jar
,
db2jcc4_license_cu.jar
, and
db2jcc4_license_cisuz.jar
files are available at the following location:
  • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
For CA TDM Portal, ensure that the
db2jcc4.jar
,
db2jcc4_license_cu.jar
, and
db2jcc4_license_cisuz.jar
files are available at the following location:
  • C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers
Run the db2licm command from the command prompt to apply the license as follows:
db2licm -a "C:\Users\Username\Desktop\10.5_DB2ConnectEE_License\db2consv_ee.lic"
Ensure that the license file path is local and does not point to a network drive.
IBM DB2 UDB 11.1
For more information about the JDBC drivers, refer to Supported Data Sourcesnotes.
Sybase ASE (SAP ASE)
Sybase ASE support is based on the Proof of Concept (PoC) executed with customers and supports limited use cases only.
Teradata 15.10 / Teradata 16.10 / Teradata 16.20
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>";
Adabas 8.2
For Data Generation in Datamaker and Data Masking, we support use cases on a per Proof of Concept (POC) basis.
Informix 12.1
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
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
Download the latest driver from https://jdbc.postgresql.org/. Place it in one or both of the following folders:
  • For use with
    TDM Portal
    :
    C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers
  • For use with
    Fast Data Masker
    :
    C:\Program Files\Grid-Tools\FastDataMasker\lib\
PostgreSQL database versions are certified with the driver version
postgresql-42.2.18.jar
.
MySQL 5.6
For CA TDM Portal, download the driver
mysql-connector-java-5.1.38-bin.jar
from http://dev.mysql.com and place it in the following folder:
C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers
MariaDB 10.2.6
The CA TDM Portal is certified with
connector-java-2.0.3
driver. Download the driver from https://downloads.mariadb.org/connector-java/ and place it in the following folder:
  • C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers
Find and reserve is not supported for MariaDB.
Netezza 7.2
Download the driver from https://github.com/dbfit/dbfit/releases.
DataDirect Shadow 7.3
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
Download the driver from http://scn.sap.com.
For more information about supported data sources in CA Test Data Manager, see Supported Data Sources.
SAP Hana
Download the driver from developers.sap.com.
For more information about supported data sources in CA Test Data Manager, see Supported Data Sources.