CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from ConvertKit Data
How to build a SQL Server Analysis Service Tabular Model from ConvertKit using CData drivers.
-
Automated Continuous AlloyDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AlloyDB replication to Apache Kafka.
-
Migrating data from SpaceX to Snowflake using CData SSIS Components.
Easily push SpaceX to Snowflake using the CData SSIS Tasks for SpaceX and Snowflake.
-
DataBind Controls to GetResponse Data in Delphi
DataBind to GetResponse in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Power BI XMLA in Excel.
-
Connect and Query Live SQL Server Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft SQL Server into Databricks
-
How to Import Data from Amazon DynamoDB into Google Sheets
Import Amazon DynamoDB into a Google spreadsheet that is automatically refreshed.
-
Analyze SAS Data Sets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS Data Sets and visualize live SAS Data Sets in Infragistics Reveal.
-
Create SSAS Tabular Models from FreeAgent Data
How to build a SQL Server Analysis Service Tabular Model from FreeAgent using CData drivers.
-
Using the CData Software ODBC Driver for Mistral AI in PyCharm
Connect to Mistral AI as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mistral AI.
-
How to Easily Query FormSite Data in OpenOffice Base
Connect to FormSite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous OnePageCrm Replication to Amazon S3
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Amazon S3.
-
Automated Continuous Google Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Directory replication to Google BigQuery.
-
Build Vault CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in GitHub Copilot to assist with building Vault CRM-powered applications.
-
Connect to Freshservice in SpagoBI
Create reports featuring live Freshservice in SpagoBI Studio. Host Freshservice reports on SpagoBI Server.
-
Visualize ClickTime Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ClickTime into TIBCO Spotfire.
-
Connect to Omnisend Data in HULFT Integrate
Connect to Omnisend as a JDBC data source in HULFT Integrate
-
How to Query Live Neo4J Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Neo4J data in natural language using Python.
-
Integrating Codex CLI with Typeform 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.
-
How to connect and process Sybase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sybase.
-
How to create Presto federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Presto in MySQL .
-
Extract, Transform, and Load Marketo Data in Informatica PowerCenter
Create a simple Workflow for Marketo in Informatica PowerCenter.
-
How to create Visio diagrams from Azure Synapse Data
Automatically update Azure Synapse with the changes you make to Visio master shapes.
-
Connect to WordPress Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Wordpress and the Script function in FileMaker Pro to connect to WordPress and work with WordPress in your FileMaker application.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy Web
Connect to Azure Data Lake Storage in MicroStrategy Web using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Analyze Teamgate Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teamgate with the CData JDBC Driver for Teamgate.
-
Object-Relational Mapping (ORM) with Microsoft Teams 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 Microsoft Teams into a Java-based ORM framework, Hibernate.
-
How to Connect Flowise AI Agents to Live Square 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 Square without replication.
-
Use the CData API Server to Access Google Sheets Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Sheets in the Power Pivot business intelligence tool.
-
Connect to Sugar CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sugar in FileMaker Pro to connect to Sugar CRM and work with Sugar CRM in your FileMaker applications.
-
Automated Continuous Gorgias Replication to MySQL
Use CData Sync for automated, continuous, customizable Gorgias replication to MySQL.
-
Integrate Theia IDE with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Codat Data in DBArtisan
Use wizards in DBArtisan to configure Codat as a data source.
-
Bidirectional Access to Freshdesk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshdesk in Filemaker Pro for Mac or Windows.
-
Integrating Claude Code with Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Snapchat Ads within assisted coding and automated development workflows.
-
How to Work with xBase Data in ETL Validator JDBC
Connect to xBase from ETL Validator jobs using the CData Software JDBC Driver.
-
Moving Data from Workday to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Workday data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software ODBC Driver for Stack Exchange in SAS for Real-Time Reporting and Analytics
Connect to real-time Stack Exchange in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Stack Exchange.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce without replication.
-
How to Access Epicor Kinetic Data Using Entity Framework
This article shows how to access Epicor Kinetic using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Freshdesk-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Freshdesk to explore live Freshdesk Data in Claude Code to assist with building Freshdesk-powered applications.
-
Access Live Square Data in Excel 365 Online (Excel for the web)
Connect to Square from Excel 365 Online (Excel for the web) with CData Connect AI.
-
ETL Oracle Sales in Oracle Data Integrator
This article shows how to transfer Oracle Sales into a data warehouse using Oracle Data Integrator.
-
Access Live Twilio Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Twilio from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to work with SurveyMonkey Data in Apache Spark using SQL
Access and process SurveyMonkey Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to RSS Feeds from a Connection Pool in Jetty
The RSS JDBC Driver supports connection pooling: This article shows how to connect faster to RSS Feeds from Web apps in Jetty.
-
Build Dashboards with HDFS Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache HDFS in DBxtra.
-
Connect to Humanity Data from PowerBuilder via JDBC
This article demonstrates how to access Humanity from PowerBuilder using the Humanity JDBC Driver.
-
Integrating Antigravity CLI with iContact via CData CLI
Connect iContact to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to update REST from Excel
This article explains how to transfer data from Excel to REST using the Excel Add-In for REST.
-
How to Access Office 365 Data Using Entity Framework
This article shows how to access Microsoft Office 365 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Crystal Reports on Gong Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gong.
-
Integrate with Onfleet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Onfleet to a JSON file on disk.
-
Query Certinia Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Certinia entities in PHP by modeling them as objects.
-
Connect to Splunk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Splunk and the Script function in FileMaker Pro to connect to Splunk and work with Splunk in your FileMaker application.
-
A PostgreSQL Interface for PivotalTracker Data using the CData ODBC Driver
Use the SQL Gateway and PivotalTracker ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Singer.io Tap for Spotify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Spotify data using
-
Build Apps with Live ActiveCampaign in Adalo using CData Connect AI
Use CData Connect AI to integrate live ActiveCampaign into the Adalo platform and build custom mobile and web applications with real-time ActiveCampaign.
-
How to connect to Phoenix Data from IntelliJ
Integrate connectivity to Apache Phoenix with wizards in IntelliJ.
-
Automated Continuous DB2 for i Replication to Oracle
Use CData Sync for automated, continuous, customizable DB2 for i replication to Oracle.
-
Design BIRT Reports on Chargebee Data
Provide current Chargebee to your embedded analytics.
-
Visualize Live Google Ad Manager Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Ad Manager.
-
Connect to Live CockroachDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to CockroachDB in CData Connect AI and connect to your CockroachDB from PostgreSQL.
-
Access Live SAP Fieldglass Data in Coginiti Pro
Connect to and query live SAP Fieldglass from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Humanity in MicroStrategy Desktop
Connect to Humanity in MicroStrategy Desktop using the CData Software ODBC Driver for Humanity.
-
Bidirectional Access to Webex Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Webex in Filemaker Pro for Mac or Windows.
-
ETL Zoho Books in Oracle Data Integrator
This article shows how to transfer Zoho Books into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Yelp
Provide connectivity to Yelp through an SAP BusinessObjects universe.
-
Connect and Visualize Live Zoom Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoom into the Databricks platform and create visualization dashboards with real-time Zoom.
-
Working with Missive Data in LINQPad
Execute LINQ queries to Missive in LINQPad.
-
Use the CData ODBC Driver for Adobe Analytics in Microsoft Power Query
You can use the CData Adobe Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Analytics into Microsoft Power Query.
-
How to Seamlessly Import CouchDB Data into IBM SPSS Modeler
Integrate CouchDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Timely Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Timely into the statistical analysis tools available in SAS JMP. This article shows how to use Timely in the Graph Builder and Query Builder.
-
Access Live Salesforce Pardot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Pardot into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Pardot in the Graph Builder and Query Builder.
-
Automate Lakebase Data Replication to Couchbase
Use CData Sync to Customize and automate Lakebase replication to Couchbase.
-
How to Import Data from Sage 300 into Google Sheets
Import Sage 300 into a Google spreadsheet that is automatically refreshed.
-
Create Power BI Reports on Real-Time Close Data
Use the CData ODBC Driver for Close to visualize Close in Power BI Desktop.
-
Connect HDFS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HDFS with IBM WebSphere for seamless data integration and connectivity.
-
How to Use a Microsoft Access Database to Update XML Data in Real Time
Update XML data by creating a linked table in Microsoft Access with the CData XML ODBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Yelp
Provide connectivity to Yelp through an SAP BusinessObjects universe.
-
How to connect SharePoint with ShipStation Data through external lists
Provide ShipStation to SharePoint users as an external list.
-
Access Live Bannerbear Data in Coginiti Pro
Connect to and query live Bannerbear from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automate Adobe Analytics Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Analytics replication to Couchbase.
-
Model Paylocity Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Paylocity, enabling the direct import of real-time Paylocity.
-
Integrate PivotalTracker Data in Pentaho Data Integration
Build ETL pipelines based on PivotalTracker in the Pentaho Data Integration tool.
-
Visualize Onfleet Data in TIBCO Spotfire through ADO.NET
Integrate Onfleet into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Omnisend
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Omnisend.
-
Automated Continuous Pipedrive Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipedrive replication to Oracle.
-
Build a PostgreSQL Interface for Invoiced Data using the CData JDBC Driver
Use the Remoting features of the Invoiced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Redis Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Redis Data and connect to Redis in Akorbi Digital RunMyProcess.
-
Automated Continuous Ontraport Replication to SQLite
Use CData Sync for automated, continuous, customizable Ontraport replication to SQLite.
-
Integrating Antigravity CLI with Auth0 via CData CLI
Connect Auth0 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to GitLab Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for GitLab Data and connect to GitLab in Akorbi Digital RunMyProcess.
-
Build AI Agents with Phoenix Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apache Phoenix through CData Connect AI.
-
How to connect SharePoint with Cassandra Data through external lists
Provide Apache Cassandra to SharePoint users as an external list.
-
Getting Started with the CData Python Connector for Pipedrive
Learn to install and license the CData Python Connector
-
Build Charts with Invoiced Data in Clear Analytics
Create dynamic charts and perform analytics based on Invoiced in Clear Analytics.
-
Visualize Live CampaignMonitor Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CampaignMonitor using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to xBase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for xBase to connect to xBase and execute queries in PowerBuilder.
-
Connect to Slack Data in RazorSQL
Connect to Slack from wizards and query Slack from the GUI in the RazorSQL database management tool.