Connecting to External Azure SQL Database from Pega application( which is hosted on pega Cloud)
Pega application (Pega Infinity 23.1) needs to connect to an external database Azure MS SQL to fetch data from a table using authentication through a service principal/registered app in Azure.
We already have this service principal/registered app set up, with all necessary credentials and details provided. The database team has also configured the database and granted access to this registered app.
Could anyone guide us on the steps to establish this connection in Pega?
I'm not very experienced with Azure, so if there’s a better approach, please feel free to suggest it—I may have missed something.
Pegasystems Inc.
GB
Below are the available documentation resources and the details summarised by our GenAI search:
To connect your Pega application to an external database like Azure MS SQL using a service principal you will need to follow these steps: 1. Ensure that you have the JDBC driver for Azure SQL Database. 2. In your Pega application navigate to the Database configuration settings. 3. Create a new database connection and select the JDBC connection method. 4. Enter the connection details including the JDBC URL which should include the server name database name and any necessary parameters for the service principal authentication. 5. Test the connection to ensure that it is successful. 6. Once the connection is established you can create data pages or data transforms to fetch data from the external database table as needed. Make sure to handle any specific configurations required for the service principal authentication in the JDBC URL or connection properties.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Using Live Data from SQL Server and Other Databases in Your Pega Applications
@BrettAllen is this a question you might be able to help with?