We are looking for the best way to make our VMS data visible to BusinessObjects and are currently investigating various ODBC options.
All the files are RMS files as is usual on VMS, but we are particularly interested in the files that are used by our CODA IAS financial system.
I would appreciate hearing from anyone with experience either with connecting to VMS RMS files, or connecting to CODA.
best regards,
'-Dzin
–
'o-Dzin Tridral
Senior Computer Officer, UIS, Cardiff University, PO Box 78, CF10 3XL T +44 29 2087 6160 E TridralO@cf.ac.uk
F +44 29 2087 4531 W http://www.cf.ac.uk Producing code from specifications is like walking on water - it’s easier if it’s frozen – Barry Boehm
We use Connx for ODBC VAX data extract. I have talked to the developer who supports CODA for us and these are his views. We do not access the RMS files that CODA uses. We load all data to CODA using the IAS link via COBOL programs. We looked at extracting information but found most of the files had the data encrypted. The IAS link proved too slow so as it was a one-off extract reports that output pure text were written and these reports were used for a one-off load.
Probably not much use but the best I can do…
You may also be interested to know that CONNX provides fast, easy, secure Read and Write access to ORACLE, DB2, SQL Server, Sybase, Informix, Ingres, RMS, Oracle Rdb, Oracle DBMS presenting them as one relational database enabling you to use ODBC, OLEDB and JDBC compliant applications and development tools of your choice.