Data integration and mash ups

techie | May 8 - 2010

Data Integration is concerned with combining data from various Sources into one consistent stream. It provides an essential Single View of Data, for example, a Single View of a Customer.

Various resources may be necessary for a business so that he can get all the data in one place quality of the data is uniformly good, it can be integrated and it may be presented in a table format for the user.
A glossary will also be provided as the user has to understand the technical terms abbreviations and code. Data mash ups, consumer mash ups and enterprise mash ups are few types of mash ups.

Data mash ups are used to combine similar types of media, and information from multiple sources. They are compiled as single presentation spread sheets. This may result in a new and unique web service that does not resemble the web services from either source.

Consumer mash ups compile Visual elements and data from multiple sources.
business mash ups encompass applications that is a combination of their own sources, application and data. Data is put into a single presentation and gives provisions for collaborative action among businesses.

Enterprise mash ups are meant for development projects that require interaction between developers and customer. They are secure and have web applications that open up actionable information. This information is from a multitude of external and internal information resources.

Web-based mash ups typically use the user’s internet browser combine and reformat the data. Server-based mash ups analyze and reformat the data on a remote server and transmit the data to the user’s browser in its final form.

Data from different file formats could be easily transferred to the most commonly used file formats. This reduces the time for installing a tool every time when you need to integrate the data.

Apatar is an open source plat form that helps to integrate data easily through simple steps. customizes the data integration to suit the customer requirements.

Connectivity to Oracle, MS SQL, MySQL, Sybase, DB2, MS Access, Postgre SQL, XML, Instant DB, Paradox, BorlandJ Data Store, Csv, MS Excel, Qed, HSQL, Compiere ERP,, Sugar CRM, Goldmine and more are possible.