KB47717: "Insufficient information to connect to the data source" error message appears when creating a DSN in MicroStrategy Connectivity Wizard using command line against a HIVE database in MicroStrategy 9.x/10.x

• Strategy

This article explains a situation where error message "Insufficient information to connect to the data source." might display when connecting to a HIVE database.

SYMPTOM:
A user tries to create a DSN to a Hive database in command line. When a user enters the command './mstrconnectwiz -console', they see the following syntax:

Upon entering the DSN information, the user gets the following error message:


Insufficient information to connect to the data source.

CAUSE:
One possible cause is that the syntax to create a Hive DSN is incorrect. Specifically, it is missing the username and password to the database.
ACTION:
The correct syntax to create a DSN to a Hive database in command line is the following:
./mstrconnectwiz HIVE DataSourceName HostName PortNumber DatabaseName
For example,
./mstrconnectwiz HIVE name_of_DSN 11.11.11.11 1433 DatabaseName -u:username -p:password

47717 KB47717

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

December 31, 2018