Wednesday, July 05, 2017

How to Automatically Migrate All Tables From a Database to Hadoop With No Coding

DZone Database Zone
How to Automatically Migrate All Tables From a Database to Hadoop With No Coding

A company wants to know when new tables are added to a JDBC source (say an RDBMS). Using the ListDatabaseTables processor, we can get a list of tables (also views, system tables, and other database objects), but for our purposes, we want tables with data. I have used the ngdbc.jar from SAP HANA to connect and query tables with ease.

For today's example, I am connecting to MySQL, as I have a MySQL database available for use and modification.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...