Add Azure SQL as a data source in Pendo Predict

This article explains how to connect your Azure SQL database to Pendo Predict so you can use it as a source when building predictive models.

Requirements

Before you begin, make sure you have:

• A Pendo Predict account
• Access to Microsoft Entra Admin Center with permissions to create app registrations
• Access to your Azure SQL database with admin privileges
• The following details from Pendo Predict (provided by your Pendo Predict contact):
  • AWS Cognito Identity ID (Subject identifier)
  • AWS Cognito Identity Pool ID (Audience)

Step 1. Create an app registration in Microsoft Entra

1. 1. Go to Microsoft Entra Admin Center -> App registrations -> New registration
2. Enter a name for the application.
3. Select Register (Single tenant is recommended).

For detailed steps, see Register an application with the Microsoft identity platform.
 

Step 2. Add a federated credential

Within the app registration you created:

1. Go to Certificates & secrets -> Federated credentials -> Add credential
2. Select Other issuer.
3. Enter the following values:
   • Issuer:`https://cognito-identity.amazonaws.com` 
   • Subject identifier: AWS Cognito Identity ID (provided by Pendo)
   • Audience: AWS Cognito Identity Pool ID (provided by Pendo)
4. Select Add.

For detailed steps, see Create a trust relationship between an app and an external identity provider.

Step 3. Grant database access

In your Azure SQL database, run the following SQL commands to grant the federated application the required permissions:

CREATE USER [Your-Entra-App-Name] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [Your-Entra-App-Name];
ALTER ROLE db_datawriter ADD MEMBER [Your-Entra-App-Name];

Replace `[Your-Entra-App-Name]` with the name of the app registration you created in Step 1.

For background on Microsoft Entra authentication with Azure SQL, see Microsoft Entra authentication with Azure SQL.

Step 4. Collect your Azure connection details

Before setting up the connection in Pendo Predict, collect the following from your Azure environment:

Step 5. Set up the connection in Pendo Predict

1. In Pendo Predict, go to Sources -> Data Connectors.

   

2. Select Add new source -> Azure SQL Server.

   

3. Enter a name for the data connector.

   

4. Fill in the connection details collected in Step 4: Azure Tenant ID, Entra Application Client ID, SQL Server Name, and Database Name.

   

5. Select Authorize to connect.

Note: Pendo Predict uses federated identity (OpenID Connect & OAuth 2.0) to connect to your Azure SQL database. No passwords or client secrets are stored or exchanged. Access tokens are short-lived and automatically rotated.