Data Source Support¶

The Delphix Masking service supports profiling, masking, and tokenizing a variety of different data sources including distributed databases, mainframe, PaaS databases, and files. At a high level, Delphix Masking breaks up support for data sources into two categories:

Dedicated Delphix Connectors: These are data sources that the Delphix Engine can connect to directly using built-in connectors that have been optimized to perform masking, profiling and tokenization.
FEML Sources: FEML (File Extract Mask and Load) is a method used to mask and tokenize data sources that do not have dedicated Delphix Connectors. FEML uses existing APIs from data sources to extract the data to a file, masks the file, and then uses APIs to load the masked file back into the database.

Dedicated Delphix Connectors¶

The Delphix Engine has dedicated masking connectors for the following data sources:

Distributed Database: DB2 LUW, Oracle, MS SQL, MySQL, SAP ASE (Sybase), PostgreSQL, MariaDB
Mainframe/Midrange: DB2 Z/OS, DB2 iSeries, Mainframe data sets
Files: Fixed Width, Delimited, XML

For a detailed view of all the versions, features, etc Delphix supports on each data source - see the sections below.

DB2 LUW Connector¶

Introduction¶

DB2 for Linux, UNIX, and Windows is a database server product developed by IBM. Sometimes called DB2 LUW for brevity, it is part of the DB2 family of database products. DB2 LUW is the "Common Server" product member of the DB2 family, designed to run on the most popular operating systems. By contrast, all other DB2 products are specific to a single platform.

Support Matrix¶

Platforms
Unix
Linux
Windows

Versions
10.1
10.5
11.1
11.5

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
	Identity Column Support	Unavailable
On-The-Fly Masking Mode	Restart Ability	Available
	Truncate	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
Profiling	Multi-Tenant	Available
	Streams	Available

Oracle Connector¶

Introduction¶

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

Support Matrix¶

Platforms
Unix
Linux
Windows
AWS RDS
OCI DBaaS on Bare Metal
OCI DBaaS on VM

Versions
10g
11gR1
11gR2
12c
12cR2
18c
19c

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Trigger	Available
	Disable Constraint	Available
	Identity Column Support	Available
On-The-Fly Masking Mode	Restart Ability	Available
	Truncate	Available
	Disable Trigger	Available
	Disable Constraint	Available
Profiling	Multi-Tenant	Available
	Streams	Available

MS SQL Connector¶

Introduction¶

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

Support Matrix¶

Platforms
Unix
Linux
Windows
AWS RDS
Azure SQL
Google Cloud SQL Server

Versions
2005
2008
2008 R2
2012
2014
2016
2017
2019

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Trigger	Available
	Disable Constraint	Available
	Identity Column Support	Available
On-The-Fly Masking Mode	Restart Ability	Available
	Truncate	Available
	Disable Trigger	Available
	Disable Constraint	Available
Profiling	Multi-Tenant	Available
	Streams	Available

PostgreSQL Connector¶

Introduction¶

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors. It is free and open-source, released under the terms of the PostgreSQL License, a permissive software license.

Support Matrix¶

Platforms
Unix
Linux
Windows
AWS RDS
AWS Aurora
Azure Database for PostgresSQL
Google Cloud SQL PostgresSQL

Versions
9.2
9.3
9.4
9.5
9.6
10
11
12

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Unavailable
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
	Identity Column Support	Available
On-The-Fly Masking Mode	Restart Ability	Unavailable
	Truncate	Available
	Disable Trigger	Available
	Disable Constraint	Available
Profiling	Multi-Tenant	Available
	Streams	Unavailable

MySQL / MariaDB Connector¶

Introduction¶

MySQL is an open-source relational database management system (RDBMS). MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB. MySQL is now owned by Oracle Corporation.

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.

A MySQL Connector may be used to connect to either a MySQL or MariaDB database instance.

MySQL Support Matrix¶

Platforms
Unix
Linux
Windows
AWS RDS
AWS Aurora
Azure Database for MySQL
Google Cloud SQL MySQL

Versions
5.5
5.6
5.7
8

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
	Identity Column Support	Available
On-The-Fly Masking Mode	Restart Ability	Unavailable
	Truncate	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
Profiling	Multi-Tenant	Available
	Streams	Available

MariaDB Support Matrix¶

Platforms
Unix
Linux
Windows
AWS RDS
AWS Aurora
Azure Database for MariaDB

Versions
10

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
	Identity Column Support	Available
On-The-Fly Masking Mode	Restart Ability	Unavailable
	Truncate	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
Profiling	Multi-Tenant	Available
	Streams	Available

SAP ASE (Sybase) Connector¶

Introduction¶

SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server product for businesses developed by Sybase Corporation which became part of SAP AG.

Support Matrix¶

Platforms
Unix
Linux
Windows

Versions
15.03
15.5
15.7
16

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Available
	Disable Trigger	Available
	Disable Constraint	Available
	Identity Column Support	Available
On-The-Fly Masking Mode	Restart Ability	Available
	Truncate	Available
	Disable Trigger	Available
	Disable Constraint	Available
Profiling	Multi-Tenant	Available
	Streams	Available

DB2 Z/OS and iSeries Connectors¶

Introduction¶

DB2 for z/OS and iSeries are relational database management systems that run on IBM Z(mainframe) and IBM Power Systems.

Support Matrix¶

Platforms
z/OS
i-Series

Versions
7.1
7.2
7.3
9
10
11

	Feature	Availability
In-Place Masking Mode	Multi-Tenant	Available
	Streams / Threads	Available
	Batch Update	Available
	Drop Indexes	Unavailable
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
	Identity Column Support	Unavailable
On-The-Fly Masking Mode	Restart Ability	Unavailable
	Truncate	Available
	Disable Trigger	Unavailable
	Disable Constraint	Unavailable
Profiling	Multi-Tenant	Available
	Streams	Available

Files Connector¶

Introduction¶

Much of the time data will live outside of databases. The data can be stored in a variety of different formats including Fixed Width, Delimited, etc.

Support Matrix¶

File Type/Format	Support Level
Fixed Width	Supported
Delimited	Supported
XML	Supported
JSON	Not Supported

Mainframe Data Set Connector¶

Introduction¶

In addition to databases and files, the Masking Engine can process data stored in Mainframe data sets commonly found on the IBM z/OS operating system. For more information on data sets, see this IBM knowledge center article

Support Matrix¶

The Masking Engine requires that data be encoded in EBCDIC rather than something like ASCII or UTF-8. EBCDIC is the encoding traditionally used on Mainframes.

On-The-Fly Masking Jobs¶

Delphix Masking supports On-The-Fly (OTF) masking jobs where the data is read from a source location and written to a different target location. Only certain combinations of connector types are supported for OTF jobs.

OTF jobs with connectors of the same type are supported. For example, masking data from an Oracle source database to an Oracle target database is supported if both are using the built-in Oracle connector, as is a job with a delimited file source and target. OTF jobs using Extended Connectors are supported if both the source and target are using the same Extended Driver (the same uploaded JDBC driver). Additionally, OTF jobs with a relational database source and a delimited file target are supported. The following data sources are supported as source connectors for OTF jobs with delimited file targets.

Oracle
DB2
MS SQL
PostgreSQL
MySQL / MariaDB
SAP ASE (Sybase)
Connectors created as Extended Connectors

No other combinations of connector types are supported. For example, an Oracle source with a PostgreSQL target, or an MS SQL source with a fixed width file target, are unsupported.