Add an ODBC Connection (Oracle, MySQL)

Important! You must create a connection Connection defines the how Connectivity Hub connects to your Source System (which contains your documents, graphics, etc.,). Your Connection includes identifying elements such as: URL of the BA Insight web service connector you are using, (File Share connector, SharePoint Online connector, etc.), Authentication mode, User Accounts and Credentials, Database information (for database connectors) before you define content.

Use the information below to create a connection to your Oracle, MySQL or other ODBC-compliant 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. Select the General Settings tab.

  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. Authentication mode: Select an authentication mode to connect to your database.

    1. Service Account

      1. Connectivity Hub uses this account for AD A directory service for Windows domain networks. A hierarchical structure that stores information about objects on the network. Used to manage permissions and control access to critical network resources. authentication to connect to the database.

    2. SQL Login

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

      2. An Active Directory A directory service for Windows domain networks. A hierarchical structure that stores information about objects on the network. Used to manage permissions and control access to critical network resources. login does not work here and requires your server to support mixed mode authentication.

  10. Click Save.