Netezza Connector Stage - DSN

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
nvalia
Premium Member
Premium Member
Posts: 180
Joined: Thu May 26, 2005 6:44 am

Netezza Connector Stage - DSN

Post by nvalia »

Hi All,

The Netezza Connector stage needs the DSN, User, Password and Database Name.

When we create the DSN we are already providing the User, password and Database Name, so why do we need to specify this again in this stage

Any reason for this duplicacy?

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

Post by chulett »

Remove it from the DSN.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nvalia
Premium Member
Premium Member
Posts: 180
Joined: Thu May 26, 2005 6:44 am

Post by nvalia »

Thanks

Even after removing the Database Name, User and Password info from System DSN and passing values in the Netezza Connector Stage (via Params) works fine.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Exactly. :wink:
-craig

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