New Comment System@Siebel Unleashed.. Do Try and give me feedback | Next Tip »Home

Siebel CRM – How to extract local database?

OkAvarageGoodVery GoodExcellent (4 votes, average: 4.50 out of 5)
Loading ... Loading ...

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 :) !!!!!!!

  • Share/Bookmark

Related Posts


Article by neel

Authors bio is coming up shortly. neel tagged this post with: , Read 387 articles by neel
  • Gopal Raturi
    Can anyone tell me how to make local db non editable i.e. nobody can make any change but can only view.
  • Vikram
    Hi,

    When do we need to Create New Database before performing the database extract?

    Thanks,
    Vikram
  • Owais
    Hi,

    Is there a way to see the Data Model used by Siebel CRM system? What I need to do is to extract data from SIEBEL CRM system on a regular basis and load it in another database for internal use.

    What would be the preferred way?

    Owais
  • Amit
    how to extract remote database? when we are given a password and username? how to set the ODBC settings?
blog comments powered by Disqus

Polls

Do you like the new Comment System and new look to Site?

View Results

Loading ... Loading ...