Ask HN: Are there any SaaS services that access your database directly?
6 comments
I came across this this morning: http://www.tray.io via an article on TC: http://techcrunch.com/2015/04/16/tray-io-raises-2-2m-for-an-...
I'm guessing there are some annoying problems around 3rd party quality / stability / undocumented or unofficial APIs.
I'm guessing there are some annoying problems around 3rd party quality / stability / undocumented or unofficial APIs.
KISSMetrics does the reverse, they bring your DB data into their service directly. But it's essentially the same setup.
http://support.kissmetrics.com/integrations/mysql/index.html
http://support.kissmetrics.com/integrations/mysql/index.html
Looker is a good example http://www.looker.com/product/data
Make sure to grant only select privileges on the database. Don't grant any privileges on sensitive information tables.
Looking at doing the same thing with GA and a few other sources.
Do you want to provide a service that fetches data from GA API and saves it at others' databases? Or are you looking for this service?
This is what enterprise application integration is all about.
For practical reasons you need the GitHub data inside your database, so you need to build system that fetches the data periodically, or a system that handles GitHub webhooks, and update your database accordingly.
Now we can imagine that could be a service that handled this "sync" part for you, fetching data from GitHub and updating it directly in your database.
The question is: is it a normal practice to do this? Does it exist somewhere? What are the problems of this approach?