# Natural access via network to ADABAS in the cloud

**URL:** <https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Natural, Adabas-on-Linux, Natural-on-Linux, NaturalONE\
**Created:** [July 12, 2023, 12:46pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957 "2023-07-12T12:46:20Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![schoone](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@schoone](https://techcommunity.softwareag.com/u/schoone)\
**Post date:** [July 12, 2023, 12:46pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/1 "2023-07-12T12:46:21Z")

</div>

#### _ **Product/components** used and **version/fix** level:_

ADABAS 7.0 / Natural 8.3 / Natural 9.0 (NaturalONE)

#### _Detailed explanation of the problem:_

Is it possible to access ADABAS in the cloud with Natural over the network? In other words, how can Natural communicate with ADABAS if these two components are not installed on the same server? If this is possible, how is the data secured (encrypted)?

#### _Error messages / **full error** message screenshot / **log** file:_

#### _Question related to a **free trial** , or to a **production (customer)** instance?_

---

<div class="post-metadata">

**Author:** ![wolfgang.winter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wolfgang.winter/32/17954_2.png) [@wolfgang.winter](https://techcommunity.softwareag.com/u/wolfgang.winter)\
**Post date:** [July 12, 2023, 1:38pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/2 "2023-07-12T13:38:46Z")

</div>

ADABAS Communication across physical boundaries requires the add-on Entire Net-Work.

Entire Net-Work secures data on the wire via (Open)SSL.

---

<div class="post-metadata">

**Author:** ![Luciano\_Pimenta](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/luciano_pimenta/32/7857_2.png) [@Luciano\_Pimenta](https://techcommunity.softwareag.com/u/Luciano_Pimenta)\
**Post date:** [July 12, 2023, 2:09pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/3 "2023-07-12T14:09:47Z")

</div>

Another method is to use the Adabas ADATCP(s) interface (requires Entire Net-Work license). This interface allows Natural running on a different node to access Adabas (on-prem or in the Cloud) via TCP/IP communication which can be encrypted if you also use Adabas Encryption for Linux solution.

---

<div class="post-metadata">

**Author:** ![schoone](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@schoone](https://techcommunity.softwareag.com/u/schoone)\
**Post date:** [July 14, 2023, 9:54am UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/4 "2023-07-14T09:54:02Z")

</div>

Hi Wolfgang, hi Luciano,

thanks for the quick responses. Do you have experience if the performance will be reduced if Adabas and Natural are not on the same server?

With kind regards,  
Vincent Schoone

---

<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:** [July 14, 2023, 3:39pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/5 "2023-07-14T15:39:28Z")

</div>

I’ve worked with customers using Adabas / Natural in the cloud with Adabas and Natural on separate servers, with response time and batch performance comparable to or better than they had on the mainframe. In one case, no Natural ran on the Adabas server and batch performance was very good.

Key to performance was to minimize network latency, so minimal distance and network hops/firewalls are very important, along with the usual requirement for high speed disk availability.

---

<div class="post-metadata">

**Author:** ![Eli\_Cohen1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/eli_cohen1/32/39733_2.png) [@Eli\_Cohen1](https://techcommunity.softwareag.com/u/Eli_Cohen1)\
**Post date:** [July 17, 2023, 9:49am UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/6 "2023-07-17T09:49:41Z")

</div>

You could also consider using Multifetch to fine tune the performance on session level and statement level.

---

<div class="post-metadata">

**Author:** ![schoone](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@schoone](https://techcommunity.softwareag.com/u/schoone)\
**Post date:** [July 26, 2023, 11:13am UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/7 "2023-07-26T11:13:04Z")

</div>

Hi Eli,

do you have a good documentation that explains what exactly Multifetch is and how it works?

Best regards,  
Vincent

---

<div class="post-metadata">

**Author:** ![Eli\_Cohen1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/eli_cohen1/32/39733_2.png) [@Eli\_Cohen1](https://techcommunity.softwareag.com/u/Eli_Cohen1)\
**Post date:** [July 26, 2023, 12:27pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/8 "2023-07-26T12:27:06Z")

</div>

Hello,  
Try to use this page  
[Accessing Data in an Adabas Database (softwareag.com)](https://documentation.softwareag.com/natural/nat921unx/webhelp/natux-webhelp/pg/pg_dbms_ada.htm#pg_dbms_multi)

---

<div class="post-metadata">

**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\
**Post date:** [July 26, 2023, 1:35pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/9 "2023-07-26T13:35:08Z")

</div>

You can read manuals but here is simple overview:

Multifetch is an option in an ADABAS call to return multiple records in a single call. The purpose is to reduce number of ADABAS calls and thus speed up the application in elapsed time.

NATURAL has an option on FIND and READ statements e.g. READ MULTI-FETCH OF n , where n is the number of records you want retrieved. The processing of these records in NATURAL loops is transparent. I personally recommend n to be some number 20 or less. This reduces number of calls by 95%, increasing it more provides diminishing returns but risks issues with larger buffers. Note you cannot use this if you are updating the same records you just retrieved, however you could do a GET SAME and UPDATE…

Great feature IMHO.

P.S. If you are using it online for lists I recommend n to be same as number of records on the screen.

😊

Eugene (Gene) Miklovich

ADABAS/NATURAL Systems Support and DBA

Cell: 916-202-7047

Normal Hours: 8am-4pm E.T.

Please call or text if assistance needed outside these hours.

---

<div class="post-metadata">

**Author:** ![Jeff\_G](https://avatars.discourse-cdn.com/v4/letter/j/e8c25b/32.png) [@Jeff\_G](https://techcommunity.softwareag.com/u/Jeff_G)\
**Post date:** [July 31, 2023, 10:31pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/10 "2023-07-31T22:31:22Z")

</div>

I agree with @Eugene.Miklovich that this is a powerful statement.  
Multi fetch is also available on HISTOGRAM statements.  
One warning: do not use multi fetch to get few records. Example: do not use multi fetch to retrieve one record. It will waste time and resources retrieving multiple records in one call when only one record is wanted or needed.

Somewhere there is a formula to determine the best _n_ value to use. It’s too complicated for me. The size of the view used is one of the factors. The smaller the view (buffer) the bigger _n_ should or could be.  
If the process is not going to read/find/hist large numbers of records, work out a reasonable guess how many records will be retrieved each time the read/find/hist is invoked. If you know that 99% of the time the logic will retrieve five records, make use 5.  
If you expect the number of records to go into six figures and it is a frequent process, do some bench mark tests of a bare-bones program (containing only the IO statement) to try different values. The more frequent and/or important the process, the more bench marks are justified.  
If nothing else, follow @Eugene.Miklovich suggestion and keep it to 20 or less.

---

<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:** [January 27, 2024, 10:31pm UTC](https://techcommunity.softwareag.com/t/natural-access-via-network-to-adabas-in-the-cloud/280957/11 "2024-01-27T22:31:51Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.
