DataStage 8.7 and Oracle 12.1

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
lazyscar
Participant
Posts: 4
Joined: Sat Feb 16, 2013 8:17 pm

DataStage 8.7 and Oracle 12.1

Post by lazyscar »

I need to use DataStage 8.7 to connect to Oracle 12.2.0.1. IBM told us to upgrade to 11.5. But I can't find a 32-bit 11.5 client , they only have 64-bit.
All of our working PC are 32-bit Windows 7.

So, is there anyone using 8.7 to connect to Oracle 12 successfully?How is the performance?

Or can I use 8.7 ODBC to connect to Oracle 12?

Thanks!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

They suggested you upgrade not because that older version won't work, but because it is... really old... and (I assume) no longer officially supported. While you could use ODBC I don't see the need, stick with native Oracle connectivity.
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Yup - 8.7 went "EOS" (End of Service) on April 30, 2017.

I checked the Oracle client / database compatibility matrix which says the Oracle 11.2 client is certified to access the Oracle 12 database.

If you could at least upgrade to 9.1, you might have a chance. IIS 9.1 did support the 11g client, which supposedly can be used to connect to a 12c database. It also is the last release that supports 32-bit clients on Windows 7.

The good news is that IBM still supports 9.1 for a few more months...
http://www-01.ibm.com/support/docview.w ... 3v13428u57.

That's your best bet.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

We use to run DataStage 8.7 jobs on AIX using an Oracle 11 client to read and write against Oracle 12 databases. No performance issues. We also upgraded to DataStage 11.x prior to the 8.7 hitting the end of its support life cycle in April 2017. And yes, the DataStage 11.x client requires 64-bit Windows.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply