CData Software - Knowledge Base
Recent Articles
-
Build AI/ML Models with Live MarkLogic Data using Dataiku
Connect MarkLogic Data with Dataiku using the CData JDBC Driver for MarkLogic.
-
Getting Started with the CData Power BI Connector for Guru
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Oracle Service Cloud Data in Talend Cloud Data Management Platform
Connect Oracle Service Cloud Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Service Cloud.
-
Work with CloudConvert Data in FoxPro
Load CloudConvert into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Microsoft Exchange Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Azure SQL Database.
-
DataBind GitHub Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for GitHub with the DevExpress Windows Forms and Web controls to provide GitHub to a chart.
-
Access Pinterest Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pinterest from HeidiSQL.
-
Build NetSuite-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for NetSuite Data and create custom apps in Bubble.
-
Getting Started with the CData JDBC Driver for Postmark
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Postmark.
-
Use Microsoft Copilot Studio to talk to your SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SurveyMonkey for you.
-
Bind Live Spark Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Spark data
-
Publish Crystal Reports on SAP ByDesign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Business ByDesign.
-
How to Access Live JotForm Data in Power Automate Desktop via ODBC
The CData ODBC Driver for JotForm enables you to integrate JotForm into workflows built using Microsoft Power Automate Desktop.
-
How to Connect Flowise AI Agents to Live Facebook Ads Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Facebook Ads without replication.
-
Integrate Live Beeminder Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Beeminder to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Exact Online Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Exact Online in Airbyte.
-
Automated Continuous Zoho Creator Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Oracle.
-
Query Oracle Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle entities in PHP by modeling them as objects.
-
Connect Google Drive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Drive using the CData Python MCP Server.
-
Build Charts with Chargebee Data in Clear Analytics
Create dynamic charts and perform analytics based on Chargebee in Clear Analytics.
-
Integrating Dataiku with Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Monday.com.
-
Replicate Twitter Ads Data to Multiple Databases via the CData Sync CLI
Replicate Twitter Ads to disparate databases with a single configuration.
-
Visualize Beeminder Data in Sisense
Create an ElastiCube in Sisense app with access to Beeminder.
-
How to Connect DBeaver to Outlook via a JDBC Driver
Manage Outlook with visual tools in DBeaver like the query browser.
-
How to create Unbounce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Unbounce in MySQL .
-
How to Access HelloSign Data Using Entity Framework
This article shows how to access HelloSign using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Confluence-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Confluence Data and create custom apps in Bubble.
-
Build OnePageCrm-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live OnePageCrm.
-
Automated Continuous SparkPost Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SparkPost replication to Google BigQuery.
-
How to Query Live Sugar CRM Data in Claude Desktop
Connect to and query live Sugar CRM Data in Claude Desktop using CData MCP Server.
-
Connect to and Query Perigon Data in QlikView over ODBC
Create data visualizations with Perigon in QlikView.
-
How to Access GitLab Data Using Entity Framework
This article shows how to access GitLab using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with OData Services in SnapLogic
Use CData Connect AI to connect to and integrate with live OData in SnapLogic.
-
Connect SparkPost to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SparkPost using the CData Python MCP Server.
-
How to integrate Mailjet with Apache Airflow
Access and process Mailjet in Apache Airflow using the CData JDBC Driver.
-
Automate CSV Data Replication to Couchbase
Use CData Sync to Customize and automate CSV/TSV Files replication to Couchbase.
-
How to Query Okta Data in MySQL Workbench
Execute MySQL queries against live Okta from MySQL Workbench.
-
Integrate Live Azure DevOps Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure DevOps and integrate live Azure DevOps into apps built in Microsoft Power Apps.
-
Analyze Live Google Sheets Data in SAS Viya
Use CData Connect AI to connect to Google Sheets from SAS Viya and deploy self-service analytics using live Google Sheets.
-
How to Connect the Power BI Service to CouchDB: Complete Guide
Connect to the CData Software Power BI Connector for CouchDB from PowerBI.com to provide real-time Apache CouchDB across the organization.
-
Replicate Recurly Data to Multiple Databases via the CData Sync CLI
Replicate Recurly to disparate databases with a single configuration.
-
Explore Geographical Relationships in PivotalTracker Data with Power Map
Create data visualizations with PivotalTracker in Power Map.
-
Integrating Claude Code CLI with Act CRM 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.
-
Import REST Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access REST. In this article, you will use the OData format to import REST into Microsoft Power Query.
-
Excel Spreadsheet Automation on Quaderno Data with the QUERY Formula
Pull data from Quaderno, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Certinia Replication to Snowflake
Use CData Sync for automated, continuous, customizable Certinia replication to Snowflake.
-
Access Adobe Target Data from MySQL in Amazon QuickSight
Connect to Adobe Target and build visualizations of Adobe Target using a MySQL Connection in Amazon QuickSight.
-
How to Create Power BI Visual Reports with Real-Time SendInBlue Data
Use CData Power BI Connectors to visualize SendInBlue in Power BI.
-
Automated Continuous CapsuleCRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to PostgreSQL.
-
Access Live Rootly Data in Coginiti Pro
Connect to and query live Rootly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to ServiceDesk Plus Data in JRuby
Create a simple JRuby app with access to live ServiceDesk Plus.
-
Analyze WordPress Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze WordPress with the CData JDBC Driver for WordPress.
-
Create Reports with Dynamics 365 Business Central Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics 365 Business Central.
-
DataBind Charts to PayPal Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PayPal from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Stream SAP Hybris C4C Data into Apache Kafka Topics
Access and stream SAP Hybris C4C in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Instantly Data with Squirrel SQL client
Connect to Instantly and execute queries in the Squirrel SQL Client.
-
Integrating ChartMogul Data in Talend Cloud Data Management Platform
Connect ChartMogul Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Tableau Connector for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Authorize.Net.
-
Building Dynamic Web Pages with LinkedIn Ads Data Using AngularJS
Create single-page applications with live connectivity to LinkedIn Ads using the CData API Server.
-
Integrating OpenCode Terminal with Freshteam 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.
-
Create Reports from Instagram Data in Looker Studio
Use CData Connect AI to gain access to live Instagram and create custom reports in Looker Studio.
-
Automated Continuous Microsoft Planner Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Google Cloud SQL.
-
Create SAP Hybris C4C Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Hybris C4C from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Gmail Data in JRuby
Create a simple JRuby app with access to live Gmail.
-
Use JayDeBeApi to access Templated Data in Python
Use standard Python scripting and the development environment of your choice to access live Templated.
-
Access Live Google Campaign Manager 360 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Campaign Manager 360 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
A PostgreSQL Interface for Productboard Data (MySQL Remoting via JDBC)
Use the Remoting features of the Productboard JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Google Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Google Ads Data from Azure Data Factory and import live Google Ads.
-
Replicate Multiple Freshteam Accounts
Replicate multiple Freshteam accounts to one or many databases.
-
Visualize Live XML Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live XML Files using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to OpenWeatherMap Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to OpenWeatherMap and work with OpenWeatherMap in your FileMaker application.
-
Using the CData Software ODBC Driver for ADP in PyCharm
Connect to ADP as an ODBC data source in PyCharm using the CData Software ODBC Driver for ADP.
-
Access Live SharePoint Excel Services Data in Coginiti Pro
Connect to and query live SharePoint Excel Services from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData ADO.NET Provider for Optimizely
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipeliner CRM
Create an ODBC connection to Pipeliner CRM in Informatica and browse and transfer Pipeliner CRM.
-
Connect to Azure Synapse in SpagoBI
Create reports featuring live Azure Synapse in SpagoBI Studio. Host Azure Synapse reports on SpagoBI Server.
-
Analyze MailerLite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailerLite from Power Pivot. You will use the Table Import Wizard to load MailerLite. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Multiple Act CRM Accounts via the CData Sync CLI
Replicate multiple Act CRM accounts to one or many databases.
-
Automate Grafana Data Replication to SAP HANA
Use CData Sync to customize and automate Grafana replication to SAP HANA.
-
Getting Started with the CData ODBC Driver for Accelo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Accelo.
-
Create Outreach.io-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Outreach.io Data from Klipfolio and build custom visualizations using live Outreach.io.
-
Create Kintone-Connected Nintex Workflows
Use CData Connect AI to connect to Kintone Data from Nintex Workflow Cloud and build custom workflows using live Kintone.
-
DataBind Controls to Google Calendar Data in Delphi
DataBind to Google Calendar in Delphi with standard data access components and controls.
-
Build AI/ML Models with Live OnePageCrm Data using Dataiku
Connect OnePageCrm Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect to Landbot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Landbot. Leverage the pyodbc module for ODBC in Python.
-
How to Access Live SAP BusinessObjects BI Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP BusinessObjects BI enables you to integrate SAP BusinessObjects BI into workflows built using Microsoft Power Automate Desktop.
-
How to import CloudConvert Data into Apache Solr
Use the CData Software JDBC Driver for CloudConvert in Data Import Handler and create an automated import of CloudConvert to Apache Solr Enterprise Search platform.
-
How to integrate OnePageCrm with Apache Airflow
Access and process OnePageCrm in Apache Airflow using the CData JDBC Driver.
-
Visualize Live LinkedIn Ads Data in the Power BI Service
Use CData Connect AI to connect to live LinkedIn Ads and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Google Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Analytics.
-
How to Connect to & Open Qualaroo Data in Microsoft Excel
This article uses the CData ODBC driver for Qualaroo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Aha! Data in Coginiti Pro
Connect to and query live Aha! from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for SAP in MicroStrategy
Connect to SAP ERP/NetWeaver in MicroStrategy Developer using the CData Software JDBC Driver for SAP.
-
Moving Data from Gmail to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Gmail data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize CSV Data in TIBCO Spotfire through OData
Integrate CSV/TSV Files into dashboards in TIBCO Spotfire.
-
Automate Dotmailer Data Replication to SAP HANA
Use CData Sync to customize and automate Dotmailer replication to SAP HANA.
-
Connect to Real-Time MailerSend Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use MailerSend in Power Apps.
-
Use the CData Software ODBC Driver for SAP BusinessObjects BI in MicroStrategy
Connect to SAP BusinessObjects BI in MicroStrategy Developer using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
Visualize Bullhorn CRM Data in TIBCO Spotfire through ADO.NET
Integrate Bullhorn CRM into dashboards in TIBCO Spotfire.
-
Create Salesforce Pardot-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Pardot Data from Klipfolio and build custom visualizations using live Salesforce Pardot.