Extracting data
Dynamics NAV offers several ways of analyzing and reporting data inside the application. If that is not enough, you can also extract data from the application and use external tools to report and analyze your data.
In this section, we will see the different ways you can extract your data from Dynamics NAV. Once it is outside the application, you can use the most convenient tool for you.
Data in Dynamics NAV can be extracted in multiple ways. The various ways include:
- Copying and pasting to Excel
- Extracting data through SQL Server
- Any external data/reporting tools that can connect to SQL Server
- Web services
- EDI
The list goes on and on…
In this section, we'll focus only on two ways of exporting the data:
- Sending data to Microsoft Office applications
- Using web services
