If you install the ETL Server on a Windows platform as a Windows system service and you plan to use ODBC connectivity, you may encounter the following issues:
The ETL Server (Grid Engine) Windows system service may not be able to detect ODBC data sources defined as user data sources, because a system service per default runs in the system environment. Please ensure that the ODBC data sources you want to access from the ETL Server and the system service share the same environment by either defining system data sources or choosing a user in the Windows service properties.
On a Windows 2003 EE 64-bit platform the ETL Server (Grid Engine) Windows service may only be able to detect data sources defined using the 32-bit ODBC Data Source Administrator executable located in the c:\WINDOWS\SysWOW64 directory (odbcad32.exe, file size 32 KB). Note that the ETL Server Windows service is unable to detect system or user data sources defined using the 64-bit ODBC Administrator executable located in the c:\WINDOWS\System32\ directory (odbcad32.exe, file size 34 KB).