I tried using the Devart Contact form but have had no response after 3 weeks so am now trying here with this query.
We are trying to extract data from Sales Force, preferably via SQL Server SSIS, for loading into a local SQL Server database.
I have downloaded the trial of the SSIS 2017 Data Flow Components.
I am having issues getting the SalesForce connector to work. When I try to connect I get an error "The remote server returned an unexpected response (405) GET not supported.
Is there any documentation on how to resolve this error?
Is a better option to use the ODBC Driver for Salesforce and if so, how do I get it and what is the licence fee?
Regards
Kevin Seerup
Issues getting Sales Force Connector to work
Re: Issues getting Sales Force Connector to work
This is our response sent to you on April, 9:
Check your spam filter in the email box.1. Make sure that the API is enabled in your Salesforce account: https://help.salesforce.com/articleView ... e=1&mode=1 .
2. Is there a proxy server in your environment? If so, open Devart Salesforce Connection Manager Editor, press the Advanced button and set parameters in the Proxy Options section.
3. For test purposes, register a free account at https://skyvia.com, create a new Salesforce connection (with the same Salesforce account as used with SSIS Data Flow Components for Salesforce) in the Connections section. Does "Test Connection" work? If so, navigate to the Query section > New SQL, select the created connection. Are you getting the list of tables in the "All tables" list?
4. Specify your connection string (mark confidential information with asterisks).
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Issues getting Sales Force Connector to work
Thanks for the reply -all fixed.