Data Migration using DataStage 8

mydsworld · Post by **mydsworld** » Mon May 12, 2008 9:04 pm

In a data migration project,data needs to be transferred from Legacy to SAP and vice versa.Please let me know the data control mechanism :

1. For data transfer from SAP to Legacy (through Idoc,flat file etc), how to mark the end of a batch transaction (like trigger files or any other method).

2. For data transfer from Legacy to SAP (through flat file,MQ etc), how to mark the end of transaction.

Thanks.

vmcburney · Post by **vmcburney** » Wed May 21, 2008 12:02 am

You have to decide whether you are using SAP PI or DataStage for extracts - with DataStage you'll need the Extract PACK for SAP to get access to iDOCs and ABAP etc. I don't know what you mean by marking the end of a transaction. You need to choose a scheduling tool - either an enterprise one like Control-M or the DataStage one. Control-M would call DataStage jobs and handle the triggering and notification when it finishes.

For legacy into SAP via MQ you should look at the DataStage MQ connector for turning flat files or database content into MQ messages.