In this article, you will learn to create an app in Azure, connect it to your Synapse Workspace and then load it in Exmon. 

In the Azure Portal, we need to create an App registration which we will use to access our Synapse Workspace. This is done under the Azure Portal -> Azure Active Directory -> App Registration 

1. Go to the Azure Portal 

2. Open App Registrations

   

3. Select New Registrations 

   

4. Name your app Azure_Demo and click Register 
5. The next window presents some key information that Exmon will use to authenticate our later execution 
6. In the left panel, click Certificates & Secrets 
7. Then select New Client Secret 

   

8. Add the description Exmon Connection and click Add at the bottom of the window 

   

9. Copy the secret value by clicking the Copy to Clipboard button 

   

Add app to Synapse Workspace 

1. Next navigate to Azure Synapse Analytics, in Azure 
2. Then move to Access Control(IAM) > Role Assignments and select the Add button 
3. Make your new App registration a Contributor to your Synapse Workspace 

Add app to Exmon 

1. Next, open up Exmon 
2. Right-click Data Providers, select New > Data Provider 

   

3. Select a name for your Data Provider 
4. Fill in a Description for your Data Provider 
5. Select the Exmon Systems in which your Data Provider should run 
6. Under Datasource Type, select Azure Synapse Connection 
7. Fill in the Tenant-Id, App-Id and the Client Secret 
8. Click Save 
9. Right-click packages, select New > Azure Synapse 

   

10. Select a name for the Azure Synapse package 
11. Select the recently created Data Provider, which should fill in the Subscription Name, Resource Group Name and Synapse Package Name dropdowns 
12. Choose the desired Subscription Name, Resource Group Name and Synapse Package Name, which should fill in the Pipeline Name dropdown 
13. Choose the pipeline to run 
14. Click Save 
15. Finally, run the Azure Synapse Package