Microsoft Dynamics NAV and SQL Server connector integrates data from Microsoft Dynamics NAV to SQL Server and vice-versa. It helps you streamline your Microsoft Dynamics NAV data with SQL Server. Using the template provided with this solution you can construct your integration process between Microsoft Dynamics NAV and SQL Server as per your own unique business model and processes. The connector is bundled with features to create custom mappings with just few clicks.
- Data Management
DBSync Microsoft NAV Adapter allows you to move data into and out of the Microsoft Dynamics NAV.
- Exporting and Migrating Data
Export data from Accounting, CRM or other ERP system into a central data warehouse for consolidated reporting.
- E-Commerce Integration
By connecting your eCommerce and Shopping carts directly to your Microsoft Dynamics NAV data, our adapter enables you to streamline your business processes and get a big picture of your efforts.
- Near real time Integration
DBSync can automate in near real-time between Microsoft Dynamics NAV and your database to provide your management team with the ability to slice and dice data to get a complete look at the company performance. Supported database integrations are JDBC and ODBC compliant databases, such as Oracle Database, SQL Server, IBM DB2, MySQL, PostgreSQL, Amazon Redshift and more.
Frequently Asked Questions
How does DBSync connect to Microsoft Dynamics NAV?
DBSync connects to Microsoft Dynamics NAV through Web Services. Services (and Pages or routines) should be exposed for other applications to consume them.
What are the pre-requisites for DBSync integration to work with Microsoft Dynamics NAV?
SOAP Web service of Microsoft Dynamics NAV should be enabled.
Is this connector available with on-demand and on-premise versions of DBSync?
This connector has the support for both the versions of DBSync.
Does DBSync need to be installed on the same machine as that of Microsoft Dynamics NAV?
This connector can be either configured on the same machine where Microsoft Dynamics NAV is installed or on a remote machine that can access Microsoft Dynamics NAV.
What is DBSync SDK?
DBSync SDK allows you to write your own custom adapters and extensions. It can be deployed to your DBSync Integration Engine with processes you need to setup.
Why do we need this additional coding?
Many times Web Services exposed cannot be imported or ETL tools cannot interpret the metadata. This causes many other ETL tools to fail. With our Java Adapter extensions, we can handle many of these cases very efficiently.
What are the supported versions of Microsoft Dynamics NAV?
This solution supports Microsoft Dynamics NAV 2009 and all versions above
Can I get a free trial version of DBSync?
Definately! DBSync is available for 14-day free trial after completing the registration process.