Data Integration

Data integration tools can be used to integrate data from a variety of data sources, including databases, spreadsheets, delimited text files, XML, JSON, KML and Web APIs. Most data integration tools provide graphical user interfaces that automate much of the integration process. The top leaders in the field of data integration are, according to Gartner: IBM, Informatica, SAP, Oracle and SAS.

Within this step we have described the activities that are essential when preparing the data for publication. An initial assessment of the data quality is necessary to determine if data cleansing and or data integration are needed to improve the data quality. In any case it is important to describe de actual data quality in the metadata.