Extraction of local databases through console (srvrmgr)

We present below the simple steps to extract a new local database. It is very useful to have a procedure like the one followed in Siebel projects, so that the extraction of a new database for a new developer who joins the team is greatly accelerated:

1. We log in to the Siebel console:

• $SIEBELDIR\bin> srvrmgr /e "enterprise_server_name" /g "gateway_server_name" /s "siebel_server_name" /u SADMIN /p "password". Where siebel_server_name is the Siebel server where we have installed the Siebel Remote component group
• We have a prompt similar to this: srvrmgr:server01>

2. Run the generation of a new database: run in the siebel console the following "start task for comp GenNewDB with DBFFile=sse_utf8.dbf "

3. We will register the user in the application as an employee as follows:

• Site Map -> Administration-Users -> Employees.
• Create it as "Employee Type = Employee"

4. Once the employee type user has been created, we must register the employee as a mobile client in the application as follows:

• >Site Map -> Administracion-Siebel Remote -> Mobile Clients:
• Mobile Client: Name of the mobile client, will be used in the extraction of the local database as the main ID of the client, it does not have to match the Client ID.

5. Register the user in the database (With SYSTEM or with one that has privileges) as follows:

• CREATE USER PRUEBA1 IDENTFIED BY PRUEBA1;
• GRANT SSE_ROLE TO PRUEBA1;

6. Extract the local database, we will write in the siebel console:

• "start task for comp DBXtract with Client=PRUEBA1, EncryptLocalDbPwd=FALSE, EncryptLocalDbMethod=None

The extraction of the database will be on the server in the path: "$SIEBELDIR\docking\PRUEBA1\*" we will find the folders (Inbox and Outbox) and the file *.dbf

Now we log in with Tools a local (User PRUEBA1 pwd PRUEBA1, the pwd is indicated in the creation of the user with the sentence in the database IDENTFIED BY PRUEBA1). In the dialog box that appears, it will ask if we want to initialize a local database. We indicate that YES.

Finally, the loading of the local database for the PRUEBA1 user will start.

It will only be necessary to make a "FULL GET" once the database finishes starting.

Finally, do a full-compile or get the most up-to-date SRF from the server.