Anchor
_Toc388361083 _Toc388361083

Anchor
_Toc388361130 _Toc388361130

Anchor
_Toc388362087 _Toc388362087

Microsoft Dynamics NAV to Database

The process of using MS NAV Adatper is explained in this section with an example of integrating MS NAV with MySQL Database.

Anchor
OLE_LINK7 OLE_LINK7

Anchor
OLE_LINK8 OLE_LINK8

DBSync Setup:

• Login into www.mydbsync.com and click on Customer Login.
• Enter your DBSync Username and Password and click on Login.
• Once logged in, click on "My home" tab from the menu and click on Launch button.

Image Added

• You will be re-directed to DBSync profile page.
• Click on Quick Start button to navigate to the configuration window as shown.

Image Added

• Click on MS NAV on the top left corner of the Quick Start window.

Image Added

• Retain the default classpath.
• Enter your MS NAV username & password in the specified field.
• Enter the base URL for the server wherein MS NAV is installed. If DBSync is installed in the same machine where MS NAV is installed URL field need not be entered.
• Click on Save Properties to save MS NAV settings.
• Click on Validate to confirm validation.
• Click on Database on the top left corner of the Quick Start window.

Image Added

• Enter your database URL.
• Enter your database username & password in the specified field.
• driver should be the type of database.
• autocommit should be true.
• dbname should be the name of database.
• Click on Save Properties to save MS NAV settings.
• Click on Validate to confirm validation.

Running the integration:

Integration can be run using scheduler or run button. Scheduler can be used to setup auto run & run button can be used to run the integration manually.

Scheduler:

• Click on the Scheduler button on the top right corner of DBSync profile page.
• Select the required profile to schedule & Process.
• Enter the frequency of sync under Cron Settings.
• In the bottom, Cron Scheduler will show the scheduled process.
• In case, the scheduled process is no longer required, you may delete the schedule.

Image Added

Manual Run:

• Click on edit on DBSync profile page.

Image Added

• Select the required process to run.

Image Added

• Click on Run to manually initiate integration.

Image Added