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




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 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 Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula 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 FineReport: Feed Dynamics GP into FineReport Google Data Studio: Create Reports from Dynamics GP in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Dynamics GP 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 KNIME: Enable the Dynamics GP JDBC Driver in KNIME LINQPad: Working with Dynamics GP in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Dynamics GP Power BI Online: Visualize Live Dynamics GP in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Dynamics GP MicroStrategy: Use the CData JDBC Driver for Dynamics GP in MicroStrategy OBIEE: Dynamics GP Reporting in OBIEE with the Dynamics GP JDBC Driver Pentaho Report Designer: Integrate Dynamics GP in the Pentaho Report Designer QlikView: Connect to and Query Dynamics GP in QlikView over ODBC R: Analyze Dynamics GP in R RapidMiner : Connect to Dynamics GP in RapidMiner 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 SAP Lumira: Consume Dynamics GP OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Dynamics GP in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Dynamics GP in Sisense Spago BI: Connect to Dynamics GP in SpagoBI Tableau: Visualize Dynamics GP in Tableau Tableau Online: Build Dynamics GP Visualizations in Tableau Online Tableau Server: Publish and Share Dynamics GP Dashboards with Tableau Server TIBCO Spotfire: Operational Reporting on Dynamics GP from Spotfire Server 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 Cassandra: Automated Continuous Dynamics GP Replication to Apache Cassandra AWS Glue: Connect to Dynamics GP in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Dynamics GP to SQL Server Clover ETL: Connect to Dynamics GP in CloverETL CSV: Automated Continuous Dynamics GP Replication to Local Delimited Files IBM DB2: Automated Continuous Dynamics GP Replication to IBM DB2 FoxPro: Work with Dynamics GP in FoxPro Google BigQuery: Automated Continuous Dynamics GP Replication to Google BigQuery Google Cloud SQL: Automated Continuous Dynamics GP Replication to Google Cloud SQL Heroku / Salesforce Connect: Replicate Dynamics GP for Use in Salesforce Connect 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 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 PostgreSQL: Automated Continuous Dynamics GP Replication to PostgreSQL Replicate to CSV: PowerShell Scripting to Replicate Dynamics GP to MySQL Snowflake: Automated Continuous Dynamics GP Replication to Snowflake SQL Server: Automated Continuous Dynamics GP Replication to SQL Server SQLite: Automated Continuous Dynamics GP Replication to SQLite Talend: Connect to Dynamics GP and Transfer Data in Talend

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 Microsoft Azure Logic Apps: Trigger Dynamics GP IFTTT Flows in Azure App Service ColdFusion: Query Dynamics GP in ColdFusion 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 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 NodeJS: Query Dynamics GP from Node.js NodeJS: Query Dynamics GP as a MySQL Database in Node.js PHP: Access Dynamics GP in PHP through the Cloud Hub PHP: Natively Connect to Dynamics GP in PHP PowerShell: Pipe Dynamics GP to CSV in PowerShell 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 SAP UI5: Integrate Real-Time Access to Dynamics GP in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Dynamics GP in a Connection Pool in Tomcat 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: