Other options
For the bulk/batch transfer of data from RDBMS to the Hadoop filesystem there aren't many options in the open source world. However, there are possible choices whereby we could transfer data from RDBMS to Hadoop, and this section tries to give you the reader some possible options so that, according to enterprise demands, they can be evaluated and brought into the data lake as technologies if found suitable.
Native big data connectors
Most of the popular databases have connectors, using which data can be extracted and loaded onto the Hadoop filesystem. For example, if your RDBMS is Oracle, Oracle provides a suite of products which integrate the Oracle database with Apache Hadoop. The figure below (Figure 09) shows the full suite of Oracle Big Data connector products and what they do (details taken from www.oracle.com).
Figure 25: Oracle Big Data connector suite of products
Similar to Oracle, MySQL RDBMS has MySQL Applier, which is the native big data connector which can be used...