Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / DB Connection type in NAV
Microsoft Dynamics NAV (Archived)

DB Connection type in NAV

(0) ShareShare
ReportReport
Posted on by cenium_c 55

Hello,

I'm quite new with NAV. Right now, my company uses Cenium 5 and Cenium 6, which are developed based on Microsoft Navisions.

We need to export data connecting to MS SQL DB Server. Anybody here can tell me how many types of connection available to interact with this MS SQL DB Server?

We are investigating the new integration architecture, so that it would be nice if you can let me know the possible options for connection types, as well as suggest the recommended type either.

Many thanks!

*This post is locked for comments

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: DB Connection type in NAV

    Hi

    It depends on what you are trying to do,

    If you only want to read information you can do so by connecting directly to the SQL database, this can use SQL or ODBC drivers, so whatever suites however if possible you should use the direct SQL driver as it is faster

    If you want to read and write you should never write directly into the NAV tables, being a financial system there are certain business rules and checks and balances that are made against all incoming transaction entered into the NAV system, if you write directly to the SQL tables these are missed and all sorts of things will break

    To handle this correctly you have several options, the best option is as Miguel says, web services, these will provide the most flexibility and control over the process from the remote application, but you can also have the two systems communicate through a shared SQL table (Specially created for this purpose), files (XML, CSV, etc....), NAV can connect to TCP ports, and oter methods

    Cheers

    Nev

  • Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on at
    RE: DB Connection type in NAV

    Since NAV 2009 you can use "Web Services". It's quite easy to implement, and nice for integrations.

    You can read more about it here: msdn.microsoft.com/.../dd355036.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans