Supported Data Sources

TDM 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.
tdm49
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.
Here you can find out more about the different data sources that CA Test Data Manager supports:
3
Relational Data Sources
All database access permissions must be controlled on the DBMS server itself.
Test Data on Demand (TDoD) only supports DSN-less connection profiles.
For more information about supported data types for Dynamic Test Data Reservation, see Configure Dynamic Test Data Reservation Service - Considerations.
For more information on implementation with specific data sources, see Notes on Implementation with Specific Data Sources (links under the
Notes
column also redirect to sections of this page).
Microsoft SQL Server
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
Microsoft SQL Server 2008
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Not Supported
Supported
Yes
Microsoft SQL Server 2012
Certified
Certified
Certified
Certified
Certified
Supported
Certified
Certified
Certified
Certified
Yes
Microsoft SQL Server 2014
Certified
Certified
Certified
Certified
Certified
Supported
Certified
Certified
Certified
Certified
Yes
Microsoft SQL Server 2014 Express Edition
Certified
Certified
Certified
Not Supported
Certified
Supported
Certified
Certified
Not Supported
Not Supported
Yes
Microsoft SQL Server 2016
Certified
Certified
Certified
Certified
Certified
Supported
Certified
Certified
Certified
Certified
Yes
Microsoft SQL Server 2016 Express Edition
Certified
Certified
Certified
Not Supported
Certified
Supported
Certified
Certified
Not Supported
Not Supported
Yes
Microsoft SQL Server 2019
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Yes
Microsoft Azure SQL
Not Supported
Supported
Not Supported
Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Supported
Yes
Oracle
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
Oracle 11g (11.2.5, 11.2.0.2)
Certified
Certified
Certified
Supported
Certified
Certified
Certified
Certified
Yes
Oracle XE
Certified
Certified
Certified
Supported
Not Supported
Certified
Not Supported
Supported
Yes
Oracle 12c (12.1.1)
Certified
Certified
Certified
Supported
Certified
Certified
Certified
Certified
Yes
Oracle 18c
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Not Supported
Supported
No
Oracle RAC 11g
Certified
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Supported
No
Oracle RAC 12c
Certified
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Supported
No
DB2
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
IBM DB2/400 iSeries V7R1
Certified
Certified
Certified
Supported
Certified
Certified
Not Supported
Supported
IBM DB2 11 for z/OS
Certified
Supported
Supported
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Supported
IBM DB2 12 for z/OS
Supported
Supported
Supported
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Supported
IBM DB2 UDB 11.1
Certified
Supported
Supported
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Supported
Teradata
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
Teradata 15.10
Not Supported
Certified
Certified
Not Supported
Not Supported
Certified
Not Supported
Not Supported
Not Supported
No
Teradata 16.10
Not Supported
Supported
Certified
Not Supported
Not Supported
Certified
Not Supported
Not Supported
Not Supported
No
Teradata 16.20
Not Supported
Supported
Supported
Not Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
Sybase
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
Sybase-IQ 16.0
Not Supported
Certified
Certified
Not Supported
Certified
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
Yes
Sybase ASE (SAP ASE)
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
PostgreSQL
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
PostgreSQL 9.5.4
Not Supported
Supported
Not Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
No
PostgreSQL 10.5
Not Supported
Certified
Not Supported
Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Supported
No
Other Database Management Systems
Database
Dynamic Test Data Reservation - TDM Portal
Data Generation - TDM Portal
Data Generation - Datamaker
Data Masking -TDM Portal
Data Masking - Fast Data Masker
Data Masking - Datamaker
Data Subsetting
Test Match
Virtual Test Data Management
Data Modelling and PII Audit
Distributed with Driver?
Notes
CA IDMS 19.0
Not Supported
Supported
Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
SAP Hana
Not Supported
Supported
Supported
Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Supported
No
Adabas 8.2
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
No
Informix 12.1
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
Ingres 10.2
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
MySQL 5.6
Not Supported
Supported
Supported
Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Certified
No
MariaDB 10.2.6
Not Supported
Certified
Not Supported
Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Certified
No
IMS 14
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
Netezza 7.2
Not Supported
Not Supported
Not Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
No
DataDirect Shadow 7.3
Not Supported
Not Supported
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
SQL Anywhere 17
Not Supported
Not Supported
Not Supported
Not Supported
Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
No
Derby 10.12.1.1
Not Supported
Not Supported
Not Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
No
Notes on Relational Data Sources
Data Discovery and Profiling
Valid on Microsoft SQL Server 2012 / Microsoft SQL Server 2014 / Microsoft SQL Server 2016 / Microsoft SQL Server 2019:
When creating Connection Profiles for Data Discovery and Profiling, leave the Database Name and Schema Name parameters blank to scan all databases.
Valid on Oracle 11g / Oracle XE / Oracle 12c / Oracle RAC 11g / Oracle RAC 12c:
When creating Connection Profiles for Data Discovery and Profiling, leave the Schema Name parameter blank to scan all schemas.
Valid on IBM DB2400 iSeries V7R1 / IBM DB2 UDB 11.1 / MySQL 5.6 / MariaDB 10.2.6:
When creating Connection Profiles for Data Discovery and Profiling, you must enter the specific Database Name you want to scan.
Note on IBM systems
Javelin does not support DB2 drivers on IBM AS-400 and z/OS.
Note on Oracle databases
For all Oracle databases, we only support a user with schema owner permissions.
Note on Teradata databases
For all Teradata databases, you can mask data using GT Subset scripts in Datamaker.
Note on Masking Mixed-Case data sources in TDM Portal / FDM
Masking in Portal / FDM does not support mixed-case data sources (i.e. names of database/schema/table/column) on the following databases:
  • All Oracle databases
  • DB2 databases on AS-400
Non-Relational Data Sources
The CA TDM Portal lets you work with various file objects and create test data that applications can use to conduct varied testing scenarios. For more information about preparing test data for non-relational data sources, see Prepare Test Data for 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
Virtual Test Data Management
Data Modelling and PII Audit
Notes
SQL Files
Not Supported
Certified
Certified
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
CSV Files
Not Supported
Certified
Certified
Certified
Certified
Not Supported
Not Supported
Not Supported
Fixed Definition Files
Not Supported
Certified
Certified
Certified
Certified
Not Supported
Not Supported
Not Supported
XML Files
Not Supported
Certified
Certified
Certified
Not Supported
Not Supported
Not Supported
Not Supported
XML file shredding requires a MS SQL Server connection profile.
Excel Files
Not Supported
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Not Supported
HTML Files
Not Supported
Not Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
Not Supported
TXT Files
Not Supported
Supported
Supported
Supported
Supported
Not Supported
Not Supported
Not Supported
VSAM/ISAM
Not Supported
Not Supported
Supported
Supported
Supported
Supported
Not Supported
Not Supported
JSON Files
Not Supported
Supported
Supported
Supported
Not Supported
Not Supported
Not Supported
Not Supported
JSON file shredding requires a MS SQL Server connection profile.
Hadoop (Hive)
Not Supported
Not Supported
Not Supported
Certified
Not Supported
Not Supported
Not Supported
Not Supported
Note:
For more information about what is supported in masking for Hadoop, see Mask Data Stored in Hadoop.