Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
Good afternoon,
I hope you are doing well.
We are currently evaluating and starting an integration architecture to synchronize data into Salesforce using IBM webMethods, and we would appreciate your technical guidance and best-practice recommendations, as we are new to the webMethods platform.
Please find attached the architecture diagram, which includes the following components:
Data Sources:
AWS Aurora RDS
Google BigQuery
Integration Platform:
IBM webMethods
Target System:
Salesforce
The objective is to extract, transform, and synchronize data from the source databases into Salesforce in a secure
We kindly request your guidance on the following points:
Recommended architecture in webMethods for this type of integration.
webMethods components that should be used (e.g., Integration Server, JDBC Adapter, Salesforce Adapter, etc.).
Best practices for:
Connecting to AWS Aurora RDS
Connecting to Google BigQuery
Synchronizing data into Salesforce
Handling large data volumes, error management, and retry mechanisms.
Security and authentication considerations.
Recommendations for implementing an initial PoC or pilot integration flow.