1 / 17

How to Connect Microsoft Power BI with Hive?

Learn how to connect Microsoft power BI with Hive into few steps. Go through our presentations and follow these simple steps for connection. For any query, contact u2013 Emorphis Technologies. Click here- http://bit.ly/2z4h1kD

emorphistechno
Download Presentation

How to Connect Microsoft Power BI with Hive?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to Connect Microsoft Power BI with Hive? Emorphis Technologies www.emorphis.com

  2. Hive is a prominent open source data warehouse built on Hadoop’s Distributed File System (HDFS). It is used for – data storage, data summarization, data query and analysis on large data systems.  www.emorphis.com

  3. System Architecture Snapshot: www.emorphis.com

  4. Simple Step to Connect Power BI to Hive Downloading & installing ODBC drivers Mainly there are two below version of ODBC available for the window. • HortonworksHiveODBC32.msi for 32-bit processors • HortonworksHiveODBC64.msi for 64-bit. www.emorphis.com

  5. Simple Step to Connect Power BI to Hive Configuring the ODBC driver • Create a Data Source Name (DSN) • Click on the Start button • Click on All Programs • Click on the Hortonworks Hive ODBC Driver 1.2 (64-bit) on program group. • Click on the 64-bit ODBC Administrator. The ODBC Data Source Administrator window opens. www.emorphis.com

  6. Simple Step to Connect Power BI to Hive Configuring the ODBC driver • Create a Data Source Name (DSN) • Click on the Start button • Click on All Programs • Click on the Hortonworks Hive ODBC Driver 1.2 (64-bit) on program group. • Click on the 64-bit ODBC Administrator. The ODBC Data Source Administrator window opens. www.emorphis.com

  7. Simple Step to Connect Power BI to Hive A window as shown below opens: www.emorphis.com

  8. Simple Step to Connect Power BI to Hive In the User DSN tab click on the Add button. A window opens as shown below. Select Hortonworks Hive ODBCDriver as highlighted in blue and the click on the finish button. www.emorphis.com

  9. Simple Step to Connect Power BI to Hive For configuration purpose, follow the procedure mentioned below: • Give data source a name / title • Description (optional though suggested) • Select ‘hive server 2’ • In service discovery mode select ‘No service Discovery’ • In the host section provide an IP address of the host machine on which hive server is running • For hive – port is 10000 • In the database section specify the database you want to connect. (optional) • Choose hive username • Choose SASL in Thrift Transport www.emorphis.com

  10. Simple Step to Connect Power BI to Hive Now click on the test button to check the connection is valid or not.  If the connection is successful, then it will show the window:  www.emorphis.com

  11. Simple Step to Connect Power BI to Hive After successful test click OK to save the configuration. It will show the DSN in the User DSN (User data sources). www.emorphis.com

  12. Simple Step to Connect Power BI to Hive Configuring Power BI • Now open Power BI tool and select ODBC from Get data. Select the DSN we defined from the DSN drop down and click on OK. • It will navigate you to a different panel where you have to select the Hive.

  13. Simple Step to Connect Power BI to Hive Connecting Hive with Power BI Now open Power BI tool and select ODBC from Get data. Select the DSN we defined from the DSN drop down and click on OK. www.emorphis.com

  14. Simple Step to Connect Power BI to Hive Connecting Hive with Power BI • It will navigate you to a different panel where you have to select the Hive. www.emorphis.com

  15. Simple Step to Connect Power BI to Hive Now all the hive database & schema will be visible. www.emorphis.com

  16. Simple Step to Connect Power BI to Hive Now you can connect & load the data for analysis & create powerful visualizations. Make sure Hive users have an appropriate permission else you may get permission error. www.emorphis.com

  17. Contact us www.emorphis.com Email- sales@emorphis.com Resource - https://blogs.emorphis.com/how-to-connect-microsoft-power-bi-with-hive/

More Related