Query Progress Database from a Website

[rob123]

Hi,

Today I've been asked if a third party company can query our Progress database from there website and return the results to a website!

Ie. it returns the clients policy information.

Can this be done?

Many thanks,

 

[medu]

well, yes and no... you probably don't want to let any third party to walk directly through your database, even if they trust them like yourself they have no business knowing your internals

build a business service for them and expose it either as a full web-service or simple REST service depending on what you have around (appserver or webspeed)... well, it might be either some other web proxy that you build directly against the database using ODBC/JDBC if you don't have any of the progress 'application server' products around; like php, perl, python, asp, java, what ever you like most

 

[MaximMonin]

Create webservice by using proxygen + WSA and deploy it.
Make client apps that calls webservice and displays result.

 

[RealHeavyDude]

There are many options depending on which technology they've built there web site. Basically I would recommend the web service technology because then you don't have to fiddle with proprietary technology and drivers.

Heavy Regards, RealHeavyDude.