Azure SQL Database
An Azure relational database service.
6,341 questions
export data from Progress OpenEdge v.11 to Azure SQL
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 70%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vishnu Tupe
20
Reputation points
Hello Microsoft Experts,
We have a requirement to export data from Progress OpenEdge v.11 to Azure SQL however couldn't find any driver for this system in Integration runtime.
Is there a way to connect to Progress OpenEdge v.11 and extract the data in Azure SQL.
Many thanks in advance.
Azure SQL Database
{count} votes
-
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator2023-07-27T21:06:14.2033333+00:00 Vishnu Tupe Thank you for reaching out.
My understanding is that you are trying to connect your Progress OpenEdge to Azure SQL.
There is no connector for Postgress OpenEdge, but you can try general ODBC connector with SHIR.
This driver provides ODBC connectivity to Progress OpenEdge databases and can be used with Azure Data Factory to extract data from OpenEdge and load it into Azure SQL.
Download from here https://www.progress.com/odbc/openedge
Quickstart: Use the copy data tool in the Azure Data Factory Studio to copy data
Please let me know the result.
Regards,
Oury
-
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator
2023-08-01T18:23:23.2066667+00:00 We haven't heard back from you. I would like to know whether you were able to go through the link I shared above. Could you please let us know about the progress.
Regards,
Oury
-
Vishnu Tupe 20 Reputation points
2023-08-21T06:24:13.9766667+00:00 Yes, we are planning to use ODBC connectors with SHIR.
Thanks for your help and support.
-
Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator
2023-08-23T15:43:31.4066667+00:00
Sign in to comment
Sign in to answer