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
sh_valavala
Participant
Posts: 3 Joined: Sat Jul 05, 2003 12:04 pm
Location: USA
Post
by sh_valavala » Wed May 25, 2005 4:00 pm
Hi,
To access SQL Server 2000 database, is there any exclusive SQL Server plug-in available with DataStage 7.5 version(server edition).
Regards
ShV
ranga1970
Participant
Posts: 141 Joined: Thu Nov 04, 2004 3:29 pm
Location: Hyderabad
Post
by ranga1970 » Wed May 25, 2005 4:38 pm
Nothing else other than ODBC
RRCHINTALA
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed May 25, 2005 4:41 pm
Exclusive? As in 'native', like the OCI stages for Oracle? No, not that I've seen.
-craig
"You can never have too many knives" -- Logan Nine Fingers
kiran_418
Participant
Posts: 40 Joined: Tue Feb 22, 2005 11:12 am
Post
by kiran_418 » Wed May 25, 2005 4:50 pm
Hi
New version of datastage 7.5.1 has plug in for Misrosoft OLE database and Microsoft SQl server Load.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed May 25, 2005 4:56 pm
True, but the MS OLEDB stage has been around for awhile and is a fairly 'generic' stage. There still isn't a native SQL Server plugin stage as far as I know.
-craig
"You can never have too many knives" -- Logan Nine Fingers
sh_valavala
Participant
Posts: 3 Joined: Sat Jul 05, 2003 12:04 pm
Location: USA
Post
by sh_valavala » Wed May 25, 2005 6:25 pm
I thank all,for your responses.
Is MS OLEDB is native Plug-in for SQL Server?
Which stage is best suitable to access SQL Server 2000 database with DataStage 7.5 server version.
Regards
ShV
ranga1970
Participant
Posts: 141 Joined: Thu Nov 04, 2004 3:29 pm
Location: Hyderabad
Post
by ranga1970 » Wed May 25, 2005 6:31 pm
I guess still its ODBC
RRCHINTALA
sh_valavala
Participant
Posts: 3 Joined: Sat Jul 05, 2003 12:04 pm
Location: USA
Post
by sh_valavala » Wed May 25, 2005 8:26 pm
Thanks Ranga.
Regards
ShV