Reporting Tool

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

@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?

[#5]

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

[#6]

Excellent!!

This is what i wanted. Thanks