I have a requirement to sync Salesforce data from 2 objects to Datawarehouse and insert/update data from Datawarehouse to Salesforce.We want this data sync to be realtime for this application.Data volume should be around 10000-15000 records per day.What is the best integration pattern for this use case.
- Change Data Capture(pilot)
- Platform Events or
- Replication API or
- Streaming API or
- Third party ETL tool(Batch data synchronization) or
- ESB (use ESB in between Datawarehouse and Salesforce)
My production org has 60000 API requests limit per 24 hours.How does this API requests effect in each use case.Currently, we don't have any integrations setup with this org and other external systems.
In future,we are also planning to setup daily bidirectional datasync between salesforce and datawarehouse for other Salesforce applications.
Please suggest best integration pattern.