SSIS Data Flow for Salesforce Marketing Cloud: API Choice & Limits
Posted: Thu 26 Apr 2018 22:14
We are looking at using the SSIS Data Flow Connector for Salesforce Marketing Cloud to connect SQL 2012 to MC (Exact Target). I understand that MC may limit throughput based on the choice of API that the connector is using (see: https://salesforce.stackexchange.com/qu ... le_rich_qa).
Does this connector use the Soap API, the RESTful API, or something else entirely to talk to MC? All else equal, ie, server and network speed being high, will this connector be able to hit the 2000 or 2500 rows per minute max allowed, and if so, are there mechanisms for governing the rate to prevent this from happening to excess?
Any advice or insight is appreciated. Thx!
Does this connector use the Soap API, the RESTful API, or something else entirely to talk to MC? All else equal, ie, server and network speed being high, will this connector be able to hit the 2000 or 2500 rows per minute max allowed, and if so, are there mechanisms for governing the rate to prevent this from happening to excess?
Any advice or insight is appreciated. Thx!