Creating an interface

Next, you create an interface.

1. In ODI Studio, select the Designer tab.
2. Expand Projects and go to your project folder.
3. Expand <project name> Folder.
4. Right click Interfaces and select New Interface.
   For example:

   
   
   
5. Select the Definition pane and specify a unique value for Name.
6. From the drop-down list, select Endeca Server: <name of logical schema> that you created earlier.
   For example:

   
   
   
7. Select the Quick Edit tab.
8. Click the Target Datastore Selection icon.
9. Uncheck Use Temporary Target.
10. Expand the Endeca Server model and select a datastore.

    For example:

    
    
    
11. Click OK.
12. Select the Mapping tab and drag the data store of the source data into the Mapping tab.
13. Map the source columns to the target datastore columns.
14. Select the Overview > Definition, then check Staging Area Different From Target.
15. From the drop-down list, select a staging database.

    The staging database must support SQL.

16. Select the Flow tab.
17. Click the Target component.

    The Target Area - Property Inspector dialog displays.

18. From the IKM Selector drop-down list, select IKM SQL to Endeca Server.
19. Under Options, modify target options as necessary.

    You must specify an Endeca data domain name for DATADOMAIN. Other options are optional. For details about the options, see Configuration reference for the IKM SQL to Endeca Server.

20. Click Save.