Dynamics GP Drivers & Connectors
for Data Integration

Connect to Dynamics GP data through easy-to-use, bi-directional drivers. Easily integrate Dynamics GP data with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


Decorative Icon Dynamics GP Logo


Other Microsoft Dynamics Technologies



BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time Dynamics GP data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Dynamics GP data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations



Alteryx Designer: Prepare, Blend, and Analyze Dynamics GP in Alteryx Designer (ODBC) Amazon QuickSight: Build Interactive Dashboards from Dynamics GP Data in Amazon QuickSight Aqua Data Studio: Connect to Dynamics GP in Aqua Data Studio AWS Databricks: Process & Analyze Dynamics GP Data in Databricks (AWS) Birst: Build Visualizations of Dynamics GP in Birst BIRT: Design BIRT Reports on Dynamics GP Clear Analytics: Build Charts with Dynamics GP in Clear Analytics DBxtra: Build Dashboards with Dynamics GP in DBxtra Domo: Create Datasets from Dynamics GP in Domo Workbench Dundas BI: Build Dashboards with Dynamics GP in Dundas BI Excel (on Mac OS): Work with Dynamics GP Data in MS Excel on Mac OS X FineReport: Feed Dynamics GP into FineReport IBM Cognos BI: Create Data Visualizations in Cognos BI with Dynamics GP Infragistics Reveal: Analyze Dynamics GP Data in Infragistics Reval JasperServer: Create Dynamics GP Reports on JasperReports Server Jaspersoft BI Suite: Connect to Dynamics GP in Jaspersoft Studio JReport Designer: Integrate with Dynamics GP in JReport Designer Klipfolio: Create Dynamics GP-Connected Visualizations in Klipfolio KNIME: Enable the Dynamics GP JDBC Driver in KNIME LINQPad: Working with Dynamics GP in LINQPad Microsoft SSAS: Build an OLAP Cube in SSAS from Dynamics GP MicroStrategy: Connect to Live Dynamics GP Data in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for Dynamics GP in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Dynamics GP in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Dynamics GP in MicroStrategy Web OBIEE: Dynamics GP Reporting in OBIEE with the Dynamics GP JDBC Driver pandas: Use pandas to Visualize Dynamics GP in Python Pentaho Report Designer: Integrate Dynamics GP in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Dynamics GP Power BI Service: Visualize Live Dynamics GP Data in the Power BI Service Power Pivot: Access Dynamics GP Data in Microsoft Power Pivot Power Query: Access Dynamics GP Data in Microsoft Power Query QlikView: Connect to and Query Dynamics GP in QlikView over ODBC R: Analyze Dynamics GP in R (JDBC) R: Analyze Dynamics GP in R (ODBC) RapidMiner: Connect to Dynamics GP in RapidMiner Redash: Build Dynamics GP-Connected Dashboards in Redash SAP Analytics Cloud: Analyze Dynamics GP Data in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics GP SAP Crystal Reports: Publish Reports with Dynamics GP in Crystal Reports SAS: Use the CData ODBC Driver for Dynamics GP in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Dynamics GP in SAS JMP Sisense: Visualize Live Dynamics GP in Sisense Spago BI: Connect to Dynamics GP in SpagoBI Tableau: Visualize Dynamics GP in Tableau Desktop Tableau Cloud: Build Dynamics GP Visualizations in Tableau Cloud Tableau Server: Publish Dynamics GP-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Dynamics GP in TIBCO Spotfire through ADO.NET TIBCO Spotfire: Visualize Dynamics GP Data in TIBCO Spotfire TIBCO Spotfire Server: Operational Reporting on Dynamics GP from Spotfire Server Visio: Link Visio Shapes to Dynamics GP

ETL, Replication, & Warehousing



From drivers and adapters that extend your favorite ETL tools with Dynamics GP connectivity to ETL/ELT tools for replication — our Dynamics GP integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Dynamics GP to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations



Amazon Redshift: Automated Continuous Dynamics GP Replication to Amazon Redshift Amazon S3: Automated Continuous Dynamics GP Replication to Amazon S3 Apache Airflow: Bridge Dynamics GP Connectivity with Apache Airflow Apache Camel: Integrate with Dynamics GP using Apache Camel Apache Cassandra: Automated Continuous Dynamics GP Replication to Apache Cassandra Apache Kafka: Automated Continuous Dynamics GP Replication to Apache Kafka Apache NiFi: Bridge Dynamics GP Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with Dynamics GP Data in Apache NiFi Azure Data Lake: Automated Continuous Dynamics GP Replication to Azure Data Lake Azure Synapse: Automated Continuous Dynamics GP Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate Dynamics GP to SQL Server CloverDX: Connect to Dynamics GP in CloverDX (formerly CloverETL) Couchbase: Automated Continuous Dynamics GP Replication to Couchbase CSV: Automated Continuous Dynamics GP Replication to Local Delimited Files Databricks: Automated Continuous Dynamics GP Replication to Databricks FoxPro: Work with Dynamics GP in FoxPro Google AlloyDB: Automated Continuous Dynamics GP Replication to Google AlloyDB Google BigQuery: Automated Continuous Dynamics GP Replication to Google BigQuery Google Cloud SQL: Automated Continuous Dynamics GP Replication to Google Cloud SQL Google Data Fusion: Build Dynamics GP-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate Dynamics GP for Use in Salesforce Connect HULFT Integrate: Connect to Dynamics GP in HULFT Integrate IBM DB2: Automated Continuous Dynamics GP Replication to IBM DB2 Informatica Cloud: Integrate Dynamics GP in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Dynamics GP Jaspersoft ETL: Connect to Dynamics GP in Jaspersoft Studio Microsoft Access: Automated Continuous Dynamics GP Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Dynamics GP Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Dynamics GP Microsoft Power Automate: Build Dynamics GP-Connected Automated Tasks with Power Automate (Desktop) MongoDB: Automated Continuous Dynamics GP Replication to MongoDB MySQL: Automated Continuous Dynamics GP Replication to MySQL Oracle Data Integrator: ETL Dynamics GP in Oracle Data Integrator Oracle Database: Automated Continuous Dynamics GP Replication to Oracle petl: Extract, Transform, and Load Dynamics GP in Python PostgreSQL: Automated Continuous Dynamics GP Replication to PostgreSQL SAP HANA: Automated Continuous Dynamics GP Replication to SAP HANA SingleStore: Automated Continuous Dynamics GP Replication to SingleStore SnapLogic: Integrate Dynamics GP with External Services using SnapLogic Snowflake: Automated Continuous Dynamics GP Replication to Snowflake SQL Server: Automated Continuous Dynamics GP Replication to SQL Server SQL Server Linked Server: Connect to Dynamics GP Data as a SQL Server Linked Server SQLite: Automated Continuous Dynamics GP Replication to SQLite Talend: Connect to Dynamics GP and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Dynamics GP in UiPath Studio Vertica: Automated Continuous Dynamics GP Replication to a Vertica Database

Workflow & Automation Tools



Connect to Dynamics GP from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Dynamics GP data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations



Developer Tools & Technologies



The easiest way to integrate with Dynamics GP from anywhere. Our Dynamics GP drivers offer a data-centric model for Dynamics GP that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations



.NET Charts: DataBind Charts to Dynamics GP .NET QueryBuilder: Rapidly Develop Dynamics GP-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Dynamics GP Apache Spark: Work with Dynamics GP in Apache Spark Using SQL AppSheet: Create Dynamics GP-Connected Business Apps in AppSheet C++Builder: DataBind Controls to Dynamics GP Data in C++Builder ColdFusion: Query Dynamics GP in ColdFusion Using JDBC ColdFusion: Query Dynamics GP in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on Dynamics GP Delphi: DataBind Controls to Dynamics GP Data in Delphi DevExpress: DataBind Dynamics GP to the DevExpress Data Grid EF - Code First: Access Dynamics GP with Entity Framework 6 EF - LINQ: LINQ to Dynamics GP EF - MVC: Build MVC Applications with Connectivity to Dynamics GP Filemaker Pro: Bidirectional Access to Dynamics GP from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to Dynamics GP from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with Dynamics GP on Linux Google Apps Script: Connect to Dynamics GP Data in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Dynamics GP Entities in Java IntelliJ: Connect to Dynamics GP in IntelliJ JBoss: Connect to Dynamics GP from a Connection Pool in JBoss JDBI: Create a Data Access Object for Dynamics GP using JDBI JRuby: Connect to Dynamics GP in JRuby Microsoft Power Apps: Integrate Live Dynamics GP Data into Custom Business Apps Built in Power Apps NodeJS: Query Dynamics GP Data in Node.js (via Connect Server) NodeJS: Query Dynamics GP through ODBC in Node.js PHP: Access Dynamics GP in PHP through the Cloud Hub PHP: Natively Connect to Dynamics GP in PHP PowerBuilder: Connect to Dynamics GP from PowerBuilder PyCharm: Using the CData ODBC Driver for Dynamics GP in PyCharm Python: Connect to Dynamics GP in Python on Linux/UNIX React: Build Dynamic React Apps with Dynamics GP Data Ruby: Connect to Dynamics GP in Ruby RunMyProcess: Connect to Dynamics GP Data in RunMyProcess RunMyProcess DSEC: Connect to Dynamics GP in DigitalSuite Studio through RunMyProcess DSEC SAP UI5: Integrate Real-Time Access to Dynamics GP in SAPUI5 MVC Apps Servoy: Build Dynamics GP-Connected Apps in Servoy Spring Boot: Access Live Dynamics GP Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access Dynamics GP in Python Tomcat: Configure the CData JDBC Driver for Dynamics GP in a Connection Pool in Tomcat Unqork: Create Dynamics GP-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Dynamics GP WebLogic: Connect to Dynamics GP from a Connection Pool in WebLogic


When Only the Best Dynamics GP Drivers Will Do

See what customers have to say about our products and support.



Frequently Asked Dynamics GP Driver Questions

Learn more about Dynamics GP drivers & connectors for data and analytics integration


The Dynamics GP driver acts like a bridge that facilitates communication between various applications and Dynamics GP, allowing the application to read data as if it were a relational database. The Dynamics GP driver abstracts the complexities of Dynamics GP APIs, authentication methods, and data types, making it simple for any application to connect to Dynamics GP data in real-time via standard SQL queries.

Working with a Dynamics GP Driver is different than connecting with Dynamics GP through other means. Dynamics GP API integrations require technical experience from a software developer or IT resources. Additionally, due to the constant evolution of APIs and services, once you build your integration you have to constantly maintain Dynamics GP integration code moving forward.

By comparison, our Dynamics GP Drivers offer codeless access to live Dynamics GP data for both technical and non-technical users alike. Any user can install our drivers and begin working with live Dynamics GP data from any client application. Because our drivers conform to standard data interfaces like ODBC, JDBC, ADO.NET etc. they offer a consistent, maintenance-free interface to Dynamics GP data. We manage all of the complexities of Dynamics GP integration within each driver and deploy updated drivers as systems evolve so your applications continue to run seamlessly.

Many organizations draw attention to their library of connectors. After all, data connectivity is a core capability needed for applications to maximize their business value. However, it is essential to understand exactly what you are getting when evaluating connectivity. Some vendors are happy to offer connectors that implement basic proof-of-concept level connectivity. These connectors may highlight the possibilities of working with Dynamics GP, but often only provide a fraction of capability. Finding real value from these connectors usually requires additional IT or development resources.

Unlike these POC-quality connectors, every CData Dynamics GP driver offers full-featured Dynamics GP data connectivity. The CData Dynamics GP drivers support extensive Dynamics GP integration, providing access to all of the Dynamics GP data and meta-data needed by enterprise integration or analytics projects. Each driver contains a powerful embedded SQL engine that offers applications easy and high-performance access to all Dynamics GP data. In addition, our drivers offer robust authentication and security capabilities, allowing users to connect securely across a wide range of enterprise configurations. Compare drivers and connectors to read more about some of the benefits of CData's driver connectivity.

With our drivers and connectors, every data source is essentially SQL-based. The CData Dynamics GP driver contains a full SQL-92 compliant engine that translates standard SQL queries into Dynamics GP API calls dynamically. Queries are parsed and optimized for each data source, pushing down as much of the request to Dynamics GP as possible. Any logic that can not be pushed to Dynamics GP is handled transparently client-side by the driver/connector engine. Ultimately, this means that Dynamics GP looks and acts exactly like a database to any client application or tool. Users can integrate live Dynamics GP connectivity with ANY software solution that can talk to a standard database.

The Dynamics GP drivers and connectors offer comprehensive access to Dynamics GP data. Our Dynamics GP driver exposes static and dynamic data and metadata, providing universal access to Dynamics GP data for any enterprise analytics or data mangement use. To explore the Dynamics GP driver data model, please review the edition-specific Dynamics GP driver documentation.

Using the CData Dynamics GP drivers and connectors, Dynamics GP can be easily integrated with almost any application. Any software or technology that can integrate with a database or connect with standards-based drivers like ODBC, JDBC, ADO.NET, etc., can use our drivers for live Dynamics GP data connectivity. Explore some of the more popular Dynamics GP data integrations online.

Dynamics GP Analytics is universally supported for BI and data science. In addition, CData provides native client connectors for popular analytics applications like Power BI, Tableau, and Excel that simplify Dynamics GP data integration. Additionally, native Python connectors are widely available for data science and data engineering projects that integrate seamlessly with popular tools like Pandas, SQLAlchemy, Dash, and Petl.

Dynamics GP data integration is typically enabled with CData Sync, a robust any-to-any data pipeline solution that is easy to set up, runs everywhere, and offers comprehensive enterprise-class features for data engineering. CData Sync makes it easy to replicate Dynamics GP data any database or data warehouse, and maintain parity between systems with automated incremental Dynamics GP replication. In addition, our Dynamics GP drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. CData offers native Excel Add-Ins for Dynamics GP integration. These Add-Ins provide live access to Dynamics GP data directly from Microsoft Excel.