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

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
mAgrollman
Posts: 1
Joined: Thu 26 Apr 2018 22:00

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

Post by mAgrollman » 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!

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Fri 27 Apr 2018 09:47

SSIS Data Flow Components for Salesforce Marketing Cloud use SOAP API.
mAgrollman wrote: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

Post Reply