Accessing CRM(vendor LexisNexis Interface) data from DS EE

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

Accessing CRM(vendor LexisNexis Interface) data from DS EE

Post by satish_valavala »

Hi,
One of our source is frontend CRM application (Third party application by LexisNexis Interface Software). CRM DB is on Oracle.
We are having DataStage 7.5 Enterprise Edition.
Do we need any special PACKs to access this data. We don't have any PACKs available.
Could anyone explain how can I access this CRM data.
Regards
VS
SriKara
Premium Member
Premium Member
Posts: 30
Joined: Wed Jun 01, 2005 8:40 am
Location: UK

Post by SriKara »

Given the fact that CRM DB is on Oracle, an Oracle enterprise stage can be used to access the database.
In our project, the front end is a siebel DB on oracle. We use Siebel packs to access the database, which gives additional advs like capturing delta records at source, accessing buisness components etc.
Using an Oracle stage may not be able to do all this but it just treats the source as a normal oracle db and we will have to do the delta processing and stuff in the ETL.
joffijoy
Participant
Posts: 22
Joined: Mon Jun 11, 2007 8:51 am

Cost and Worth of Siebel Pack

Post by joffijoy »

SriKara wrote:Given the fact that CRM DB is on Oracle, an Oracle enterprise stage can be used to access the database.
In our project, the front end is a siebel DB on oracle. We use Siebel packs to access the database, which gives additional advs like capturing delta records at source, accessing buisness components etc.
Using an Oracle stage may not be able to do all this but it just treats the source as a normal oracle db and we will have to do the delta processing and stuff in the ETL.
Do you know How much it would cost to purchase these Packs and how usefull are these?
Post Reply