Ask HN: Handle customer DB access in SaaS
Ask HN: Handle customer DB access in SaaS
2 by cyptus | 5 comments on Hacker News.
when providing SaaS how do you handle (big) customers that requests access to their data for BI applications? most BI solutions like power bi struggles hard to obtain data from HTTP-APIs as they are paged, aggregated in other ways, authenticated with OAuth and so on. integrations are very easy if access to a sql layer would be given instead. But of course direct database access is also a struggle if using a multi tenant environment which would need at least some kind of row-level-security and a own read-replica. Also the customer needs to know every detail of the database schema which makes internal changes harder again and is an unnecessary detail. Is there any other way then filling a second database event based with the correct „business-based“ schema (like a cache) and provide direct access to this? Is there any option to provide an „sql“ api to the application architecture?
2 by cyptus | 5 comments on Hacker News.
when providing SaaS how do you handle (big) customers that requests access to their data for BI applications? most BI solutions like power bi struggles hard to obtain data from HTTP-APIs as they are paged, aggregated in other ways, authenticated with OAuth and so on. integrations are very easy if access to a sql layer would be given instead. But of course direct database access is also a struggle if using a multi tenant environment which would need at least some kind of row-level-security and a own read-replica. Also the customer needs to know every detail of the database schema which makes internal changes harder again and is an unnecessary detail. Is there any other way then filling a second database event based with the correct „business-based“ schema (like a cache) and provide direct access to this? Is there any option to provide an „sql“ api to the application architecture?
Comments
Post a Comment