CData Software - Knowledge Base



Recent Dynamics 365 Business Central Articles

PowerShell Scripting to Replicate Dynamics 365 Business Central to MySQL

Write a simple PowerShell script to replicate Dynamics 365 Business Central to a MySQL database.

Visualize Dynamics 365 Business Central from Tableau

Use the Tableau Desktop business intelligence tool to connect to Dynamics 365 Business Central.

Import Dynamics 365 Business Central Data into SQL Server using SSIS

Easily back up Dynamics 365 Business Central to SQL Server using the SSIS components for Dynamics 365 Business Central.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Connect to Dynamics 365 Business Central and Transfer Data in Talend

Integrate Dynamics 365 Business Central with standard components and data source configuration wizards in Talend Open Studio.

Work with Dynamics 365 Business Central in FoxPro

Load Dynamics 365 Business Central into a FoxPro database. This article includes full code and a walk-through of the process.

Create Data Visualizations in Cognos BI with Dynamics 365 Business Central

Access Dynamics 365 Business Central as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Natively Connect to Dynamics 365 Business Central in PHP

The CData ODBC driver for Dynamics 365 Business Central enables you to create PHP applications with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.

Build an OLAP Cube in SSAS from Dynamics 365 Business Central

Connect to Dynamics 365 Business Central in an Analysis Services project using the Dynamics 365 Business Central Data Provider and build OLAP cubes for use in analytics, reporting, and more.

Analyze Dynamics 365 Business Central with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Dynamics 365 Business Central from Power Pivot. You will use the Table Import Wizard to load Dynamics 365 Business Central. You can visually build the import query or use any SQL supported by the driver.

Connect to Dynamics 365 Business Central in Ruby

Connect to Dynamics 365 Business Central in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.