Hi ,
Oracle ERP Ver 11.4.5 is accessed through OCI stage (Am using DataStage Ver 4.2 on NT) to extract Data from Oracle ERP to SQL Server for reporting purposes.
ODBC stage for Oracle does not work on DataStage 4.2 .It will give an error message.
1.Step I set ODBC Connectivity to Oracle ERP using ODBC Administrator/UNIX (am not a unix guy - u need to check)
2.During Installation of DataStage, you need to invoke the plugin for oracle
3. Once the ODBC is set , your plug in can be invoked from manager , import table definition --- plugin
4. Your job designs will use OCI stage instead of ODBC( Red colour cylinder instead of ODBC blue )
5. OCI Stage does not allow you view data option on the output side i.e when you write from any stage onto Oracle OCI , you will not be able to use the view data option
6. Last but not least, Oracle OCI stage DOES NOT USE NUMERIC ROUND FUNCTION Of DS Transform i.e when you use the NumericRound function , you will get data truncated messages.
Use Oracle ROUND function from the input side itself....
ALL THE VERY BEST
Srinivas.B
Srinivas.B
Dubai
Mobile :00971507380893
about oracle erp
Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration