Vignette
This is the third and final article in our series on migrating content from a previous version of Vignette to Vignette V7. The first article in the series painted the broad overview and in the last article we talked in detail about the Content Analysis part of the process. Now, we continue by digging into the final planning phase: Defining the Migration Approach.

Migration Process -- Define the Approach

This step in the content migration process defines an overall approach for content transformation and migration.
Vignette Content Migration Diagram

Diagram: Content Migration Approach (click to enlarge) Process Flow # Vignette content is analyzed. Content analysis provides type of content that can be migrated by automation using data mapping between V6 - V7 and data transformation logic. # Depending on content analysis output, content is selected for either automated migration process or manual migration process. # For manual migration, administrator uses Vignette CMA to create content instances in the V7 content repository. # Automated migration process fetches content from V6 content repository on production stage, applies transformation logic and inserts content instances into V7 content repository on management stage. # Once content is committed in the V7, Vignette content creation workflow triggers. # Migrated content is reviewed and approved through Vignette workflow process. # Manual content checks for data quality and data integrity should be carried out at this stage. # Approved content then goes through Vignette publish workflow process and get published on the production stage. # Content is displayed on the Website using Vignette content delivery process.

Automated Content Migration Process

This process defines an approach for automated content migration. Content Analysis step has identified content that can be migrated by automation and also defined mapping between V7 and V6 content data. Now, same content data will be passed through this process for an automated migration. Content that can not be migrated automatically need to be carried out manually. Automated migration can be achieved in two ways: # Using Vignette content management APIs # Using VBIS adapter process Vignette Content Management APIs Vignette provides content management APIs to manage content instances. Using this APIs XML code of objects can be imported and exported to and from the Vignette content suite. Following diagram gives a broad overview of the approach for content migration using V7 Content Management APIs.
Vignette Content Migration Diagram

Diagram: Automated Migration Approach 1 - V7 Content Management APIs V7 expects XML objects of content instances for import and export. To import content instance of a particular Content Type into V7, one needs to get an exact XML structure of the Content Type. There are two ways to get XML structure of Content Type in V7: # Export XML object of existing Content Type from V7 using APIs. # Get XML object of Content Type from ‘content type definition’ in Vignette CMA console. Pure Java programs can be written to handle the migration process. Java program connects to the V6 content database on the management stage using JDBC driver. Content analysis step has identified content to be migrated from V6 system. Identified content is fetched from V6 database. This data is applied transformation logic as derived in the content analysis step to map it to the V7 Content Type. Transformed data is used to form XML object for a particular Content Type. XML data is then used to create new content instances using V7 content management APIs. Java Code Snippets Code to export XML of existing content instance for Article Content Type in V7:
Vignette Content Migration Diagram
Code to import XML of Article content instance in V7:
Vignette Content Migration Diagram
VBIS Adapter Process V7 Business Integration Studio (VBIS) provides a graphical user interface for building adapter processes. VBIS provides adapters for database connection, VCM connection and other processing. Using these adapters, a flow diagram is created to transfer data from one point to other. The following diagram gives a broad overview of the approach for content migration using VBIS Adapter process.
Vignette Content Migration Diagram

Diagram: Automated Migration Approach 2 – VBIS Adapter Process VBIS flow diagram is created using adapters. JDBC adapter connects to the V6 content database on the management stage using JDBC driver. Content analysis step has identified content to be migrated from V6 system. Identified content is fetched from V6 database. This data is passed through the custom built transformation adapter. The transformation adapter can be written in VBIS Basic language that contains transformation logic as mentioned in the content analysis to map data to the V7 Content Type. Finally the transformed data is passed through the V7 VCM adapter to create new content instances.

Conclusion

By following a well defined migration process, content can be migrated from older Vignette versions into V7 with less manual intervention and less effort.

About the Author

Sandip Mane is a Sr. Technical Architect at Infosys Technologies Limited.