Working with Preference File (JSON) for Post-migration

When you update the schema and use the feature of preferences, then a migrateSchema.json file would need to be created in the root folder of ActiveMatrix® Adapter for Database project. A template of the preference file is installed in the tools folder of the plug-in in the following location:

$TIBCO_HOME/bw/palettes/adb/version/tools/migrateSchema.json_template

A Preference file (JSON format) can be used in the following manner:
  • The JSON preference file template must be used for reference only and must not be modified or used as it is. The preference file must be edited with the necessary properties and their corresponding values.
  • The file created under the root folder of the ActiveMatrix® Adapter for Database project created on ActiveMatrix BusinessWorks 6.x does not just contain the ActiveMatrix BusinessWorks Plug-in for Database plug-in, but also other plug-ins that support the adapter migration.
  • Key and values are case sensitive in the migrateSchema.json file.

The migrateSchema.json configuration has at least one of DBPoller, DBMerger, or DBRequester keys that has 3 tuples separated by a colon (:). The first tuple indicates the ActiveMatrix BusinessWorks 5.x adapter field name, the second tuple indicates schema reference of migrated ActiveMatrix BusinessWorks 6.x project and the third tuple indicate the replaced value inside schema reference. For example: 

					"DBPoller": {
						"P__AC__PARENT" : "/ActiveDatabaseAdapterConfiguration.adbResource/ADBPublisher/ADBPublisher_schema:P__AC__PARENT",
						"<BW5SchemaElementName>" : "/<Relative Path of Shared Resource/Shared Resource Name>/<Name of Plugin Schema>/<BW Plugin XSD Name>:<BW6SchemaElementName>"
					},
					"DBMerger": {
						"<BW5SchemaElementName>" : "/<Relative Path of Shared Resource/Shared Resource Name>/<Name of Plugin Schema>/<BW Plugin XSD Name>:<BW6SchemaElementName>"
					},
					"DBRequester": {
						"<BW5SchemaElementName>" : "/<Relative Path of Shared Resource/Shared Resource Name>/<Name of Plugin Schema>/<BW Plugin XSD Name>:<BW6SchemaElementName>"
					},
					"VARIABLES":
					{
						"<BW5LoopVariableElementName>" : "/<Relative Path of Shared Resource/Shared Resource Name>/<Name of Plugin Schema>/<Type of Key [DBPoller OR DBMerger OR DBRequester]>/<BW Plugin XSD Name>:<BW6SchemaElementName>"
					}

BW5SchemaElementName is replaced by BW6SchemaElementName inside the BW6 Plugin schema reference if it is available.

Limitations
  • Some errors such as unexpected output error, activity configuration error, or an XSLT out of Sync error might occur in the migrated ActiveMatrix BusinessWorks 6.x project. To resolve this issue, right-click the input mapping and select Show Check and Repair.
  • In the BW6 Schema Element Name, you must specify the BW6 element that has to be replaced in the mappings as there are several different schemas in ActiveMatrix BusinessWorks Plug-in for Database.
  • The Parse XML activity supports only 'text' Input Style.
  • The JMS Send Message activity and JMS Receive Message activity support only 'XML text' Message Type.