Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Reporting Tool

Solved Go to solution
Highlighted

Reporting Tool

New Contributor

Dear Community,

I finally was able to work and manage my twitter analysis using NiFi + Hortonworks. Now that i've accomplished my data source, i would like to create a nice report output.

got a suggestion?

ps: I used to work with Bi Publisher.

Regards

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Reporting Tool

@CriCL

Try Zeppelin notebook. Here is a basic example of ingesting data from a source via NiFi, store it to Hive and access it via Zeppelin:

https://community.hortonworks.com/articles/87230/customer-demographics-demo-with-apache-nifi-hive-a-...

There are several good notebooks in HDP sandbox, but also Github. That is if you stored your data in HDFS or HBase and you wanted to see how to report on it with Zeppelin.

Other notebooks can be also connected to HDP, e.g. iPython or Jupyter.

5 REPLIES 5

Re: Reporting Tool

@CriCL

Try Zeppelin notebook. Here is a basic example of ingesting data from a source via NiFi, store it to Hive and access it via Zeppelin:

https://community.hortonworks.com/articles/87230/customer-demographics-demo-with-apache-nifi-hive-a-...

There are several good notebooks in HDP sandbox, but also Github. That is if you stored your data in HDFS or HBase and you wanted to see how to report on it with Zeppelin.

Other notebooks can be also connected to HDP, e.g. iPython or Jupyter.

Re: Reporting Tool

New Contributor

Hi @Constantin Stanca Thanks for replying. I've tried Zeppeling and his Notebooks, but what i need is to create my own layouts and finally export to pdf, xls or even rtf.

Regards

Re: Reporting Tool

New Contributor

@CriCL

I am not sure why wouldn't you be able to create your layout with any of the notebooks, e.g. Zeppelin, iPython or Jupyter and print to output to PDF use a PDFWriter driver to print to, for example.

Also, you can use the BI of your choice as long as it can use JDBC or ODBC access to Hive or Phoenix for HBase, for example. You could also point R Studio to Hive and you can render your report to PDF using markup available in R.

When you say "I want to create my own layouts" could you be more specific ... What is missing?

Re: Reporting Tool

@CriCL

Got you. I like to use R Studio connected to HDP and use markdown language to generate PDF files: http://rmarkdown.rstudio.com/pdf_document_format.html

True. This is more a tool for data science.

On the other hand any tool that you like and can use ODBC or JDBC can connect to Hive or to HBase via Phoenix. Try that approach.

Re: Reporting Tool

New Contributor

Excellent!!

This is what i wanted. Thanks

Don't have an account?
Coming from Hortonworks? Activate your account here