Moving data from system A to system B

This is pretty old age problem to be solved in majority of projects.

History: It comes under Flow based programming: https://en.wikipedia.org/wiki/Flow-based_programming

Scope:
Our focus is to move data from system A to system B. Only Extraction and Loading. Not much about Transformations.

———————————
Option 0: Hand coding in Python / Java / PERL …etc
This is good for small sets of data. Also good for POC.
Not suggested to push to production without failover, managing jobs, scheduling jobs,…etc

———————————

Option 1: If system is heavy and need robust solution, better to go with Apache NiFi
https://nifi.apache.org/

The US National Security Agency open-sourced its Niagrafiles, or NiFi, data-flow software.
https://en.wikipedia.org/wiki/Apache_NiFi

How to enable security for NiFi?
http://ijokarumawak.github.io/nifi/2016/11/15/nifi-auth/

How to write Java code for NiFi and other languages?
https://community.hortonworks.com/questions/75977/run-java-code-in-apache-nifi.html

Other directory with date suffix examples
https://community.hortonworks.com/questions/44215/is-there-a-processor-in-nifi-that-can-create-many.html

Commercial support available:
https://hortonworks.com/apache/nifi/

Versioning available:
https://community.hortonworks.com/questions/61475/nifi-workflow-version-control-deployment.html

Externalizing variables possible.
Easy to move configurations from QA to Prod

We can slim down the system to minimize its foot print
https://community.hortonworks.com/articles/32605/running-nifi-on-raspberry-pi-best-practices.html

NiFi support Hadoop HDFS
https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi.processors.hadoop.PutHDFS/

Alternatives:
http://storm.apache.org/index.html
But Storm objective is different.

———————————

Option 2: Use streaming API of Apache Spark
http://spark.apache.org/docs/latest/streaming-programming-guide.html
Sqoop Vs Flume
https://www.dezyre.com/article/sqoop-vs-flume-battle-of-the-hadoop-etl-tools-/176

———————————

Option 3: If you are using CDAP, better to use Hydrator to generate JSON and use it.
Bit more study required around metrics, management and tracking these jobs.
http://docs.cask.co/cdap/4.1.0/en/developers-manual/pipelines/developing-pipelines.html

https://github.com/cdap-guides/cdap-etl-guide
http://blog.cask.co/2016/06/bringing-relational-data-into-data-lakes/

Better to stay away from CDAP stack. There is not much public acceptance. No response on their forums. If we ask question, they wont respond. If we call them, they will ask us to buy their support/consulting hours. Nothing wrong in this. But we can’t afford.
http://cask.co/support/

We can check their poor support in their groups
https://groups.google.com/forum/#!forum/cdap-user

———————————

Option 4: Pentaho Kettle
http://wiki.pentaho.com/display/BAD/Kettle+on+Spark
It is not ready for Big Data as on March 2017
Good for small java enterprise projects (Coding required with Kettle API). Used in the past.
http://javadoc.pentaho.com/kettle/ – Java documentation quality is not good.
https://community.hortonworks.com/questions/24014/what-is-the-difference-between-nifi-and-kettle.html

———————————

Option 5: Commercial products

https://www.talend.com/
http://www.robertomarchetto.com/talend_studio_vs_kettle_pentao_pdi_comparison
https://streamsets.com/

http://www.alteryx.com/ is good product and it is having better support with https://www.tableau.com/ (BI/Analytics)

———————————

Option 6: Spring Batch

If we want to minimize number of servers, we want minimal solution, Spring Batch is good one.
But it needs continuous maintenance when there is change in Spring / Java version.

Spring Integration: http://docs.spring.io/spring-integration/reference/html/ftp.html
Spring batch partitioning: https://keyholesoftware.com/2013/12/09/spring-batch-partitioning/
Spring Batch Reference: http://docs.spring.io/spring-batch/reference/html/index.html
Spring Batch UI: http://docs.spring.io/spring-batch-admin/reference/reference.xhtml

———————————

Conclusion:
Use Apache NiFi as much as possible. Works well in production and also quick in POCs

As on March 11 2017: https://groups.google.com/forum/#!topic/cdap-user/hiuUP3jIxNs
CDAP Hydrator is not in a position to compete with Apache NiFi
-0-

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s