Hi,
If what you want is a local client application such as Excel or Access to use the Citrix data channel to access the ODA driver on the Citrix server I think you are out of luck unless you want to write your own virtual data channel using the Citrix SDK. (See cdn.citrix.com)
If you are willing to publish the app used for data manipulation then you can use ODA on the Citrix server to provide data for published apps such as Access and Excel. ODA is installed automatically by the client install program.
ODA is a great concept in that is supports OW authentication, row security, data dictionary descriptions, etc. It has unfortunately been pretty hard to use. From release to release and service pack to service pack things break are fixed and break again. There a number of mainstream ODBC compliant applications, such as Crystal Reports, that do not work reliably with the ODA driver. There are also a series of limitations around what kind of joins you can do and how many tables can participate in a join.
The following KG documents discuss ODA's limitations:
Oti-00-0087
oti-01-0137
ott-01-0016
Oti-00-0088
What my clients usually end up doing is to configure special read-only database user id's and use those to configure direct ODBC connections for their particular database platform. You can provide row level security by using database views over the tables you want to protect and then granting SELECT access to the views.
You can preload the user id in the ODBC connection setup. This solution still requires that they enter password when accessing it.
Regards,
Justin Miller
[email protected]
working with B7332 and XE on AS/400, NT, Solaris and AIX