> Expert > Activate > Analytics in Web Console > Data Cube Overview > End-Users > Data Cube Data Connectors > Adding a Database Data Source to Data Cube

Adding JDBC Drivers to Data Cube

Many common database management system (DBMS) drivers (such as drivers for Microsoft SQL, Oracle, and MySQL) are included with Data Cube. To connect to other types of DBMSs, you can add the Java Database Connector (JDBC) API driver to Data Cube.

Before You Begin

You must obtain the JDBC driver JAR file for the type of database that you want to use. See your database vendor documentation.

Procedure

  1. Log on to the Index Store client associated to the Index Server that you want to use for the data source.

  2. Open the Commvault software installation directory, and then go to CVAnalytics\DataCube\app\sharedLib.

    Tip

    The default installation directory is located at C:\Program Files\CommVault\ContentStore.

  3. Copy the JDBC driver JAR file into the sharedLib folder.

  4. On the Index Store client, restart the Commvault Data Analytics service.

    See Restarting a Service.

  5. Log on to the Web Console.

    Note

    If you are already logged on to the Web Console, to see the new database driver, you must log out, and then log back on.

  6. Add the new database data source.

    See Connecting to a Database with Data Cube.

    When you configure the data source, select the Index Server to which you added the JDBC driver JAR file, and the new database type appears in the Drivers list.

Loading...