Page 1 of 1
Accessing CRM(vendor LexisNexis Interface) data from DS EE
Posted: Sat Jun 04, 2005 9:18 am
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.
Posted: Sun Jun 05, 2005 1:07 am
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.
Cost and Worth of Siebel Pack
Posted: Fri Aug 24, 2007 2:19 pm
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?