...
Deploy IBM DB2 plugins from Hub.
Go back to Hub again and find the DB2 plugins under plugins section.
Click on the DB2 plugins and then Deploy them on the Cloud Data Fusion instance.
Once plugins are deployed, click on Create Pipeline to go to Data pipeline studioPipeline Studio.
Create data pipeline.
Select the IBM DB2 source from the list of sources.
Configure the DB2 plugin by clicking on the properties. Provide the basic configurations as follows:
where,
Driver name: Name of the driver provided while uploading the DB2 driver.
Host: Host where the DB2 server is running.
Port: Port of DB2 server.
Database: Name of the DB2 database.
Import Query: Select query to import data from the DB2 table.
Also provide credentials required to connect to the DB2 server.
Once the details are filled in, click on the GetSchema button followed by Execute to import schema from the source table as:
Click Apply to use this schema as an output schema for the plugin.
Click on the sink and choose BigQuery sink.
Configure BigQuery sink as below specifically by providing the Dataset and Table name as:
Click on Deploy once the pipeline is built.
Run the data pipeline.
Click on Run to run the pipeline.
...