Support Questions

Find answers, ask questions, and share your expertise

Reporting Tool

avatar
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

avatar
Super Guru

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

View solution in original post

5 REPLIES 5

avatar
Super Guru

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

avatar
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

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

avatar
Super Guru

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

avatar
Contributor

Excellent!!

This is what i wanted. Thanks