Hi,
Currently we extract from Oracle and db2 databases going forward we need to extract from SAP HR i am looking under Database palette can't see any SAP database so how we connect to SAP databases then?
Thanks
Connect to sap hr
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I think you need an experience ETL architect who knows how SAP and DataStage work. SAP does have an underlying database engine and there is a SAP Pack for DataStage that requires an additional purchase. You need to work out if you are going for direct database access or through the SAP application layer. You need to work out how you identify delta data sets. You need to work out who gives you access to the SAP system and what dev/test/prod environments are available.
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