External Database Connector

External Database Connector application facilitates the exchange of data between any external database and Microsoft Dynamics 365 Business Central cloud or on-premises ERP system.

At Intelligent Systems, we understand that businesses need to be flexible in their daily collaborations with partners by using different sources of data, extraneous to their ERP system. This could lead to delays and difficulties in performing daily tasks due to the inconsistent information and need of manual data processing.

For this reason, our team developed External Database Connector, an application that connects the existing databases your company may have with the Dynamics 365 Business Central. The connection is established through an API (Application Programming Interface). The tool works with all databases that support Open Database Connectivity (ODBC) and the API runs on Windows Server 2016 or later version.

With easy setups and data mappings the application assists companies in the effortless data exchange between different sources of data and the ERP system. It can read information from tables, views, and fields. The app maps them to the corresponding tables and fields in the Dynamics 365 Business Central and creates new or overwrites existing entries. The latest version of the app supports data exports from Dynamics 365 Business Central tables or queries to external databases via fields mappings.

External Database Connector is the right tool for:

• Organizations that need to connect existing databases with their Dynamics 365 Business Central ERP system
• Companies with cloud, or on-premises databases
  
  

Supported databases: MySQL, Microsoft SQL server, Oracle, PostgreSQL, MongoDB, MS Access and more.

Features:

• Establish connection between external databases and the ERP database through API (Application Programming Interface)
• Import data from external databases to Dynamics 365 Business Central via tables and fields mapping
• Execute raw queries
• Data transactions log
• Data export to external database from Dynamics 365 Business Central tables or queries via fields mapping
• Automated data processing via job queue scheduler
• E-mail notifications after processing

Benefits:

• Facilitate the information flow between different external databases and Dynamics 365 Business Central by automating data exchange process

• Flexible mapping setup supporting an indefinite number of records
• Reduces time and efforts for manual data transfers and eliminates human errors
  
  

Supported Languages:

This app is available in English (United States). Translation is possible in other languages.

Supported countries:

All countries where Dynamics 365 Business Central is available.

Supported Editions:

This app is compatible with Microsoft Dynamics 365 Business Central Essentials and Microsoft Dynamics 365 Business Central Premium edition.

For more on the External Database Connector app, get in touch with us: Contact Intelligent Systems | ERP, CRM, BI, Cloud (isystems-group.com)