Access Oracle DB from mainframe Adabas/Natural


I would like to know if it is possible to read data from an Oracle database running on a windows or Unix platform from a Mainframe Adabas/Natural environment.



The Adabas SQL Gateway together with an Oracle adaptor allows federated queries from SQL based applications.
Using SQL statements in Natural requires the Natural SQL gateway in addition.


Architecturally, it might be better to consider making a service that provides the information you need from Oracle and then calling that service from Natural.

Natural and Adabas are so tightly integrated that it seldom makes sense to consider writing a web service for data, but in this case where your data source is elsewhere, I don’t think it’s a bad idea, as it is more likely your Oracle data source will move without you knowing about it.