Dynamics GP Integration Guides and Tutorials

Ready to get started?

Learn more:

Dynamics GP Connectivity Solutions

In this article

Related articles


A list of guides and tutorials for connecting to and working with live Dynamics GP data.

CData Software connectivity tools provide access to live Dynamics GP data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Dynamics GP data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Dynamics GP in Alteryx Designer
Amazon QuickSightConnect ServerBuild Interactive Dashboards from Dynamics GP in Amazon QuickSight
Aqua Data StudioJDBCConnect to Dynamics GP in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Dynamics GP Data in Databricks (AWS)
BirstJDBCBuild Visualizations of Dynamics GP in Birst
BIRTJDBCDesign BIRT Reports on Dynamics GP
Clear AnalyticsODBCBuild Charts with Dynamics GP in Clear Analytics
DBxtraODBCBuild Dashboards with Dynamics GP in DBxtra
DomoODBCCreate Datasets from Dynamics GP in Domo Workbench
Dundas BIODBCBuild Dashboards with Dynamics GP in Dundas BI
Excel (on Mac OS)ODBCWork with Dynamics GP Data in MS Excel on Mac OS X
FineReportJDBCFeed Dynamics GP into FineReport
Google SheetsConnect ServerAccess Live Dynamics GP in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Dynamics GP
Infragistics RevealConnect ServerAnalyze Dynamics GP Data in Infragistics Reval
JasperServerJDBCCreate Dynamics GP Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Dynamics GP in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Dynamics GP in JReport Designer
KlipfolioConnect ServerCreate Dynamics GP-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Dynamics GP JDBC Driver in KNIME
LINQPadADO.NETWorking with Dynamics GP in LINQPad
Looker StudioConnect ServerCreate Reports from Dynamics GP in Looker Studio
MetabaseConnect ServerCreate Interactive Dynamics GP-Connected Metabase Dashboards
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Dynamics GP
MicroStrategyConnect ServerConnect to Live Dynamics GP in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for Dynamics GP in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Dynamics GP in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Dynamics GP in MicroStrategy Web
OBIEEJDBCDynamics GP Reporting in OBIEE with the Dynamics GP JDBC Driver
pandasPythonUse pandas to Visualize Dynamics GP in Python
Pentaho Report DesignerJDBCIntegrate Dynamics GP in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Dynamics GP
Power BI ServiceConnect ServerVisualize Live Dynamics GP in the Power BI Service
QlikViewODBCConnect to and Query Dynamics GP in QlikView over ODBC
RJDBCAnalyze Dynamics GP in R (JDBC)
RODBCAnalyze Dynamics GP in R (ODBC)
RapidMinerJDBCConnect to Dynamics GP in RapidMiner
SAP Analytics CloudConnect ServerAnalyze Dynamics GP in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics GP
SAP Crystal ReportsJDBCPublish Reports with Dynamics GP in Crystal Reports
SASODBCUse the CData ODBC Driver for Dynamics GP in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Dynamics GP in SAS JMP
SisenseJDBCVisualize Live Dynamics GP in Sisense
Spago BIJDBCConnect to Dynamics GP in SpagoBI
TableauTableauVisualize Dynamics GP in Tableau Desktop
Tableau CloudConnect ServerBuild Dynamics GP Visualizations in Tableau Cloud
Tableau ServerTableauPublish Dynamics GP-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Dynamics GP in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Dynamics GP from Spotfire Server
VisioODBCLink Visio Shapes to Dynamics GP

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Dynamics GP Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Dynamics GP Replication to Amazon S3
Apache AirflowJDBCBridge Dynamics GP Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Dynamics GP using Apache Camel
Apache NiFiJDBCBridge Dynamics GP Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Dynamics GP Data in Apache NiFi
Azure Data LakeCData SyncAutomated Continuous Dynamics GP Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Dynamics GP Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Dynamics GP to SQL Server
CloverDXJDBCConnect to Dynamics GP in CloverDX (formerly CloverETL)
DatabricksCData SyncAutomated Continuous Dynamics GP Replication to Databricks
FoxProODBCWork with Dynamics GP in FoxPro
Google AlloyDBCData SyncAutomated Continuous Dynamics GP Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Dynamics GP Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Dynamics GP Replication to Google Cloud SQL
Google Data FusionJDBCBuild Dynamics GP-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to Dynamics GP in HULFT Integrate
Informatica CloudJDBCIntegrate Dynamics GP in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Dynamics GP
Jaspersoft ETLJDBCConnect to Dynamics GP in Jaspersoft Studio
Microsoft ExcelExcelTransfer Data from Excel to Dynamics GP
Microsoft Power AutomateConnect ServerBuild Dynamics GP-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL Dynamics GP in Oracle Data Integrator
petlPythonExtract, Transform, and Load Dynamics GP in Python
SAP HANACData SyncAutomated Continuous Dynamics GP Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Dynamics GP Replication to SingleStore
SnapLogicJDBCIntegrate Dynamics GP with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous Dynamics GP Replication to Snowflake
SQL Server Linked ServerConnect ServerConnect to Dynamics GP as a SQL Server Linked Server
TalendJDBCConnect to Dynamics GP and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Dynamics GP in UiPath Studio
VerticaCData SyncAutomated Continuous Dynamics GP Replication to a Vertica Database

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate Dynamics GP with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for Dynamics GP
DenodoJDBCCreate A Data Source for Dynamics GP in Denodo Platform
DremioJDBCConnect to Dynamics GP as an External Source in Dremio
MySQL Federated TablesODBCConnect to Dynamics GP as Federated Tables in MySQL
Oracle DatabaseODBCAccess Dynamics GP as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for Dynamics GP
Salesforce ConnectConnect ServerEdit and Search Dynamics GP External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to Dynamics GP as a Linked Server
SQL Server PolyBaseODBCConnect to Dynamics GP as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live Dynamics GP Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Dynamics GP
.NET QueryBuilderODBCRapidly Develop Dynamics GP-Driven Apps with Active Query Builder
Apache SparkJDBCWork with Dynamics GP in Apache Spark Using SQL
AppSheetConnect ServerCreate Dynamics GP-Connected Business Apps in AppSheet
ColdFusionJDBCQuery Dynamics GP in ColdFusion Using JDBC
ColdFusionODBCQuery Dynamics GP in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Dynamics GP
DevExpressADO.NETDataBind Dynamics GP to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Dynamics GP with Entity Framework 6
EF - LINQADO.NETLINQ to Dynamics GP
EF - MVCADO.NETBuild MVC Applications with Connectivity to Dynamics GP
Filemaker ProODBCBidirectional Access to Dynamics GP from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Dynamics GP from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Dynamics GP on Linux
Google Apps ScriptConnect ServerConnect to Dynamics GP in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Dynamics GP Entities in Java
IntelliJJDBCConnect to Dynamics GP in IntelliJ
JBossJDBCConnect to Dynamics GP from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Dynamics GP using JDBI
JRubyJDBCConnect to Dynamics GP in JRuby
Microsoft Power AppsConnect ServerIntegrate Live Dynamics GP into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery Dynamics GP in Node.js (via Connect Server)
NodeJSJDBCQuery Dynamics GP through ODBC in Node.js
PHPODBCNatively Connect to Dynamics GP in PHP
PowerBuilderADO.NETConnect to Dynamics GP from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for Dynamics GP in PyCharm
PythonODBCConnect to Dynamics GP in Python on Linux/UNIX
RubyODBCConnect to Dynamics GP in Ruby
RunMyProcessConnect ServerConnect to Dynamics GP in RunMyProcess
RunMyProcess DSECJDBCConnect to Dynamics GP in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild Dynamics GP-Connected Apps in Servoy
Spring BootJDBCAccess Live Dynamics GP Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Dynamics GP in Python
TomcatJDBCConfigure the CData JDBC Driver for Dynamics GP in a Connection Pool in Tomcat
UnqorkConnect ServerCreate Dynamics GP-Connected Applications in Unqork
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for Dynamics GP
WebLogicJDBCConnect to Dynamics GP from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport Dynamics GP Data into Apache Solr
DB ArtisanJDBCManage Dynamics GP in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to Dynamics GP in DBArtisan
DBeaverJDBCConnect to Dynamics GP in DBeaver
DbVisualizerJDBCConnect to Dynamics GP in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd Dynamics GP to Informatica Enterprise Data Catalog
MySQL WorkbenchODBCQuery Dynamics GP in MySQL Workbench (ODBC)
Power QueryConnect ServerWork with Live Dynamics GP Data in Power Query
QuerySurgeJDBCValidate Dynamics GP Data with QuerySurge
RazorSQLJDBCConnect to Dynamics GP in RazorSQL
SQuirreLJDBCConnect to Dynamics GP in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess Dynamics GP in Anypoint Using SQL
Power AutomateConnect ServerIntegrate Dynamics GP into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to Dynamics GP through SSIS
SSIS ImportSSISImport Dynamics GP Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing Dynamics GP Records from SQL Server

Back to top