Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Installing the Siebel Customer-Centric Enterprise Warehouse Environment > Process of Creating the Development Repository >

Importing Application Workflows into the Repository

This task is a step in the Process of Creating the Development Repository.

You must import individual workflows for every application purchased within the Siebel Customer-Centric Enterprise Warehouse. Each application involves importing the application-specific XML file using the PowerCenter Repository Manager or the command line. For example, for the Siebel Supply Chain Analytics applications there are two XML files—SupplyChain_Application_Oracle11i_Import_Control.xml and SupplyChain_Application_Oracle11i.xml. Use the SupplyChain_Application_Oracle11i.xml file to import the object metadata into the repository.

NOTE:  The process of importing the object metadata into the repository could use a large amount of memory and can be time-consuming on the machine that runs the import. For this reason, do not leave the process, using the PowerCenter Repository Manager, unattended. If you want to use an unattended process, please use the command line approach described in the following section.

To import the object metadata into the repository using the Repository Manager

1. Open Repository Manager and connect to the repository.
2. Open the source-specific configuration folder.

   For example, open the Configuration for PeopleSoft 8.4 folder.

3. On the Repository menu, click Import Objects.

   The Import Wizard appears.

4. Click Browse, and open your XML file in the $Siebel\ETL\Applications folder

   where $Siebel is the path of the Siebel Customer-Centric Enterprise Warehouse installation directory.

5. Click Next, click Add All, and then click Next.

   NOTE:  Click the Add All and not the Add option.

6. In the Match Folders screen, match the folders in your XML file to the folders in your destination repository, and click Next.
7. Specify the rules to resolve object conflicts and click Next.

   A Conflict Resolution Wizard window appears to resolve all conflicts.

8. Click Import.
9. Repeat the procedure for each application and XML file.

To import the object metadata into the repository using the command line

1. Navigate to the $Siebel\ETL\Applications folder, and open the application-specific Import Control XML file using Microsoft WordPad or Notepad.
2. Replace all occurrences of the TARGETREPOSITORYNAME with the repository name you entered in Creating and Configuring an Empty Siebel Business Analytics Repository.

   For example, you see the following line in the XML file:

   TARGETREPOSITORYNAME="<Put your Target Repository Name here>"/>

   If your repository name is MY_REPOSITORY, then change the line to the following:

   TARGETREPOSITORYNAME="MY_REPOSITORY"/>

   Replace all other occurrences of TARGETREPOSITORYNAME with MY_REPOSITORY in the file.

3. Start a command window and navigate to the $pmclient folder where $pmclient is the path of the PowerCenter Client installation directory.
4. Type pmrep, and press Enter.

   The pmrep command prompt appears.

5. Connect to the repository using the following command:

   Connect -r <repository_name> -n <repository_user_name> -x <repository_password> -h <repository_server_host_name> -o <repository_server_port_number>

   A message confirming the connection with the repository appears.

6. Use the following command to import the metadata for an application:

   ObjectImport -i <application_xml_file> -c <application_import_control_xml_file>

   The application_xml_file is the application-specific XML file found in the $Siebel\ETL\Applications folder. The application_import_control_xml_file is the application-specific Import Control XML file found in the $Siebel\ETL\Applications folder.

7. Repeat Step 1, Step 2, and Step 6 for each application.