Data Migration and the Market

1. Data Migration and the Market Philip Howard Research Director – Bloor Research

2. Agenda • What is data migration? • What’s happening in the market? • What are the vendors doing? • What will happen next? • Data(base) migration

3. What is data migration? A re-appreciation of Pervasive “Data migration is any movement of persistent data that involves some sort of restructuring of that data while the usage of that data (operational versus analytical) remains constant.”

4. Simple vs complex data migration • Simple data migration retains context • Complex data migration alters context

5. What’s happening in the market? • Anecdotally, there seems to be a significant increase in data migration projects • The fact that VCs are interested in the space is indicative • We plan to conduct a further survey into the market next year

6. If there is an increase – why? • Increased visibility • Methodologies and best practice • Expertise • Better tools • Zero-downtime We hope it’s because of de-risking

7. And … Does this also mean that there are less cost and time overruns?

8. Key elements of tools • Profiling (and re-profiling) • Business focus (& data quality, support for zero-downtime and so on)

9. What are vendors doing with profiling? • Starting to become aware that profiling has been too quality focused – certainly Dataflux and Trillium • Specialists (eg X88, Exeros [IBM]) offering extended capability, especially for complex environments such as MDM

10. What are the vendors doing with the business? Support for Business Entities is not the only aspect of Business Focus but it is particularly significant for data migration. With the exception of Celona, few vendors have specialised facilities to support data migration. In particular, they don’t support the concept of business entities – yet!

11. Business entities & vendors • Celona supports • SAP recommends working at this level but Business Objects does not have appropriate facilities yet – it probably will have • IBM acquired both Princeton Softech (Optim) and Exeros but no signs of implementing support for business entities along with DataStage • Informatica acquired Applimation and has definite plans to introduce support for business entities • Oracle introduced Edition-based Redefinition in Oracle 11gR2 and has acquired GoldenGate – no sign of support for business entities

12. What will happen next? • Big trend in data integration is business/IT collaboration • Glossaries and semantics • Verticals • Logical/physical separation • Specification generation • Would make sense to include business entities

13. What else will happen next? • Trend towards putting operational data into data warehouses • Analytic data warehouses often using operational database schemas

14. Data(base) migration • Business entities less important • Migration away from Oracle

15. Conclusion • Migrations seem to be on the up – we hope to confirm this, and the reasons behind it, and whether there are fewer/smaller overruns next year • Lots of profiling is probably the key to data migration • Profiling vendors waking up to need for cross-source discovery • For application-centric data migration support for business entities is a significant benefit • Vendors focusing on business/IT collaboration • Relatively slow to introduce business entities • Ultimately expect to become standard – but as option, not suitable for developers