Configuring and running the ODI procedure

The procedure is installed in <install path>\IKMSQLtoEndecaServer\3.1.0\procedure. It allows you to directly invoke a Web service, using the SOAP protocol, to post a request to write data to Endeca Server and get a response file.

1. Import the procedure into ODI:
   1. In ODI Studio, select the Designer tab.
   2. Expand Projects > <Project Name> > First Folder.
   3. Right click Procedures and select Import Procedure....

      For example:

      
      
      

      The Import Procedure (XML File) dialog displays.

   4. In the File import directory field, browse to <install path>\IKMSQLtoEndecaServer\3.1.0\procedure and click Open.

      For example:

      
      
      
   5. Select Endeca_Web_Service_Procedure and click OK.
   6. Click Close to dismiss the Import Report.
2. Create a physical schema and logical schema to associate with the Web Service request:
   1. Select the Topology tab.
   2. Expand Physical Architecture > Technologies > File.
   3. Right click File Generic and select New Physical Schema.

      For example:

      
      
      
   4. Select the Context tab.
   5. Click the plus (+) icon.
   6. From the Context list, select an existing context.
   7. From the Logical Schema list, select an existing logical schema or specify a new name to define a new logical schema.

      If you specify a logical schema that does not exist yet, ODI creates it automatically when you save the physical schema.

   8. Click Save All.
   9. Select the Definition tab.
   10. For both the Directory (Schema) list and Directory (Work Schema) list, specify a path to a directory where the request and response files are stored.

       Note that on Windows systems, you need to escape paths containing the \ character by adding a second \ character. For example, C:\\test.

3. Double-click the imported procedure and select the Details tab.
4. Double-click Set Endeca Server Logical Schema and from the Command on Source list, select the Endeca Server logical schema.
5. Return to the Details tab.
6. Double-click Set File Logical Schema and from the Command on Source list, select the File logical schema.
7. Now configure the ODI procedure itself:
   1. Under Options, specify values for ENDECA_WS_RELATIVE_PATH, REQUEST_FILE_NAME, and RESPONSE_FILE_NAME.
   2. Other options are optional. For details about the options, see Configuration reference for the ODI procedure.
8. Click Save.