Microsoft Power Apps


Microsoft Power Apps


This page outlines the steps to connect Microsoft Power Apps to the CData Connect Cloud Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect Cloud 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.

Connecting to CData Connect Cloud

To establish a connection from Microsoft Power Apps to the CData Connect Cloud Virtual SQL Server API, follow these steps.

  1. Log in to Microsoft Power Apps.

  2. In the navigation menu, open Dataverse > Connections.

  3. Click New connection to open the list of available connections.

  4. Select SQL Server. In the modal that appears, select SQL Server Authentication.

  5. Enter the connection settings.
    • SQL server name—enter the Virtual SQL Server endpoint and port separated by a comma: tds.cdata.com,14333
    • SQL database name—enter the Connection Name of the CData Connect Cloud data source you want to connect to (for example, Salesforce1).
    • Username—enter your CData Connect Cloud username. This is displayed in the top-right corner of the CData Connect Cloud interface. For example, test@cdata.com.
    • Password—enter the PAT you generated on the Settings page.
    • Leave the Choose a gateway field blank.

  6. Click Create to establish the connection.

Your connection now appears in your connection list. You can add more data sources from your CData Connect Cloud account by repeating this process and entering a different SQL database name.

Learn More

For more information about SQL Server connections in Microsoft Power Apps, please see Microsoft’s support article.