In today's data driven world the ability to seamlessly move and transform data is a must have. Additionally, communication between business teams can greatly benefit from a common representation of data. The TIBCO EBX® Data Exchange Add-on meets all of these requirements and allows you to import, export, transfer, transform and model data.
All data flow requires mapping between a data source and target. In some cases the add-on can automatically propose a mapping, in others a custom mapping is required. The following bullet points describe these two scenarios further:
Default add-on functionality allows business users to import, export, and transfer data between sources and targets of similar structure. No additional configuration is needed.
The add-on also allows users to move data between disparate sources and targets, and to transform data. An administrator will need to configure the add-on if this functionality is required. However, as an added benefit to business users, this happens behind the scenes. Their data flow tasks aren't burdened with increased complexity.
Simply put, the add-on's data modeling capabilities allow you to generate a TIBCO EBX® compliant data model from an XML, Excel, or DDL file. This process is outlined below:
Create a data model by pointing the add-on to a compatible source file containing the model's structure.
Generate an XSD file that contains the data model and is compliant with EBX®.
Create, or use an existing, data model using the Data Modeler Assistant and import the XSD file.
See the Dynamic Data Modeling User Guide for more information.