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, Salesforce
-
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 |
|
|
|
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 |
11gR1 |
11gR2 |
12c |
12cR2 |
18c |
19c |
21c |
|
|
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 |
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 |
13 |
14 |
Enterprise DB |
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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
|
|
|
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)
- Salesforce
- 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.
Salesforce
Introduction
There has been an increasing demand for an easy way to manage and utilize the highly sensitive data stored in Salesforce. With this new Select Connector offering, sensitive data discovery and masking algorithm assignment is automatically handled for the Salesforce default schema; this is not only unique in the market, but also the first time Delphix is delivering this solution as an addition to its product suite. This is the top compliance solution for Salesforce on the market and provides a dramatically simpler deployment option to manage and secure this business-critical data. For more information, please visit the Application Solutions documentation.
Support Matrix
|
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 |
Unavailable |
|
Disable Trigger |
Unavailable |
|
Disable Constraint |
Unavailable |
Profiling |
Multi-Tenant |
Available |
|
Streams |
Available |
SAP
Introduction
SAP teams must access high-quality, compliant data to move to S/4HANA or accelerate key projects. Therefore, they must continuously profile and scramble all of their sensitive data and move it to lower environments for dev/test and QA. Since SAP column/table names are not intuitive, it’s time-consuming to find PII.
Delphix’s Select Connector for SAP (on the Delphix Continuous Compliance platform) allows you to leverage relevant, fresh, and consistently scrambled data with referential integrity across all SAP and non-SAP environments and sources to meet ever-changing compliance and security requirements while accelerating development.
Delphix’s Select Connector for SAP also includes SAP Compliance Accelerator that accelerates the Continuous Compliance setup for the most commonly used SAP modules, resulting in a much faster time to mask your SAP data. For full documentation, see Application Solutions documentation.
Support Matrix
|
Feature |
Oracle |
HANA |
In-Place Masking Mode |
Multi-Tenant |
Available |
Available |
|
Streams/Threads |
Available |
Available |
|
Batch Update |
Available |
Available |
|
Drop Indexes |
Available |
Unavailable |
|
Disable Trigger |
Available |
Unavailable |
|
Disable Constraint |
Available |
Unavailable |
|
Identity Column Support |
Available |
Unavailable |
On-The-Fly Masking Mode |
|
Available |
Available |
Profiling |
Multi-Tenant |
Available |
Available |
|
Streams |
Available |
Available |
!!! note
Drop Indexes, Disable Trigger, Disable Constraint, and Identity Column Support are not supported natively while masking HANA. Use pre/post scripts if you want to use these features.
SAP Compliance Accelerator
Platform \ dxac |
dxac v2.0.0 |
Delphix Continuous Compliance Engine |
6.0.14 |
Continuous Compliance API |
5.1.9 |
MacOS |
10.15.7+ |
Windows |
10 |
RHEL |
7.9, 8.x |
SAP Source Version and OS Version
Applications |
Database |
Driver |
RHEL 8.x |
RHEL 7.9 |
Windows 10 |
MacOS |
SAP S/4 HANA 1909 |
HANA SP05 |
SAP NDBC Driver 2.12.7 |
Supported |
Supported |
Supported |
Supported |
SAP S/4 HANA 2020 |
HANA SP05 |
SAP NDBC Driver 2.12.7 |
Supported |
Supported |
Supported |
Supported |
SAP ECC |
Oracle |
Delphix Compliance Engine Native Connector |
Supported |
Supported |
Supported |
Supported |
!!! note
- HANA requires SAP NGDBC Driver as an [extended connector](https://maskingdocs.delphix.com/Connecting_Data/Managing_Extended_Connectors/) for Delphix Compliance Engine. You can get the driver from [mavencentral](https://mvnrepository.com/artifact/com.sap.cloud.db.jdbc/ngdbc/2.12.7) link.
- Oracle is a native connector.