Integrations
      Back to home
      1. Help center
      2. Integrations

      Microsoft SQL Server Integration

      Automating your Data Types discovery and Privacy Requests fulfillment by integrating MineOS to Microsoft SQL Server

      This integration allows you to:

      • Automate content classification to detect PII data types stored in your MSSQL tables.
      • Automate Copy and Delete requests for your MSSQL tables.

      Before you start

      • Make sure your MineOS plan supports integrations.
      • Make sure you have the correct information and connectionString to connect to your MSSQL database.
      • This integration supports MSSQL server version 2019 and up.

       

      Make sure to whitelist MineOS IPs in your database: IP Whitelist

       

      Setting up

      To connect the MS SQL integration, follow these steps:

      1. On the left sidebar, click Data Inventory and then Data Sources
      2. Click on Add data source
      3. Select MSSQL from the catalog, then enter the MSSQL page from your data sources list
      4. In the RequestHandling tab, check the Handle this data source in privacy requests  or check the Use source in Content Discovery checkbox and choose the Integration handling style.
      5. create a new user and grant it with the following privileges:
        1. SELECT on the desired database, and tables on your MySQL Database , you can use 
          db_datareader role on the database.
          • This role allows read access to all tables and views within the database.
        2. DELETE on the desired database, and tables on your MySQL Database
          (to support DSR  DELETE requests, if you only need a classification scan skip this)
        3. View Definition on system tables.
          • Grants permission to view metadata of system objects like tables, schemas, and indexes.
      6. Enter your Database ConnectionString which should include:
          1. User ID,
          2. User Password,
          3. Server's IP,
          4. Server's Port,
          5. Database Name

       

       

      Content Discovery

      When using Content Discovery for your tables data, you need to make sure you have given the user the required permissions to your relevant tables.

      Upon content discovery, we will scan your tables, and analyze each row's data in our PII Processing Engine. These scan results will be added to the data types of your integration general info.

      DSR Queries

      To manage your DSR handling actions, you need to define the queries that will run on the Database for each possible action:

      Note: The queries you use won't be validated. You should run them in your account to make sure they are running as expected

      Query used for search records & delete validation

      The query will be used for showing how many records were found as well as showing a sample (preview) of the data. Also, it will be used as a validation for the delete action.

       

      Example Query:

      SELECT name,phone,address FROM `database1`.`table1` WHERE name =  '';

      * Preview will return the count of the number of records returned in the query response

      * Preview will show the first 3 values from the query response, it supports strings and long types

      * The 'endUserEmail' variable is mandatory

       

      Copy Query

      The Copy query will be used for the Copy action. Copy action is running on the ticket processing page in ticket of type Copy when clicking on Generate Copy

      Example Query:

      SELECT * FROM `database1`.`table1` WHERE name = '';

      * Copy will show all records returned in the query response

      * The 'endUserEmail' variable is mandatory

       

      Delete Query

      The Delete query will be used for the Delete action. Delete action is running on the ticket processing page in ticket of type Deletion when clicking on Delete from X sources

       

      Example Query:

      DELETE FROM `database1`.`table1` WHERE name = '';

      * The 'endUserEmail' variable is mandatory

       

      Paste the details and queries in the Request handling tab in the correct inputs and click Save.

       

      What's next?

      Read more about the deletion process using integrations here.

      Read more about the get a copy process using integrations here.

      Talk to us if you need any help with Integrations via our chat or at portal@saymine.com, and we'll be happy to assist!🙂

      xncncn