CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for Zoho Creator
Learn to install and license the CData Python Connector and configure a connection to live Zoho Creator data.
-
How to Connect to Live Campaigner 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 Campaigner data for you.
-
Automated Continuous Email Replication to SQLite
Use CData Sync for automated, continuous, customizable Email replication to SQLite.
-
Connect and Query Live ADP Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ADP data into Databricks and enable direct, live querying and analysis without replication.
-
Access ConstantContact Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ConstantContact data.
-
Connect to SAP Ariba Source Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Ariba Source data.
-
Model, Search, and Visualize Live Epicor Kinetic Data in ThoughtSpot
Use CData Connect AI to connect to live Epicor Kinetic data for modeling, searching, and visualizing.
-
Connect to Cohere from Asprova with CData Software ODBC Driver for Cohere
This article shows how to connect faster to Cohere data from Asprova.
-
Integrating Codex with Bannerbear 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.
-
Integrate with Typeform Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Typeform data in SnapLogic.
-
How to Query Live Access Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Access data data in natural language using Python.
-
Publish Reports with Google Spanner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Spanner data.
-
Analyze VWO Data in Looker
Use CData Connect AI to connect to VWO Data from Looker and build custom apps using live VWO data.
-
How to Use a Microsoft Access Database to Update Elasticsearch Data in Real Time
Update Elasticsearch data by creating a linked table in Microsoft Access with the CData Elasticsearch ODBC Driver.
-
Deploy the ADO.NET Provider for iContact on an SSRS Report Server
Connect to iContact data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Model Salesforce Data 360 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Data 360, enabling the direct import of real-time Salesforce Data 360 data.
-
Integrating Dataiku with Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Adobe Analytics data.
-
Connect to and Query Splunk Data in QlikView over ODBC
Create data visualizations with Splunk data in QlikView.
-
Connect to Authorize.Net Data from a Connection Pool in JBoss
Integrate Authorize.Net data into Java servlets: Use the Management Console in JBoss to install the Authorize.Net JDBC Driver.
-
Access Webflow Data from MySQL in Amazon QuickSight
Connect to Webflow and build visualizations of Webflow data using a MySQL Connection in Amazon QuickSight.
-
Query MessageBird Data as a MySQL Database in Node.js
Execute MySQL queries against MessageBird data from Node.js.
-
How to create an RPA flow for LightSpeedRetail Data in UiPath Studio
Use the LightSpeedRetail ODBC Driver to create workflows that access real-time LightSpeedRetail data without any coding.
-
Analyze Asana Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Asana data with the CData JDBC Driver for Asana.
-
How to Connect to Auth0 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Auth0 data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Real-Time PolarTeamPro Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PolarTeamPro data in Power Apps.
-
How to Easily Query ClickTime Data in OpenOffice Base
Connect to ClickTime data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Getting Started with the CData Python Connector for Spark
Learn to install and license the CData Python Connector and configure a connection to live Spark data.
-
Create SSAS Tabular Models from IBM Informix Data
How to build a SQL Server Analysis Service Tabular Model from IBM Informix data using CData drivers.
-
Automated Continuous Dynamics 365 Business Central Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to IBM DB2.
-
Migrating data from Gong to Snowflake using CData SSIS Components.
Easily push Gong data to Snowflake using the CData SSIS Tasks for Gong and Snowflake.
-
How to Work with Blackbaud FE NXT Data in ETL Validator JDBC
Connect to Blackbaud FE NXT from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Access Wave Financial Data Using Entity Framework
This article shows how to access Wave Financial data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate JotForm with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JotForm with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JotForm data.
-
Migrating data from Recurly to Databricks using CData SSIS Components.
Easily push Recurly data to Databricks using the CData SSIS Tasks for Recurly and Databricks.
-
Use Agno to Talk to Your Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Moosend data for you.
-
Build Dashboards with CircleCI Data in Dundas BI
Create dynamic dashboards and perform analytics based on CircleCI data in Dundas BI.
-
Build Automated Workflows with Live Stripe Data in Workato
Use CData Connect AI to connect to live Stripe data and build automated workflows in Workato.
-
Create Splunk-Connected Applications in Appsmith
Connect to Splunk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Splunk data.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Desktop
Connect to TigerGraph data in MicroStrategy Desktop using the CData Software ODBC Driver for TigerGraph.
-
Bind Live Avro Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Avro data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Manage FreshBooks Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FreshBooks.
-
Getting Started with the CData Power BI Connector for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage Cloud Accounting.
-
Integrate Trae with Live Zoho Inventory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zoho Inventory data from within the AI-powered IDE.
-
How to Connect to Live Bullhorn CRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Bullhorn CRM data through natural language.
-
Connect to Zoho Books Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Books data from Filemaker Pro on Mac.
-
Access Optimizely Data from MySQL in PHP
Connect to Optimizely through the standard MySQL libraries in PHP.
-
Build Dashboards with Deel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Deel data in Dundas BI.
-
Connect to ShipEngine from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ShipEngine data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Add Float Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Float with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for SAS Data Sets in MicroStrategy Web
Connect to SAS Data Sets data in MicroStrategy Web using the CData Software ODBC Driver for SAS Data Sets.
-
How to Connect Office 365 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Office 365 data in real time using natural language.
-
Extract, Transform, and Load Discord Data in Informatica PowerCenter
Create a simple Workflow for Discord data in Informatica PowerCenter.
-
DataBind Controls to Microsoft OneDrive Data in C++Builder
DataBind to Microsoft OneDrive data in C++Builder with standard components and controls.
-
Migrating data from Microsoft Teams to Google BigQuery using CData SSIS Components.
Easily push Microsoft Teams data to Google BigQuery using the CData SSIS Tasks for Microsoft Teams and Google BigQuery.
-
How to Connect DBeaver to Dynamics NAV via a JDBC Driver
Manage Dynamics NAV data with visual tools in DBeaver like the query browser.
-
Connect to PDFMonkey Data in JRuby
Create a simple JRuby app with access to live PDFMonkey data.
-
Connect to Mailgun Data in RapidMiner
Integrate Mailgun data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Smartsheet Data in Claris FileMaker Pro
Use the CData ODBC Driver for Smartsheet in FileMaker Pro to connect to Smartsheet and work with Smartsheet data in your FileMaker applications.
-
Operational Reporting on ChargeOver Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ChargeOver data.
-
Choosing the Best Method to Connect Mocean to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mocean data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Consume Stripe OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Stripe feeds that reflect any changes in SAP Lumira.
-
Access Live Zoho Creator 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 Creator data through MCP integration.
-
Analyze Hubstaff Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hubstaff data in Microsoft R Open.
-
QuickBooks Time Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks Time facts in real time.
-
Build Dashboards with Zoho CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho CRM data in DBxtra.
-
Build AI/ML Models with Live Perigon Data using Dataiku
Connect Perigon Data with Dataiku using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for Mode in MicroStrategy Web
Connect to Mode data in MicroStrategy Web using the CData Software ODBC Driver for Mode.
-
Create Datasets from Kintone in Domo Workbench and Build Visualizations of Kintone Data in Domo
Use the CData Software ODBC Driver for Kintone to create datasets from Kintone data in Domo Workbench and then build visualizations in the Domo service.
-
Automate Oracle Service Cloud Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Service Cloud data replication to Couchbase.
-
Build Avro-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Avro data.
-
Replicate Bitly Data from PowerShell
Write a quick PowerShell script to query Bitly data. Use connectivity to the live data to replicate Bitly data to SQL Server.
-
Publish eBay-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live eBay data.
-
Automate SAP Hybris C4C Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Hybris C4C data replication to Azure Synapse.
-
Connect to SparkPost Data in Jaspersoft Studio
Execute SQL to remote SparkPost data in Jaspersoft Studio.
-
Migrating data from Zoho CRM to Snowflake using CData SSIS Components.
Easily push Zoho CRM data to Snowflake using the CData SSIS Tasks for Zoho CRM and Snowflake.
-
Connect to ServiceDesk Plus Data in RapidMiner
Integrate ServiceDesk Plus data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Amazon Marketplace Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Google BigQuery.
-
Replicate Multiple Zoho Inventory Accounts via the CData Sync CLI
Replicate multiple Zoho Inventory accounts to one or many databases.
-
Build Visualizations of Cloudflare Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cloudflare data in Birst.
-
How to connect to Google Ad Manager Data with Squirrel SQL client
Connect to Google Ad Manager data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Amazon DynamoDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to IBM DB2.
-
Create Data Visualizations Based On Impala Data in Mode
Use CData Connect AI to connect to Impala Data from Mode and build visualizations using live Impala data.
-
Connect to and Visualize Live Reckon Accounts Hosted Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Reckon Accounts Hosted data.
-
How to Use a Microsoft Access Database to Update Paylocity Data in Real Time
Update Paylocity data by creating a linked table in Microsoft Access with the CData Paylocity ODBC Driver.
-
Use the CData ODBC Driver for VWO in Microsoft Power Query
You can use the CData VWO ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import VWO data into Microsoft Power Query.
-
Query SAP ByDesign Data in DataGrip
Create a Data Source for SAP ByDesign in DataGrip and use SQL to query live SAP ByDesign data.
-
Migrating data from Workable to Databricks using CData SSIS Components.
Easily push Workable data to Databricks using the CData SSIS Tasks for Workable and Databricks.
-
Connect to CouchDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live CouchDB data from Crystal Reports.
-
Integrating Boomi Agentstudio with Excel Online Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Excel Online data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Live Microsoft OneDrive 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 Microsoft OneDrive data for you.
-
Query Adobe Commerce Data in DataGrip
Create a Data Source for Adobe Commerce in DataGrip and use SQL to query live Adobe Commerce data.
-
Query Drip Data as a MySQL Database in Node.js
Execute MySQL queries against Drip data from Node.js.
-
Connect to Parquet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Parquet and the SQL Gateway to access Parquet data from Google Apps Script.
-
Integrating Cursor with Stripe 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 Hacker News from Asprova with CData Software ODBC Driver for Hacker News
This article shows how to connect faster to Hacker News data from Asprova.
-
Connect to QuickBooks Online Data in DBArtisan
Use wizards in DBArtisan to configure QuickBooks Online data as a data source.
-
Build Toggl-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Toggl Data and create custom apps in Bubble.
-
How to Build an ETL App for Cosmos DB Data in Python with CData Connect AI
Build ETL pipelines that read and write live Cosmos DB data in Python with petl and the CData Connect AI Python SDK.
-
Excel Spreadsheet Automation on Zoom Data with the QUERY Formula
Pull data from Zoom, automate spreadsheets, and more with the QUERY formula.
-
Rapidly Develop HBase-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by HBase.