This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks for the extra info. There was an issue with the download tool that was fixed in version 10.0.9.58949 that was causing timeout issues (see release notes). Since you're on 10.1 it doesn't seem like this should be the issue. If you can't get this worked out with customer support you could try using the deprecated Salesforce tool that doesn't rely on the download tool. To get to the deprecated version right-click on a blank section of the Connectors toolbar and click "Show Deprecated Tools".
Yes I know about the deprecated tool, I was previously using that until the 10.1 as the v10 replacement of the deprecated tool was not proxy aware.
The latest version is the best version of the three that I have used.
I have been playing around with the time between scheduled jobs that use the salesforce connector. So instead of running the three workflows straight after each other (normally the first runs and the seond two fail) I have spacing them throughout the day. This has improved the success of the workflows. So whilst not ideal I can still get my jobs to run.
Without engaging the network team or salesforce team at the client site, My thoughts are that it is something to do with when the salesforce user login not being closed off quickly enough or cleared from queue once the download is complete. (apologies probably not the best technical description)
To this end, I still think there are probably some improvements the alteryx can make to this tool. It is a little light weight and unreliable for me to use in a more business critical function.
Thanks for your feedback. If you're able to get to the bottom of this with the Salesforce/network team at the client site (perhaps your Alteryx customer service rep can assist) then we'd love to hear the outcome to see if there's anything we can do to improve the product.
reading the API request limit page I don't think this is the issue.
I run 3 individual work flows that connect to Tasks, Events, Leads I take a full dowload of each of these tables and write them into SQL Server as they do not have a salesforce warehouse environment.
Total rows is less than 200K
This is super frustrating and as I've mentioned in string previously it is better in the latest version but still not great. Ideally the organistion would have salesforce data in the warehouse which I could connect to. Then I wouldn't use the Salesforce connector.
However that would take Alteryx off the hook so to speak.
I have previously raised this as an issue with Alteryx and was told the latest versions would fix it. But the issue persists. It's definately improved which is totally commendable but not at a level that I would consider reliable enough to be using the tool in a product environment which has a daily ETL component.