Skip to main content
Skip table of contents

MicroStrategy Developer - Create JDBC Database Connection

Prerequisite

  • A JDBC Hive driver must be installed on the MicroStrategy server.

Set a JDBC Database Connection

Create a connection

Using the MicroStrategy Developer, the administrator needs to create a "fake" ODBC connection that will be changed to a JDBC connection.

  • Step 1 : Create an OBDC datasource
  • Step 2 : Change the connection string
    • 2a. Go to the advanced tab of the Database Connections window

  • 2b. Modify the connection string in the Additional connection string parameters. Copy the following line, fill the value surrounded by <>, then paste it. Parameters are defined as shown below:
CODE
JDBC;DRIVER={com.microstrategy.hive.jdbc41.HS2Driver};
URL={jdbc:hive2://<serveraddress>:<port>;UseNativeQuery=1;hive.resultset.use.unique.column.names=false;AuthMech=<AuthMechvalue>;};

Define connection parameters

  • <serveraddress>: Server Address of the (one of the) master node
  • <port>: Port number (by default is 10000)
  • <AuthMechvalue>: Authentication mechanism. Set the property to one of the following values (more information here):
    • 0 for No Authentication
    • 1 for Kerberos
    • for User Name
    • 3 for User Name And Password
    • 6 for Hadoop Delegation Token

Example:

CODE
JDBC;DRIVER={com.microstrategy.hive.jdbc41.HS2Driver};
URL={jdbc:hive2://indexima.io:10000;UseNativeQuery=1;hive.resultset.use.unique.column.names=false;AuthMech=3;};



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.