Azure SQL Setup

Syncaroo
Syncaroo
  • Updated

The Azure SQL Synapse enables data synchronization between Azure SQL schema and Syncari entities. After the Synapse is authenticated, a user can activate the Azure SQL Synapse, which enables Syncari to replicate the schema of Azure SQL and make it available within the Unified Data Model. Using Sync Studio, a user can map Azure SQL tables to Syncari entities, and Azure SQL fields to Syncari fields.

If your Azure SQL security requires you to whitelist an IP you can find that here.

 

Azure SQL Information

You will need the following information from your Azure SQL administrator:

  • Cluster Name
  • Database Name
  • Schema Name

API User Setup

Create Entra Authentication Application

  • Ensure Entra authentication is enabled for this server. Go to the SQL Server -> Settings -> Microsoft Entra ID

 

Screenshot 2023-11-15 at 3.12.18 PM.png

 

  • To create the application, From Azure Home, go to Microsoft Entra ID or Default Directory. Click on App Registrations

Screenshot 2023-11-15 at 3.14.29 PM.png

 

  • Click on New Registration 
  • Enter a Name and select the appropriate account type: (minimum requirement: Single tenant) and click Register
  • Copy the Name and the Client ID. Go to Client Credentials, create a new Client secret and copy the Client Secret value.

Screenshot 2023-11-15 at 3.15.58 PM.png

 

  • Click on API Permissions and add user_impersonation permission for Azure SQL Database

Screenshot 2023-11-15 at 2.46.21 PM.png

  • Go to Endpoints and copy the value for OAuth 2.0 Token Endpoint (v2)

Screenshot 2023-11-15 at 2.48.59 PM.png

Create Database User

Use the name of the created Entra application 

CREATE USER [apiuser] FROM EXTERNAL PROVIDER

Grant access to the schema

GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: [Schema Name] TO [apiuser];

 

Synapse Setup

Step 1: Start by logging in to your Syncari subscription

  1. Navigate to Synapses
  2. Find Azure SQL in the Synapse Library
  3. Drag the Azure SQL Synapse to the canvas

Screenshot 2023-11-15 at 3.00.38 PM.png

 

Step 2: Configure your Synapse parameters

  1. Enter [Synapse Name]
    This will be the label name for the Synapse in Syncari
  2. Enter [Cluster Name]
  3. Enter [Schema Name]
  4. Enter [Database Name]
  5. Enter [Access Token URL]
    1. Use the value we copied for OAuth 2.0 Token Endpoint (v2)
  6. Click "Next"

Screenshot 2023-11-15 at 3.06.17 PM.png

 

Step 3: Define your authentication parameters and authenticate:

  1. Enter [Client ID]
  2. Enter [Client Secret]
  3. Click "Authenticate"
  4. Click "Next"

Screenshot 2023-11-15 at 3.10.19 PM.png

 

Step 4: Activate your Synapse

  1. Click "Make Synapse Active"
  2. Click "Close"

Screen_Shot_Mysql.png

Congratulations! You have completed the setup of Azure SQL.

If you receive any errors message after clicking Authenticate, confirm each of the parameters in the previous steps are configured properly. If the error persists, contact one of our Onboarding and Support team members.

 

Share this

Was this article helpful?

0 out of 0 found this helpful