Hi,
I'm looking for comments on using ODBC with MS SQL.... when the payroll module is active.
This is recently converted from V6/Progress to E9/MS SQL & ODBC not used yet.
I'm especially interested in security related to the payroll tables in MS SQL.
- How to duplicate the security enforced in the E9 application when an ODBC connection is used.
--- No data returned from a payroll table. (or only allow for payroll administrators).
I have some ODBC experience with Epicor to add views/external queries, reports, etc...
Used to have a db admin to help with the security... but doing it myself these days.
Thanks in advance....