EDC support for MS Azure (SQL Server)

Posted by Gertjan Hendriks on 28-Nov-2016 08:00

Hi,

Some time ago I posted a way to connect to Azure SQL Server databases via Corticon's EDC (https://community.progress.com/community_groups/corticon/f/14/t/15229). This solution was officially not supported by Progress, but it worked.

I do get more and more questions about whether or not Progress Corticon (EDC) will offcially support Azure SQL Server databases in the (near) future. Can Progress give us an insight on this?

Thank you,

-Gertjan

Corticon - Forum
Posted by James Arsenault on 30-Nov-2016 00:02

Gertjan,
 
SQL Azure and SQL Server must be similar (or identical) from a client perspective. By selecting “Microsoft SQL Server 2012” as the database server you are specifying the driver and hibernate dialect to use. Corticon uses Data Direct drivers; the Data Direct page on SQL Azure states you need the JDBC SQL Server Driver
 
https://www.progress.com/jdbc/microsoft-sql-azure
 
It the SQL Server driver works I would assume the hibernate dialect would as well. I think all that’s missing is formal certification by Corticon. We will look at adding this in our 5.6.1 release.
 
Regards,
Jim
 
 

All Replies

Posted by James Arsenault on 30-Nov-2016 00:02

Gertjan,
 
SQL Azure and SQL Server must be similar (or identical) from a client perspective. By selecting “Microsoft SQL Server 2012” as the database server you are specifying the driver and hibernate dialect to use. Corticon uses Data Direct drivers; the Data Direct page on SQL Azure states you need the JDBC SQL Server Driver
 
 
It the SQL Server driver works I would assume the hibernate dialect would as well. I think all that’s missing is formal certification by Corticon. We will look at adding this in our 5.6.1 release.
 
Regards,
Jim
 
 

Posted by Gertjan Hendriks on 30-Nov-2016 00:48

Thank you for your answer, Jim!

This thread is closed