Migration and conversion - connect_cdc_sqdata - 4.1

Connect CDC (SQData) Architecture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
4.1
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Architecture
Topic type
Installation
How Do I
Copyright
2024
First publish date
2000
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T13:24:57.122078

Legacy systems are often the lifeblood of a company. Migration to newer technologies can be a slow and painful process particularly with large "homegrown" applications. Sometimes the transition can be accomplished with a one time data conversion, often however the migration plan requires months or even years. Connect CDC (SQData) can address both use cases, sometimes even at the same time. The flexibility of the Apply Engine can transform virtually any source data to any target data structure for a one-time conversion.

One-way migration strategies may require current data from the source platform for an extended period of time while the ongoing conversion of individual applications or subsystems take place. Sometimes it is necessary to capture data from the applications whose migration is complete in order to support other formerly integrated applications still running on the original platform and database. When the source and target applications both utilize relational databases, two way replication can be relatively painless. Migration involving a change in data structure, for example from hierarchical to relational can be accommodated with minimal effort. Even the reverse flow of changes, from the a relational database back to the a legacy hierarchical database can be accomplished but the design of the relational database may require some additional data to facilitate the relational to hierarchical data mapping.