Data Integration

"We provide the team that delivers using your preferred tools"



There is no doubt that Data Integration is difficult. Design and development often consumes 60% to 80% of a BI project. Usually project and data‐mapping specifications are created up front in Microsoft Project, Word and Excel. The developer then translates this into the DI tool, but there is no closed‐loop process because the information is not stored in a common repository. Generally the process of designing, building and implementing new integration links and transformations is too ”slow” to be able to meet the needs of the current fast changing business environment.

In particular data mapping is usually a very labor‐intensive, manual process, and despite the current sophistication of many tools they fail to provide effective help with the mapping of data entities and definition of objects. This remains a largely manual process.

Although many of the tools for DI are now based around the use of graphical interfaces they are still focused on use by ”developers” rather than ”business users.” All too often these UIs look different and behave very differently from one module to another, compounding the complexity of learning and using the tool.

DI is our speciality. We can assist in the unbiased selection of the most suitable tools, or work with your preferred vendor products. Our consultants are experienced in the use of Informatica, SAP/BO, ..

"Informatica has developed their product offerings far beyond the data warehousing and data integration arena. Their offerings now deal with problematic issues like ERP integration, data quality, identity management, master data management (MDM), data stewardship, metadata control, and synchronisation of data from the ERD through ETL to the target systems. There are many enhancements in the latest version of Powercenter Advanced edition that can help our customers with their data integration issues"

Scott, Informatica Consultant at Hawkland Solutions.