Azure Synapse packages in Timextender Orchestration¶

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

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 Timextender Orchestration 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 Timextender 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 Timextender Orchestration¶

1. Next, open up Timextender Orchestration and Data Quality Desktop client
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 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