< Previous | Next >

SQL Replication to InfoSphere DataStage tutorial

Learn how to integrate SQL Replication and InfoSphere® DataStage® to provide a real-time data feed that you can use to create dynamic data warehouses.

Learning objectives

After you complete this tutorial, you will know how to:
  • Set up SQL Replication between two DB2® databases by using ASNCLP command scripts
  • Use the ASNCLP program to generate DataStage definition files for creating DataStage jobs
  • Create a DataStage project and data connection
  • Import table definitions from DB2 into DataStage
  • Compile and run a DataStage job
  • Browse the contents of a data set to verify end-to-end integration

Time required

Two to three hours
< Previous | Next >