Connecting the connections.xml and the LookupMgrCustomizing.xml files

Some settings in the connections.xml file, which is required by the com.ibm.streams.db toolkit and its operators, must correlate with Lookup Manager parameters and with settings in the LookupMgrCustomizing.xml file.


Lookup Manager application – connecting the connections.xml and LookupMgrCustomizing.xml files

Procedure

  • Set the name attribute of the connection_specification element to the value of the lm.db.connectionName parameter. For example, SAMPLE as shown in the below figure.
  • Set the name attribute of the access_specification element to the value of the Name attribute of the DataSource element that is part of the LookupMgrCustomizing.xml file. For example, DimMaster1 as shown in the figure.

  • Set the column names for the native_schema element, so they fit to the database schema. Use the same names for the Name attributes of the ValueDefinition elements in the LookupMgrCustomizing.xml file.

  • Set the SPLType attributes of the ValueDefinition elements in the LookupMgrCustomizing.xml file according to the type mapping described in the com.ibm.streams.db toolkit.

Related links:

  • Reference > Toolkits > Specialized toolkits > com.ibm.streams.db > Connection specifications document for the Database Toolkit > Access specification element for the Database Toolkit > Native_schema element > Column element