How to Connect Hadoop into Qlikview?

    How to Connect Hadoop into Qlikview?


    Step 1: Install “MapR Hive ODBC Connector 64 bit” from this link.

    (http://package.mapr.com/tools/MapR-ODBC/MapR_Hive/MapRHive_odbc_2.1.8.1005/Windows/MapRHiveODBC64.msi)

     

    Note: QlikView must be 64 bit.

     

    Step 2:  Create “Data Sources Name” from ODBC 64 bit Administration.

    Administrative Tools --> ODBC Data Sources (64-bit)

     

    2.jpg

     

    Step 3: Click Add button in User DSN tab.

     

    3.jpg

     

    Step 4: Select “MapR Hive ODBC Connector” and Click Finish. It will appear "MapR Hive ODBC Connector DSN Setup" box.

     

    4.jpg

     

    Step 5: In "MapR Hive ODBC Connector DSN Setup" box,

                Enter Data Source Name as “XXXXXX”.

                Host Name: Give your IP Address.

                Database: Enter your Database name.

                User Name: Give your Database user name.

     

    Step 6: Click Test Button.

    If Test is success,

    5.jpg

     

     

    Click OK.

     

    Step 7: Open Qlikview 64 bit.

    Step 8: Go "Edit Script". File --> Edit Script.

    In bottom of the Edit Script,

    Database select ODBC.

    Force 32Bit is Uncheck.

     

    Click Connect.

     

    10.jpg

     

    Step 9: Select your Data Sources. “Show user DSNs” is Check.

    Enter your user id and password.

    Click “Test Connection...”

    Click OK.

     

    It will generate the Connection String Like this,

     

    ODBC CONNECT TO "Data Sources name" (XUserid is XXXXXX, XPassword is XXXXXX);

     

    You have to change like this,

     

    ODBC CONNECT TO [DataSourcesname;Host=xxxxxx;Port=xxxxxxx] (XUserid is XXXXXX, XPassword is XXXXXX);


    Reload the qwv and save.


    Click Select and you will get Database details in QlikView.

     

    --------------------------------------------------------------------------------------------------END-----------------------------------------------------------------------------------------------