CData Software - Knowledge Base
Recent Articles
-
Connect to Autopilot Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Autopilot in the Denodo Virtual DataPort Administrator.
-
Working with Invoiced Data in LINQPad
Execute LINQ queries to Invoiced in LINQPad.
-
Connect to Google Calendar Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Calendar in the Denodo Virtual DataPort Administrator.
-
Access Live MySQL Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MySQL through MCP integration.
-
Natively Connect to Webflow Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Webflow. Leverage the native support for ODBC in PHP.
-
Integrate Google Directory with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Directory with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Directory.
-
Connect to Aircall Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Aircall in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Klaviyo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Klaviyo replication to Azure SQL Database.
-
Automated Continuous Couchbase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Couchbase replication to Google BigQuery.
-
Build Charts with Sybase IQ Data in Clear Analytics
Create dynamic charts and perform analytics based on Sybase IQ in Clear Analytics.
-
Access Live Zoho Inventory Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Zoho Inventory through MCP integration.
-
Edit and Search Google Search External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Search to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Search objects that you can access from apps and the dashboard.
-
Connect to Cloudflare Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cloudflare and the SQL Gateway to access Cloudflare from Google Apps Script.
-
Create Informatica Mappings From/To an ODBC Data Source for AdRoll
Create an ODBC connection to AdRoll in Informatica and browse and transfer AdRoll.
-
Connect to AdRoll Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AdRoll.
-
Connect Front to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Front using the CData Python MCP Server.
-
Connect to LeadDesk Data in CloverDX (formerly CloverETL)
Transfer LeadDesk using the visual workflow in the CloverDX data integration tool.
-
Connect to Zendesk Data from a Connection Pool in JBoss
Integrate Zendesk into Java servlets: Use the Management Console in JBoss to install the Zendesk JDBC Driver.
-
DataBind Harvest Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Harvest to a chart.
-
Work with Marketo Data in FoxPro
Load Marketo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating GitHub Copilot CLI with MailChimp 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 OData Services with the Salesforce Data Provider
This article shows how to publish an OData feed of Saleforce data by creating a WCF Service Application. This article uses the ADO.NET Provider for Salesforce, but the same steps will work for any of the CData ADO.NET Providers.
-
Connect Planio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Planio with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Live Superchat Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Superchat using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Cvent Data in DBVisualizer
Integrate Cvent with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Microsoft OneDrive Data in NetBeans
Connect to Microsoft OneDrive in NetBeans with the data source configuration wizard.
-
How to connect to PayPal Data in DBVisualizer
Integrate PayPal with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Google Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Ads data access from reports, embedded analytics, and more.
-
How to Connect to Live JSON Services 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 JSON for you.
-
Build Sybase IQ Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sybase IQ and build visualizations in Tableau.
-
How to Build an ETL App for Paylocity Data in Python with CData Connect AI
Build ETL pipelines that read and write live Paylocity in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Pipedrive Replication to MySQL
Use CData Sync for automated, continuous, customizable Pipedrive replication to MySQL.
-
How to Access Live Okta Data in Visual Studio Code via Cline
Run CData MCP Server for Okta on Windows Subsytem for Linux (WSL) and connect to live Okta from the Cline extension in Visual Studio Code.
-
Replicate Multiple Eventbrite Accounts via the CData Sync CLI
Replicate multiple Eventbrite accounts to one or many databases.
-
How to Access Kafka Data Using Entity Framework
This article shows how to access Apache Kafka using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Viewing Drift Data in RAD Studio Data Explorer
How to view Drift in RAD Studio Data Explorer using the CData ODBC Driver for Drift.
-
Access Live Salesloft Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Salesloft data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to & Open REST Data in Microsoft Excel
This article uses the CData ODBC driver for REST to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to work with Suadeo Data in Apache Spark using SQL
Access and process Suadeo Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect to Moosend Data from Spring Boot
Connect to Moosend in a Spring Boot Application using the CData API Driver for JDBC
-
Query Yelp Data in ColdFusion
Write standard ColdFusion data access code to connect to Yelp.
-
Migrating data from Bullhorn CRM to Databricks using CData SSIS Components.
Easily push Bullhorn CRM to Databricks using the CData SSIS Tasks for Bullhorn CRM and Databricks.
-
Migrating data from Figshare to Google BigQuery using CData SSIS Components.
Easily push Figshare to Google BigQuery using the CData SSIS Tasks for Figshare and Google BigQuery.
-
How to Query Live Nuclia Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Nuclia data in natural language using Python.
-
Create Datasets from EmailOctopus in Domo Workbench and Build Visualizations of EmailOctopus Data in Domo
Use the CData Software ODBC Driver for EmailOctopus to create datasets from EmailOctopus in Domo Workbench and then build visualizations in the Domo service.
-
How to Access BigQuery Data Using Entity Framework
This article shows how to access Google BigQuery using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Live SAP BusinessObjects BI Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP BusinessObjects BI from the MuleSoft Anypoint Platform to integrate live SAP BusinessObjects BI into custom reports and dashboards.
-
Integrating Cursor CLI with ServiceNow 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.
-
Connect to and Query SAP BusinessObjects BI Data in QlikView over ODBC
Create data visualizations with SAP BusinessObjects BI in QlikView.
-
Connect to Workday Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Workday as an External Source in Dremio.
-
Integrate Goose with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP SuccessFactors LMS from within the local AI agent.
-
How to Visualize Microsoft Planner Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Microsoft Planner in Python.
-
Consume Snowflake OData Feeds in PowerBuilder
This article demonstrates how to consume Snowflake as OData feeds from PowerBuilder using the API Server.
-
Connect to Google Translate Data in DBeaver
Use the CData ODBC Driver to connect to Google Translate in DBeaver.
-
Connect to Flowlu from a Connection Pool in WebLogic
Use the CData JDBC Driver for Flowlu to connect to Flowlu from Web applications running on WebLogic.
-
DataBind Planio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Planio to a chart.
-
Use Biml to Build SSIS Tasks to Replicate Planio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Planio to SQL Server.
-
Operational Reporting on Microsoft Planner Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Planner.
-
Integrate Cursor with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Dropbox from within the editor.
-
Publish Elasticsearch-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Elasticsearch.
-
Process & Analyze Helpscout Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Helpscout Data.
-
How to Connect to Live Dynamics CRM Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Dynamics CRM without replication.
-
Create Microsoft Exchange-Connected Business Apps in AppSheet
Connect to Microsoft Exchange Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Exchange.
-
Analyze Microsoft Teams Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Teams in Microsoft R Open.
-
Connecting Moonlit Workflow with Salesforce Pardot Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Salesforce Pardot in real time.
-
Getting Started with the CData ADO.NET Provider for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connecting Moonlit Workflow with JSON Services via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your JSON in real time.
-
Automated Continuous Yelp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Yelp replication to Apache Cassandra.
-
Access Live Teamwork Data in AWS Lambda
Connect to live Teamwork in AWS Lambda using the CData JDBC Driver.
-
Integrate SurveyMonkey Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SurveyMonkey and integrate live SurveyMonkey into your Power Automate tasks.
-
Connect RabbitMQ to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect RabbitMQ with IBM WebSphere for seamless data integration and connectivity.
-
Integrating SAP Fieldglass Data in Talend Cloud Data Management Platform
Connect SAP Fieldglass Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Fieldglass.
-
How to Visualize Qualaroo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Qualaroo in Python.
-
Integrate JDBC-ODBC Bridge Data in Pentaho Data Integration
Build ETL pipelines based on JDBC-ODBC Bridge in the Pentaho Data Integration tool.
-
Connect to and Query Salesloft Data in QlikView over ODBC
Create data visualizations with Salesloft in QlikView.
-
Write a Simple Go Application to work with Wrike Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Wrike.
-
Connect and Visualize Live Power BI XMLA Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Power BI XMLA into the Databricks platform and create visualization dashboards with real-time Power BI XMLA.
-
Connect to MarkLogic Data in CloverDX (formerly CloverETL)
Transfer MarkLogic using the visual workflow in the CloverDX data integration tool.
-
Integrate with SAP ByDesign Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Business ByDesign in SnapLogic.
-
Access Live Twitter Ads Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Twitter Ads through MCP integration.
-
Connect to Amazon Athena Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon Athena from HeidiSQL.
-
Build AI/ML Models with Live GitLab Data using Dataiku
Connect GitLab Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect to Azure Table Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Table Storage. Leverage the pyodbc module for ODBC in Python.
-
Create NetSuite-Connected Business Apps in AppSheet
Connect to NetSuite Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to NetSuite CRM & ERP.
-
Connect to Real-Time Stack Exchange Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Stack Exchange in Power Apps.
-
Connect to Freshdesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshdesk and the SQL Gateway to access Freshdesk from Google Apps Script.
-
Access Harvest Data from MySQL in Amazon QuickSight
Connect to Harvest and build visualizations of Harvest using a MySQL Connection in Amazon QuickSight.
-
Connect to Live GitHub Data in PostGresSQL Interface through CData Connect AI
Create a live connection to GitHub in CData Connect AI and connect to your GitHub from PostgreSQL.
-
Visualize Live Drip Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Drip using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
ETL Azure Analysis Services in Oracle Data Integrator
This article shows how to transfer Azure Analysis Services into a data warehouse using Oracle Data Integrator.
-
Integrate Live BigQuery Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google BigQuery and integrate live Google BigQuery into apps built in Microsoft Power Apps.
-
Automate Drip Data Replication to Azure Synapse
Use CData Sync to customize and automate Drip replication to Azure Synapse.
-
Migrating data from Jira Assets to Google BigQuery using CData SSIS Components.
Easily push Jira Assets to Google BigQuery using the CData SSIS Tasks for Jira Assets and Google BigQuery.
-
How to Connect DBeaver to Omnisend via a JDBC Driver
Manage Omnisend with visual tools in DBeaver like the query browser.
-
How to Query Jumpseller Data in MySQL Workbench
Execute MySQL queries against live Jumpseller from MySQL Workbench.
-
Prepare, Blend, and Analyze BigQuery Data in Alteryx Designer (Connect AI)
Build workflows to access live Google BigQuery for self-service data analytics.
-
Use CData Connect AI to Access Google Ad Manager Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Ad Manager in the Power Pivot business intelligence tool.
-
Object-Relational Mapping (ORM) with Sybase Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Sybase into a Java-based ORM framework, Hibernate.
-
Add Adobe Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Adobe Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Neo4J Data in DBArtisan
Use wizards in DBArtisan to configure Neo4J as a data source.