# Error “504 Gateway Timeout” while using CData Salesforce Pardot SSIS connector

**URL:** <https://community.cdata.com/t/error-504-gateway-timeout-while-using-cdata-salesforce-pardot-ssis-connector/407>\
**Category:** Data Sources\
**Tags:** article, ssis, pardot, activities, prospect, bulk-api\
**Created:** [September 20, 2023, 6:42pm UTC](https://community.cdata.com/t/error-504-gateway-timeout-while-using-cdata-salesforce-pardot-ssis-connector/407 "2023-09-20T18:42:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kristjana\_Mato](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@Kristjana\_Mato](https://community.cdata.com/u/Kristjana_Mato)\
**Post date:** [September 20, 2023, 6:42pm UTC](https://community.cdata.com/t/error-504-gateway-timeout-while-using-cdata-salesforce-pardot-ssis-connector/407/1 "2023-09-20T18:42:22Z")

</div>

While retrieving data from the ‘Visitor Activities’ view in Salesforce Pardot, after more than two minutes we get an error “504 Gateway Timeout” and no records are returned. It happened because of the number of records that those views have. So, in this case, we are querying the whole visitor activity database, the size of data being retrieved is too big, and this is expected to time out. The solution to this problem would be using the Pardot Bulk API. This approach was developed precisely for high-volume use cases. To enable it, set _ResponseMode_ connection property to _Bulk_, and the driver will switch to Bulk API.

 ![6a223a3d-b8b4-464d-bf71-ed7a7ea83d0f.png](https://us1.discourse-cdn.com/cdata/original/1X/4b2e4dc960748ce8668c03eb3af95973e4ba9a17.png)