- Sabir Foux
- PowerServer 2020 or older (Obsolete)
- Monday, 2 September 2019 03:31 AM UTC
What is our need:
When a user logs into the app all data written to and retrieved from the database needs to be unique to their tenant.
Where we are now:
Our app is going from the desktop client/server to the web. Data was physically separated by each client location so there was no need to add a specific identifier to their data in the database.
What we've considered:
We've considered unloading the clients' data into a file and then updating the DB tables with a tenant ID or something similar. Then reloading the data and having each user's login credentials connect them to their data and not another clients'.
Our question:
Is there another option besides the manual process I mentioned above or is it the only one available given the situation? Note, we began looking into dynamically setting the data source with the appeon workarounds.pbl however SQL Anywhere is not supported.
As always, any advice, tips, or suggestions, are appreciated.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.