Created 02-11-2019 10:44 AM
Hi,
I have a dashboard for reporting. I wan to create customized report from the data stored in hive. when user selects some parameters and based on that parameter the data should be fetch from Hive and report will be generate by reporting tool.
This is possible or not ? If yes than how can i achieve ?
Thank you.
Created on 02-11-2019 11:37 AM - edited 08-17-2019 02:36 PM
What BI tool are you using? Depending on the tool you will need to create a role with select privilege on that underlying database and give that role to the user to generate the report.
Most BI tools use ODBC/JDBC to connect with hive you can using LDAP to manage the groups who can create dashboards makes the work the users/groups more manageable.
Powerful Hortonworks Hive ODBC driver from progress
HTH
Created 02-12-2019 07:15 AM
I am using SSRS. I am trying to connect Hortonworks Hive ODBC driver to connect Hive with SSRS. But i am facing some issue.
Created 02-12-2019 07:17 AM
When i need to accept some parameter from third party application/portal and needs data from hive based on that parameter how can i perform ?