|
I remember doing the same almost 30 years back, copying data from an Oracle database to an MSSQL database. It was a fairly limiting approach, performance wasn't great, and diagnosing problems was a total PITA. Afterwards I did an integration using an antiquated version of BizTalk, which was all based on COM and to this day remains my most loathed software ever. It was way too complex, the UI was crap, it was flakey as hell, and ridiculously slow. Later versions got better, but it was a very low bar. Later I used a Java-based Apache project to do an integration - I forget the name. It was actually really good, easy to use but also allowing full control. Later still, I did some integrations using custom C# code based around WWF (Windows Workflow Foundation) - the UI in Visual Studio was horrendously slow and flakey, it was too complex to build your own pipeline segments, and difficult to diagnose issues in production. But it did work fairly well for simple stuff. And then later still I used PowerCenter - I was the architect, so wasn't that hands on, but the PowerCenter guys liked it, and we ended up adopting it as our standard integrations tool, with hundreds of integrations across the company. |