Chapter 23. Making Changes

The stream configuration held in Theon needs to be transformed to be used by TheonCoupler. This requires first exporting the content in XSDDB into a SchemaTree and then deriving that into the necessary changes.

ttkm export
ttkm derive ddl
ttkm install

The DDL for TheonCoupler adds the necessary metadata columns to each couple target table and if necessary a corresponding target table exclusion table. It also adds a couple specific coupling function, triggered update function against the target table and a state function which can be manually queried to interrogate the metadata values.

Then the stream configuration files themselves need to be built, this is just another transform.

ttkm derive coupler

Then the stream can be run using the stream action of the Toolkit.