Forum Discussion
Getting data from navision
hello,
does anyone have an idea on how i can get data from navision without a url? I am connecting to navision through RDP to the machine that has the database and i want to connect to it without using a OData URL
Hi, Hussein_charif
If you have access to SQL Server where the Navision database is located, you can run direct SQL queries to extract data. This requires an understanding of the structure of the database and the SQL language.
You can also write custom C/AL (for older versions of Navision) or AL (for newer Dynamics 365 Business Central) code to export the data. These codes can be used to create reports or export data to a file. You can check the following link:
How to Process URL Without Opening a Web Browser in C/AL - NAVUSER
Although you mentioned not using OData, you can still use SOAP web services, which is another type of web service available in Navision. These services can be configured and used without the need for OData URLs.
For more information on extracting data, you can check out the link below:
Importing and Exporting Data in Microsoft Dynamics NAV 2013 R2 CU 8 - Microsoft Dynamics 365 Blog
Extracting data - Microsoft Dynamics NAV [Book]
Export-NAVData (Microsoft.BusinessCentral.Management) - Dynamics NAV | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Hussein_charif
If you have access to SQL Server where the Navision database is located, you can run direct SQL queries to extract data. This requires an understanding of the structure of the database and the SQL language.
You can also write custom C/AL (for older versions of Navision) or AL (for newer Dynamics 365 Business Central) code to export the data. These codes can be used to create reports or export data to a file. You can check the following link:
How to Process URL Without Opening a Web Browser in C/AL - NAVUSER
Although you mentioned not using OData, you can still use SOAP web services, which is another type of web service available in Navision. These services can be configured and used without the need for OData URLs.
For more information on extracting data, you can check out the link below:
Importing and Exporting Data in Microsoft Dynamics NAV 2013 R2 CU 8 - Microsoft Dynamics 365 Blog
Extracting data - Microsoft Dynamics NAV [Book]
Export-NAVData (Microsoft.BusinessCentral.Management) - Dynamics NAV | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.