I found out that it took some trial to connect to a remote SQL Server-database, which is hosted in Microsoft's Azure cloud-environment, using the Enterprise Data Connector (EDC).
As Azure's SQL Server requires SSL to connect, finding the right connect-string required resulted in many errors. The EDC-documentation (up to version 5.4.1) unfortunately lacks any information about this. Thanks to Harold-Jan Verlee and a little bit of tweaking, I got things working. It might help others in the future and spare some valuable time.
Enter the following in the Database Connection-pane, at the Database Access-tab of your vocabulairy (with Studio in Integration & Deployment-mode):
Database Server:Microsoft SQL Server 2012
At the additional properties-fields of the Database Access-tab, add the following values:
Please note that the hostNameInCertificate value starts with *. In some cases this might cause an error, where EDC will tell you what URL to use instead (for instance, data.am1-3.database.windows.net).A Database Connection might look like this (with fictional database-URL):
Thanks for the information. SQL Azure is not a platform we have tested previously.
James Arsenault | Product Development | Progress Software email: firstname.lastname@example.org | direct: 781-280-4934