PL/SQL stored procedures…just about everybody’s got some of this legacy code, but who wants to deal with it? Most IT leaders we talk to put in the bare minimum to maintain their PL/SQLs since the cost of migrating the code (a very labor intensive process) outweighs the benefits. As a result, data managers opt to ‘kick the can’ down the road, hoping a better solution will someday present itself for modernizing messy legacy code.
If you, too, have been waiting for a better option, then that day may come sooner than you thought (or hoped). At Informatica World 2017, Bitwise demonstrated our very unique value to the data community by showcasing an automated approach to modernizing legacy PL/SQL and T-SQL code.
Just about everyone we talked to at the event said that they have this code that somebody wrote a long time ago, and they’ve got to keep someone with a special skill set to maintain it. While the jobs run as intended, the code is nearly undecipherable, creating an untenable long-term risk and making the possibility of converting it to a newer ETL tool a painful proposition.
Sound familiar? It did to many of our customers, too, which is why we developed a capability to automate the conversion of PL/SQL or T-SQL (or any ETL) to Informatica or any other ETL platform.