Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In the [ODBC Drivers] section, add a new line by typing 'JethroODBCDriver' as a name for the driver, an equal sign (=), and then 'Installed':

    Code Block
    [ODBC Drivers]
    JethroODBCDriver=installed
  2. Create a section that has the same name as the driver (as specified in the previous step - JethroODBCDriver), and then specify the following configurations:

    Code Block
    [JethroODBCDriver]
    APILevel=1
    ConnectFunctions=YYY
    Description=64-bit JethroData DSII
    Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.so
    DriverODBCVer=03.8090
    SQLLevel=1
  3. Connect to your instance by providing your application with a connection string. The elements format of the connection string is:

...

  1. Edit /var/opt/MicroStrategy/env/ODBC.sh
    Add the following lines of code at the end of the script:
    SIMBAINI='/opt/jethro/jethroodbc/conf/JethroODBC.ini'
    export SIMBAINI
  2. Use MicroStrategy connectivity wizard to create a DSN, using "MySql ODBC 5.x Driver" data base type. You will be required to provide the location of Jethro's driver. 
    The location is: /opt/jethro/jethroodbc/lib/libJethroODBC64.so
  3. Alternatively, you can manually edit the MSTR odbc.ini file: /var/opt/Microstrategy/odbc.ini, and insert the DSN information manually:
    1. Under [ODBC Data Sources] add: yourdsnname=MySQL ODBC 5.x Driver
    2. Create a new DSN paragraph as explained above, for example:

      [yourdsnname]
      DriverUnicodeType=1
      Description=MySQL ODBC 5.x Driver
      PORT=9111
      DATABASE=tpcds
      CHARSET=utf8
      SERVER=12.34.56.789
      OPTION=2
      SOCKET=
      Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.so

    3. edit odbcinst.ini and add the following line under [ODBC Drivers]:
      JethroODBCDriver = Installed
    4. add another paragraph:

      [JethroODBCDriver]
      APILevel=1
      ConnectFunctions=YYY
      Description=64-bit JethroData DSII
      Driver=/opt/jethro/jethroodbc/lib/libJethroODBC64.so
      DriverODBCVer=03.8090
      SQLLevel=1
      Setup=/opt/jethro/jethroodbc/lib/libJethroODBC64.so