Page History

The process of using MS NAV Adatper Adapter is explained in this section with an . An example is provided of integrating MS NAV with MySQL Database. Four Process Flows are used to build integration. Based on the requirement, more Process Flows can be built. Wiki link iPaaS can be referred to, to learn about building Process Flows / Process Definition Language.DBSync Setup:

• MS NAV Customers to DB Customers:
  • To sync MS NAV Customers with Database Customers table.
• MS NAV Invoice to DB Invoice:
  • To sync MS NAV Invoice with Database Invoice table.
• DB Customers to MS NAV Customers:
  • To sync Database Customer table with MS NAV Customers module.
• DB Invoice to MS NAV Invoice:
  • To sync Database Invoice table with MS NAV Invoice module.
    
    

1. Login into www.mydbsync.com

...

1. .  Click on Customer Login.
2. Enter your DBSync Username and Password and click on Login.
3. Once logged in, click

...

1. on the "My Home" tab from the menu and click

...

1. on Development Studio.

...

1. You will be re-directed to the DBSync

...

1. Project Console.
2. Click

...

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

...

1. on Connectors in the left section of Project Console. You will see MSNAV Connector.
2. Click on the MSNAV connector and update the details as mentioned below.
3. Retain the default classpath.
4. Enter your MS NAV username & password in the specified field.
5. 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

...

1. needs not be entered.
2. Click on Save Properties to save MS NAV Database settings.
3. Click on Validate to confirm validation.
4. Click on the Database on the top left corner of the

...

1. QuickStart window.

...

1. Enter your database URL.
2. Enter your database username & password in the specified field.
3. The driver should be the type of database.

...

1. Autocommit should be true.

...

1. Dbname should be the name of the database.
2. Click on Save Properties to save MS NAV Database settings.
3. Click on Validate to confirm validation.

...

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

Scheduler

...

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

...

Manual Run

...

...

1. Click edit on the DBSync profile page.

Image Removed

1. Select the required process to run.

Image Removed

...

1. Click Run to manually initiate integration.

...