Connecting to Microsoft SQL Server

Privacy Dynamics can connect to your SQL Server database. This guide helps you authenticate and authorize Privacy Dynamics to access your data in SQL Server.

Requirements

To complete this guide, you will need the following:

• A SQL Server database.
• A Privacy Dynamics account.

Instructions

Before you can connect to SQL Server in Privacy Dynamics, you will want to create a new service account user and role for Privacy Dynamics to use.

Configure Your SQL Server Database

We recommend creating a dedicated user called svc_pvcy with limited permissions to read from the source database. You can add appropriate roles and permissions based on your needs.

Add the SQL Server Connection in Privacy Dynamics

1. Sign in to your Privacy Dynamics account.
2. Go to the Connections page.
3. Select Add Connection.
4. Choose SQL Server and select Next.
5. Enter the connection details:
   • Name - a name for you to identify the connection.
   • Host - the endpoint, without the port or database name.
   • Port - the port we use to connect to your database. The default is 5432.
   • Username - the username of the service account we created earlier (svc_pvcy).
   • Password - the password for the service account user.
   • Database - the name of the database you would like to use.
6. Select TEST CONNECTION to verify the credentials.
7. Select ADD CONNECTION and your connection saves if there are no errors.

Other Configuration

If you have network access controls in place that limit connections to SQL Server, you will need to add Privacy Dynamics' IP addresses to your Allowlist. You can find those IP addresses in this public JSON file.