Learn more
 

Ready to get started?

Learn more:

Dynamics GP Connectivity Solutions

In this article

Related articles

Dynamics GP Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live Dynamics GP data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on 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 (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from Dynamics GP Data 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
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
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Dynamics GP
MicroStrategyConnect ServerConnect to Live Dynamics GP Data 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 Data in the Power BI Service
Power PivotConnect ServerAccess Dynamics GP Data in Microsoft Power Pivot
Power QueryConnect ServerAccess Dynamics GP Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from Dynamics GP Data in Qlik Sense Cloud
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
RedashConnect ServerBuild Dynamics GP-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze Dynamics GP Data 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 SpotfireConnect ServerVisualize Dynamics GP Data in TIBCO Spotfire
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 CassandraCData SyncAutomated Continuous Dynamics GP Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Dynamics GP Replication to Apache Kafka
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)
CouchbaseCData SyncAutomated Continuous Dynamics GP Replication to Couchbase
CSVCData SyncAutomated Continuous Dynamics GP Replication to Local Delimited Files
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
Heroku / Salesforce ConnectCData SyncReplicate Dynamics GP for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Dynamics GP in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Dynamics GP Replication to IBM DB2
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 AccessCData SyncAutomated Continuous Dynamics GP Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Dynamics GP Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Dynamics GP
Microsoft Power AutomateConnect ServerBuild Dynamics GP-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Dynamics GP Replication to MongoDB
MySQLCData SyncAutomated Continuous Dynamics GP Replication to MySQL
Oracle Data IntegratorJDBCETL Dynamics GP in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Dynamics GP Replication to Oracle
petlPythonExtract, Transform, and Load Dynamics GP in Python
PostgreSQLCData SyncAutomated Continuous Dynamics GP Replication to PostgreSQL
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 ServerCData SyncAutomated Continuous Dynamics GP Replication to SQL Server
SQL Server Linked ServerConnect ServerConnect to Dynamics GP Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Dynamics GP Replication to SQLite
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 (JDBC)
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
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Dynamics GP
Apache SparkJDBCWork with Dynamics GP in Apache Spark Using SQL
AppSheetConnect ServerCreate Dynamics GP-Connected Business Apps in AppSheet
C++BuilderODBCDataBind Controls to Dynamics GP Data in C++Builder
ColdFusionJDBCQuery Dynamics GP in ColdFusion Using JDBC
ColdFusionODBCQuery Dynamics GP in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Dynamics GP
DelphiODBCDataBind Controls to Dynamics GP Data in Delphi
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 Data 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 Data into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery Dynamics GP Data in Node.js (via Connect Server)
NodeJSODBCQuery Dynamics GP through ODBC in Node.js
PHPConnect ServerAccess Dynamics GP in PHP through Connect Server
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
ReactConnect ServerBuild Dynamic React Apps with Dynamics GP Data
RubyODBCConnect to Dynamics GP in Ruby
RunMyProcessConnect ServerConnect to Dynamics GP Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Dynamics GP in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Dynamics GP in SAPUI5 MVC Apps
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)ODBCBuild 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 WorkbenchConnect ServerQuery Dynamics GP Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery Dynamics GP in MySQL Workbench (ODBC)
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
Nintex Workflow CloudConnect ServerBuild Dynamics GP-Connected Workflows in Nintex
Power AutomateConnect ServerIntegrate Dynamics GP Data 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