CData Software - Knowledge Base
Recent Articles
-
Bridge Pipeliner CRM Connectivity with Apache NiFi
Access and process Pipeliner CRM in Apache NiFi using the CData JDBC Driver.
-
Integrate Azure Table Data into Power Automate Desktop using CData Connect
CData Connect for Azure Table Data enables you to integrate Azure Table Storage into workflows built using Microsoft Power Automate Desktop.
-
Access Live AgileCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AgileCRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Gmail Data Using Entity Framework
This article shows how to access Gmail using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Procore Replication to Snowflake
Use CData Sync for automated, continuous, customizable Procore replication to Snowflake.
-
Import and Visualize Aha! Data in Power View
Create data visualizations based on Aha! in Excel.
-
Moving Data from Avro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Avro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create ChartMogul Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ChartMogul from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a PostgreSQL Interface for Contentful Data using the CData JDBC Driver
Use the Remoting features of the Contentful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Exa Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Exa.
-
Connect to Sage Cloud Accounting Data in JRuby
Create a simple JRuby app with access to live Sage Business Cloud Accounting.
-
Build Bugsnag-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Bugsnag Data in Claude Code to assist with building Bugsnag-powered applications.
-
How to Seamlessly Import Odoo Data into IBM SPSS Modeler
Integrate Odoo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Voice Agents in ElevenLabs with access to Live Google Drive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Drive.
-
Natively Connect to Okta Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Okta. Leverage the native support for ODBC in PHP.
-
Connecting Agentforce with Workday Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Workday for you.
-
Use the CData Software JDBC Driver for DocuSign in MicroStrategy Desktop
Connect to DocuSign in MicroStrategy Desktop using the CData Software JDBC Driver for DocuSign.
-
Access Email Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Email from HeidiSQL.
-
Getting Started with the CData SSIS Components for Impala
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Impala.
-
A PostgreSQL Interface for Webex Data (MySQL Remoting via JDBC)
Use the Remoting features of the Webex JDBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Shippo Data into FineReport
How to set Shippo as a JDBC data source in FineReport.
-
Connect Sage 300 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage 300 using the CData Python MCP Server.
-
Build a Singer.io Tap for NetSuite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live NetSuite data using
-
Query Sage Cloud Accounting Data in DataGrip
Create a Data Source for Sage Cloud Accounting in DataGrip and use SQL to query live Sage Business Cloud Accounting.
-
Integrate Real-Time Access to IBM Cloud Object Storage in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Cloud Object Storage in real time.
-
How to create an RPA flow for Grafana Data in UiPath Studio
Use the Grafana ODBC Driver to create workflows that access real-time Grafana without any coding.
-
Import Oracle Sales Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Sales Data and provide access to live Oracle Sales for custom reports in the Power BI Service.
-
Connect EnterpriseDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your EnterpriseDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect Amazon QuickSight to Greenplum Data
Create a connection to Pivotal GreenPlum in CData Connect AI and insert Pivotal GreenPlum into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Tavily Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Excel Add-In for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua Reporting.
-
Getting Started with the CData ODBC Driver for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Ad Manager.
-
Query Paymo Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Paymo entities in PHP by modeling them as objects.
-
Work with Jumpseller Data in FoxPro
Load Jumpseller into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Gong-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gong.
-
Connect to BigQuery Data in CloverDX (formerly CloverETL)
Transfer Google BigQuery using the visual workflow in the CloverDX data integration tool.
-
Integrate with Ontraport Data in JReport Designer
Create charts and reports based on Ontraport in JReport Designer.
-
How to Connect DBeaver to Billsby via a JDBC Driver
Manage Billsby with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Power BI Connector for Anaplan
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Anaplan.
-
Integrating Kiro CLI with AlloyDB Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Access Live HubSpot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HubSpot into the statistical analysis tools available in SAS JMP. This article shows how to use HubSpot in the Graph Builder and Query Builder.
-
Connect to Yelp Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Yelp and work with Yelp in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on HubSpot within intelligent agent workflows.
-
Analyze SageHR Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SageHR in Microsoft R Open.
-
Automated Continuous Invoiced Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Invoiced replication to PostgreSQL.
-
How to create Visio diagrams from SendGrid Data
Automatically update SendGrid with the changes you make to Visio master shapes.
-
How to Connect to Live Azure Synapse Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure Synapse for you.
-
Build Oracle Eloqua-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Eloqua to explore live Oracle Eloqua Data in Gemini Code Assist to assist with building Oracle Eloqua-powered applications.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshservice
Create Freshservice data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Visualizations of PolarTeamPro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PolarTeamPro in Birst.
-
Process & Analyze Dynamics NAV Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics NAV Data.
-
Replicate ActiveCampaign Data in Heroku for Use in Salesforce Connect
Replicate ActiveCampaign to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Databricks Data in Excel 365 Online (Excel for the web)
Connect to Databricks from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Gumroad Data in MySQL Workbench
Execute MySQL queries against live Gumroad from MySQL Workbench.
-
Create SendGrid Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SendGrid data access from reports, embedded analytics, and more.
-
DataBind Mailgun Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mailgun to a chart.
-
Connect to TigerGraph Data as an External Source in Dremio
Use the CData JDBC Driver to connect to TigerGraph as an External Source in Dremio.
-
Visualize FreeAgent Data in TIBCO Spotfire through ADO.NET
Integrate FreeAgent into dashboards in TIBCO Spotfire.
-
How to Query SAP Netweaver Gateway Data in MySQL Workbench
Execute MySQL queries against live SAP Netweaver Gateway from MySQL Workbench.
-
Access Live Yelp Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Yelp in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Clockify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clockify replication to Google Cloud SQL.
-
Build Microsoft Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Ads to explore live Microsoft Ads Data in GitHub Copilot to assist with building Microsoft Ads-powered applications.
-
How to Query Spark Data in MySQL Workbench
Execute MySQL queries against live Apache Spark SQL from MySQL Workbench.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sendwithus to Power BI dashboards. Simply drag and drop Sendwithus into data visuals on the Power BI canvas.
-
Automated Continuous Smartsheet Replication to Databricks
Use CData Sync for automated, continuous, customizable Smartsheet replication to Databricks.
-
Connect to Procore from a Connection Pool in WebLogic
Use the CData JDBC Driver for Procore to connect to Procore from Web applications running on WebLogic.
-
Connect ZohoInvoice Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoInvoice using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bidirectional Access to AgileCRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AgileCRM in Filemaker Pro for Mac or Windows.
-
Automated Continuous XML Replication to SQL Server
Use CData Sync for automated, continuous, customizable XML replication to SQL Server.
-
Automated Continuous Asana Replication to Vertica
Use CData Sync for automated, continuous, customizable Asana replication to Vertica.
-
Create Dashboards and Visualize Live Instagram Data in Geckoboard
Use CData Connect AI to connect to live Instagram and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect to Live Cloudant Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your IBM Cloudant for you.
-
Create Bitly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bitly from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to & Open SAP Business Warehouse Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Business Warehouse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Semantic Layer Views for Quaderno Data in APOS Live Data Gateway
Use the CData Connector for Quaderno in APOS Live Data Gateway to build Semantic Layer Views for Quaderno.
-
Extract, Transform, and Load Nuclia Data in Informatica PowerCenter
Create a simple Workflow for Nuclia in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Klipfolio in MicroStrategy Desktop
Connect to Klipfolio in MicroStrategy Desktop using the CData Software JDBC Driver for Klipfolio.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy Web
Connect to Pivotal GreenPlum in MicroStrategy Web using the CData Software JDBC Driver for Greenplum.
-
Integrating LangChain with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Elasticsearch within automated workflows.
-
Replicate Front Data in Heroku for Use in Salesforce Connect
Replicate Front to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Marketo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Marketo with the CData JDBC Driver for Marketo.
-
Use the CData ODBC Driver for MessageBird from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MessageBird to connect to MessageBird from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MessageBird in Excel.
-
Moving Data from Pipeline CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pipeline CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Workable Data in RazorSQL
Connect to Workable from wizards and query Workable from the GUI in the RazorSQL database management tool.
-
Extract, Transform, and Load Supabase Data in Informatica PowerCenter
Create a simple Workflow for Supabase in Informatica PowerCenter.
-
Integrate Cline with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Business ByDesign from within your IDE.
-
Build a Singer.io Tap for Opsgenie With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Opsgenie data using
-
Integrate with PolarTeamPro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PolarTeamPro to a JSON file on disk.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway and execute queries in PowerBuilder.
-
Replicate Coinbase Data to Multiple Databases via the CData Sync CLI
Replicate Coinbase to disparate databases with a single configuration.
-
Connect to Superchat in SpagoBI
Create reports featuring live Superchat in SpagoBI Studio. Host Superchat reports on SpagoBI Server.
-
Access Files in Box Accounts with Nested Folders
A step-by-step guide on retrieving data files within sub-folders of a Box account using CData Box Drivers for seamless data access and integration.
-
Use JayDeBeApi to access Kintone Data in Python
Use standard Python scripting and the development environment of your choice to access live Kintone.
-
Create Datasets from Mailjet in Domo Workbench and Build Visualizations of Mailjet Data in Domo
Use the CData Software ODBC Driver for Mailjet to create datasets from Mailjet in Domo Workbench and then build visualizations in the Domo service.
-
Feed SQL Analysis Services Data into FineReport
How to set SQL Analysis Services as a JDBC data source in FineReport.
-
Getting Started with the CData ADO.NET Provider for Deel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create a Data Access Object for Parallel Data using JDBI
A brief overview of creating a SQL Object API for Parallel in JDBI.
-
Moving Data from OpenWeatherMap to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OpenWeatherMap data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SparkPost Data in NetBeans
Connect to SparkPost in NetBeans with the data source configuration wizard.
-
Automated Continuous Amplitude Replication to Vertica
Use CData Sync for automated, continuous, customizable Amplitude replication to Vertica.