Setup Synapse on Privacera Portal¶
These steps apply to both Self-Managed and Data Plane deployments..
Info
For Data Plane deployments, make sure you configure MSSQL Application to work with Synapse.
- For Self-Managed, log in to the Privacera Portal; for Data Plane, log in to the Privacera Discovery Admin Console.
- Navigate to Settings > Data Source Registration
- Under the system name you added here, click the more icon. Select Add Application > JDBC APPLICATION
- Under Configure JDBC Application, provide values for the Application Name and Application Code fields.
-
Under Application Properties, provide values for the following:
Important
Identify the user who must have appropriate permissions in your data source. For scanning, you need a user with read permission, and for processing compliance policies, you need read and write permissions. Login credentials of that user are needed for the JDBC Username and JDBC Password properties as shown below.
-
JDBC Url:
jdbc:sqlserver://<domainName>:<port>;databaseName=<db_name>
-
JDBC Username:
<user_with_readwrite_permission>
-
JDBC Password:
<login_credentials_of_identified_user>
-
JDBC Driver Class:
com.microsoft.sqlserver.jdbc.SQLServerDriver
For more information about Driver Class You can refer List of JDBC Driver Class for all datasources
Tip
You don't need to update any other fields during the initial setup. You can update them later as needed.!!! warning
-
-
Click TEST CONNECTION. Ensure that a message named success is displayed.
- Click SAVE
- Prev topic: Prerequisites
- Next topic: Advanced Configuration