How to: automatically download RE NXT backup each night for reports, data warehouse etc

Ian Codeulike

I wrote this blog post a while ago and thought it might be useful here for some. As you probably know with RE NXT if you have the ‘Bulk Data Delivery’ option you can download a backup of (most) of your RE NXT database each night and restore it on your own SQL Server. There are some challenges if you want to automate that process though, e.g. dealing with Azure SAS urls and finding the latest backup from the set of seven most recent ones, etc. I automated it using SQL Server and Powershell, details are in the blog post:

RENXT - automatic download of database for reporting, sql etc

Happy to answer any questions.

Alex Wong

@Ian Codeulike
nice work, there were a lot of others that have asked for this on Community, it will be helpful for them.

Carol Ewart

@Ian Codeulike This is awesome! Thank you!

Steve Birnbaum

@Ian Codeulike
Hi, I saw your post about accessing your NXT data in a data warehouse. If anyone wants to connect about using SKY API for data warehousing feel free to contact me at Steve@DataMoose.org