Running data movement between Db2 Warehouse and MapR

You can run data movement between Db2® Warehouse and the MapR platform.

Before you begin

Install IBM® Fast Data Movement on MapR. Use an additional parameter when installing to specify the mapr user:
./fast_data_movement_install.sh --hdfs_user mapr

About this task

Data movement between Db2 Warehouse and MapR can only be run from Hadoop and it works for TXT and Hadoop-specific formats.

Procedure

To run data movement in TXT, PARQUET, ORC, RCFILE, or AVRO format:
  1. Define the configuration in the import or export XML file. Define the data format in fq.data.format and MapR credentials in: 
     <property>
        <name>fq.sql.user</name>
        <value>mapr</value>
        <description>User name. Required if User/Password authentication should be used. </description>
    </property>
    <property>
        <name>fq.sql.password</name>
        <value>mapr</value>
        <description>Password. Required if user name was provided.</description>
    </property>
  2. Run the following command: 
    fdm.sh -conf /fastDataMovement/fq-export-remote-conf.xml