Accessing Windows ODBC from UNIX DataStage

ArndW · Post by **ArndW** » Tue Jan 25, 2005 7:20 am

I recall having had to use a 3rd party tool to access an ODBC data source on the Windows platform (SQL Server, Access, etc.) from a UNIX-based DataStage installation. Is this still the case, or is the access now done differently; in this case it is AIX accessing SQL-Server.

s_boyapati · Post by **s_boyapati** » Tue Jan 25, 2005 7:27 am

ArndW wrote:I recall having had to use a 3rd party tool to access an ODBC data source on the Windows platform (SQL Server, Access, etc.) from a UNIX-based DataStage installation. Is this still the case, or is the access now done differently; in this case it is AIX accessing SQL-Server.

Yes. you can use 3rd party tool in 7.x too. but DS uses ODBC drivers by default, configured in ODBC.ini.

ArndW · Post by **ArndW** » Tue Jan 25, 2005 7:31 am

Thanks for responding - but I am aware of using ODBC on UNIX; but there are/were complications when reading a remote Non-UNIX ODBC Db, are there not? It might have been in the other direction, i.e. reading ODBC databases on UNIX from Windoze.

roy · Post by **roy** » Tue Jan 25, 2005 10:29 am

Hi,
As long as you have a ODBC driver for your platform that supposrt access to remote DB you can configure it, but there are some implications:
if this driver can't use the existing driver manager that comes with DS I belive you can only have 1 valid driver manager at any time.
in any case if you use the ODBC drivers that coem with DS have a look see under the branded_odbc directory for docs on work-arounds for issues with the connections for various DBs.
IHTH,

ArndW · Post by **ArndW** » Tue Jan 25, 2005 10:34 am

Thanks Roy & s_boyapati.

It is slowly coming back to me now - the 3rd party drivers were necessary on UNIX boxes when Windows was attempting to access databases; the other way around was easier.

I'll give it a go tomorrow when the Server gets installed.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 25, 2005 4:51 pm

DataStage has for some while shipped with ODBC drivers from Data Direct (formerly Merant). This suite includes a driver for Microsoft SQL Server.

It's called VMmsss19.so and is to be found in $DSHOME/../branded_odbc/lib. The "msss" in the name stands for "MicroSoft Sql Server". (It has a .sl suffix on some UNIX variants.)

DSXchange

Accessing Windows ODBC from UNIX DataStage

Accessing Windows ODBC from UNIX DataStage

Re: Accessing Windows ODBC from UNIX DataStage