Create a SQL Data Source (Classic)

Steps for Operations Hub classic version.

Before you begin

Log in to Operations Hub.

Procedure

  1. From the main navigation menu, select DATASOURCES.
    The DATASOURCES workspace appears, displaying a list of data sources.
  2. Select Add New Data Source, and then enter values as specified in the following table.
    Field Name Description
    Name Enter the unique name of the data source.
    Description Enter the description of the data source.
    Datasource Type Select Relational Database.
    Database Type Observe that this field defaults to Microsoft SQL Server, currently the only supported database type.
    Host Enter the IP address or host name of database server. For example: 10.181.213.211 or databaseserver01.

    This field only appears if you select Relational Database as the Datasource Type.
    Port Enter the port you want to use to connect to the SQL Server.

    This field only appears if you select Relational Database as the Datasource Type.
    Database Enter the database name that you want to connect to.

    This field only appears if you select Relational Database as the Datasource Type.
    Certificates Required Select the check box if connecting to the data source requires SSL certificates. If you select this check box, the Choose Certificate button appears, allowing you to select the certificate.
    User Name In the SQL Authentication section, provide the user name for the database you want to access.
    Password In the SQL Authentication section, provide the password of the user configured in the database.
    Test button

    After the required fields are filled in, click the Test button.

    On a successful connection check, a message is shown beside the Test button as "Successfully connected to the Database” indicating that test connection to database can be established using the above details.

    If it fails, it reads: “Failed to connect to the Database. More Details.” Click the “More Details ”link to view detailed reason in a pop-up.
  3. Select the Test button.

    The following example shows a successful SQL Database connection.

    If it fails, a message appears stating: Failed to connect to the Database. Click on More Details link to view detailed reason in a popup.

  4. Select Save.