• Prerequisites
• Connecting to CData Connect
  • Step 1: Preparing Visual Studio
  • Step 2: Creating the Data Model Project
  • Step 3: Importing Data
  • Step 4: Deploying the Project

This page outlines the steps to connect Azure Analysis Services to the CData Connect Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

• Connect a data source to your CData Connect account. See Connections for more information.
• Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.
• Create a server in Azure Analysis Services to which you will deploy your data from CData Connect.

Connecting to CData Connect

To establish a connection from Azure Analysis Services to the CData Connect Virtual SQL Server API, follow these steps.

Note: These steps involve creating a tabular model project through Visual Studio and deploying the model to Azure Analysis Services. For further instructions on using Azure Analysis Services, please refer to Microsoft documentation.

Step 1: Preparing Visual Studio

1. Open Visual Studio. In the navigation bar, select Extensions > Manage Extensions.

2. In the search bar, enter Microsoft Analysis Services Projects 2022. When it appears in the list, click Download.

3. When the installer file finishes downloading, close Visual Studio and double-click the extension installation file to install it.

4. Follow the installation prompts. When the installation finishes, restart Visual Studio.

Step 2: Creating the Data Model Project

1. In Visual Studio, create a new project.

2. Select Analysis Services Tabular Project.

3. In Configure your new project, enter a name for your project in the Project name field.

4. Specify a location for the project files and set Framework to the latest available value.

   

5. Click Create. The Tabular model designer dialog opens.

6. Select Workspace server and enter the address of your Azure Analysis Services server (for example, asazure://eastus.azure.windows.net/myAzureServer).

7. Set Compatibility Level to SQL Server 2022 / Azure Analysis Services (1600).

   Note: The rest of this guide is written for this compatibility level. If you select a different compatibility level, the steps below may not apply, and you might encounter issues when connecting to your data.

   

8. Click Test Connection and sign in to your server.

9. Click OK to create the project. Your Visual Studio window should resemble the following screenshot:

   

Step 3: Importing Data

1. In Visual Studio, in Tabular model Explorer, right-click Data Sources and select Import From Data Source.

   

2. In Table Import Wizard, select SQL Server database and click Connect.

   

3. In the Server field, enter the Virtual SQL Server endpoint and port separated by a comma: tds.cdata.com,14333.

   

4. Click OK. In the new window, select Database.

5. Enter the following information:

   • User name—enter your CData Connect username. This is displayed in the top-right corner of the CData Connect interface. For example, test@cdata.com.

   • Password—enter the PAT you generated on the Settings page.

     

6. Click Connect. In the Navigator window that opens, select your desired data source and click OK.

   

7. Navigator refreshes and displays the tables in your data source. Select your tables and click Load.

   

Step 4: Deploying the Project

1. In Visual Studio, select Solution Explorer.

   

2. Right-click your project and select Deploy.

   • For more information about deploying data, please see this Microsoft help page.

   • For more information about on-premises data gateways, please see this Microsoft help page.

Once you deploy your data to Azure Analysis Services, you can use your data to create data models. For more information please see Azure Analysis Services documentation.