I'm testing Lightning Connect with a Microsoft Azure SQL db.  I'm getting an error when validating the external data source in Salesforce.  Here's the config:


When I click Validate and Sync, I get this error:
The external system is unreachable. Make sure that the URL is correct in the external data source settings, and that the server's SSL certificate is valid for its domain name. Attempted to reach this URL: https://[myservername].database.windows.net:1433/$metadata

I have tried Anonymous authentication but I get the same error.

I've set up Azure firewall rules for the Salesforce IP addresses.

Is there a way to achieve Salesforce OData Integration without using Lightning Connect, with or without making use of External Data Source and External Objects.

I'm testing Lightning Connect with a Microsoft Azure SQL db.  I'm getting an error when validating the external data source in Salesforce.  Here's the config:


When I click Validate and Sync, I get this error:
The external system is unreachable. Make sure that the URL is correct in the external data source settings, and that the server's SSL certificate is valid for its domain name. Attempted to reach this URL: https://[myservername].database.windows.net:1433/$metadata

I have tried Anonymous authentication but I get the same error.

I've set up Azure firewall rules for the Salesforce IP addresses.

Hello

 

I want to integrate salesforce data with my coldfusion code.

Such that there is customised object merchandise in salesforce.

I want my coldfusion code to add / update / delte new merchandise to it.

is it possible?

 

Thanks

Anyone using the ODBC drivers from Datadirect?

 

http://www.datadirect.com/index.ssp

 

We use java and soql api to connect. We are also looking for a solution to connect using access / excel (other than queryamp - which we really like.) 

 

I was able to do some pretty complex queries with the odbc driver that cannot be done easily via SOQL.  I was also able to update fields to null.

 

Looking for feedback / limitations.

  

Last Jannuary, I talked to OpenAccess, a developer of toolkits for developing ODBC connectors, about using their product to build a connector to Salesforce.com. Although I got a 30-day trial, developing the actual connector was beyond my skills.

Last week OpenAccess contacted me about a beta version of an ODBC connector for Salesforce.com. You can download the beta version at:

http://www.openaccesssoftware.com/support/SalesF-Files-Index.asp

The installlation requires that your computer have the  Microsoft.Net framework runtime installed (obtainable from http://www.microsoft.com/downloads/details.aspx?FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en).

Once you install everything (about 10 minutes), you can use the  ODBC connector to link any ODBC-compliant app to your Salesforce database.

At present, there is no pricing or licensing cost on the web site. The beta license expires on September 27. Also, the ODBC connector only supports the SELECT statement, so no UPDATE or CREATE at the moment.

I testing it by creating an ODBC connection in Excel using the new salesforce ODBC connector as my source. I could then point/click to select from all the tables in my account, including custom objects.

Lots of possibilities here, but this is all the information I have. If you want more info, contact OpenAccess.