Can DataStage call Oracle APIs?
Moderators: chulett, rschirm, roy
Can DataStage call Oracle APIs?
Can DataStage call Oracle APIs?
DataStage is going to be used for
1. Batch interfaces from legacy to Oracle Advanced Pricing
2. One-time conversions of legacy data to Oracle Advanced Pricing. We will not be using Oracle Warehouse Builder
it seems like we cannot load data into Advanced Pricing except though APIs
so can we connect to Oracle API from DataStage, is stage we can use in DataStage?
1. Batch interfaces from legacy to Oracle Advanced Pricing
2. One-time conversions of legacy data to Oracle Advanced Pricing. We will not be using Oracle Warehouse Builder
it seems like we cannot load data into Advanced Pricing except though APIs
so can we connect to Oracle API from DataStage, is stage we can use in DataStage?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If these APIs are exposed as Oracle functions or stored procedures, then the answer is yes out of the box.
If it's a C-callable API, then the answer is yes but only via customization - either a parallel routine invoked from a Transformer stage or a user-written stage type.
If it's a C-callable API, then the answer is yes but only via customization - either a parallel routine invoked from a Transformer stage or a user-written stage type.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Are you and the OP the same? How are you related to this post?raki wrote:We have functions which calls Oracle APIs. Now how can we use those functions in DataStage. Can we use stored procedure stage?. How can we pull data using stored procedure?
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE