| Many companies viewpoint of data integration is | | | | processes of change data capture. These prebuilt |
| blinkered, they see it as something that is purely IT | | | | transformations increase the productivity of the |
| department related and is involved with the mythical | | | | developer productivity and allow a greater |
| subjects of ETL and data warehousing. They are | | | | consistency in the final results.. |
| missing, and therefore not utilising the power behind | | | | Data integration is chiefly associated with batch |
| these tools to harness all the information held by | | | | processing (ETL) that then send the transformed |
| the company and use it productively | | | | data to data warehouse or some other storage |
| If you ignore the advantages of Data integration, | | | | based technology such as EAI, EII or SOA. The |
| warehousing and ETL you are paying a high price | | | | reality of working this way is that companies had to |
| for integrating data, thereby encouraging the | | | | start from scratch every time they had a new data |
| creation of data silos and forces the spending of an | | | | integration task. This resulted in data silos being built |
| inordinate amount of time reconciling data to fill the | | | | using different technologies, therefore producing |
| information gaps. | | | | inconsistent business intelligence. |
| Seen simply data integration involves the ability to | | | | Data integration vendors are now combining all the |
| gather information, transform it into something | | | | relevant technologies into data integration suites |
| understandable and then present it in a way that is | | | | which enable companies to integrate data in a |
| useful to the stakeholder. Now that is ETL in a | | | | consistent manner with the appropriate transport |
| nutshell. ETL tools allow the automation of these | | | | technology. |
| tasks and give developers a toolkit to enhance their | | | | As more powerful suites, data integration has |
| hand-coding abilities. These tools, for example, | | | | evolved and now includes such initiatives as:data |
| include transformations for the basic tasks of | | | | migration, application consolidation, business |
| converting data and performing lookups to complex | | | | information and and product information management. |