CData Software - Knowledge Base



Recent Dynamics GP Articles

How to publish and share Dynamics GP dashboards with Tableau Server

The CData ODBC driver for Dynamics GP enables you integrate Microsoft Dynamics GP into Tableau dashboards.

Create Informatica Mappings From/To an ODBC Data Source for Dynamics GP

Create an ODBC connection to Dynamics GP in Informatica and browse and transfer Microsoft Dynamics GP.

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.

Integrate Dynamics GP in the Pentaho Report Designer

Publish reports based on Microsoft Dynamics GP in the Pentaho BI tool.

How to Visualize Dynamics GP Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Dynamics GP in Python.

DataBind Controls to Dynamics GP in Delphi

DataBind to Microsoft Dynamics GP in Delphi with standard data access components and controls.

Connect to Dynamics GP from Asprova with CData Software ODBC Driver for Dynamics GP

This article shows how to connect faster to Dynamics GP data from Asprova.

How to use SQLAlchemy ORM to access Dynamics GP in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics GP.

Natively Connect to Dynamics GP in PHP

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

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.

Analyze Dynamics GP in Infragistics Reveal

Use the CData Connect Server to create an OData API on top of Microsoft Dynamics GP and visualize live Microsoft Dynamics GP in Ingragistics Reveal.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics GP

Provide connectivity to Microsoft Dynamics GP through an SAP BusinessObjects universe.

Visualize Dynamics GP in TIBCO Spotfire through OData

Integrate Microsoft Dynamics GP into dashboards in TIBCO Spotfire.

Integrating Dynamics GP in Talend Cloud Data Management Platform

Connect Dynamics GP with Talend Cloud Data Management Platform using the [product_name].

Connect to Dynamics GP in DBArtisan

Use wizards in DBArtisan to configure Microsoft Dynamics GP as a data source.

Design BIRT Reports on Dynamics GP

Provide current Microsoft Dynamics GP to your embedded analytics.

Create Data Visualizations in Cognos BI with Dynamics GP

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

Connect to Dynamics GP from a Connection Pool in Jetty

The Dynamics GP JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dynamics GP from Web apps in Jetty.

Create SSAS Tabular Models from Dynamics GP

How to build a SQL Server Analysis Service Tabular Model from Microsoft Dynamics GP using CData drivers.

Manage Dynamics GP in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Dynamics GP.

Visualize Dynamics GP in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Dynamics GP into TIBCO Spotfire.

Connect to and Query Dynamics GP in QlikView over ODBC

Create data visualizations with Microsoft Dynamics GP in QlikView.

Connect to Dynamics GP as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics GP.

Bidirectional Access to Dynamics GP from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics GP in Filemaker Pro for Mac or Windows.

Connect to Dynamics GP in CloverDX (formerly CloverETL)

Transfer Microsoft Dynamics GP using the visual workflow in the CloverDX data integration tool.

Viewing Dynamics GP in RAD Studio Data Explorer

How to view Microsoft Dynamics GP in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics GP.

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.

Import and Visualize Dynamics GP in Power View

Create data visualizations based on Microsoft Dynamics GP in Excel.

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.

Connect to Dynamics GP in NetBeans

Connect to Microsoft Dynamics GP in NetBeans with the data source configuration wizard.

How to update Dynamics GP from Excel

This article explains how to transfer data from Excel to Dynamics GP using the Excel Add-In for Dynamics GP.

Connect to Dynamics GP from PowerBuilder

This article demonstrates how to access Microsoft Dynamics GP from PowerBuilder using the Dynamics GP JDBC Driver.

Work with Dynamics GP in FoxPro

Load Microsoft Dynamics GP into a FoxPro database. This article includes full code and a walk-through of the process.

Access Dynamics GP as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics GP from your Oracle system.

How to Connect to Dynamics GP in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics GP. Leverage the pyodbc module for ODBC in Python.

Connect to and Visualize Live Dynamics GP in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics GP.

Visualize Dynamics GP in Sisense

Create an ElastiCube in Sisense app with access to Microsoft Dynamics GP.

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.

Build a Simple VCL Application for Dynamics GP

How to build a simple VCL Application to view Microsoft Dynamics GP in RAD Studio using the CData ODBC Driver for Dynamics GP.

Connect to Dynamics GP in Ruby

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

Connect to Dynamics GP in Aqua Data Studio

Access Microsoft Dynamics GP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Access Dynamics GP in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Dynamics GP.

Connect to Dynamics GP from a Connection Pool in WebLogic

Use the CData JDBC Driver for Dynamics GP to connect to Microsoft Dynamics GP from Web applications running on WebLogic.

Configure the CData JDBC Driver for Dynamics GP in a Connection Pool in Tomcat

Connect to Microsoft Dynamics GP from a connection pool in Tomcat.

Analyze Dynamics GP with Power Pivot

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

Excel Spreadsheet Automation with the QUERY Formula

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

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 Live Dynamics GP in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics GP.

How to Build Dynamic React Apps with Dynamics GP

Use the CData Connect and React to Build Dynamic Web Apps with Live Dynamics GP .

Connect to Dynamics GP as a Linked Server

Use CData Connect to set up a linked server for Microsoft Dynamics GP.

Use Dash to Build to Web Apps on Dynamics GP

Create Python applications that use pandas and Dash to build Dynamics GP-connected web apps.

Publish Dynamics GP-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics GP.

How to connect to Dynamics GP from Google Apps Script

Use CData Software Connect Server to access Microsoft Dynamics GP in Google Apps Script.

Use the CData ODBC Driver for Dynamics GP from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Dynamics GP to connect to Microsoft Dynamics GP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dynamics GP in Excel.

Provide OData Services of Dynamics GP from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Microsoft Dynamics GP by developing a WCF Service Application.

Connect to Dynamics GP in RapidMiner

Integrate Microsoft Dynamics GP with standard components and data source configuration wizards in RapidMiner Studio.

Publish Dynamics GP-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics GP.

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.

Explore Geographical Relationships in Dynamics GP with Power Map

Create data visualizations with Microsoft Dynamics GP in Power Map.

Extract, Transform, and Load Dynamics GP in Informatica PowerCenter

Create a simple Workflow for Microsoft Dynamics GP in Informatica PowerCenter.

Enable the Dynamics GP JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Microsoft Dynamics GP.

DataBind Wijmo Grid to Dynamics GP

Provide real-time Microsoft Dynamics GP to interactive controls.

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.

Connect to Dynamics GP in RunMyProcess through Connect Server

Use CData Connect Server to create an OData API for Dynamics GP and connect to Microsoft Dynamics GP in Akorbi Digital RunMyProcess.

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.

Connect to Dynamics GP in Google Apps Script

Use the ODBC Driver for Dynamics GP and the SQL Gateway to access Microsoft Dynamics GP from Google Apps Script.

Publish Crystal Reports on Dynamics GP

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Dynamics GP.

Connect to Dynamics GP in JRuby

Create a simple JRuby app with access to live Microsoft Dynamics GP.

How to Connect to & Open Dynamics GP in Microsoft Excel

This article uses the CData ODBC driver for Dynamics GP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Connect to Dynamics GP from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Dynamics GP to connect to Microsoft Dynamics GP and execute queries in PowerBuilder.

Object-Relational Mapping (ORM) with Dynamics GP Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Dynamics GP into a Java-based ORM framework, Hibernate.

Connect to Dynamics GP from a Connection Pool in JBoss

Integrate Microsoft Dynamics GP into Java servlets: Use the Management Console in JBoss to install the Dynamics GP JDBC Driver.

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.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics GP

Provide connectivity to Microsoft Dynamics GP through an SAP BusinessObjects universe.

Using AngularJS to Build Dynamic Web Pages with Dynamics GP

Use the CData Connect Server to create Dynamics GP OData feeds and build single-page applications with live Microsoft Dynamics GP.

Build Dashboards with Dynamics GP in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Dynamics GP in DBxtra.

Create Apps from Dynamics GP in Qlik Sense Cloud

Use the CData Connect Server to create an OData API for Microsoft Dynamics GP and build apps from live Microsoft Dynamics GP in Qlik Sense Cloud.

Connect to Dynamics GP from PowerBuilder

This article demonstrates how to access Microsoft Dynamics GP from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics GP.

Feed Dynamics GP into FineReport

How to set Microsoft Dynamics GP as a JDBC data source in FineReport.

DataBind Controls to Dynamics GP in C++Builder

DataBind to Microsoft Dynamics GP in C++Builder with standard components and controls.

Import Dynamics GP into FileMaker Pro

Create reports that integrate Microsoft Dynamics GP in Filemaker Pro.

How to connect to Dynamics GP in DBVisualizer

Integrate Microsoft Dynamics GP with visual data analysis tools and data connection wizards in DBVisualizer

How to connect to Dynamics GP from IntelliJ

Integrate connectivity to Microsoft Dynamics GP with wizards in IntelliJ.

Connect to Dynamics GP in Jaspersoft Studio

Execute SQL to remote Microsoft Dynamics GP in Jaspersoft Studio.

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.

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.

Natively Connect to Dynamics GP in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dynamics GP. Leverage the native support for ODBC in PHP.

Edit and Search External Dynamics GP Objects in Salesforce Connect

Use CData Connect Server to securely provide OData feeds of Microsoft Dynamics GP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics GP objects that you can access from apps and the dashboard.

Connect to Dynamics GP in SpagoBI

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

How to connect to Dynamics GP with Squirrel SQL client

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

Publish Reports with Dynamics GP in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics GP.

How to Use a Microsoft Access Database to Update Dynamics GP in Real Time

Update Dynamics GP data by creating a linked table in Microsoft Access with the CData Dynamics GP ODBC Driver.

Build Dashboards with Dynamics GP in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft Dynamics GP in Dundas BI.

Query Dynamics GP in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Dynamics GP.

Visualize Dynamics GP in Tableau

The CData ODBC driver for Dynamics GP enables you integrate Microsoft Dynamics GP into Tableau dashboards.

Create Reports with Dynamics GP in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics GP.

Load Dynamics GP to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics GP to a database.

Use the Connect Server to Access Dynamics GP in Microsoft Power Pivot

Use the Connect Server to connect to live Microsoft Dynamics GP in the Power Pivot business intelligence tool.

ETL Dynamics GP in Oracle Data Integrator

This article shows how to transfer Microsoft Dynamics GP into a data warehouse using Oracle Data Integrator.

Working with Dynamics GP in LINQPad

Execute LINQ queries to Microsoft Dynamics GP in LINQPad.

Visualize Dynamics GP in TIBCO Spotfire through ADO.NET

Integrate Microsoft Dynamics GP into dashboards in TIBCO Spotfire.

Build Charts with Dynamics GP in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Dynamics GP in Clear Analytics.

How to connect PolyBase to Dynamics GP

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics GP.

How to Build an ETL App for Dynamics GP in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Dynamics GP in Python with petl.

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.

Analyze Dynamics GP in SAP Analytics Cloud

Use the CData Connect Server to create an OData API on top of Microsoft Dynamics GP and visualize Microsoft Dynamics GP in SAP Analytics Cloud.

How to Connect DBeaver to Dynamics GP via a JDBC Driver

Manage Microsoft Dynamics GP with visual tools in DBeaver like the query browser.

How to create Visio diagrams from Dynamics GP

Automatically update Microsoft Dynamics GP with the changes you make to Visio master shapes.

Visualize Dynamics GP from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics GP.

Create Dynamic Dynamics GP Grids Using the Infragistics XamDataGrid

Learn how you can connect Dynamics GP to Infragistics XamDataGrid to build dynamic grids.

How to create Dynamics GP federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics GP in MySQL .

Connect to Dynamics GP in RazorSQL

Connect to Dynamics GP from wizards and query Microsoft Dynamics GP from the GUI in the RazorSQL database management tool.

Integrate with Dynamics GP in JReport Designer

Create charts and reports based on Microsoft Dynamics GP in JReport Designer.

Import Dynamics GP into Microsoft Power Query

The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dynamics GP. In this article, you will use the OData format to import Microsoft Dynamics GP into Microsoft Power Query.

Using the CData Software ODBC Driver for Dynamics GP in PyCharm

Connect to Dynamics GP as an ODBC data source in PyCharm using the CData Software ODBC Driver 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.

How to publish and share Dynamics GP dashboards with Tableau Server

The CData ODBC driver for Dynamics GP enables you integrate Microsoft Dynamics GP into Tableau dashboards.

Create Informatica Mappings From/To an ODBC Data Source for Dynamics GP

Create an ODBC connection to Dynamics GP in Informatica and browse and transfer Microsoft Dynamics GP.

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.

Integrate Dynamics GP in the Pentaho Report Designer

Publish reports based on Microsoft Dynamics GP in the Pentaho BI tool.

How to Visualize Dynamics GP Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Dynamics GP in Python.

DataBind Controls to Dynamics GP in Delphi

DataBind to Microsoft Dynamics GP in Delphi with standard data access components and controls.

Connect to Dynamics GP from Asprova with CData Software ODBC Driver for Dynamics GP

This article shows how to connect faster to Dynamics GP data from Asprova.

How to use SQLAlchemy ORM to access Dynamics GP in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics GP.

Natively Connect to Dynamics GP in PHP

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

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.

Analyze Dynamics GP in Infragistics Reveal

Use the CData Connect Server to create an OData API on top of Microsoft Dynamics GP and visualize live Microsoft Dynamics GP in Ingragistics Reveal.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics GP

Provide connectivity to Microsoft Dynamics GP through an SAP BusinessObjects universe.

Visualize Dynamics GP in TIBCO Spotfire through OData

Integrate Microsoft Dynamics GP into dashboards in TIBCO Spotfire.

Integrating Dynamics GP in Talend Cloud Data Management Platform

Connect Dynamics GP with Talend Cloud Data Management Platform using the [product_name].

Connect to Dynamics GP in DBArtisan

Use wizards in DBArtisan to configure Microsoft Dynamics GP as a data source.

Design BIRT Reports on Dynamics GP

Provide current Microsoft Dynamics GP to your embedded analytics.

Create Data Visualizations in Cognos BI with Dynamics GP

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

Connect to Dynamics GP from a Connection Pool in Jetty

The Dynamics GP JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dynamics GP from Web apps in Jetty.

Create SSAS Tabular Models from Dynamics GP

How to build a SQL Server Analysis Service Tabular Model from Microsoft Dynamics GP using CData drivers.

Manage Dynamics GP in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Dynamics GP.

Visualize Dynamics GP in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Dynamics GP into TIBCO Spotfire.

Connect to and Query Dynamics GP in QlikView over ODBC

Create data visualizations with Microsoft Dynamics GP in QlikView.

Connect to Dynamics GP as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics GP.

Bidirectional Access to Dynamics GP from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics GP in Filemaker Pro for Mac or Windows.

Connect to Dynamics GP in CloverDX (formerly CloverETL)

Transfer Microsoft Dynamics GP using the visual workflow in the CloverDX data integration tool.

Viewing Dynamics GP in RAD Studio Data Explorer

How to view Microsoft Dynamics GP in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics GP.

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.

Import and Visualize Dynamics GP in Power View

Create data visualizations based on Microsoft Dynamics GP in Excel.

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.

Connect to Dynamics GP in NetBeans

Connect to Microsoft Dynamics GP in NetBeans with the data source configuration wizard.

How to update Dynamics GP from Excel

This article explains how to transfer data from Excel to Dynamics GP using the Excel Add-In for Dynamics GP.

Connect to Dynamics GP from PowerBuilder

This article demonstrates how to access Microsoft Dynamics GP from PowerBuilder using the Dynamics GP JDBC Driver.

Work with Dynamics GP in FoxPro

Load Microsoft Dynamics GP into a FoxPro database. This article includes full code and a walk-through of the process.

Access Dynamics GP as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics GP from your Oracle system.

How to Connect to Dynamics GP in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics GP. Leverage the pyodbc module for ODBC in Python.

Connect to and Visualize Live Dynamics GP in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics GP.

Visualize Dynamics GP in Sisense

Create an ElastiCube in Sisense app with access to Microsoft Dynamics GP.

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.

Build a Simple VCL Application for Dynamics GP

How to build a simple VCL Application to view Microsoft Dynamics GP in RAD Studio using the CData ODBC Driver for Dynamics GP.

Connect to Dynamics GP in Ruby

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

Connect to Dynamics GP in Aqua Data Studio

Access Microsoft Dynamics GP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Access Dynamics GP in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Dynamics GP.

Connect to Dynamics GP from a Connection Pool in WebLogic

Use the CData JDBC Driver for Dynamics GP to connect to Microsoft Dynamics GP from Web applications running on WebLogic.

Configure the CData JDBC Driver for Dynamics GP in a Connection Pool in Tomcat

Connect to Microsoft Dynamics GP from a connection pool in Tomcat.

Analyze Dynamics GP with Power Pivot

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

Excel Spreadsheet Automation with the QUERY Formula

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

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 Live Dynamics GP in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics GP.

How to Build Dynamic React Apps with Dynamics GP

Use the CData Connect and React to Build Dynamic Web Apps with Live Dynamics GP .

Connect to Dynamics GP as a Linked Server

Use CData Connect to set up a linked server for Microsoft Dynamics GP.

Use Dash to Build to Web Apps on Dynamics GP

Create Python applications that use pandas and Dash to build Dynamics GP-connected web apps.

Publish Dynamics GP-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics GP.

How to connect to Dynamics GP from Google Apps Script

Use CData Software Connect Server to access Microsoft Dynamics GP in Google Apps Script.

Use the CData ODBC Driver for Dynamics GP from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Dynamics GP to connect to Microsoft Dynamics GP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dynamics GP in Excel.

Provide OData Services of Dynamics GP from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Microsoft Dynamics GP by developing a WCF Service Application.

Connect to Dynamics GP in RapidMiner

Integrate Microsoft Dynamics GP with standard components and data source configuration wizards in RapidMiner Studio.

Publish Dynamics GP-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics GP.

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.

Explore Geographical Relationships in Dynamics GP with Power Map

Create data visualizations with Microsoft Dynamics GP in Power Map.

Extract, Transform, and Load Dynamics GP in Informatica PowerCenter

Create a simple Workflow for Microsoft Dynamics GP in Informatica PowerCenter.

Enable the Dynamics GP JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Microsoft Dynamics GP.

DataBind Wijmo Grid to Dynamics GP

Provide real-time Microsoft Dynamics GP to interactive controls.

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.

Connect to Dynamics GP in RunMyProcess through Connect Server

Use CData Connect Server to create an OData API for Dynamics GP and connect to Microsoft Dynamics GP in Akorbi Digital RunMyProcess.

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.

Connect to Dynamics GP in Google Apps Script

Use the ODBC Driver for Dynamics GP and the SQL Gateway to access Microsoft Dynamics GP from Google Apps Script.

Publish Crystal Reports on Dynamics GP

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Dynamics GP.

Connect to Dynamics GP in JRuby

Create a simple JRuby app with access to live Microsoft Dynamics GP.

How to Connect to & Open Dynamics GP in Microsoft Excel

This article uses the CData ODBC driver for Dynamics GP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Connect to Dynamics GP from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Dynamics GP to connect to Microsoft Dynamics GP and execute queries in PowerBuilder.

Object-Relational Mapping (ORM) with Dynamics GP Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Dynamics GP into a Java-based ORM framework, Hibernate.

Connect to Dynamics GP from a Connection Pool in JBoss

Integrate Microsoft Dynamics GP into Java servlets: Use the Management Console in JBoss to install the Dynamics GP JDBC Driver.

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.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics GP

Provide connectivity to Microsoft Dynamics GP through an SAP BusinessObjects universe.

Using AngularJS to Build Dynamic Web Pages with Dynamics GP

Use the CData Connect Server to create Dynamics GP OData feeds and build single-page applications with live Microsoft Dynamics GP.

Build Dashboards with Dynamics GP in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Dynamics GP in DBxtra.

Create Apps from Dynamics GP in Qlik Sense Cloud

Use the CData Connect Server to create an OData API for Microsoft Dynamics GP and build apps from live Microsoft Dynamics GP in Qlik Sense Cloud.

Connect to Dynamics GP from PowerBuilder

This article demonstrates how to access Microsoft Dynamics GP from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics GP.

Feed Dynamics GP into FineReport

How to set Microsoft Dynamics GP as a JDBC data source in FineReport.

DataBind Controls to Dynamics GP in C++Builder

DataBind to Microsoft Dynamics GP in C++Builder with standard components and controls.

Import Dynamics GP into FileMaker Pro

Create reports that integrate Microsoft Dynamics GP in Filemaker Pro.

How to connect to Dynamics GP in DBVisualizer

Integrate Microsoft Dynamics GP with visual data analysis tools and data connection wizards in DBVisualizer

How to connect to Dynamics GP from IntelliJ

Integrate connectivity to Microsoft Dynamics GP with wizards in IntelliJ.

Connect to Dynamics GP in Jaspersoft Studio

Execute SQL to remote Microsoft Dynamics GP in Jaspersoft Studio.

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.

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.

Natively Connect to Dynamics GP in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dynamics GP. Leverage the native support for ODBC in PHP.

Edit and Search External Dynamics GP Objects in Salesforce Connect

Use CData Connect Server to securely provide OData feeds of Microsoft Dynamics GP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics GP objects that you can access from apps and the dashboard.

Connect to Dynamics GP in SpagoBI

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

How to connect to Dynamics GP with Squirrel SQL client

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

Publish Reports with Dynamics GP in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics GP.

How to Use a Microsoft Access Database to Update Dynamics GP in Real Time

Update Dynamics GP data by creating a linked table in Microsoft Access with the CData Dynamics GP ODBC Driver.

Build Dashboards with Dynamics GP in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft Dynamics GP in Dundas BI.

Query Dynamics GP in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Dynamics GP.

Visualize Dynamics GP in Tableau

The CData ODBC driver for Dynamics GP enables you integrate Microsoft Dynamics GP into Tableau dashboards.

Create Reports with Dynamics GP in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics GP.

Load Dynamics GP to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics GP to a database.

Use the Connect Server to Access Dynamics GP in Microsoft Power Pivot

Use the Connect Server to connect to live Microsoft Dynamics GP in the Power Pivot business intelligence tool.

ETL Dynamics GP in Oracle Data Integrator

This article shows how to transfer Microsoft Dynamics GP into a data warehouse using Oracle Data Integrator.

Working with Dynamics GP in LINQPad

Execute LINQ queries to Microsoft Dynamics GP in LINQPad.

Visualize Dynamics GP in TIBCO Spotfire through ADO.NET

Integrate Microsoft Dynamics GP into dashboards in TIBCO Spotfire.

Build Charts with Dynamics GP in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Dynamics GP in Clear Analytics.

How to connect PolyBase to Dynamics GP

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics GP.

How to Build an ETL App for Dynamics GP in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Dynamics GP in Python with petl.

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.

Analyze Dynamics GP in SAP Analytics Cloud

Use the CData Connect Server to create an OData API on top of Microsoft Dynamics GP and visualize Microsoft Dynamics GP in SAP Analytics Cloud.

How to Connect DBeaver to Dynamics GP via a JDBC Driver

Manage Microsoft Dynamics GP with visual tools in DBeaver like the query browser.

How to create Visio diagrams from Dynamics GP

Automatically update Microsoft Dynamics GP with the changes you make to Visio master shapes.

Visualize Dynamics GP from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics GP.

Create Dynamic Dynamics GP Grids Using the Infragistics XamDataGrid

Learn how you can connect Dynamics GP to Infragistics XamDataGrid to build dynamic grids.

How to create Dynamics GP federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics GP in MySQL .

Connect to Dynamics GP in RazorSQL

Connect to Dynamics GP from wizards and query Microsoft Dynamics GP from the GUI in the RazorSQL database management tool.