We just completed 8.1 DataStage installation on Windows OS. I need to
create a connection to SQL Server 2008. But when I create a parallel job
and pick SQL Server Enterprise, I do not know how to point to the SQL
Server environment. Is there a step-by-step documentation that I can
follow anywhere or has anyone successfully connected to SQL Server
without using ODBC ?
Thanks!
DataStage and SQL Server 2008 connectivity
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 13
- Joined: Wed Apr 07, 2010 11:50 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Open the manuals (Start > All Programs > Information Server > Documentation) and scroll down to "Connectivity Guide for Microsoft SQL Server and OLE DB Data"
Open the manuals (Start > All Programs > Information Server > Documentation) and scroll down to "Connectivity Guide for Microsoft SQL Server and OLE DB Data"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 13
- Joined: Wed Apr 07, 2010 11:50 pm
I have been able to create a connection to SQL Server from Windows but
not much luck on the Linux server. Does anyone know if SQL Server Enterprise Stage is available ?
I was able to create an ODBC data source but wondering if there is a simpler way.
Eventually, what I'm trying to accomplish is be able to pass different
database names in my job parameters at runtime. Using ODBC would
mean that I have to pre-create all data sources ahead of time.
not much luck on the Linux server. Does anyone know if SQL Server Enterprise Stage is available ?
I was able to create an ODBC data source but wondering if there is a simpler way.
Eventually, what I'm trying to accomplish is be able to pass different
database names in my job parameters at runtime. Using ODBC would
mean that I have to pre-create all data sources ahead of time.
N.K.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: