Synchronizing Masking Jobs & Universal Settings Across Engines

In 5.2 we introduced the ability to synchronize Masking Algorithms between engines to ensure consistent masking, regardless of the engine executing the masking. In 5.3 are expanding the list of syncable objects to include:

  • Masking Jobs

  • Connectors

  • Rulesets

  • Domains

  • File Formats

The sync of objects is possible through improvements to several sync API endpoints, including:

  • GET /syncable-objects[?object_type=<type>]

  • POST /export

  • POST /export-async

  • POST /import

  • POST/import-async

This expansion of syncable objects ensures that users can sync their Masking Jobs and all the objects necessary for that masking job to execute successfully - regardless of the masking engine it lives on, allowing for easier scaling of Delphix Masking across the enterprise. Please see Managing Multiple Masking Engines for more details.

Support for Kerberized Connections

In 5.2.4 we added support for Kerberos for our Oracle Masking Connector. In 5.3 we have expanded the list of connectors that support Kerberos to:

  • SQL Server

  • Sybase

To enable Kerberized connectors your engine must be configured properly configure Kerberos and you must configure your masking Connectors for Kerberos. Kerberos can be enabled by going to the Advanced mode on Oracle, SQL Server & Sybase. Please see Managing Connectors for more details.

New API Endpoints

In 5.2 we released an all-new set of API endpoints allowing for the automation of many masking workflows. In 5.3 we have expanded this list of API endpoints around Algorithms, Users, Roles, File Upload, System Information, Login, Rulesets, and Connector. Below are the net new API endpoints:


Group

Endpoint

Description




Algorithms

POST /algorithms

Create algorithm

DELETE /algorithms/{algorithmName}

Delete algorithm by name

GET /algorithms/{algorithmName}

Get algorithm by name

PUT /algorithms/{algorithmName}

Update algorithm by name

PUT /algorithms/{algorithmName}/randomize-key

Randomize key by name




Users

GET /users

Get all users

POST /users

Create user

DELETE /users/{userId}

Delete user by ID

GET /users/{userId}

Get user by ID

PUT /users/{userId}

Update user by ID




Roles

GET /roles

Get all roles

POST /roles

Create role

DELETE /roles/{roleId}

Delete role by ID

GET /roles/{roleId}

Get role by ID

PUT /roles/{roleId}

Update role by ID



Rulesets

PUT /database-rulesets/{databaseRulesetId}/bulk-table-update

Update the rule set’s tables

PUT /database-rulesets/{databaseRulesetId}/refresh

Refresh the rule set




Connectors

POST /database-connectors/{databaseConnectorId}/test

Test a database connector

POST /database-connectors/test

Test an unsaved database connector

POST /file-connectors/{fileConnectorId}/test

Test a file connector

POST /file-connectors/test

Test an unsaved file connector


Async Tasks

GET /async-tasks

Get all asyncTasks

GET /async-tasks/{asyncTaskId}

Get asyncTask by ID

PUT /async-tasks/{asyncTaskId}/cancel

Cancel asyncTask by ID



File Upload/Download

DELETE /file-uploads

Delete all file uploads

POST /file-uploads

Upload file

GET /file-downloads/{fileDownloadId}

Download file

System Information

GET /system-information

Get version, etc.

Login/Logout

PUT /logout

User logout

Executions

GET /execution-components

Status for a table, file, or VSAM file


In addition to the net new API endpoints, we have improved pre-existing API endpoints. Some of the improvements include:

  • Addition of DB2 iSeries & Mainframe to connector endpoints.

  • Addition of Kerberos configuration on Oracle, SQL Server & Sybase connectors

  • Ability to have ruleset refresh drop tables

  • Support for XML file types

  • Addition of dataType to column metadata

For more information please on Delphix Masking APIs please see Masking APIs Please note that the previous generation of Masking APIs (commonly referred to as V4) is EOL and no longer supported in this release. All users are encouraged to migrate to the V5 APIs.