IBM Lift supports two cloud data properties today.

Source Target
IBM PureData for Analytics, CSV file set IBM Db2 Warehouse on Cloud (formerly dashDB)
DB2 for Linux, UNIX and Windows, CSV file set DB2 on Cloud


Use the Lift CLI to Migrate PureData System for Analytics Data to Db2 Warehouse on Cloud

Learn how to migrate data from IBM PureData System for Analytics to Db2 Warehouse on Cloud using the IBM Lift CLI.


Get Going with IBM Cloud Lift

Note: The following videos show the IBM Cloud Lift user interface which will be sunset on March 30, 2018.

Step 1: Set up a Secure Gateway connection.
Every source database connection requires that you set up a Secure Gateway. This is IBM’s point-to-point VPN technology, and it allows our cloud service to reach into your on-premises database. When creating your source database connection, you will be asked to specify this Secure Gateway connection. Check out this video for step-by-step instructions for setting up Secure Gateway.

Step 2: Migrate your first data set

Step 3: Optionally, learn how to user our Lift Data Load API to integrate data migration capabilities into your apps or scripts.
Learn how to use our Lift Data Load API to integrate data migration capabilities into your apps or scripts.



Set up a Secure Gateway Connection

Learn how to set up a secure gateway as the first step to migrating your data to Db2 Warehouse on Cloud by using IBM Cloud Lift.



Migrate CSV Data to Db2 Warehouse on Cloud

Learn how to migrate your CSV data to Db2 Warehouse on Cloud using IBM Cloud Lift.

Try it for yourself!

For a quick test, you may download the sample data shown in this video, bluemix-lift-sample-files.zip, containing the following files:

  • The DDL file: traffic_violations_md.sql
  • The data file: TRAFFIC_VIOLATIONS_MD.csv

Copy the TRAFFIC_VIOLATIONS_MD.csv file to your Slingshot data directory with a subdirectory specifying the schema. For example, if you want the data to end up in table "SAMPLE"."TRAFFIC_VIOLATIONS_MD" then copy the file to &ltslingshot data directory&gt/SAMPLE/TRAFFIC_VIOLATIONS_MD.csv.

More resources

Read the migration guide (PDF)

Read how to set up the CSV directory (PDF)



Migrate PureData System for Analytics Data to Db2 Warehouse on Cloud

Learn how to migrate data from IBM PureData System for Analytics to Db2 Warehouse on Cloud using IBM Cloud Lift.

More resources



Migrate Data with the Lift Data Load API

The IBM Cloud Lift Data Load API allows you to perform your migration from on-premises sources to targets on the
cloud. For details on the Lift Activities API, go here.
▼Learn More

1 comment on"Migrate"

  1. Lift asks for source table name , Is there a way to extract all tables in one go?

Join The Discussion

Your email address will not be published. Required fields are marked *