Extending pluggable SQL to new domains
Pluggable SQL can be extended to be used in new MDM domains.
Procedure
What to do next
You can reuse the common SQL Builders and Resultset Processors with the help of the preceding metadata class implementation.
The
metadata implementation class is configured in the DWLCommon_extension.properties file's optimized.sql.metadata.<GroupName>=<Implementation
class for metadata>
property, where <GroupName>
is
the group name of the parent in the domain.
If the existing
SQL Builder is not sufficient for your implementation, you can define
a new SQL Builder:
- Any new SQL Builder must implement the interface
com.ibm.mdm.admin.ots.sql.OTSSQLBuilder
, including the generateQuery() method. - The generateQuery method returns a string array of SQL statements that consist of two SQL statements: one for base and one for Point In Time (PIT).
- The implementation must be configured in the DWLCommon_extension.properties file's
optimized.sql.sqlbuilder.<GroupName>=<Implementation class for SQL Builder>
property.