SSIS Data Flow for Salesforce Marketing Cloud: API Choice & Limits

[mAgrollman]

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!

[Pinturiccio]

SSIS Data Flow Components for Salesforce Marketing Cloud use SOAP API.

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?

SOAP API does not have explicitly stated limitation. SFMC recommends to use no more than 2000 API calls per minute. If a conflict occurs, we repeat the attempt one more time with a small delay. This usually works.

After the first installation of SSIS Data Flow Components for Salesforce Marketing Cloud, a 30 day trial period starts. Thus, you can evaluate the product. It can be downloaded from our site: https://www.devart.com/ssis/download.html