3 ms·
Ask HN: Best practices for keeping various business systems in sync?
https://imgur.com/a/NZvdkL4
We use these systems for our small business (20 employees, 3 physical locations).
(A) ERP: Handling Inventory and Accounting.
(B) Less Annoying CRM: Tracking Customer Interactions. It's a CRM.
(C) Mailchimp: Sending customer marketing communications
(D) Google Suite: Email, Contacts, Calendar and Drive
(E) Sparkpost: Automated internal emails with report attachments. Notification emails to customers.
(F) Server: Runs scripts for (E) and (G)
(G) Hugo/Netlify Main Site: Mostly static site. Interacts with (C) and (D)
My question is how do you keep track of everything and keep it all in sync?
Do you create a separate database and use scripts to update it from all these different sources?
How do you handle this at your companies?
I foresee increased interaction between all of these systems and it's getting overwhelming keeping them synced and working together.
- itamarst 8y agoZapier is one tool people use.
- dhruvkar 8y agoI'm using that in limited cases, but it seems like a stop-gap solution at best, because: * Not enough granularity * Uses polling for most integrations rather than web hooks * Has task limits on all plans which may not be suitable for a high number of integrations/interactions.
- evanlivingston 8y agoIntegromat solves these issues.
- dhruvkar 8y agoThanks, I'll check it out.
- deleted 8y ago[deleted]
- mgliwka 8y agoI've seen this being handles using an ESB in the middle (solutions like WSO2, MuleESB). The ESB receives all relevant events and triggers actions based on that.
- dhruvkar 8y agoInteresting, had never heard of ESBs before. Found this which explained this briefly (for people reading)[0]. Does it sort of act like an API? 0: https://www.mulesoft.com/resources/esb/what-esb https://www.mulesoft.com/resources/esb/what-esb
- Mandatum 8y agoIt usually consumes and publishes API's to facilitate the "ESB" function (which is incredibly vague, but pretty much acts as the "glue" to do all-the-things). The ESB term is so overused, and products like the one you linked have so much functionality baked into them, they can act as pretty much any business or system function in an organisation. And they do.
- aprdm 8y agoAt a startup I worked We had our own database and synced those systems from our datastore
- dhruvkar 8y agoI see. That's what I'm leaning towards.