I was invited to attend a conference call to discuss two items attached to the meeting invitation. I had been involved in neither of them until that point. I decline, pointing this out. They insist. So I dial in, and wish I hadn’t… except that, if I hadn’t dialled in, I wouldn’t be able to bring you this little nugget of WTF-itude.
There’s a major ETL project. Y’know – Extract, Transform, Load. Except that they (again) seem to be ignoring the “T” part, or, indeed, the part about making sure they can accurately read the data from the source SQL Server and put it into the destination Oracle server. In the immortal words of the ancient philosopher Clarksonius, “How hard can it be?”
(from 5 seconds onwards)
The discussion got to the point where they asked us to re-design the database and rewrite the applications so that they could extract the data more easily.
No, you didn’t misread that.
Ain’t gonna happen. This is a system that has been running in production for several years, and has data feeds in both directions that will also be affected (and lacks the necessary documentation to ensure that we could hit them all, if we were inclined to follow this insanity). On the other hand, *they* are still building and testing their extraction routines…