You have an ongoing requirement to move data from one database to another. In this case, your operational data is in DB2 database running on z/OS on the company mainframe. There is a business need to periodically copy the data to an Oracle database. (The DB2 system is “off-limits” when it comes to ad hoc reporting.)
There are many excellent ETL (Extract, Transform, and Load) tools on the market that might be considered – open source and closed source, both commercial and free. Whether free or $$$, they often take substantial investments in time and skills to get working.
There are a number of SQL desktop tools that might help extract data from one system, put it into some type of intermediate file, and push it into another. But these tools typically can’t take advantage of the high-performance capabilities of the ETL tools, or the brand-specific loading tools, like Oracle’s SQL*Loader utility. They just do traditional database inserts either via ODBC or JDBC.
Well, then why not simply use Oracle’s SQL*Loader? Much easier said than done. You’ll be faced with control files and command lines, and that’s just the “load” part. What about getting the data out of your DB2 system, properly prepared for loading into Oracle? Is there a DB2 “unload” utility?
What if you could move your data from DB2 to Oracle without buying an expensive application? What if you could avoid having to learn a complicated application? What if you could move your data by simply pointing-and-clicking, by simply configuring a Windows Control Panel? Extracting and inserting your data by using nothing more than an ODBC driver? Yet, still get support for Oracle’s bulk protocols for maximum performance? With Progress DataDirect Connect and Connect64 for ODBC, it can be that easy!
How would you do this? Install a couple of ODBC drivers, click a few buttons, and you’ll have copied data from DB2, and loaded your data into Oracle! Seriously!
Over the next two days I will publish a two part series. Part 1 will explain the ease at which you can extract data from DB2, and part 2 explain loading this data into Oracle in a few simple steps, with nothing more than an ODBC driver!
View all posts from Greg Stasko on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.