SQL Server access

Are there any 3rd party APIs available for DB access (Insert/Delete) for Navision 2009 version? If not, are there any other ways to achieve this functionality in a secured way?

Hi!

Well, as you are running SQL Server you don’t need any special “API” or anything, as alomost any MS or 3rd party tool is enabled to connect! THere are .NET components or Automation Servers like MS ADO to connect via code etc…

Please seach the forum about ADO and you’ll get plenty of advices.

But there are some general issues you must have in mind:

  1. when accessing the NAV db from “outside” you have to bypass NAV’s securtity system, hence you might create a security risk here
  2. when accessing the NAV db from “outside” you have to bypass NAV’s business logic, hence you might corrupt data integrity
  3. when accessing the NAV db from “outside” you have to use compatible datatypes, else you corrupt data integrity
  4. when accessing the NAV db from “outside” you must ever write into real ERP tables; you have to insert your data into buffer tables, the process the data via NAV codeunits/reports/etc. to create valid NAV data

Regards,
Jörg

You can access the sql server database through command prompt (OSQL.exe) provided proper authentication should be there. You will get the output in command prompt.

Thank you Jörg and Kathik for your quick response !!!