IBM Cloud 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


Get Going with Lift

We’ve put out a number of how-to videos to help you get started with migrating data into Db2 Warehouse on Cloud.

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

Join The Discussion

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