CData Software - Knowledge Base



Recent Dynamics GP Articles

Replicate Dynamics GP from PowerShell

Write a quick PowerShell script to query Microsoft Dynamics GP. Use connectivity to the live data to replicate Microsoft Dynamics GP to SQL Server.

Connect to Dynamics GP in SpagoBI

Create reports featuring live Microsoft Dynamics GP in SpagoBI Studio. Host Dynamics GP reports on SpagoBI Server.

Build MVC Applications with Connectivity to Dynamics GP

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics GP from an ASP.NET MVC application.

Excel Spreadsheet Automation with the QUERY Formula

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

Use the CData ODBC Driver for Dynamics GP in SAS JMP

You can use the CData ODBC Driver to integrate Microsoft Dynamics GP into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dynamics GP in the Graph Builder and Query Builder.

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.

Automate Dynamics GP Integration Tasks from PowerShell

Are you looking for a quick and easy way to access Microsoft Dynamics GP from PowerShell? We show how to use the Cmdlets for Dynamics GP and the CData ADO.NET Provider for Dynamics GP to connect to Microsoft Dynamics GP and synchronize, automate, download, and more.

Establish a Live Connection with Dynamics GP using Tableau Bridge

The CData ODBC Driver for Dynamics GP enables you to integrate live Microsoft Dynamics GP into Tableau Cloud dashboards using the Tableau Bridge.

Connect to Dynamics GP in Squirrel SQL Client

Connect to Microsoft Dynamics GP and execute queries in the Squirrel SQL Client.

Connect to Dynamics GP in Ruby

Connect to Microsoft Dynamics GP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Create Informatica Mappings From/To a JDBC Data Source for Dynamics GP

Create Dynamics GP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.