We are trying to provide a service based on CRM (Salesforce) data to our customers in China. Salesforce doesn't exist (yet...) in CN, and wondering if something like this could be useful in moving needed data to AWS China. Then I realized that Redshift is not your typical OLTP db and not suitable for regular querying from an application. Curious to hear HNs thoughts.
EDIT: Someone mentioned Heroku Connect in one of the comments. We do use this to archive certain objects (> 75 million records) and I have thought about replicating this data to AWS China (Postgres). Could be one option but some of our data is real time (e.g. customer orders), not sure what the "freshness" of the data would be.
EDIT: Someone mentioned Heroku Connect in one of the comments. We do use this to archive certain objects (> 75 million records) and I have thought about replicating this data to AWS China (Postgres). Could be one option but some of our data is real time (e.g. customer orders), not sure what the "freshness" of the data would be.