# Extract data from adabas files so it cab be used in SQL server

**URL:** <https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas\
**Created:** [November 14, 2022, 8:41pm UTC](https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011 "2022-11-14T20:41:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mary\_Ubillus](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/mary_ubillus/32/23283_2.png) [@Mary\_Ubillus](https://techcommunity.softwareag.com/u/Mary_Ubillus)\
**Post date:** [November 14, 2022, 8:41pm UTC](https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011/1 "2022-11-14T20:41:18Z")

</div>

Hi trying to extract Data from adabas files to flat files any ideas I know I can write to work file .But I need to extract the Data so it can be used in SQL Server just a bit just a bit rusty here ..

Mary

Mary

#### What are you trying to achieve? Please describe it in detail.

#### Do you get any error messages? Please provide a **full error** message screenshot and log file.

#### Have you installed all the latest fixes for the products and systems you are using?

---

<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:** [November 14, 2022, 9:47pm UTC](https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011/2 "2022-11-14T21:47:21Z")

</div>

The standard way is to create a file with the Parent fields (scalar) plus the ISN.

Then create a file for each of the MU’s and PE’s with ISN and occurrence number (CHILD tables).

---

<div class="post-metadata">

**Author:** ![Mary\_Ubillus](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/mary_ubillus/32/23283_2.png) [@Mary\_Ubillus](https://techcommunity.softwareag.com/u/Mary_Ubillus)\
**Post date:** [November 14, 2022, 9:51pm UTC](https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011/3 "2022-11-14T21:51:20Z")

</div>

When you say file you mean work file ?

---

<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:** [November 14, 2022, 10:29pm UTC](https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011/4 "2022-11-14T22:29:12Z")

</div>

Yes, you would write out each parent/child “table” to a separate work file as record (fixed columns) or csv file. As Gene says, parent unique identifier is its ISN and the child unique identifier is the ISN plus the MU/PE index.

---

<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:** [May 13, 2023, 10:29pm UTC](https://techcommunity.softwareag.com/t/extract-data-from-adabas-files-so-it-cab-be-used-in-sql-server/266011/5 "2023-05-13T22:29:32Z")

</div>

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