Local Database Extract Process

Database Extract:

Generate New Database:

In case of any changes in Database schema or initial db extract, we need to do Gen New  DB.

1. Go to Site Map à Administration - Server Management à Jobs
2. Create New job for component “Generate New Database”
3. After Success, follow the below steps for extracting.

Check the following System Preferences in application.
Sitemap-->Administration Application --> System Preferences

Docking:Transaction Logging - TRUE

Extract Database to user:

1. Create an Employee with position Developer
2. Add the Employee as Mobile User by following steps.
1. Go to Sitemap à Administration – Siebel Remote à Mobile Clients
2. Add the Employee as Mobile Client.(Mobile Client name and UserID is same)
3. Select Routing Model as MOBILE CLIENT – STANDARD.
3. Create a Job for Database Extract by following steps.
1. Go to Sitemap à Administration – Server Management à Jobs
2. Create a new Job for Component Database Extract.
3. Add Job Parameters Client Name, Value is User ID.

                        For multiple users User Ids with comma separated.

4. Start Job and wait for successful completion of the job.
3. Change the parameters in Tools.cfg file.

DockConnString           =<Development Siebel Server Name>

5. Open Siebel Tools  -- login to tools with your user name (ex. SKAMMAR and pwd is SKAMMAR)

                       Click Yes on below message.

Local Database DSN Connection Settings:

Select correct the sse_data.dbf file and enter the same dsn from tools when it asked.

This will extract the database for you.

6. Once extract is completed, you need to get all the projects from tools from Tools menu à Check Out à Select All Projects and Click Get button.

That's all. You are all set for Configuration Development and Checkout and Checkin Objects from Siebel Tools.
It may ask to select Server Database DSN and Local Database DSN. When asked give proper connection DSNs to get the projects and chekin-checkouts.


Happy Configuring and Developing...


Stay tuned to more....


Thanks,
Srinivas