Before going on How To we need to answer the question Why?
Local database extract is required if you have mobile clients and it is essential for developer. As a Siebel developer does all his development in local environment and only checks in the code after he is sure of his changes. Local dbf is just a sub part of development database and have admin views and records that are in My view of application of that particular user.
*You don’t not have views like All Opportunities and All Quotes in Local Env.
A normal mobile client takes local dbf performs its functions on the move and then synchronizes with server when he returns back to office. So, that is why workflows cannot be executed on the mobile clients as they require Server components to run.
To perform a local database extract you need to follow the steps given below.
1. Go to Site Map » Administration » Server Management » Jobs.
2. Click New button
3. In the Component field, select Database Extract from the picklist.
4. In the Requested Server field, enter the name of the server on which to run the Database Extract job
5. In the Job Parameters list, which is located below the Jobs list and the Job Detail form, click New and add the required parameter for Database Extract which is Client Name
The value for the Client Name parameter is the user id of the Mobile Web Client for which you want to extract database.
For example if you want to extract database for user: TestUser then you would supply the Client Name parameter with the following value
Client Name: TestUser
There are other parameters also that you can provide in addition to the above parameter
In the Jobs list, with the Database Extract record still selected, click Start.
And you are done
!!!!!!!

1 Comment at "Siebel CRM - How to extract local database?"
how to extract remote database? when we are given a password and username? how to set the ODBC settings?
Comment Now!