Hi --
I have a client interested in accessing Progress data from a SQL app. What questions should I be asking in order to determine if it would be better to set up ODBC access so that the Progress db appears as a linked server in SQL, versus setting up dataserver/replication to populate SQL tables from Progress either periodically or real-time?
Pros/cons I thought of:
Your thoughts?
This is 11.6 on RHEL7.
You should look into Pro2SQL, which provides replication of selected tables to another database.
(this is a extra-cost psc product)