Get Data from another Database

bill · 2014-06-13

Hi All. I have an issue. There is a need to run a report and gather data from another database. Is there a way to connect to another database and specific company get the data and transfer them into the other Navision database?

Saalek · 2014-06-13

Hi

Use NAV Webservices to do it.

Regards

bill · 2014-06-13

Thanks for your responce.

Is there a function or somenthing like CHANGECOMPANY in order to do this via C/AL code?

mohana_cse06 · 2014-06-13

Yes, read this for help
http://msdn.microsoft.com/en-us/library/dd338929.aspx

bill · 2014-06-13

thanks mohana, but this is not my need. I know the CHANGECOMPANY functionality, i asked if there is a function like CHANGECOMANY in order to connect to another database within the same server.

Saalek · 2014-06-13

Hi

You can do thinks that we did a few years ago.
Use ODBC to create a connection to a database and then use Microsoft ADO (or ADO.NET) to manage tables and Info.
I used it to connect ACCESS and SQL databases, so using NAV ODBC will be similar.

But, I think the best solution are web services

Regards

Wisa123 · 2014-06-13

If the External Database is on another Server you need a stable Connection to both used DB's:
Establish a linked Server Connection
http://msdn.microsoft.com/en-us/library/ms188279.aspx
Then create a view for all the Data you need.

If the Database is on the same sqlserver instance just create the view and a NAV table using the LinkedObject <Yes> Property.

The second possibility would be to solve the issue using WebServices.

___
Wisa

bill · 2014-06-13

thank you all for your feedback. Your info was very helpful.

Get Data from another Database

Comments

Categories