Open Forum

Expand all | Collapse all

Connecting NAV to external server/database

  • 1.  Connecting NAV to external server/database

    Posted Jul 12, 2019 09:35 AM
    Hi all,

    I am working on a project to transfer data out of NAV (minimal data updated periodically every few weeks). We are on NAV 2018 on prem.

    I have server A with Database AB (this is NAV server and prod database)
    I have server B with Database BB (physical server on site)
    The databases are linked in SQL server management tool.

    My original plan was to have data inputted DB AB (inside NAV), and then through a scheduled job in SQL transfer the data to DB BB.  The problem was DB BB had some kind of logic built in that would not allow me to write data into it.  Of the ~20 fields, 18 wrote fine but two had issues with passing the data.

    So the next thought was to start the process in DB BB, write the data here - and then have it transfer to DB AB through the scheduled job queue. Which would work without any issues I can foresee - as I have much more control in the NAV database/logic.  But now I am thinking to the future and how we will eventually move to BC in the cloud and it does not sound like this approach will age well.

    So my question... with BC in the cloud, what are the methods available to accomplish a task like this?

    ------------------------------
    Matt McDowell
    Supply Chain Analyst
    Valley Blades Limited
    Waterloo ON
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Connecting NAV to external server/database

    Posted Jul 12, 2019 12:55 PM
    I would look to use web services to accomplish this:

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services


    ------------------------------
    Ron Summers
    Tigunia
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Connecting NAV to external server/database

    SILVER CONTRIBUTOR
    Posted Jul 15, 2019 01:29 AM
    Hi Matt,

    I agree with the Ron, If you are planning to move to BC in future then it will be better to use Web Services.

    ------------------------------
    DEEPAK KUMAR
    BC/NAV Consultant
    AlleTechnologies Inc.
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Connecting NAV to external server/database

    TOP CONTRIBUTOR
    Posted Jul 17, 2019 03:36 PM
    Most likely to manual of a process. however:
    We have a  Veeam Backup & Replication system that takes a snapshot and we can go grab the database: mdf & ldf in 15 minute intervals.  In looking at our NAV 2015 to NAV 2018 project we have a 240 GB DB .  Kind of just like dropping the database, etc. Then using the Azure Storage Explorer which does not have a lot of limitation move the database to storage explorer.  Then from the Azure Server pick it up from storage explorer.    Also, Azure Storage Explorer might also allow you to grab a copy of the database and shuttle it from in place to target environment though I have not done this.

    ------------------------------
    Ronald McVicar, IT Software Mgr
    NSP (Quality Meats)
    nspproteins.com
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Connecting NAV to external server/database

    GOLD CONTRIBUTOR
    Posted Jul 17, 2019 11:36 PM
    Matt,

    If you are planning to move to BC in cloud (Saas) version, then you will not have much control over the SQL. In this case, the best approach would be using web services or API's.


    ------------------------------
    Thanks
    Suresh Kulla
    NAV Technical Architect
    Atlanta GA
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role