Use Case Accelerators > Using DataFunnel to Bulk Load DB2 and SQL Server Data to HDFS

Using DataFunnel to Bulk Load DB2 and SQL Server Data to HDFS

Article #: Product: Version:

Summary

DMExpress DataFunnel is a command-line tool that can rapidly transport large volumes of data from relational databases to a variety of different data stores in a single command. It uses a simple JSON configuration file to define the set of data transfers to be executed.

In this use case accelerator, DataFunnel is used to transfer data from two relational databases - SQL Server and DB2 for z/OS - into flat files residing on HDFS.

Resolution

Using DataFunnel is a two-step process:

Attachments

428_Data_Funnel_conf.json

Additional Information

Last updated: