# Third-Party ODBC connectivity

**URL:** <https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Installation-and-Setup-on-Open-Systems\
**Created:** [March 22, 2011, 5:27am UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547 "2011-03-22T05:27:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sean3](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Sean3](https://techcommunity.softwareag.com/u/Sean3)\
**Post date:** [March 22, 2011, 5:27am UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547/1 "2011-03-22T05:27:41Z")

</div>

What has to be in place so that a third-party application can run SQL queries and updates through an ODBC connection to an ADABAS backend?

---

<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:** [March 22, 2011, 9:16pm UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547/2 "2011-03-22T21:16:19Z")

</div>

You need the ADABAS SQL Gateway add-on to open Adabas to SQL processing. There are also third party providers who also claim to provide this functionality.

Natively, Adabas does not support SQL in order to keep it as the fastest DBMS on the planet. Obviously the need is there to support SQL, however. ADABAS SQL Gateway supports ANSI standard SQL.

Hope this helps!

---

<div class="post-metadata">

**Author:** ![Sean3](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Sean3](https://techcommunity.softwareag.com/u/Sean3)\
**Post date:** [March 22, 2011, 9:58pm UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547/3 "2011-03-22T21:58:56Z")

</div>

Thank you, Brian. I do have a few further clarifying questions.

My preference would be to keep everything Software AG. The third-party software doesn’t care what the back-end database is, as long as it’s an ODBC compliant data source to pull and push to.

(1) Is the SQL Gateway add-on the only component that I would need to enable ODBC connectivity for read and write capability to the DBMS? (I certainly hope so)

(2) Is there any documentation (demo/paper) available from Software AG on connecting to ADABAS through the SQL Gateway via ODBC?

(3) Is this functionality (SQL Gateway) available in any way with the ADABAS community edition (free download) which I could use for testing?

I certainly appreciate your response. It seems that this subject (ODBC Integration) would generate a popular interest for discussion.

Sean

---

<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:** [March 23, 2011, 1:22am UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547/4 "2011-03-23T01:22:57Z")

</div>

Check out the documentation at [techcommunity.softwareag.com/ecosystem/documentation](http://techcommunity.softwareag.com/ecosystem/documentation) under Adabas.

---

<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:** [March 23, 2011, 2:28am UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547/5 "2011-03-23T02:28:55Z")

</div>

To answer your questions:

1. Yes, Adabas SQL Gateway will open your Adabas C database to update DML as well as inquiry DML if you so choose.

2. As Douglas mentioned, you can find the documentation at [http://techcommunity.softwareag.com/ecosystem/documentation/adabas/cxx1102/overview.htm](http://techcommunity.softwareag.com/ecosystem/documentation/adabas/cxx1102/overview.htm) .

3. As for the community edition of Adabas, I know the capabilities are limited, so I cannot answer your question. Best would be to discuss with your Software AG sales rep about engaging in some kind of trial or proof of concept.

For more information, please check out the product info page at: [http://www.softwareag.com/Corporate/products/adabas/sql/default.asp](http://www.softwareag.com/Corporate/products/adabas/sql/default.asp)

---

<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:59pm UTC](https://techcommunity.softwareag.com/t/third-party-odbc-connectivity/96547/6 "2021-04-02T14:59:58Z")

</div>


