# OpenPDC historian retentions

**URL:** <http://discussions.gridprotectionalliance.org/t/openpdc-historian-retentions/1202>\
**Category:** openPDC\
**Created:** [October 2, 2023, 12:28pm UTC](http://discussions.gridprotectionalliance.org/t/openpdc-historian-retentions/1202 "2023-10-02T12:28:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andre\_Santos](http://discussions.gridprotectionalliance.org/user_avatar/discussions.gridprotectionalliance.org/andre_santos/32/856_2.png) [@Andre\_Santos](http://discussions.gridprotectionalliance.org/u/Andre_Santos)\
**Post date:** [October 2, 2023, 12:28pm UTC](http://discussions.gridprotectionalliance.org/t/openpdc-historian-retentions/1202/1 "2023-10-02T12:28:23Z")

</div>

Hi, openPDC historian has retention policies for saving data to a database ?

For example, auto deleting older rows since new one is coming. I have to do my own retention based on the database that I use or there are a configuration parameter that I dont see ?

Thanks.

---

<div class="post-metadata">

**Author:** ![StephenCWills](http://discussions.gridprotectionalliance.org/user_avatar/discussions.gridprotectionalliance.org/stephencwills/32/20_2.png) [@StephenCWills](http://discussions.gridprotectionalliance.org/u/StephenCWills)\
**Post date:** [October 3, 2023, 7:57pm UTC](http://discussions.gridprotectionalliance.org/t/openpdc-historian-retentions/1202/2 "2023-10-03T19:57:33Z")

</div>

Hi Andre,

It sounds like maybe you are using the `AdoOutputAdapter` to write real-time data to a SQL database using openPDC? That adapter does not have any options for automatically deleting data. This could perhaps be implemented using a custom adapter, but we don’t have any such adapter built in that can be used to automatically delete data from a SQL database based on a retention policy.

Thanks,  
Stephen