Exposing Web services from a VMS Alphaserver

[Steve Leski]

Hi,

Does anyone know what I would need to be able to expose RMS/RDB legacy data to Web service clients on my company's local network?

[Karl Rohwedder]

Steve,

- you could write a CGI script using DCL which calls SQL to gather data
- you could use the Oracle JDBC driver and use TOMCAT... to access RDB
- Dr. Wermelskirchen from DECUS/Germany enhanced a PHP module to access RDB
- ...
I've tested the PHP module a little bit and its looks good. DECUS/Germany realizes several RDB/WEB Applications using this beast.

If you are interesetd, I can produce a link next week, when I am at work again...

regards Kalle

[Jan van den Ende]

Steve,

until now we are satified with the CGI route (for RMS applications).

Proost.

Have one on me.

jpe

[Steve Leski]

Thank you Karl & Jan,

I should have specified that I'd like to use the SOAP protocol. HP offers an e-business extension kit. Another solution is to use Apache Axis with Tomcat.

I was looking to replace ACMS tasks with SOAP (XML) messages that could be consumed by Java and .Net clients.

Time to go home and drink beer.

[Robert Atkinson · Accepted solution]

Steve,
we use Attunity Connect, which exposes any type of VMS data as a database.

You can then use your favorite tools, .Net, BizTalk, etc, to interrogate the data.

Rob.

[Ian Miller.]

Attunity Connect supports ODBC connections to VMS resources. hp provide various parts - see
http://h71000.www7.hp.com/ebusiness/technology.html
but I can't see a complete solution.

Is this of interest?
http://www.wrq.com/products/verastream/
or this
http://www.ericom.com/host_publisher.asp

[Andy Bustamante]

You may also want to review Bridgeworks, http://h71000.www7.hp.com/commercial/bridgeworks/bridgeworks_index.html

[labadie_1]

use Python to acces Rms files or Rdb databases

see http://vmspython.dyndns.org/

and particularly
http://vmspython.dyndns.org/demosrc/rms_demo_2.txt

http://vmspython.dyndns.org/demosrc/rms_demo_1.txt

http://vmspython.dyndns.org/demosrc/rdb_demo.txt

I am, currently working for a customer, "webifying" his applications, with Webware, see

http://vmspython.dyndns.org/webkit/

[Ian Miller.]

See Web Services Integration Toolkit field test
http://h71000.www7.hp.com/openvms/products/ips/wsit/

[Steve Leski]

Thanks Ian, Rob et all,

I'll be looking at both Attunite and the Web services toolkit.

Steve