Migrating Adapter Projects Created on ActiveMatrix BusinessWorks 5.x to Plug-In Projects

You can migrate a project that is created by using TIBCO ActiveMatrix® Adapter for Database 7.2.0 and the ActiveMatrix BusinessWorks 5.x project created in TIBCO Designer™ to ActiveMatrix BusinessWorks 6.x or TIBCO BusinessWorks™ Container Edition by using the migration tool in TIBCO Business Studio.

Prerequisite
  • For databases using native drivers in ActiveMatrix BusinessWorks 6.x, the JAR files must be added to the <TIBCO_HOME> directory before the migration is initiated.

Projects Supported for Migration

You must use the migration tool to migrate projects to ActiveMatrix BusinessWorks Plug-in for Database. Migration is supported for the following project specifications:

Project Specification Supported for Migration To
Projects created in ActiveMatrix® Adapter for Database 7.2.0
  • ActiveMatrix BusinessWorks 6.x
  • TIBCO BusinessWorks Container Edition
ActiveMatrix BusinessWorks 5.x projects created in TIBCO Designer
Migration Restrictions
  • You can migrate ActiveMatrix BusinessWorks 5.x projects to ActiveMatrix BusinessWorks 6.x. However, you cannot migrate version 6.x projects to version 5.x.
  • Migration supports only those ActiveMatrix BusinessWorks 5.x projects that have no designtime or runtime errors. The projects must be validated and processes must be run successfully end to end on ActiveMatrix BusinessWorks 5.x before migrating to ActiveMatrix BusinessWorks 6.x.
  • Migration is based on the information received from the adapter palette activities.
Considerations When Migrating Projects
  • To avoid post migration issues, ensure that correct connection parameters are provided in the project or in the JSON reference file at the time of migration.
  • Ensure that your user workspace is the same as the ActiveMatrix BusinessWorks 6.x target directory (the location where you want to migrate the projects). When running the command for migration from the CLI, migration fails if the user workspace directory and the ActiveMatrix BusinessWorks 6.x target directory are not the same. For example, bwmigrator.exe -data <user workspace> -projectDir <BusinessWorks 6.x target directory> <BusinessWorks 5.x project location>.
  • Global variables are migrated to ActiveMatrix BusinessWorks 6.x project only if they are created in ActiveMatrix BusinessWorks 5.x project and are referred in one of the ActiveMatrix BusinessWorks 5.x projects or are mentioned in the JSON reference file as a global variable.
  • If there is an ActiveMatrix BusinessWorks 5.x generic activity that uses the Database Adapter AE schema in the ActiveMatrix BusinessWorks 5.x project, after migration you must manually correct the ActiveMatrix BusinessWorks 6.x generic activities to use the plug-in activity schema.
  • Migration requires online schema, which means it retrieves the schema from the Database server during migration for the respective activity.
  • After migration, you might notice some additional files (such as ae folder and ae2xsd.xsd file in the Schemas folder and the AESchemas folder) that you do not require. Ignore such files.
  • A validation error occurs in the migrated ActiveMatrix BusinessWorks 6.x project when one ActiveMatrix BusinessWorks 5.x project is saved with two different names and both the projects are migrated to the plug-in. To resolve this issue, delete the Namespaces/Imports from Process > Dependencies.
  • After migration to ActiveMatrix BusinessWorks Plug-in for Database on ActiveMatrix BusinessWorks 6.x or TIBCO BusinessWorks Container Edition, a project created by using ActiveMatrix® Adapter for Database that is installed on ActiveMatrix BusinessWorks 5.x, might display some errors, such as xslt-out-of-sync with schema component properties or input schema with misplaced input data.

    To remove the errors and run the project, on the Input tab in the Properties section of the activity, right-click the input item that displays the error and select the Show Check and Repair option. In the Mapper Check and Repair window, select the items to be fixed and click OK.

Note: It is recommended to review the TIBCO ActiveMatrix BusinessWorks 6.x Migration guide for additional information such as naming conventions, and more.