MicroStrategy ONE

How to Connect to OData (CData Driver)

On this page, learn about supported authentication, prerequisites, installation, and enabling the CData OData ODBC driver feature via MicroStrategy Web.

Supported Authentication

The CData OData ODBC driver has been tested with basic authentication which involves a username, password, and the service URL.

The following authentication methods have not been tested with the CData OData ODBC driver:

  • NTLM
  • Kerberos
  • SAML Bearer Assertion (OAuth2.0)

Prerequisites

MicroStrategy Secure Enterprise should be installed and configured, including an instance of MicroStrategy Developer, MicroStrategy Web, and the MicroStrategy Intelligence Server.

CData OData ODBC Driver 2019 should be downloaded.

Installation

Install CData OData ODBC Driver 2019 on each Intelligence Server in the cluster.

For Windows

  1. Install the driver and accept the prompts for installing libraries.

  2. Select the Configure ODBC Data Source checkbox.
  3. Click Finish.
  4. Add the URL of the OData service, user, and password.
  5. Select Basic for the Auth Schema.
  6. Click Test Connection.

For Linux

Install the driver on RHEL7.6 or Amazon Linux

  1. Download the CData OData driver in the Intelligence Server.

  2. Run the following commands:

    Copy 
    sudo yum install glibc libstdc++ zlib libgcc

    To install the required libraries:

    Copy 
    sudo rpm -ivh ./ODataODBCDriverforUnix.rpm

    This will install the driver in /opt/cdata/cdata-odbc-driver-for-odata.

  3. To activate the driver, go to the directory, /opt/cdata/cdata-odbc-driver-for-odata/bin.

  4. Run the following command to run the License Manager:

    Copy 
    sudo ./install-license.x64 
  5. Enter your credentials when prompted.

Update the driver encoding format

When connecting to SAP Gateway OData services, which uses the UTF-8 encoding format, you must update the driver encoding format.

  1. Go to the directory, /opt/cdata/cdata-odbc-driver-for-odata/lib/.

  2. Update the cdata.odbc.odata.ini file to reflect the following:

    Copy 
    DriverManagerEncoding = UTF-8

Enable the CData OData ODBC Driver Feature

  1. Log in to MicroStrategy Web as an administrator.
  2. In the top right corner, click on the username > Prederences.
  3. From the left panel, navigate to Project Defaults.
  4. At the bottom of the page, locate OData (CData Driver) and set the feature status to On.
  5. Click Apply.
  6. Return to the project page and click Create > Add External Data.

  7. In the Data Import dialog, verify that the OData icon is visible to the user.