In order to authenticate, set the following connection properties:
Set URL to the JDBC URL for the HDFS driver, setting the necessary connection properties. #Hortonworks jdbc driver for mac driver
(C:\Program Files\CData JDBC Driver for HDFS\lib\ on Windows.)
Set MSTR_JDBC_JAR_FOLDER to the path of the JAR file for the JDBC driver. Add the JDBC keyword to the connection string. Set the connection string as follows and click OK:. (MicroStrategy requires a certified driver to interface through JDBC the actual driver will not be used.) In the Driver menu, select MicroStrategy Cassandra ODBC Driver. Click the link to show the connection string and opt to edit the connection string. Choose Generic in the Database menu and Generic DBMS in the Version menu. Add a new data source and choose the DSN-less data sources option. In the datasets panel, click New Data, select Databases, and choose Select a Table as the Import Option. Open MicroStrategy Desktop and create a new dossier. Follow the steps below to add HDFS data as a dataset using JDBC and create visualizations and reports of HDFS data. In addition to connecting to HDFS in MicroStrategy enterprise products, you can connect to HDFS in MicroStrategy Desktop. With built-in dynamic metadata querying, you can use native MicroStrategy data types to visualize and analyze HDFS data.Ĭonnect to and Visualize HDFS Data using MicroStrategy Desktop 
When you issue complex SQL queries from MicroStrategy to HDFS, the driver pushes supported SQL operations, like filters and aggregations, directly to HDFS and utilizes the embedded SQL engine to process unsupported operations (often SQL functions and JOIN operations) client-side. The CData JDBC Driver offers unmatched performance for interacting with live HDFS data in MicroStrategy due to optimized data processing built into the driver. In this article, we walk through adding HDFS as a data source in MicroStrategy Desktop and creating a simple visualization of HDFS data.
When you pair MicroStrategy with the CData JDBC Driver for HDFS, you gain database-like access to live HDFS data from MicroStrategy, expanding your reporting and analytics capabilities. MicroStrategy is an analytics and mobility platform that enables data-driven innovation.
0 kommentar(er)
