OCI PLUG IN

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

OCI PLUG IN

Post by vasubabu »

Hi,

I am working with Parellel jobs version 8.0.1 on windows server.I am not able to find the OCI stage in my pallete.How can i get the OCI stage into my palette.Do i need to install the oracle drivers separatly?can anybody gicve me the solution?i am able to connect to oracle through DRS stage.
VASU..
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The "OCI" stage is a Server stage. For PX you would use the OE or Oracle Enterprise stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Post by vasubabu »

chulett wrote:The "OCI" stage is a Server stage. For PX you would use the OE or Oracle Enterprise stage. ...
Yes.that OE stage only i am not able to find in my palett.
VASU..
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you find it in the Stage Types branch of your Repository, specifically \Stage Types\Parallel\Database folder?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Post by vasubabu »

ray.wurlod wrote:Can you find it in the Stage Types branch of your Repository, specifically \Stage Types\Parallel\Database folder? ...
I have checked it but it is not there in stagetypes/database
VASU..
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Did you specifically check in StageTypes \ Parallel \ Database?
-craig

"You can never have too many knives" -- Logan Nine Fingers
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

In Designer

View-->Customize Palette -->Stage Type -->Parallel --> Database

Here you can add the stage to your palette
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

True... but the alleged issue is the fact that it isn't even in the repository, so technically there would be nothing to add to the palette.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vasubabu
Participant
Posts: 153
Joined: Wed Jan 25, 2006 2:38 am

Post by vasubabu »

chulett wrote:True... but the alleged issue is the fact that it isn't even in the repository, so technically there would be nothing to add to the palette. ...
Isthere any other solution to get those stages?
VASU..
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What we're being told is that all stages should be installed automatically. One 'solution' might be to uninstall and reinstall everything but without knowing what happened the first time there's nothing to guarentee it won't happen again. You could always try it... but I would suggest contacting your official support provider for help with this.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply