# How to sync discourse database to data warehouse

**URL:** https://meta.discourse.org/t/how-to-sync-discourse-database-to-data-warehouse/54244
**Category:** Support
**Created:** [December 14, 2016, 4:32pm UTC](https://meta.discourse.org/t/how-to-sync-discourse-database-to-data-warehouse/54244 "2016-12-14T16:32:55Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Ajay\_Varia](https://avatars.discourse-cdn.com/v4/letter/a/6bbea6/32.png) [@Ajay\_Varia](https://meta.discourse.org/u/Ajay_Varia)
#### Post date: [December 14, 2016, 4:32pm UTC](https://meta.discourse.org/t/how-to-sync-discourse-database-to-data-warehouse/54244/1 "2016-12-14T16:32:55Z")

</div>

Hello,

I would like to sync our hosted discourse database to our data warehouse in redshift.  
I see that I can manually get a backup postgres from the admin.

Is there an automated way to do this?

Thanks!

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [December 14, 2016, 5:31pm UTC](https://meta.discourse.org/t/how-to-sync-discourse-database-to-data-warehouse/54244/2 "2016-12-14T17:31:29Z")

</div>



---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [December 14, 2016, 5:33pm UTC](https://meta.discourse.org/t/how-to-sync-discourse-database-to-data-warehouse/54244/3 "2016-12-14T17:33:43Z")

</div>

Hi Ajay,

Out of the box, you can use the [RSS](https://community.masterclass.com/latest.rss), [API](https://meta.discourse.org/t/discourse-api-documentation/22706) or [Web hooks](https://meta.discourse.org/t/setting-up-webhooks/49045) to feed information from Discourse to other systems.

Would that work for you?