SQL Server Connection

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

Post Reply
tostay2003
Participant
Posts: 97
Joined: Tue Feb 21, 2006 6:45 am

SQL Server Connection

Post by tostay2003 »

I want to connect to SQLServer, and I am using Ascential 7.5.1. I dont see any plugin of SQLServer. Is it abnormal, not to have plugin for SQLServer???

Will DRS (Dynamic RDBMS stage), work to extract data from SQLServer??? (I heard this from someone,but not for sure).


or do i need to go for ODBC only, is there no other stage???

and does ODBC connectivity work for SQLServer. Because ODBC connectivity didnt work for netezza in version 7.5.1
Top
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

There should be a plug-in available for SQL Server. May be it was not installed. Besides, you can also use DRS and ODBC to connect to SQLserver and extract data. I have connected to SQLServer using plug-in and ODBC earlier.
Kris

Where's the "Any" key?-Homer Simpson
Top
shawn_ramsey
Participant
Posts: 145
Joined: Fri May 02, 2003 9:59 am
Location: Seattle, Washington. USA

Post by shawn_ramsey »

kris007 wrote:There should be a plug-in available for SQL Server. May be it was not installed. Besides, you can also use DRS and ODBC to connect to SQLserver and extract data. I have connected to SQLServer using plug-in and ODBC earlier.
If you are on Unix then your only choice is ODBC. DRS may support SQL Server but it would still be using the ODBC drivers.
Shawn Ramsey

"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
Top
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

Missed the Unix. I thought I read it as Windows. On windows you do have a plug in for SQLServer(I have used that earlier and that is what I meant in my earlier post). We are currently using ODBC and DRS to connect to SQLServer here on Unix.
Kris

Where's the "Any" key?-Homer Simpson
Top
tostay2003
Participant
Posts: 97
Joined: Tue Feb 21, 2006 6:45 am

Post by tostay2003 »

Thanks for the help
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

Set up the ODBC connection, make sure you use a hostname and not an IP if your SQL-Server is on a DHCP assigned machine. Also, you need the port number as well, very important.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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 »

You could hunt for a version of SQL Server that runs on UNIX, but you won't find one. You could create your own plug-in stage, but it's really not worth the effort. The vendor supplies a UNIX-based ODBC driver that can connect to SQL Server on Windows.
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
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Post by yaminids »

I have been using ODBC to connect to SQL Sever for a year now and did not run into any kind of issues
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As have we.
-craig

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

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”