Learn more
 

CData Software - Knowledge Base

Recent Dynamics GP ADO.NET Articles

Export Data from SQL Server to Dynamics GP through SSIS

Easily push SQL Server data to Dynamics GP using the CData SSIS Tasks for Dynamics GP.

How to Access Dynamics GP Using Entity Framework

This article shows how to access Microsoft Dynamics GP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Deploy the ADO.NET Provider for Dynamics GP on an SSRS Report Server

Connect to Microsoft Dynamics GP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Back Up Microsoft Dynamics GP to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics GP. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dynamics GP data.

Build an OLAP Cube in SSAS from Dynamics GP

Establish a connection to Microsoft Dynamics GP data from SQL Server Analysis Services, and use the Dynamics GP Data Provider to build OLAP cubes for use in analytics and reporting.

How to Import Dynamics GP into SQL Server using SSIS

Easily back up Microsoft Dynamics GP to SQL Server using the SSIS components for Dynamics GP.

DataBind Dynamics GP to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Dynamics GP with the DevExpress Windows Forms and Web controls to provide Microsoft Dynamics GP to a chart.

Visualize Dynamics GP in TIBCO Spotfire through ADO.NET

Integrate Microsoft Dynamics GP into dashboards in TIBCO Spotfire.

LINQ to Dynamics GP

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Dynamics GP Data Provider.

Automate Dynamics GP Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Microsoft Dynamics GP from PowerShell? This article demonstrates how to utilize the Dynamics GP Cmdlets for tasks like connecting to Microsoft Dynamics GP, automating operations, downloading data, and more.