Anonymize PostgreSQL Database
This guide will show you how to anonymize an existing PostgreSQL database.
Last updated
Was this helpful?
This guide will show you how to anonymize an existing PostgreSQL database.
Last updated
Was this helpful?
Click on Import Table to open the Import Tables dialog.
b) For newly created Projects, the Import Dialog appears automatically after saving your project and loading from an existing PostgreSQL Database
After saving your new project and loading data from an existing PostgreSQL database, the Import dialog will appear automatically.
The Import dialog window allows you to browse your PostgreSQL databases and tables. Here are the steps to follow:
Load Schema: Click on a table to load its schema, including columns and foreign keys (if available), as well as additional SQL definitions.
Browse Databases: Double-click on a database to view its available tables.
Selecting Tables
Select Tables: Click on the nodes of the tables you want to anonymize or work with and check the boxes next to them.
Import Tables: Click on Import into Data Model to import the selected tables into your data model.
After importing the schemas into your DataFakery project, define the desired fakers and configurations to proceed with the anonymization process.
In this example, we create two fakers for the columns Login ID and Job Title. Additionally, we add a suffix $$ to clearly mark the anonymized data. Click here for further information on setting up fakers and generators to anonymize your data.
Click here for further information regarding Setting up Fakers and Generators to anonymize your data.
The Export section in the ribbon toolbar provides various options for exporting your data. Here are the functionalities available:
Generate Scripts
Click this option to generate scripts for your data. This is useful for creating SQL scripts or other types of data manipulation scripts based on your current dataset and configurations.
Export to Database
Use this option to export your data directly to a database. This is helpful for seamlessly integrating your generated or transformed data into your database systems.
Docker Containers
Click this option to manage and configure Docker containers for your database. This allows you to run your databases in isolated environments.
Export to File
This option allows you to export your data to a file. This can be used for creating backups, sharing datasets, or importing the data into other applications.
Use these export options to manage and utilize your data effectively, whether you need scripts, database integration, Docker container management, or file exports.
this example, we choose Generate Scripts, which generates *.sql files in the desired folders. Since we only anonymized and need the table Employee, we select it exclusively.
To export your data to T-SQL files, follow these steps:
Generate Scripts: Click on the Generate Scripts icon in the ribbon toolbar.
Select Folder: Choose the desired folder where the *.sql files will be saved.
Select Table: Since we only need the anonymized Employee table, select Employee from the list of available tables.
Export: Proceed with the script generation. The selected table's data will be exported to the specified folder as a T-SQL file.
This process ensures that only the necessary data, in this case, the Employee table, is exported, facilitating efficient data handling and usage.
The preview pane shows the content of the generated SQL script file, allowing you to review the changes and data insertions.
Carefully review the generated script to ensure it meets your requirements. Check for correct anonymization and data integrity.
Once satisfied with the evaluation, you can proceed to execute the script in your SQL environment to apply the changes to your database.
