# Require Addition information on ADM export

**URL:** <https://forums.pega.com/t/require-addition-information-on-adm-export/8775>\
**Category:** General\
**Tags:** 24-1, pega-adaptive-decision-manager, system-administration, data-management\
**Created:** [December 23, 2024, 4:24pm UTC](https://forums.pega.com/t/require-addition-information-on-adm-export/8775 "2024-12-23T16:24:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SiddharthaB6233](https://avatars.discourse-cdn.com/v4/letter/s/77aa72/32.png) [@SiddharthaB6233](https://forums.pega.com/u/SiddharthaB6233)\
**Post date:** [December 23, 2024, 4:24pm UTC](https://forums.pega.com/t/require-addition-information-on-adm-export/8775/1 "2024-12-23T16:24:44Z")

</div>

we are exporting ADM model data export, How can this data can be analysed externally ?

challenges facing:

1. Jason to csv conversion

2. pyModel data is encrypted.

Use performed export based on the below links guidance.

[Exporting the ADM Datamart · pegasystems/pega-datascientist-tools Wiki · GitHub](https://github.com/pegasystems/pega-datascientist-tools/wiki/Exporting-the-ADM-Datamart)

[Exporting adaptive model data for external analysis | Pega Academy](https://academy.pega.com/challenge/exporting-adaptive-model-data-external-analysis/v5)

[Exporting the ADM Datamart · pegasystems/pega-datascientist-tools Wiki · GitHub](https://github.com/pegasystems/pega-datascientist-tools/wiki/Exporting-the-ADM-Datamart)

---

<div class="post-metadata">

**Author:** ![TomVanDuist](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/tomvanduist/32/9272_2.png) [@TomVanDuist](https://forums.pega.com/u/TomVanDuist)\
**Post date:** [December 30, 2024, 8:29am UTC](https://forums.pega.com/t/require-addition-information-on-adm-export/8775/2 "2024-12-30T08:29:43Z")

</div>

Hi @SiddharthaB6233,

Can you please explain which method you have tried to export the data? Any method mentioned in the [documentation on GitHub](https://github.com/pegasystems/pega-datascientist-tools/wiki/Exporting-the-ADM-Datamart) should work, if you face any specific issue with any of the methods we can try to help you out if you are able provide some more context.

With the encrypted column in point (2), do you mean the `pyModelData` column in the `PR_DATA_DM_ADMMART_MDL_FACT` table, as mentioned [here](https://docs.pega.com/bundle/platform-241/page/platform/decision-management/database-tables-monitoring-models.html)? If yes, you can ignore the data in this column as you will not need it for any analysis.

Best,  
Tom

---

<div class="post-metadata">

**Author:** ![Sairohith](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/sairohith/32/23362_2.png) [@Sairohith](https://forums.pega.com/u/Sairohith)\
**Post date:** [January 2, 2025, 5:00pm UTC](https://forums.pega.com/t/require-addition-information-on-adm-export/8775/3 "2025-01-02T17:00:03Z")

</div>

@SiddharthaB6233 To analyze exported ADM data externally, first convert the JSON data to CSV using tools like Python or `jq`. In Python, you can write a script to load the JSON, extract keys as headers, and save the records in CSV format. If the `pyModel` data is encrypted, you will need Pega’s decryption API or utilities. Work with your Pega admin team or support to access these tools or enable unencrypted export by modifying data extraction rules, ensuring compliance with security policies. Once converted and decrypted, clean the data for accuracy and use analysis tools like Excel, Tableau, or Python libraries to visualize trends. Always store sensitive data securely and seek Pega support if issues persist with decryption or export processes

---

<div class="post-metadata">

**Author:** ![Otto\_Perdeck](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/otto_perdeck/32/22620_2.png) [@Otto\_Perdeck](https://forums.pega.com/u/Otto_Perdeck)\
**Post date:** [January 3, 2025, 11:03am UTC](https://forums.pega.com/t/require-addition-information-on-adm-export/8775/4 "2025-01-03T11:03:56Z")

</div>

@SiddharthaB6233 If you have additional questions after Tom’s answer please let me know. You can also post to the PDS tools discussions: [pegasystems/pega-datascientist-tools · Discussions · GitHub](https://github.com/pegasystems/pega-datascientist-tools/discussions).

You should not attempt to create CSV, instead just export the dataset to the standard Pega format (which is a flavor of zipped NDJSON). As Tom mentioned, the pyModelData field is internal and you should be ignoring this in the analysis. It could (if size is a concern) be dropped from the export as per the article mentioned by Tom.

-Otto