Loading...

Creating an ODBC Driver for Data Cube

To connect Data Cube sources to external business intelligence tools, you must create and configure an ODBC driver on the client where your business intelligence (BI) tools are installed. The ODBC driver enables BI tool users to connect to Data Cube from their BI tool clients.

Before You Begin

Procedure

  1. Log in to the computer where your BI tool is installed.
  2. Download and install the MapR Drill OBDC Driver.

    For installation instructions, see the Apache Drill documentation.

  3. After installing the ODBC driver, open ODBC Administrator.

    The ODBC Administrator program is located in the MapR Drill ODBC Driver installation directory.

  4. In the ODBC Data Source Administrator dialog under the System DSN tab, click Add.
  5. In the Create New Data Source dialog, select MapR Drill ODBC Driver.
  6. Click Finish.

    The MapR Drill ODBC Driver DSN Setup dialog appears.

  7. In the MapR Drill ODBC Driver DSN Setup dialog, configure the driver:
    • In Data Source Name, enter a name for the data source. This name will appear in the BI tool interface.
    • In Connection Type, select Zookeeper Quorum and copy the Analytics Engine URL (quorum) that you obtained from Data Cube.

      For more information, see Starting the CV Drill Service for Data Cube.

    • Click the Authentication Type list, select Basic Authentication, and then enter your Web Console user credentials in the User and Password boxes.
    • To test the source, click Test.
  8. When finished, click OK.

    The data source name appears under the System DSN list in the ODBC Data Source Administrator dialog.

  9. Click OK to close the ODBC Data Source Administrator dialog.

What to Do Next