Page 1 of 1
Difference between ODBC and DRS stage for SQL Server
Posted: Mon Jul 23, 2007 6:12 am
by JeroenDmt
We need to make connection with SQL Server from Datastage. I was wondering what the difference is between using the ODBC (Enterprise) stage or using the DRS stage to connect to SQL Server. I think they both use the ODBC driver (being on Unix).
Is there any reason to use the ODBC Enterprise stage or the DRS stage?
Why would you use one or the other?
Posted: Mon Jul 23, 2007 9:11 am
by abc123
When writing to SQL Server, on version 7.5.1A, ODBC stage cuts off the first character for character columns and DRS stage cuts off the last character. I find out DRS stage better. It is more powerful.
Posted: Mon Jul 23, 2007 11:33 am
by JeroenDmt
So it's a matter of which character is more important: the first one of the last one?
Why do you find DRS stage better?
Posted: Mon Jul 23, 2007 1:02 pm
by abc123
It seems to have more options to do things. Also, there is a way around this last character cutoff. There are certain drivers that you need to install (IBM has them) or you can add a space and increase output column length by 1 in a transformer right before writing to the table.
Posted: Mon Jul 23, 2007 2:54 pm
by us1aslam1us
From my understanding DRS stage has both the ODBC and Native API connectivity(Like connecting to Oracle or other DBMS) whereas ODBC stage only uses Open Database Connectivity. As far as performance is concerned it depends on you requirement and the approach in your design.