Step 1 : Start the rest server in Hortonworks Linux machine
/usr/hdp/2.2.6.0-2800/hbase/bin/hbase-daemon.sh start rest -p 9768
Note: 9768 is port I have selected. make sure this port is free in your machine or else use a different port.
Step 2 : Download Simba ODBC Driver (in Windows Machine, where your tableau server is)
http://www.simba.com/connectors/apache-hbase-odbc
Step 3 : Install it.
Step 4 :
Go to path highlighted in Yellow -> Add your Public Virtual IP ( you can get it from Azure VM - Dashboard) . Enter port as used in command in step 1.
Step 5 : If you are using Azure , make sure in endpoints you have opened 9768 port.
Step 6 : Test the connection, it should show list of tables.
Step 7 : Connect with tableau using Other ODBC Connection. Select Simba as DNS and provide Server.
Step 8 : If it doesn't work, make sure you have copied Simba licence file, which you received in email to the installed location. (C:\Program Files\Simba HBase ODBC Driver\lib)
/usr/hdp/2.2.6.0-2800/hbase/bin/hbase-daemon.sh start rest -p 9768
Note: 9768 is port I have selected. make sure this port is free in your machine or else use a different port.
Step 2 : Download Simba ODBC Driver (in Windows Machine, where your tableau server is)
http://www.simba.com/connectors/apache-hbase-odbc
Step 3 : Install it.
Step 4 :
Go to path highlighted in Yellow -> Add your Public Virtual IP ( you can get it from Azure VM - Dashboard) . Enter port as used in command in step 1.
Step 5 : If you are using Azure , make sure in endpoints you have opened 9768 port.
Step 6 : Test the connection, it should show list of tables.
Step 7 : Connect with tableau using Other ODBC Connection. Select Simba as DNS and provide Server.
Step 8 : If it doesn't work, make sure you have copied Simba licence file, which you received in email to the installed location. (C:\Program Files\Simba HBase ODBC Driver\lib)
No comments:
Post a Comment