Add an OLEDB Connection (Oracle, MySQL)

Important! You must create a connection before you define content.

Use the information below to create a connection to your SQL database in BA Insight Connectivity Hub.

  1. In Connectivity Hub, select the Connections tab.

  2. Select New… > SQL connection

  3. Enter a unique descriptive Title for the connection and select your data provider.

  4. In the General Settings tab provide the connection details to your database.

  5. Connection mode: Select either:

    1. Basic - Requires a database server address and database name

    2. Advanced - Requires a Connection string

  6. Database Server Address:

    1. Connection string to your MS SQL server instance

    2. If you are using named instances, this account should include the instance name such as MyServerName.

  7. Database Name: This is the name of the database to connect to.

  8. Provide a value for the Connection Timeout field (configures the time in seconds that a command will wait once you execute it.

    • If the command hasn't completed once the timeout is reached, the attempt is aborted)

  9. Select an authentication mode to connect to your database.

    1. Use Service Account

      1. Grant database access to the following user accounts:

        1. Account running the Job Service

        2. Account running the Connectivity Hub Admin site.

    2. SQL Login

      1. Enter a SQL Server type user name and password that has read access to your database.

      2. An Active Directory login does not work here and requires your server to support mixed mode authentication.

  10. Click Save.