5 ms·
Of course giving out access is probably a bad idea -- so what would be a good alternative for them to do instead?
by gkoberger 14y ago
Of course giving out access is probably a bad idea -- so what would be a good alternative for them to do instead?
- kodablah 14y agoThese types of services just can't be SaaS. Ideally they would provide a prebuilt VM to drop in your environment (like GitHub Enterprise does). I had been struggling with the same quandry with regards to a code review system and a monitoring system I have been working on.
- btown 14y agoOne might argue that a self-updating prebuilt VM is functionally equivalent to a SaaS offering.
- swisspol 14y agoIn our case we set up a dedicated cheap database server only for ChartIO. Then we have a script that copies to it analytics data from our production servers every few hours (while also anonymizing what needs to be just to be extra safe).
- john_w_t_b 14y agoThis is a good approach. I work with ERP systems for large companies, and it's typical to separate the transactional database (OLTP) from the analytics database (OLAP). There's usually a replication process to copy transactions into the reporting system.
- thingsilearned 14y agoGreat use case! We don't support an API that you can push data to, but that's because whatever API we build, it would never be easier to learn or have as much language support than just spinning up a PostgreSQL instance and writing the data to it. Quite a few of our customers use us this way.
- swisspol 14y agoYou guys should really suggest this approach in the setup guide (it can be phrased in a way not to scare potential users). The alternative of directly accessing production database servers is really risky.
- thingsilearned 14y agoAgreed. I'll work on it.
- aiiane 14y agoYep. That's the kind of approach I'd like to see Chartio recommending (or at least, providing suggestions for).
- tixocloud 14y ago+1 for getting non-operational stuff off of the production servers. In my opinion, production servers should be left untouched by analytics and what not. I'd prefer not tying up resources that could better serve customers.
- rdl 13y agoThis seems like what you'd do just to protect your production server from some crazy load/etc. issues from analysis, too. I can't imagine giving read-only access to a core rw database server to anything which didn't need it.
- thingsilearned 14y agoSadly the alternative is data warehousing (which all of our competitors do). Its the worst solution as it 1. gives a copy of your data to someone else 2. is legally questionably still your data 3. is stagnant (as you usually only backup once a week) 4. there is no way to track where that data goes
- swisspol 14y agoWell, I'd say 1, 2 and 4 also apply to ChartIO ;) We like your service after comparing various ones but for us the advantage vs data warehousing is a much easier setup and UX.