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:

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
  • 2 for User Name
  • 3 for User Name And Password
  • 6 for Hadoop Delegation Token

Example:

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