Linking Progress to MS SQL Server

Syn

New Member
Hello,

This is my first post here and I'm not sure if I'm in the right arena, but here I go.

We use a Progress based system and are looking to link it to a MS SQL database. I wish to output data from Progress to be picked up by the other program. This should be initiated outside of Progress (Probably an API needed).

Please help me find useful information regarding this issue, any case studies in the area or even the name of the relevant API to use.

I've found some information about SQL-92 could this be used and linked through the ODBC? Any extra info in this area would also be appreciated.

Simon Nunn
 
I'm in a similar situation - I've built a realTime xml-based eCommerce application and have recently landed a customer that uses Progress & SX.Enterprise (by NxTrend) on the backend. I'm trying to integrate my eCommerce application with the SXapi - curious if there is any SQL tie-in that would aid me in this. Let me know what you find out.
 
So far I have discovered that the easies way to link to Progress is via the ODBC (Theoretically). Also a friend has sent me some VB6 using ADODB.Connect which is his intelectual property, so it's not mine to give.

I am working on a .net version now so I'll give what I can, when I can.


Sy Nunn
 
Linking Progess to MS SQL Server (and other databases)

We have a product that will exchange data from a Progress database to a number of other databases in real-time. They can be similar or dissimilar schemas. We use a simple XML package and a JMS to transmit the data as record is changed or use our API to poll the database for what you want and when you want it. Take a look at www.intelxport.com.
 
Back
Top