[/map {"- map/map "}) [/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) About this guide (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) About this guide (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This guide describes how to download, install, configure, and run the IKM SQL to Endeca Server.The IKM SQL to Endeca Server provides an integration module that enables writing source data to an Endeca Server target within ODI. (shortdesc] (topicmeta] (topicref] [/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Installing the IKM SQL to Endeca Server (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Installing the IKM SQL to Endeca Server (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes the prerequisites to installing the IKM SQL to Endeca Server into Oracle Data Integrator, the installation procedure, and then describes the contents of the installation directory. (shortdesc] (topicmeta][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Endeca Server version support (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Endeca Server version support (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The IKM SQL to Endeca Server 3.1.0 supports writing data to Endeca Server 7.6.0. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Prerequisite software (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Prerequisite software (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) Before you install the IKM SQL to Endeca Server into Oracle Data Integrator, you must have already installed the following software on your machine: (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Prerequisite setup (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Prerequisite setup (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) After you have installed the prerequisite software, you must perform the following before you install the IKM SQL to Endeca Server: (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Downloading the IKM SQL to Endeca Server (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Downloading the IKM SQL to Endeca Server (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) You download the IKM SQL to Endeca Server from the Oracle Software Delivery Cloud. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Installing the IKM SQL to Endeca Server (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Installing the IKM SQL to Endeca Server (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This process describes how to install the drivers for the knowledge module and also the XML definition of Endeca Server.Later in this guide, you import the knowledge module (i.e. the ikm directory contents).The knowledge module is project dependent and cannot be imported until you first create and configure a project. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Package contents and directory structure (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Package contents and directory structure (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The IKMSQLtoEndecaServer directory is the root directory for the IKM SQL to Endeca Server. (shortdesc] (topicmeta] (topicref] (topicref][/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Configuring the IKM SQL to Endeca Server (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Configuring the IKM SQL to Endeca Server (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The following procedures describe how to configure and run the IKM SQL to Endeca Server in ODI.次の手順を順番どおりに実行してください。After you complete the procedures, you can run an ODI Interface that integrates data into an Endeca Server. (shortdesc] (topicmeta][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Importing the Endeca Server technology into ODI (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Importing the Endeca Server technology into ODI (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) You use ODI Studio to import the Endeca Server technology into ODI. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Adding flexfield definitions (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Adding flexfield definitions (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) You must add flexfield definitions to ODI to define Endeca Server fields.便利な方法として、IKM SQLからEndeca Serverでは、ODIにフレックスフィールドを作成するためにmetadata-importというコマンドライン・ユーティリティを用意しています。The metadata-import utility requires a few configuration settings for SDK, Java, and driver locations. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Creating an Endeca Server data server (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Creating an Endeca Server data server (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) Next, you create an Endeca Server data server. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Creating a physical schema (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Creating a physical schema (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) After you have created an Endeca Server technology, you create a physical schema to associate with it. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Creating a logical schema (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Creating a logical schema (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) After you have created an Endeca Server, you create a logical schema to associate with it. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Creating a model (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Creating a model (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) Next, you create a model. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Creating a datastore (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Creating a datastore (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) Next, you create a datastore. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Modifying column settings in a datastore (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Modifying column settings in a datastore (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) Once you have created a datastore and its columns, you can assign Endeca properties to each column in the datastore.Endecaフレックスフィールド・プロパティによって、各列値にEndeca検索設定が構成されます。たとえば、Endecaプロパティによって、列の値がテキスト検索可能か、値検索可能か、単一割当てか、複数割当てかなどが定義されます。The definition of each Endeca property is documented in the "Property Description Record (PDR)" topic of the Oracle Endeca Server Developer's Guide. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Importing the knowledge module (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Importing the knowledge module (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) In this procedure, you import the knowledge module contained in the <install path>\ikm_sql_to_endeca_server\3.1.0\ikm directory.This module is project dependent and cannot be imported until you first create and configure a project. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Creating an interface (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Creating an interface (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) Next, you create an interface. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Configuration reference for the IKM SQL to Endeca Server (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Configuration reference for the IKM SQL to Endeca Server (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) When you open the Target component for the IKM SQL to Endeca Server, you find configuration options in the Options area of the Target Area - Property Inspector dialog.These options are described below. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Mapping source data types to Endeca Server data types (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Mapping source data types to Endeca Server data types (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) When the knowledge module writes source data to an Endeca Server target, it is possible to encounter errors if data types do not map correctly between the database source and the Endeca Server target. (shortdesc] (topicmeta] (topicref] (topicref][/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Using the ODI Procedure to Write to Endeca Server (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Using the ODI Procedure to Write to Endeca Server (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes how to configure and run the ODI procedure provided with the IKM SQL to Endeca Server. (shortdesc] (topicmeta][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Configuring and running the ODI procedure (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Configuring and running the ODI procedure (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) 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. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Configuration reference for the ODI procedure (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Configuration reference for the ODI procedure (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) When you open the Options tab of the ODI procedure, you the find configuration options that are described below. (shortdesc] (topicmeta] (topicref] (topicref][/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Uninstalling the IKM SQL to Endeca Server (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Uninstalling the IKM SQL to Endeca Server (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes how to uninstall the IKM SQL to Endeca Server from Oracle Data Integrator. (shortdesc] (topicmeta][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Uninstalling the IKM SQL to Endeca Server (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Uninstalling the IKM SQL to Endeca Server (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) To uninstall the module, you delete all the objects you created, in the opposite order that you first created them.たとえば、インタフェースを最後に作成した場合は、それを最初に削除します。Then you remove the IKM data integration code, then delete the datastore, then the model, and so on until all aspects of the IKM SQL to Endeca Server have been removed. (shortdesc] (topicmeta] (topicref] (topicref] [/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Conventions used in this guide (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Conventions used in this guide (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The following conventions are used in this document. (shortdesc] (topicmeta] (topicref] [/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Copyright and disclaimer (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Copyright and disclaimer (linktext] (topicmeta] (topicref] [/map/reltable {"- map/reltable "}) [/map/reltable/relheader {"- map/relheader "}) [/map/reltable/relheader/relcolspec {"- map/relcolspec "}) (relcolspec][/map/reltable/relheader/relcolspec {"- map/relcolspec "}) (relcolspec] (relheader] [/map/reltable/relrow {"- map/relrow "}) [/map/reltable/relrow/relcell {"- map/relcell "}) [/map/reltable/relrow/relcell/topicref {"- map/topicref "}) [/map/reltable/relrow/relcell/topicref/topicmeta {"- map/topicmeta "}) [/map/reltable/relrow/relcell/topicref/topicmeta/navtitle {"- topic/navtitle "}) About this guide (navtitle][/map/reltable/relrow/relcell/topicref/topicmeta/linktext {"- map/linktext "}) About this guide (linktext][/map/reltable/relrow/relcell/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This guide describes how to download, install, configure, and run the IKM SQL to Endeca Server.The IKM SQL to Endeca Server provides an integration module that enables writing source data to an Endeca Server target within ODI. (shortdesc] (topicmeta] (topicref] (relcell][/map/reltable/relrow/relcell {"- map/relcell "}) [/map/reltable/relrow/relcell/topicref {"- map/topicref "}) [/map/reltable/relrow/relcell/topicref/topicmeta {"- map/topicmeta "}) [/map/reltable/relrow/relcell/topicref/topicmeta/navtitle {"- topic/navtitle "}) Installing the IKM SQL to Endeca Server (navtitle][/map/reltable/relrow/relcell/topicref/topicmeta/linktext {"- map/linktext "}) Installing the IKM SQL to Endeca Server (linktext][/map/reltable/relrow/relcell/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes the prerequisites to installing the IKM SQL to Endeca Server into Oracle Data Integrator, the installation procedure, and then describes the contents of the installation directory. (shortdesc] (topicmeta] (topicref] [/map/reltable/relrow/relcell/topicref {"- map/topicref "}) [/map/reltable/relrow/relcell/topicref/topicmeta {"- map/topicmeta "}) [/map/reltable/relrow/relcell/topicref/topicmeta/navtitle {"- topic/navtitle "}) Configuring the IKM SQL to Endeca Server (navtitle][/map/reltable/relrow/relcell/topicref/topicmeta/linktext {"- map/linktext "}) Configuring the IKM SQL to Endeca Server (linktext][/map/reltable/relrow/relcell/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The following procedures describe how to configure and run the IKM SQL to Endeca Server in ODI.次の手順を順番どおりに実行してください。After you complete the procedures, you can run an ODI Interface that integrates data into an Endeca Server. (shortdesc] (topicmeta] (topicref] [/map/reltable/relrow/relcell/topicref {"- map/topicref "}) [/map/reltable/relrow/relcell/topicref/topicmeta {"- map/topicmeta "}) [/map/reltable/relrow/relcell/topicref/topicmeta/navtitle {"- topic/navtitle "}) Using the ODI Procedure to Write to Endeca Server (navtitle][/map/reltable/relrow/relcell/topicref/topicmeta/linktext {"- map/linktext "}) Using the ODI Procedure to Write to Endeca Server (linktext][/map/reltable/relrow/relcell/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes how to configure and run the ODI procedure provided with the IKM SQL to Endeca Server. (shortdesc] (topicmeta] (topicref] [/map/reltable/relrow/relcell/topicref {"- map/topicref "}) [/map/reltable/relrow/relcell/topicref/topicmeta {"- map/topicmeta "}) [/map/reltable/relrow/relcell/topicref/topicmeta/navtitle {"- topic/navtitle "}) Uninstalling the IKM SQL to Endeca Server (navtitle][/map/reltable/relrow/relcell/topicref/topicmeta/linktext {"- map/linktext "}) Uninstalling the IKM SQL to Endeca Server (linktext][/map/reltable/relrow/relcell/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes how to uninstall the IKM SQL to Endeca Server from Oracle Data Integrator. (shortdesc] (topicmeta] (topicref] (relcell] (relrow] (reltable] (map]