# Access Oracle DB from mainframe Adabas/Natural

**URL:** <https://techcommunity.softwareag.com/t/access-oracle-db-from-mainframe-adabas-natural/92769>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes, Adabas-on-Windows-UNIX\
**Created:** [February 16, 2010, 8:50pm UTC](https://techcommunity.softwareag.com/t/access-oracle-db-from-mainframe-adabas-natural/92769 "2010-02-16T20:50:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keith](https://avatars.discourse-cdn.com/v4/letter/k/f05b48/32.png) [@Keith](https://techcommunity.softwareag.com/u/Keith)\
**Post date:** [February 16, 2010, 8:50pm UTC](https://techcommunity.softwareag.com/t/access-oracle-db-from-mainframe-adabas-natural/92769/1 "2010-02-16T20:50:40Z")

</div>

Hi,

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.

Thanks.

---

<div class="post-metadata">

**Author:** ![anon72918622](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@anon72918622](https://techcommunity.softwareag.com/u/anon72918622)\
**Post date:** [February 17, 2010, 1:34pm UTC](https://techcommunity.softwareag.com/t/access-oracle-db-from-mainframe-adabas-natural/92769/2 "2010-02-17T13:34:06Z")

</div>

Hi,

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.

Regards,  
Wolfgang

---

<div class="post-metadata">

**Author:** ![Brian\_Johnson1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/brian_johnson1/32/163_2.png) [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\
**Post date:** [February 17, 2010, 10:16pm UTC](https://techcommunity.softwareag.com/t/access-oracle-db-from-mainframe-adabas-natural/92769/3 "2010-02-17T22:16:44Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:58pm UTC](https://techcommunity.softwareag.com/t/access-oracle-db-from-mainframe-adabas-natural/92769/4 "2021-04-02T14:58:03Z")

</div>