Can DataStage call Oracle APIs?

y2ariyas · Post by **y2ariyas** » Fri Dec 22, 2006 10:55 am

chulett · Post by **chulett** » Fri Dec 22, 2006 10:58 am

Define exactly what you mean by 'Oracle APIs' in this context.

DSguru2B · Post by **DSguru2B** » Fri Dec 22, 2006 10:58 am

Like for example, what specific API are you looking to execute. If it can be executed from command line, i believe it can be executed within DataStage. Need more info for a specific answer.

y2ariyas · Post by **y2ariyas** » Fri Dec 22, 2006 2:02 pm

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?

ray.wurlod · Post by **ray.wurlod** » Fri Dec 22, 2006 4:18 pm

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.

raki · Post by **raki** » Wed Dec 27, 2006 3:38 pm

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?

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 3:41 pm

Using Stored procedure Stage.

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 3:44 pm

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?

Are you and the OP the same? How are you related to this post?