Anonymization setup and installation
Published 16 October 2023
Supported operating systems
Supported databases
Installation
To install Anonymize CLI as a stand-alone tool, follow any instructions provided with your download link and make sure that the executable is in the directory where you'll run the commands, or make sure the folder path of the executable is in your system’s PATH.
Installing with other Redgate Test Data Manager tools
General prerequisites for anonymization
Read/Write access permissions to the database you intend to anonymize
Make sure that the database you intend to anonymize is not a live production database. We will be modifying the data in it.
If you are running the Anonymize CLI in your own bespoke pipeline outside of Redgate Test Data Manager workflows, we recommend you provision an up-to-date copy of your production database (e.g. using Redgate Clone).
Database Connections in Redgate Test Data Manager
If you are using Redgate Test Data Manager, a suitable connection will be provided so that anonymization is run during image creation.
Database connection string formats
For different types of connection strings explained in full, please visit https://www.connectionstrings.com/
Here are some examples of connection string formats that work with Anonymize CLI for you to follow, however these are not exhaustive.
MySQL
"Server=[Your_Server_Address]; Database=[Your_Database_Name]; Uid=[Your_Account_Username]; Pwd=[Your_Password];"
Oracle
"DATA SOURCE=[Your_Server_Address]/[Your_Database_Name]; PASSWORD=[Your_Password]; USER ID=[Your_Username];"
PostgreSQL
"host=[Your_Server_Address]; Port=[Your_Port]; Database=[Your_Database_Name]; User Id=[Your_Username]; Password=[Your_Password];"
SQL Server
"Server=[Your_Server_Address]; Database=[Your_Database_Name]; User Id=[Your_Login_Name]; Password=[Your_Password]; Trust Server Certificate=true;"
