Dynamics 365 Business Central Connector
Connecting to Dynamics 365 Business Central via ODBC
The Dynamics 365 Business Central ODBC Driver is a powerful tool that allows you to connect to live Dynamics 365 Business Central data directly from all applications that support ODBC connectivity. Access the Dynamics 365 Business Central database and read, write and update items, sales orders and purchase orders through a standard ODBC driver interface. This connector is suitable for both Qlik Sense like QlikView, but can also be used for other tools, such as our data warehouse solution TimeXtender and other BI tools, such as PowerBI In Excel.
Your benefits
- Powerful metadata queries enables SQL-like access to non-database resources.
- Push-down optimization pushes SQL operations down to the server where possible, improving performance Client-side query execution engine, supports SQL-92 operations not available on the server.
- Connect to live Salesforce Marketing Cloud data for real-time access to data.
- Seamless integration with leading BI, reporting and ETL tools as well as with custom applications.
- Full support for data aggregation and complex JOINs in SQL queries.
- Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
Specifications
- Supports 32-bit and 64-bit applications.
- ODBC 3.8 compliant proprietary protocol based drivers.
- Extensive ANSI SQL-92 support.
- Full Unicode support - any language, any data.
- Cross platform ODBC. Available for Windows, Linux and macOS.