Table of Contents

• Create Synapse Workspace
• Configure Synapse Security
• Create Synapse SQL Database
• Add Azure Synapse Connector

Create Synapse Workspace

1. Log into the Azure Portal.

2. Click Create a Resource.

3. Select the Azure Synapse Analytics resource.

4. Select an Azure Subscription and Resource Group where you want to create the Synapse workspace.

5. Provide a unique Workspace name.

6. Select the Region containing your storage account.

7. Select your Storage Account.

8. Select an existing File system name or create a new one.

9. Click Next: Security.

10. Check the box for Use only Microsoft Entra ID authentication.

11. Click Review + create.

12. Click Create.

Configure Synapse Security

A Managed Service Identity was created when the Synapse workspace was created. You will need to grant this user the Storage Blob Data Contributor role.

1. In the Azure portal, find your storage account.

2. Select Access control (IAM).

3. Select Add and then select Add role assignment.

4. In the list of job function roles, select Storage Blob Data Contributor and select Next.

5. In the Add role assignment page, select Assign access to Managed identity.

6. Select Select members.

7. In Managed identity filter by Synapse workspace.

8. The workspace identity is the same as your workspace name. When displayed, pick your workspace identity and then Select.

9. In the Add role assignment page, make sure the list of Members includes your desired Microsoft Entra ID account. Once verified, select Review + assign.

10. In the confirmation page, review the changes and select Review + assign.

11. Open the Synapse workspace.

12. Click Open Synapse Studio.

13. Click Manage

14. Select Access control

15. Add the user that will authenticate the Synapse connector in Popdock as a Synapse Administrator.

Create Synapse SQL Database

1. Open the Synapse workspace.

2. Click Open Synapse Studio.

3. Click the Data tab.

4. Click Add resource.

5. Select SQL database.

6. Select Serverless SQL pool type.

7. Provide a Database name.

8. Click Create.

9. Expand SQL database.

10. Click on actions for your database.

11. Select New SQL script -> Empty script.

12. Use the below script to create a master key in the SQL database.

-- Replace 'YourStrongPasswordHere!' with a secure password
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'YourStrongPasswordHere!';
GO

13. Click Run.

Add Azure Synapse Connector

1. Log into Popdock.

2. Go to Connectors and then select Add Connector.

3. Select the Azure Synapse tile.

4. Set the Azure Synapse SQL endpoint to your serverless SQL endpoint.

5. Set the Database to the database you create in Azure Synapse Studio.

6. Click Validate to check that your connection settings are correct.

7. If the validation is successful, click Connect.

Need help with adding the Azure Synapse connector? Email support at support@eonesolutions.com