How to Register the MicroStrategy Hadoop Gateway

Registering MicroStrategy Hadoop Gateway stores the configuration of the MicroStrategy Hadoop Gateway in the Intelligence Server environment. In this stage, you define the operation mode and connectivity parameters.

How to Browse the Hadoop Distributed File System and Preview Files

1. Log into MicroStrategy Web.
2. Click Create > Add External Data.
3. In the Connect your Data dialog, click Hadoop.

   

4. Select Browse Hadoop Files using MicroStrategy Big Data Engine when "Select Import Options" form appears.

   

5. Click Next. The "Connect to Hadoop" form appears with the HDFS file browser.
6. In Hadoop File Browser entry, click Change Connection on top of screen.

   

7. Select Edit connection string to enable connection string modification.

   

8. Make sure you configure appropriate Hadoop NameNode IP/Host and port in the connection string.

   Hadoop NameNode IP address is: 10.242.109.2, and HDFS port number is by default: 8020. The MicroStrategy Hadoop Gateway is deployed on host IP: 10.242.109.10 with port: 30005 (port can be configured in MicroStrategy Hadoop Gateway configuration file). The connection string for the above data should look like this:

   Copy

   hadoopName=10.242.109.2;hdfsPort=8020;BDEIP=10.242.109.10;BDEPORT=30005;

If Hadoop NameNode High Availability Has Been Enabled

1. Ask your Hadoop cluster administrators about the HDFS nameservice.
2. Replace the attribute hadoopName with hadoopNameService in the connection string, and remove the attribute hdfsPort.

   Here, the HDFS nameservice is "nameservice1" in the cluster. The connection string should look like this:

   Copy

   hadoopNameService=nameservice1;BDEIP=10.242.109.10;BDEPORT=30005;

   All of attributes in the connection string are case sensitive.

3. Click OK to save connectivity parameters and finish MicroStrategy Hadoop Gateway registration. HDFS folders and files will appear if everything has been configured properly.

Once the MicroStrategy Hadoop Gateway is running, the Import Data feature can be used to import data as an Intelligent Cube for data consumption.

Related Topics

Introduction to the MicroStrategy Hadoop Gateway

Environment Considerations

How to Deploy the MicroStrategy Hadoop Gateway

How to Start the MicroStrategy Hadoop Gateway

Troubleshooting

Known Issues

Frequently Asked Questions