How to schedule an export from Nav 5.0 SP1

Hi there!

I'm from the BI world...

I have a client who need to do some reporting based on data from Nav 5.0 SP1. We have not decided which BI platform to use, yet - but most likely it would be Tableau or Power BI.

Nevertheless, the report will present sales figures and prices on customers, sales men, regions, product lines ect. in charts and (heat)maps.

Thing is, we need to extract data from nav and convert into a usefull datasource e.g. csv, excel, txt or a SQL database.

And we would like to set up / schedule data extract to run every week.

Are there any good / standard / recommend approaches?

Are there any out-of-the box opportunities to setup schedules with data extracts in Nav 5.0? Or do can we use scripting from SSIS or PowerShell or something else?