web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV table sync
Microsoft Dynamics NAV (Archived)

NAV table sync

(0) ShareShare
ReportReport
Posted on by Shyamraoo 354

Hi 

We are using staging table to integrate two applications, the staging table is created in NAV, the SSIS job pull the information from the external system and puts it in NAV staging table. but when I check the data in nav it is not available but once I refresh the table the data comes in. 

Anyone know how to refresh the table using code because am trying to run the job in NAV to pull the data from staging table to sales order. since the staging table gets updated only when I refresh the table my job was not able to create the sales order.

Any help much appreciated. 

Thanks,

Shyam Kumar N

*This post is locked for comments

I have the same question (0)
  • Verified answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at

    Shyamaroo,

    Have you tried using NAV's Web Services and the Job Queue to do this (automated / scheduled integration between your app and NAV)?

    Remember that using SQL tools like SSIS to insert data into NAV or manipulate NAV data is not a best practice and opens the door to many issues. SQL does not interact with or understand NAV business logic, so it will be unable to trigger important code that needs to run in NAV to validate data being entered into a field, or perform OnInsert / OnModify / OnDelete actions that may be critical for the table in NAV. And of course, you run into issues like this because you cannot call code like CurrPage.UPDATE to refresh a page in NAV from SSIS.

    Using Web Services allows you to interact with NAV's business logic layer, and the built-in Job Queue allows you to automate or schedule your integration if NAV needs to actively perform a certain action.

    I hope this helps! If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Verified answer
    Shyamraoo Profile Picture
    Shyamraoo 354 on at

    Thanks for your reply Ansari, I know it is not the right way to directly insert into SQL table, but the project is already moved into live environment and i dont have option to use webservice but I resolved this issue by adding SELECTLATESTVERSION function before my job queue runs.

    Anyways thanks again for your detailed explanation.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans