Looking to see how others are providing live data to users? We are on SaaS, not sure if that makes a difference. Currently, we are using a mix of OData connections to live and PowerBI connections to ODBC, our replicated database.
Concerns/Question about OData:
- It hits our live database → We have ODBC, connect to that?
- OData is setup with a single user account for all reports that we have to remote into the computer to enter credentials. Setup multiple to reduce complete failure?
- We are unable to track what reports are connected to Epicor through OData. If something breaks, how do you keep track of what connections you set up?
- Does OData need a security manager level account?
- Should we look into Access Scope?
- The OData user account got locked out during our upgrade and we are unable to determine why.