Loading SAP data through DataStage
Moderators: chulett, rschirm, roy
Loading SAP data through DataStage
Please let me know the methods (datastage plug-ins) for loading SAP data keeping in the mind :
1. Huge volume of data
2. Less volume of data.
Please let me know which SAP plug-in is to be used in which case.
Thanks.
1. Huge volume of data
2. Less volume of data.
Please let me know which SAP plug-in is to be used in which case.
Thanks.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
There is a SAP plugin stage for DataStage parallel jobs that can read from a SAS dataset, write to a SAS dataset and run a SAS program. So you could for example read from an external data source, pass it to some SAS code and write the results to a SAS dataset from a parallel DataStage job.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Different Loading option of SAP data through DataStage
I am looking for SAP data loading and not SAS data.
Basically looking for which SAP plugin (in DataStage) to use in which case (less data volume/huge data volume and othere relevant consideration).
Basically looking for which SAP plugin (in DataStage) to use in which case (less data volume/huge data volume and othere relevant consideration).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am
There are several ways to load the data into the SAP system.
1)If the data which you are trying to load gets loaded into the SAP standard tables then you need to write BDC.
a)First you need to prepare the data and place the file in the SAP system.
b)once the file is created then the BDC(ABAP Code) should be triggered independently.
2) If data is getting loaded into the SAP custom tables then you can write the BAPI. The point a remains the same and once the file is created, BAPI should be called from DataStage. The import parameters of the BAPI should be the file name and file path in the SAP system.
OR
One can write the independent ABAP code which loads the data into the SAP custom table.
The above two approaches are can be followed for any kind of data volume
If the data volume is less say in thousands then you can go for IDOC load stage but IDoc load stage does not give an complete error message when it fails to execute. This becomes very hard to debug or fix the issue.
1)If the data which you are trying to load gets loaded into the SAP standard tables then you need to write BDC.
a)First you need to prepare the data and place the file in the SAP system.
b)once the file is created then the BDC(ABAP Code) should be triggered independently.
2) If data is getting loaded into the SAP custom tables then you can write the BAPI. The point a remains the same and once the file is created, BAPI should be called from DataStage. The import parameters of the BAPI should be the file name and file path in the SAP system.
OR
One can write the independent ABAP code which loads the data into the SAP custom table.
The above two approaches are can be followed for any kind of data volume
If the data volume is less say in thousands then you can go for IDOC load stage but IDoc load stage does not give an complete error message when it fails to execute. This becomes very hard to debug or fix the issue.
-
- Participant
- Posts: 46
- Joined: Tue Aug 10, 2004 11:07 am
- Location: Mclean VA
-
- Participant
- Posts: 46
- Joined: Tue Aug 10, 2004 11:07 am
- Location: Mclean VA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Let's try to get one thing clear from the outset - by "loading SAP data" do you mean loading data from SAP into DataStage, or loading data from DataStage into SAP?
Should have asked this question earlier.
There are plug-in stages (and other techniques) for each operation.
Should have asked this question earlier.
There are plug-in stages (and other techniques) for each operation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Loading SAP data
By 'loading SAP data', I meant loading data from legacy to SAP system using DataStage.
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am