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?
Difference between ODBC and DRS stage for SQL Server
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)