Talking to SQL Server 2005 with DataStage Server 6.0

iansta · Post by **iansta** » Wed Nov 14, 2007 4:02 pm

Guys,

Is it possible to connect to SQL Server 2005 via datastage 6.0 server. I would image that I would be okay even if through ODBC.

Thanks

Ian

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 4:10 pm

Have you tried it?

iansta · Post by **iansta** » Wed Nov 14, 2007 5:55 pm

No, I've not been able to try it. I need the information as part of a matrix that we are putting together for a client to justify there upgrade to v8.

They are moving to sql 2005 but have not yet got implemented.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 8:43 pm

I don't understand. Or are you after a "no" answer to help justify the upgrade?

At one level ODBC is ODBC so, if you have the appropriate driver, then DataStage is just another client application. On the other hand, DataStage 6.0 may only support ODBC 2.0 protocols, which may limit some of the functionality available in later, ODBC 3.0 drivers.

Without a copy of DataStage 6.0 ready to hand to test I really can not offer any cogent advice, hence my earlier question.

iansta · Post by **iansta** » Thu Nov 15, 2007 6:47 pm

No, I'm looking for confirmation of my thoughts that as long as the right ODBC driver is in place, version 6 will be able to connect to SQL 2005. Not being able to try it myself means that I'm theorising so if someone has done it already it proves the theory.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 15, 2007 8:21 pm

That's essentially my thoughts, with the caveat given in my earlier post.