question Re: Reporting Tool in Archives of Support Questions (Read Only)

Reporting Tool

cristianvlean — Fri, 16 Sep 2022 11:12:34 GMT

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

Re: Reporting Tool

cstanca — Tue, 07 Mar 2017 10:10:43 GMT

@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-1.html

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

cristianvlean — Tue, 07 Mar 2017 10:23:21 GMT

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

demerovb — Tue, 07 Mar 2017 10:53:36 GMT

@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

cstanca — Wed, 08 Mar 2017 01:00:32 GMT

@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

cristianvlean — Wed, 08 Mar 2017 09:35:38 GMT

Excellent!!

This is what i wanted. Thanks