Apache Drill is certified with the MicroStrategy Analytics Enterprise Platform™. You can connect MicroStrategy Analytics Enterprise to Apache Drill and explore multiple data formats instantly on Hadoop. Use the combined power of these tools to get direct access to semi-structured data without having to rely on IT teams for schema creation.
Complete the following steps to use Apache Drill with MicroStrategy Analytics Enterprise:
Drill uses standard ODBC connectivity to provide you with easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version is compatible with the Apache Drill version that you use.
Ideally, you should upgrade to Drill 0.7, which uses the v0.07.0.0608 version of the driver. Earlier versions of Drill use the v0.07.0.0600 ODBC driver version located at:
http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.07.0.0600/
Complete the following steps to install and configure the driver:
Download the driver from the following location:
http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.07.0.0608/MapRDrillODBC32.msi
Note: Use the 32-bit Windows driver for MicroStrategy 9.4.1.
Complete steps 2-8 under Installing the Driver on the following page:
https://cwiki.apache.org/confluence/display/DRILL/Using+the+MapR+ODBC+Driver+on+Windows
Complete the steps on the following page to configure the driver:
Note: Verify that you are using the 32-bit driver since both drivers can coexist on the same machine.
a. Verify the version number of the driver.
b. Click Test to verify that the ODBC configuration works before using it with MicroStrategy.
The steps listed in this section were created based on the MicroStrategy Technote for installing DBMS objects which you can reference at:
Complete the following steps to install the Drill Object on MicroStrategy Analytics Enterprise:
MapR_Drill.PDS
. When you get this file, store it locally in your Windows file system.MicroStrategy Analytics Enterprise can now access Apache Drill.
Complete the following steps to use the Database Instance Wizard to create the MicroStrategy database connection for Apache Drill:
You can now use MicroStrategy Analytics Enterprise to access Drill as a database instance.
This step includes an example scenario that shows you how to use MicroStrategy, with Drill as the database instance, to analyze Twitter data stored as complex JSON documents.
The Drill distributed file system plugin is configured to read Twitter data in a directory structure. A view is created in Drill to capture the most relevant maps and nested maps and arrays for the Twitter JSON documents. Refer to the following page for more information about how to configure and use Drill to work with complex data:
https://cwiki.apache.org/confluence/display/DRILL/Query+Data
Complete the following steps to create a project:
Complete the following steps to create a Freeform Report and analyze data:
You can see that there are three major sources for the captured tweets. You can change the view to tabular format and apply a filter to see that iPhone, Android, and Web Client are the three major sources of tweets for this specific data set.
In this scenario, you learned how to configure MicroStrategy Analytics Enterprise to work with Apache Drill.
MicroStrategy announced post certification of Drill 0.6 and 0.7 with MicroStrategy Analytics Enterprise 9.4.1