You can find this by logging into the Azure portal and navigating to Azure Synapse Analytics -> Select your database -> Overview -> Server name. In addition to providing authentication (see below), set the following properties to connect to a Azure Synapse database:

Select 'Azure Synapse' from the Add Connection panelĮnter the necessary authentication properties to connect to Azure Synapse.Log into Connect Cloud, click Connections and click Add Connection.The personal access token is only visible at creation, so be sure to copy it and store it securely for future use.Ĭonnect to Azure Synapse from Connect CloudĬData Connect Cloud uses a straightforward, point-and-click interface to connect to data sources.On the User Profile page, scroll down to the Personal Access Tokens section and click Create PAT.Click on your username at the top right of the Connect Cloud app and click User Profile.Best practices would dictate that you create a separate PAT for each service, to maintain granularity of access. If you are connecting from a service, application, platform, or framework that does not support OAuth authentication, you can create a Personal Access Token (PAT) to use for authentication. You can review and edit users from the Users page.Enter the new user's email address and click Send to invite the user.Navigate to the Users page and click Invite Users.Create OData endpoints for Azure Synapse dataĪs needed, create Users to connect to Azure Synapse through Connect Cloud.Provide user access to the new connection in CData Connect Cloud.Connect to Azure Synapse from CData Connect Cloud.To work with live Azure Synapse data in Unqork, you need to:

Create a simple Unqork application to display Azure Synapse data.Register Azure Synapse (via Connect Cloud) as on Unqork service.Add Azure Synapse OData endpoints in Connect Cloud.Connect to Azure Synapse from Connect Cloud.Add a Personal Access Token for the Connect Cloud user.This enables you to create your own custom application with Azure Synapse data. CData Connect Cloud exposes Azure Synapse as a REST endpoint, which you can then query from Unqork with simple HTTP requests. Unqork is a completely visual, no-code application development platform that helps large organizations build complex custom software. From there you can build custom business applications in a visual, drag-and-drop interface. You can use CData Connect Cloud to feed Azure Synapse data to Unqork.

Drag and drop app builder for azure