Get Started with Relational Database Connector
This topic guides you through how to get started integrating the Relational Database Connector and Operations Hub.
Before You Begin
Before beginning with your relational database connector, be aware of the following:
- This release of Operations Hub supports fetching data via stored procedures from Microsoft SQL Server only.
-
Be sure to confirm that you can to successfully connect to the SQL Database:
- Test that you can connect to SQL Server with another client (for example: SSMS, UDL files), using the SQL account you want to use in Operations Hub.
- Confirm that the TCP/IP Protocol is enabled on the SQL Server. You will not be able to connect from Operations Hub until you enable TCP/IP using the SQL Server Configuration Manager.
- Ensure that you have a working SQL Database, and that the selected database has stored procedures.
Steps
The following sections walk you through:
- Create a data source of type Relational Database. Refer to the Add Relational Database Data Source (Classic) section.
- Provide the details to the external database. Refer to the Create a Query to a Relational Database section.
- Create a Query of type Relational Database, and specify the expected inputs and outputs of a Stored Procedure. Refer to the Create a Query to a Relational Database section.
- Map the query in the page designer to use the query to fetch the data from the external database. Refer to the Use the Relational Database Query in the Designer section.
- View the page in the end app. For an example, see Example of Adding Relational Database Queries to a Page.