ODI - Endeca Integration (IKM SQL to Endeca Server)

Card Puncher Data Processing

Stop the agent process Copy the jar files located in the lib directory of the downloaded files Paste them in the following location. If the ODI agent is a Java application running in WebLogic Server: C:\Oracle\Middleware\user_projects\domains\odiagent\lib. Standalone agent: \odi\agent\lib
  • For an agent in a weblogic Server, add this java system property in the setDomainEnv script: JAVA_OPTIONS=-DUseSunHttpHandler=true
set JAVA_OPTIONS=-DUseSunHttpHandler=true
JAVA_OPTIONS=-DUseSunHttpHandler=true
export JAVA_OPTIONS
  • Start the agent
You must see in the agent log that the agents process new jars:
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\endeca-server-driver.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\endeca_bulk_load-7.6.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\guava-14.0.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\httpclient-4.0.3.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\httpcore-4.0.1.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\log4j-1.2.15.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\slf4j-api-1.7.2.jar'
*sys-package-mgr*: processing new jar, 'C:\OdiHome\odi\agent\lib\slf4j-log4j12-1.7.2.jar'

Flex fields
  • Add the following jar in the metadata-import.bat file:
c:\OdiHomeEE\oracle_common\modules\oracle.jps_12.1.2\jps-api.jar;c:\OdiHomeEE\oracle_common\modules\oracle.idm_12.1.2\identitystore.jar

  • Start
3.1.0\tools>metadata-import.bat OdiRepository.properties
Loading properties from:
3.1.0\tools\OdiRepository.properties
ODI_MASTER_DRIVER=oracle.jdbc.OracleDriver

ODI_MASTER_URL=jdbc:oracle:thin:@localhost:1521/pdborcl.hotitem.local

ODI_WORK_REP=WORKREP

ODI_MASTER_USER=DEV_ODI_REPO

ODI_SUPERVISOR=SUPERVISOR

Please specify the database user password for the ODI repository database:
Please specify the Work repository login password:
Loading ODI repository configuration complete.
Mar 20, 2014 1:06:46 PM oracle.odi.core.datasource.DataSourceDefinitionUtils createDriverManagerDataSourceDefinition
INFO: New data source: [DEV_ODI_REPO/*******@jdbc:oracle:thin:@localhost:1521/pdborcl.hotitem.local]
Mar 20, 2014 1:06:48 PM oracle.odi.core.datasource.DataSourceDefinitionUtils createDriverManagerDataSourceDefinition
INFO: New data source: [DEV_ODI_REPO/*******@jdbc:oracle:thin:@(description=(address=(host=localhost)(protocol=tcp)(port=1521))(connect_data=(service_name=PDBOR
Mar 20, 2014 1:06:50 PM org.eclipse.persistence.default
INFO: EclipseLink, version: Eclipse Persistence Services - 2.4.2.v20130514-5956486
Mar 20, 2014 1:06:50 PM org.eclipse.persistence.default.connection
INFO: work-session login successful
Mar 20, 2014 1:06:50 PM org.eclipse.persistence.default.connection
INFO: master-session login successful
Mar 20, 2014 1:06:51 PM org.eclipse.persistence.default.connection
INFO:  login successful
Mar 20, 2014 1:06:51 PM oracle.odi.adapter.OdiAdapter refreshRepositorySeededObjects
WARNING: Refreshing static component type cache.
FlexField {Endeca Property IsUnique|ENDECA_PROPERTY_IS_UNIQUE} is added!
FlexField {Endeca Property Display Name|ENDECA_PROPERTY_DISPLAY_NAME} is added!
FlexField {Endeca Property Navigation Select|ENDECA_PROPERTY_NAVIGATION_SELECT} is added!
FlexField {Endeca Property Navigation Sorting|ENDECA_PROPERTY_NAVIGATION_SORTING} is added!
FlexField {Endeca Property Attribute Group|ENDECA_PROPERTY_ATTRIBUTE_GROUP} is added!
FlexField {Endeca Property IsValueSearchable|ENDECA_PROPERTY_IS_VALUE_SEARCHABLE} is added!
FlexField {Endeca Property Language|ENDECA_PROPERTY_LANGUAGE} is added!
FlexField {Endeca Property IsSingleAssign|ENDECA_PROPERTY_IS_SINGLE_ASSIGN} is added!
FlexField {Endeca Property Search Interface|ENDECA_PROPERTY_SEARCH_INTERFACE} is added!
FlexField {Endeca Property IsTextSearchable|ENDECA_PROPERTY_IS_TEXT_SEARCHABLE} is added!
FlexField {Endeca Property TextSearchWildcards|ENDECA_PROPERTY_TEXTSEARCHWILDCARDS} is added!
FlexField {Endeca Property ShowRecordCounts|ENDECA_PROPERTY_SHOW_RECORD_COUNTS} is added!
Mar 20, 2014 1:06:54 PM org.eclipse.persistence.default.connection
INFO: work-session logout successful
Mar 20, 2014 1:06:54 PM org.eclipse.persistence.default.connection
INFO: master-session logout successful

In ODI Studio
  • Windows > Odi Security Navigator > SECURITY ADMIN
  • Double click Column. On the Column tab, select Flexfields.
Endeca Flexfield Security
Creating the topology
  • an Endeca Server data server
Odi Topology Endeca Server
  • a Physical Schema
  • a Logical Schema
Model
Mapping
Odi Endeca Logical Mapping Properties
  • Create a mapping with the “Empty Dataset” check-box unchecked
  • In the Logical View:
    • Verify the mapping properties
    • Drag the database table in the canvas
    • Drag the Endeca data store in the canvas
    • Verify in the target properties that the Integration Type is “Control Append”
    • Map the two by dragging a line between the two side-node
    • Verify the mapping by clicking on the target columns
Odi Endeca Mapping Target Source Column
  • In the physical view:
    • Verify in the properties that the preset staging location is the database
    • Verify by clicking on the target the Knowledge Module and its options:
Odi Endeca Mapping Physical Target Properties
Operator
Odi Endeca Operator Steps
Support
Message missing required fields: spec
java.lang.Exception: 
java.lang.Exception: 
com.oracle.endeca.eidi.mdex.exception.ConnectionException: 
com.google.protobuf.UninitializedMessageException: 
Message missing required fields: spec

The primary key for datastore records is called a “spec”.
Documentation / Reference







Share this page:
Follow us:
Task Runner