Relationships overview
WebSphere Process Server V7 WebSphere Integration Developer V7 Relationship instance data migration
This presentation will provide details on the enhancements made to relationship editor and how the relationship instance data migration is made simpler in version 7.0
Relationship editor and manager enhancements
Relationship editor and manager enhancements Before version 7.0, there is no direct way to import the relationship instance data from the existing spreadsheet to WebSphere Integration Developer; from the existing spreadsheet to WebSphere Process Server; from WebSphere Process Server back to WebSphere Integration Developer; from WebSphere Process Server back to the spreadsheet; from WebSphere Process Server to WebSphere Process Server for migration. New V7
In versions before version 7.0, there is no direct and easy way to migrate the data from one format to another or from one environment to another easily. The relationship data had to be manually entered in WebSphere Integration Developer editor by business operator.
Relationship editor Enhancements
Relationship editor Enhancements Export comma separated (CSV) data on static relationship instance from relationship editor Import CSV data on static relationship instance into relationship editor New V7
Shown here in the highlighted red box are the enhancements to relationship editor in WebSphere Integration Developer. In version 7.0 pre-defined static relationship data stored in a spreadsheet can be imported into WebSphere Integration Developer’s relationship designer as comma-separated values, or CSV, files. The relationship instance data input in WebSphere Integration Developer can be exported back to the spreadsheet in the format of comma-separated values.
Relationship editor enhancements
Relationship editor enhancements Improved the relationship instance pre-population user interface: Before version 7.0: The view is a mapping to the XML file. Version 7.0: The view is a mapping to the real table. New V7
In versions before 7.0, the relationship instance pre-population user interface used to show a mapping to the XML file, but now in version 7, the view is a mapping to the real table which is easier and simpler to do.
Relationship manager enhancements
Relationship manager enhancements Export and import comma separated value (CSV) data on static relationship instance from and into relationship manager Export and import static relationship instance data in relationship instance format from and into relationship manager New V7
Shown here in the highlighted red box are the enhancements to relationship manager in WebSphere Process Server. If the relationship instance data is updated in WebSphere Process Server, it can be exported back into WebSphere Integration Developer, or spreadsheet in the format of comma-separated values. It is also easier to migrate the relationship instance data from one server to another by exchanging the relationship instance or comma-separated values file. Relationship instance data is a xml based format that captures the data along with any metadata attached with the data like roles and other attributes.
Relationship instance data – CSV formats
Relationship instance data – CSV formats Two types of CSV are supported Simple format Lossless format Usage import your existing data. To exchange data between Excel, WebSphere Integration Developer and WebSphere Process Server. Import Supports any kind of comma-separated values format. The users should bind the columns to the roles when importing. The format strictly matches the definition. No binding interaction is needed when importing. Export Contains only the instance data values. Minor data loss. Contains the instance data values, the property data, and the meta-data. No data loss. Supported by WebSphere Integration Developer WebSphere Integration Developer Supported by WebSphere Integration Developer WebSphere Process Server Creation Created by the spreadsheet editor or WebSphere Integration Developer Created by WebSphere Integration Developer, WebSphere Process Server New V7
Two types of comma-separated values are supported, simple and lossless format. The CSV file is simple and can be opened by Excel and similar editors, which enables the business people to edit the relationship instances directly. Simple format just contains data separated by commas. So when you import the data into WebSphere Integration Developer, you need to manually map the columns to roles. Lossless format contains information on roles, property data and metadata information so no manual mapping of roles is needed when importing into WebSphere Integration Developer. Lossless format is supported by WebSphere Process Server for both import and export of the instance data.
Relationship instance data – Relationship instance format
Relationship instance data – Relationship instance format an XML file that contains details on roles, role instances, properties and meta data, Can be directly imported into WebSphere Process Server and exported from WebSphere Process Server. Relationship instance file New V7
Shown here is an example of the relationship instance format. It is an xml file that defines the roles, role instances, namespace, properties and metadata that goes along with the data. Data in relationship instance format can be directly imported into WebSphere Process Server. You can export the relationship instance data from WebSphere Process Server in the relationship instance format which simplifies the process of migrating data from one environment to another.
Summary
Summary Section
This section will provide a summary of this presentation.
Summary
Summary WebSphere Integration Developer relationship editor enhancements Relationship editor enhanced to support import/export of relationship instance data in comma separated format WebSphere Process Server relationship manager enhancements can import relationship instance data into WebSphere Process server in CSV and relation ship instance (.ri) format Relationship instance data from WebSphere Process Server can be exported into CSV or relationship instance (.ri) format
To summarize, relationship instance data migration is made simpler in version 7.0. WebSphere Integration Developer relationship editor is enhanced to support import/export of relationship instance data in comma separated format. You can now import relationship instance data into WebSphere Process server in CSV and relation ship instance (.ri) format. Relationship instance data from WebSphere Process Server can be exported into CSV or relationship instance (.ri) format making migration of data from one environment to another simple
Feedback
Feedback Your feedback is valuable You can help improve the quality of IBM Education Assistant content to better meet your needs by providing feedback. Did you find this module useful? Did it help you solve a problem or answer a question? Do you have suggestions for improvements? Click to send e-mail feedback: mailto:iea@us.ibm.com?subject=Feedback_about_WBPMv70_Rels_InstanceData_Migration.ppt This module is also available in PDF format at: ../WBPMv70_Rels_InstanceData_Migration.pdf
You can help improve the quality of IBM Education Assistant content by providing feedback.
Trademarks