MS SQL Sever Connectivity for Parallel extender

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
imbos123
Charter Member
Charter Member
Posts: 18
Joined: Mon Jul 24, 2006 1:43 pm

MS SQL Sever Connectivity for Parallel extender

Post by imbos123 »

I need to coonect to MS SQL server to get data from the tables. Which stage I should use for it. I am using Datastage parallei edition and installed on UNIX.
Thanks
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Welcome Aboard,
You can use either the ODBC stage or the DRS stage. I am not exactly sure if PX is equipped with DRS or not, if it is, go for that.
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
shawn_ramsey
Participant
Posts: 145
Joined: Fri May 02, 2003 9:59 am
Location: Seattle, Washington. USA

Re: MS SQL Sever Connectivity for Parallel extender

Post by shawn_ramsey »

imbos123 wrote:I need to coonect to MS SQL server to get data from the tables. Which stage I should use for it. I am using Datastage parallei edition and installed on UNIX.
The ODBC Stage
Shawn Ramsey

"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
Top
mctny
Charter Member
Charter Member
Posts: 166
Joined: Thu Feb 02, 2006 6:55 am

Re: MS SQL Sever Connectivity for Parallel extender

Post by mctny »

imbos123 wrote:I need to coonect to MS SQL server to get data from the tables. Which stage I should use for it. I am using Datastage parallei edition and installed on UNIX.
ODBC stage, however you need to have corresponding records in your odbc file in DS home directory in unix, anything else?
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Top
imbos123
Charter Member
Charter Member
Posts: 18
Joined: Mon Jul 24, 2006 1:43 pm

Post by imbos123 »

Thanks for your help. I gotch u.
Thanks
Top
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

I prefer DRS to ODBC , for some of my tables I cannot see data using ODBC properly, I get all ????, might be some setting problem I am not aware of but DRS works very good for me :) .
Kris

Where's the "Any" key?-Homer Simpson
Top
mctny
Charter Member
Charter Member
Posts: 166
Joined: Thu Feb 02, 2006 6:55 am

Post by mctny »

kris007 wrote:I prefer DRS to ODBC , for some of my tables I cannot see data using ODBC properly, I get all ????, might be some setting problem I am not aware of but DRS works very good for me :) .
I thought DRS is slow, never tried though.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Just for completeness, there is a SQL Server Enterprise stage available on the Windows-platform DataStage EE.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

mctny wrote:I thought DRS is slow, never tried though.
I personally didnot notice any difference(both of them are slackers anyway)
Kris

Where's the "Any" key?-Homer Simpson
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”