Masking Toolkits (KBA6598)
KBA
KBA# 6598At a Glance
Description: | This page contains brief information about tools available to assist with the masking solution. |
---|---|
Support note: | These tools are provided by Technical Services or the Delphix community and as such not supported by Delphix Support. Issues with the tools should be directed to the respective channel. Should there be an error on the engine related to a bug - this should be raised with support. |
DXM-Toolkit: | DX-Toolkit for Masking (DXM) - Phyton based Command-Line tool: |
Msk-AI-Agnt: | Masking AI Agent (Msk-AI-Agnt) is a tool for load balancing masking jobs, sync jobs, environments, global objects, and the entire engine, and backup and restore engine metadata to/from the file system. |
Masking Initializer | Masking Initializer is a tool that can be used to back up and restore a masking engine. |
Toolkits
The following links jump to the appropriate section of the document:
DXM-Toolkit
DX-Toolkit for Masking (DXM) is a Command-Line script delivered by the Delphix Professional Services team. It is used to manipulate the Delphix Masking Engine.
The script 'dxmc' is a single command with parameters and arguments delivered as an executable file with libraries. DXM is written in Python, minor knowledge of Python is required.
Applicable Delphix Versions for DXM-Toolkit
- Click here to view the versions of the Delphix engine to which this article applies
-
Major Release All Sub Releases 6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.5.0 5.3
5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0
Help
To get help:
dxmc [--help]
Response:
Usage: dxmc [OPTIONS] COMMAND [ARGS]... dxmc is a Delphix Masking Toolkit command line interface This command can be used to run all applications If option --engine is not specified, dxm will run all actions against masking engines configured with default option set to Y. To run command on all engines configured for this toolkit use all as a engine_name Options: --version Show the version and exit. --help Show this message and exit. Commands: algorithms Algorithm group allow to control Algorithm application Application group allow to control applications column Column group allow to control inventory connector Connector group allow to control environments domain Domain group allow to control domains engine engine is a group of command to add, delete and list Masking... environment Environment group allow to control environments expression Expression group allow to control Profile expressions fileformat Filetype group allow to control file types job Job group allow to control job meta Meta group allow to control tables and files metadata profilejob Profile job group allow to control Profile jobs profileset Profileset group allow to control Profile Sets role Role group allow to control user roles ruleset Ruleset group allow to control rulesets sync Sync objects between engines or export/import to files user User group allow to control users
Example: version
dxmc --version dxmc, version 0.8.2
Useful tips:
Use the command 'engine' to configure the details to your engine:
dxmc engine
Example: engine list
dxmc engine list Engine name IP username protocol port default proxy URL proxy user =========== =========== ======== ======== ===== ======= ========= ========== yourEngine 11.11.11.11 admin http 80 Y N/A N/A
Example: connector list
dxmc connector list Engine name Environment name Connector name Connector type =========== ================ ============== =============== yourEngine Payroll MSSQL_CON MSSQL yourEngine Income ORACLE_CON ORACLE yourEngine Expenses MSSQL_SAP MSSQL yourEngine Expenses MS_ADV MSSQL yourEngine File SFTP_CON DELIMITED
Msk-AI-Agnt
Masking AI Agent is built using python 3.x. It has been created to assist with:
- Intelligently load balancing masking job across multiple engines.
- Sync job/environment/global objects/entire engine.
- Backup/Restore masking engine metadata to/from the file system.
Help
./mskaiagnt --help
Response:
Usage: mskaiagnt [OPTIONS] COMMAND [ARGS]... Options: -v, --verbose -d, --debug --help Show this message and exit. Commands: version Script Version add-engine This module will add engine to pool list-engine This module will remove engine from pool del-engine This module will remove engine from pool pull-joblist This module will pull joblist from engine gen-dxtools-conf This module will generate dxtools conf file for... sync-job This module will sync particular job between 2... sync-env This module will sync particular env between 2... sync-eng This module will sync particular env between 2... sync-globalobj This module will sync global objects between 2... cleanup-eng This module will cleanup engine run-job This module will execute masking job on best... list-eng-usage This module will find green engines offline-backup-eng This module will offline backup engine offline-restore-eng This module will offline restore engine from backups
Example: version
./mskaiagnt version AI Agent for Delphix Masking Server - 1.1.2 ********************************************************************************* Script Version : 1.1.2
Example: add-engine
This adds engines to the pool. There are three engines added in this example.
./mskaiagnt add-engine -m yourEngine_01 -t 64 -s 10 ./mskaiagnt add-engine -m yourEngine_02 -t 64 -s 10 ./mskaiagnt add-engine -m yourEngine_03 -t 64 -s 10
Example: list-engines
In this example, there is just one engine added - yourEngine.
./mskaiagnt list-engine EngineName Total Memory(GB) System Memory(GB) yourEngine 64 10
Masking Initializer
Masking Initializer is a command-line tool that can be used to back up and restore a masking engine using the APIv5 endpoints.
It allows backup/restoration of the following objects.
Masking Job-related objects
- Applications
- Environments
- Connectors (Database and File)
- Rulesets (Database and File)
- Table metadata
- File metadata
- Column metadata
- Masking jobs
- Profiling jobs
- Mounts
Global Objects
- Profile Sets
- Profile Expressions
- Domains
- Syncable Objects
- File formats
- File field metadata
- Users
- JDBC Drivers
Link
The link to the tool:
This also includes descriptions as well as examples.
Related Articles
The following articles may provide more information or related information to this article: