Dynamics GP
 

Connect to Dynamics GP data through easy-to-use, bi-directional drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Other Microsoft Dynamics Technologies

Other Microsoft Dynamics Drivers



Connect to Microsoft Dynamics GP Data from Anywhere!

Easily access live Microsoft Dynamics GP data from BI, Analytics, Reporting, ETL, & Custom Apps.







Dynamics GP Integration Guides and Tutorials

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 Amazon QuickSight: Build Interactive Dashboards from Dynamics GP 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 Google Sheets: Access Live Dynamics GP in Google Sheets 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 Looker Studio: Create Reports from Dynamics GP in Looker Studio Metabase: Create Interactive Dynamics GP-Connected Metabase Dashboards Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula Microsoft SSAS: Build an OLAP Cube in SSAS from Dynamics GP MicroStrategy: Connect to Live Dynamics GP 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 in the Power BI Service 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 SAP Analytics Cloud: Analyze Dynamics GP 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 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 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) 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 HULFT Integrate: Connect to Dynamics GP in HULFT Integrate 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 Excel: Transfer Data from Excel to Dynamics GP Microsoft Power Automate: Build Dynamics GP-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL Dynamics GP in Oracle Data Integrator petl: Extract, Transform, and Load Dynamics GP in Python 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 Linked Server: Connect to Dynamics GP as a SQL Server Linked Server 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


MuleSoft Anypoint: Access Dynamics GP in Anypoint Using SQL Power Automate: Integrate Dynamics GP into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to Dynamics GP through SSIS SSIS Import: Import Dynamics GP Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing Dynamics GP Records from SQL Server

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 Apache Spark: Work with Dynamics GP in Apache Spark Using SQL AppSheet: Create Dynamics GP-Connected Business Apps in AppSheet 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 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 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 into Custom Business Apps Built in Power Apps NodeJS: Query Dynamics GP in Node.js (via Connect Server) NodeJS: Query Dynamics GP through ODBC in Node.js 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 Ruby: Connect to Dynamics GP in Ruby RunMyProcess: Connect to Dynamics GP in RunMyProcess RunMyProcess DSEC: Connect to Dynamics GP in DigitalSuite Studio through RunMyProcess DSEC 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.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Using the Dynamics GP Drivers