News for hackers. Stuff that matters.

Ask HN: Are there any SaaS services that access your database directly?

For example, you have a Postgres database and for some reason you also need data from some third-party app elsewhere, say, GitHub.

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?

( 7 comments | 5 points | on HN )
Re:Ask HN: Are there any SaaS services that access your data... by benologist on Thursday April 16, 2015 @06:13PM (#9391045)
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.

Re:Ask HN: Are there any SaaS services that access your data... by anthony_franco on Thursday April 16, 2015 @09:28PM (#9391789)
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

Re:Ask HN: Are there any SaaS services that access your data... by dkasper on Thursday April 16, 2015 @06:42PM (#9391167)
Looker is a good example http://www.looker.com/product/data
Re:Ask HN: Are there any SaaS services that access your data... by iroot on Friday April 17, 2015 @12:54AM (#9392321)
Make sure to grant only select privileges on the database. Don't grant any privileges on sensitive information tables.
Re:Ask HN: Are there any SaaS services that access your data... by jackgolding on Friday April 17, 2015 @12:28AM (#9392267)
Looking at doing the same thing with GA and a few other sources.
Re:Ask HN: Are there any SaaS services that access your data... by fiatjaf on Friday April 17, 2015 @07:54AM (#9393686)
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?
Re:Ask HN: Are there any SaaS services that access your data... by Avalaxy on Thursday April 16, 2015 @07:02PM (#9391243)
This is what enterprise application integration is all about.