how to retrieve data from seibel to mdb

Question

I am a newbie with Seibel CRM. So I need to retrieve data separate by object (account,lead,contact,…) into Access (mdb). Please advice me how to and any advise.. Thanks for support

Answer 1

There's no out-of-the-box tool for exporting your data to an Access database. However, Siebel data is stored in some RDBMS -- which one depends on your setup. You'll need to import data from your Siebel database to the Access database using an ODBC connection. Here's an example.

Answer 2

Most entities are stored in their own tables - S_PARTY and S_ORG_EXT hold Account data; S_OPTY holds Leads, etc. - see Siebel Tools or the Siebel Data Model Reference.

Each of the tables also has it's own filters to divide the tables records by type (e.g. Contacts vs. Employees) and the relationships between tables is not totally clear from the database level (you'll need your local Siebel developer for that)

if you don't have a local Siebel developer then you might be able to spool SQL from the dedicated web client and figure out how tables are related from there - but this would be quite a lot of work

• B