Data mashup is the process of gathering content from more than one sourceand merging that information in order to present a clear and concise viewof that data. The Sun Data Mashup Engine is a JBI-compliant service engine that provides EnterpriseData Federation, or mashup services, in multiple forms. It provides a singleview of data from dissimilar sources, including static web pages, tabulardata exposed as web services, relational databases, flat files, and so on.The Sun Data Mashup Engine joins, aggregates, and cleanses the source data, and then exposesthe resulting data set in a unified view, providing real-time views of informationfor master data consumers.
You are watching: What is the role of a mashup editor?
Sun Data Mashup Engine Overview
The Sun Data Mashup Engine provides server side mashup for dispersed data. More specifically,it provides a single relational view of data that have different origins butare located within the same enterprise. You use the service engine to integrateinformation from delimited flat files, fixed-width flat files, relationaldatabases, RSS Feeds, web (HTML), XML, WebRowSet, and Microsoft Excel spreadsheets,and then join the various data sources, cleanse the data, and generate a report.After a successful deployment of the composite application, which containsthe Data Mashup project, you can open the generated report in a browser, whereit functions as a web service and can consume other applications.
You can use the Sun Data Mashup Engine to build a NetBeans project with unified viewsof your data from different sources, configure the project, create and deploya composite application, and enable the generated report to function as avirtual database. Data Mashup is a standalone product. It can, however, exposecertain JBI-based MDM Suite data sources as services.
There are several classifications of data mashup.
Sun Data Mashup Engine Features
Sun Data Mashup Engine provides your business with a powerful assortment of design-timefeatures that you can use to create and configure Enterprise Data Mashups.The runtime features allow you to monitor the mashup processes and to reviewany data errors.
The Sun Data Mashup Engine provides the following features:
Exposes data services for Web 2.0 mashups and real time viewsfor MDM clients.
Supports JSON as well as WebRowSet.
Supports both SOAP and REST invocation.
Leverages various Binding Components (BCs) to access ERP/CRMsystems. The XSLT Service Engine can be used for further transformation.
Creates a unified view of data from disparate sources.
Integrates information from a variety of heterogeneous sources,including relational databases, flat files, DCOM documents, spreadsheets,XML documents, HTML documents, RSS and Atom feeds, and Xquery row sets. toprovide unified view.
Provides data mashup services capabilities for SOA using theOpenESB and NetBeans infrastructure.
Exposes the aggregation of multiple data sources to mashupclient frameworks, enabling Web 2.0 type applications in an enterprise.
Provides time-bound view caching for improved response timesand can be called as a virtual materialized view.
Provides multiple views of the resulting data through XSLTtransformation by applying a composite weaving pattern.
Transforms the resulting data set into various formats byweaving the output with an XSLT Service Engine, enabling deployment on multiplechannels.
Ensures extensibility through the ability to consume JBI Services.
Reuses the NetBeans Database Explorer to browse source tablesand to drag and drop source tables into the Data Mashup Editor to define thejoin conditions.
Provides the ability to view the result set using the DataMashup Editor cache management view features.
Creates a data services layer in true service-oriented architectures.
Enables integration on-demand. The mashed up views can beused by clients to build highly responsive and interactive enterprise applicationsusing existing client-side frameworks.
Sun Data Mashup Engine Architecture
The Sun Data Mashup Engine design-time components allow you to specify the data sourceand target databases, map source fields and columns to target fields and columns,define custom processing, and test and validate the Data Mashup processes.Design-time components include the NetBeans project system, a wizard to guideyou through creating and configuring Data Mashup process, and a mapping editorwhere you can map source and target data and customize the transformation.The output of a Data Mashup process can be further weaved with the XSLT ServiceEngine to produce different output formats that can be deployed to multiplechannels. The following diagram shows the Sun Data Integrator components and their relationshipto one another.
Figure11 Data Mashup Architecture
Sun Data Mashup Engine Development Phase
The development phase consists of standard tasks for specifying sourceand target databases and advanced tasks for further customizing the data transformationlogic.
Standard Development Tasks
The following steps outline the basic procedure for developing an ETLprocess using Sun Data Integrator.
Create a virtual database.
Add the external tables containing the content to aggregate.
Create a new Data Mashup project in NetBeans.
Using the wizard, create the Data Mashup file.
Using the Data Mashup Editor, specify join and filter conditions.
Add the Data Mashup service to a composite application.
Build and deploy the composite application.
Test the deployment.
Advanced Development Tasks
You can perform additional tasks during the development phase to customizeyour Data Mashup application further.
Data Transformation –Add operators to join and filter conditions to create advanced SQL queries.
Business Process Integration -Call a Data Mashup process from a BPEL business process, web service, Javaclient, or other application.
Multiple-Channel Deployment -Weave Data Mashup with XSLT using the CASA Editor to create multiple assemblieswith different style sheets to support multiple distribution channels.
Data Mashup Wizard
The Data Mashup Wizard takes you through the steps to set up an EnterpriseData Mashup and, based on the information you specify, creates a collaborationthat defines the configuration of the process.
Figure12 New File Wizard for Data Mashup
Enterprise Data Mashup Editor
Once you define the Data Mashup framework using the wizard, you canfurther customize the configuration Collaboration Editor.
Figure13 Enterprise Data Mashup Editor
Sun Data Mashup Engine Runtime Phase
Once all of the development tasks are complete and the system is running,you can perform any of these maintenance tasks.