Performing a Data Extraction

Use the following procedure to preform a data extraction.

To perform the data extraction

1. In the siebel_server\BIN directory, run the Syndexp.exe executable file.

   Use the command line arguments listed in the table in the topic Setting the Environment to define multiple variables that are specific to the user environment. For example:

   syndexp /U sadmin /P <password> /D phdemo /E “Rule One" /C siebsrvr_siebel

   Note: Interruption of the extraction process at any point causes the system to fail and necessitates restarting the data extraction from the beginning.

2. If an interruption occurs, you must go into the Pharma Node Attachment Administration view (navigate to the Syndicated Data Files view) and delete the previously generated data files. You also must go into each node and delete the latest file that was created in the previous run.

   After the program executes the Syndicated Data Loading (SDL) process, it displays the name of the user whose data is being extracted. This process continues until it has completed the extraction process for each user defined in the Syndicated Data Export Rules.

3. After you successfully complete the extraction process, you can create a batch file for use with subsequent extractions.

   The extracted files are output in a compressed form to minimize file transfer time. Files are transferred using Siebel Remote, which is described in Siebel Remote and Replication Manager Administration Guide. After mobile users receive their extracted files, they must import the data into their local databases.