# Natural on Mainframe and Oracle Database

**URL:** <https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes, Natural-on-Windows-Unix\
**Created:** [January 30, 2008, 2:46am UTC](https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055 "2008-01-30T02:46:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chris3](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@chris3](https://techcommunity.softwareag.com/u/chris3)\
**Post date:** [January 30, 2008, 2:46am UTC](https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055/1 "2008-01-30T02:46:34Z")

</div>

hi,

may i know if it’s possible to initiate DML (select/insert/update/delete) into Oracle database directly from Natural (4.2.1) in Mainframe?

is yes, please share how you managed to achieve it.

thanks,

chris

---

<div class="post-metadata">

**Author:** ![anon29934956](https://avatars.discourse-cdn.com/v4/letter/a/ee7513/32.png) [@anon29934956](https://techcommunity.softwareag.com/u/anon29934956)\
**Post date:** [January 30, 2008, 2:06pm UTC](https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055/2 "2008-01-30T14:06:19Z")

</div>

Today there is no possibility to access Oracle on mainframes with Natural on mainframes. However a new product was created named:  
:arrow: Natural SQL Gateway  
to access SQL databases running on Windows or Unix server from Natural mainframes.  
Regards,  
Michael

---

<div class="post-metadata">

**Author:** ![chris3](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@chris3](https://techcommunity.softwareag.com/u/chris3)\
**Post date:** [January 30, 2008, 6:53pm UTC](https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055/3 "2008-01-30T18:53:37Z")

</div>

hi michael,

thanks for the info. i went ahead and researched on Natural SQL Gateway. please correct me if i’m wrong. Natural SQL Gateway currently only works for IBM’s DB2 UDB, not Oracle.

i got this information from here:

[url][http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat424mf/dbms/udb-over.htm[/url]](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat424mf/dbms/udb-over.htm%5B/url%5D)

i think one of the options, if not the only option available, is to call a broker that then calls a java program. the java program will be tasked to select/insert/update/delete records in the Oracle Database.

my next question would be, has anyone ever tried this before? may i have some sample codes to try?

thanks,

chris

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [January 30, 2008, 9:23pm UTC](https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055/4 "2008-01-30T21:23:39Z")

</div>

There are samples within the EntireX Communicator examples directory. I would suggest using an EntireX RPC Java RPC Server and use the CALLNAT interface from Natural to call the services that the EntireX Java RPC Server exposes.

---

<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:49pm UTC](https://techcommunity.softwareag.com/t/natural-on-mainframe-and-oracle-database/76055/5 "2021-04-02T14:49:05Z")

</div>