CData Software - Knowledge Base
Recent Articles
-
Connect to CouchDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access Apache CouchDB in Google Apps Script.
-
How to connect to SAP Ariba Procurement Data in DBVisualizer
Integrate SAP Ariba Procurement with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Claude to Talk to Your Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle Database for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ClickUp
Provide connectivity to ClickUp through an SAP BusinessObjects universe.
-
Excel Spreadsheet Automation on Guru Data with the QUERY Formula
Pull data from Guru, automate spreadsheets, and more with the QUERY formula.
-
Connect to Email Data in Aqua Data Studio
Access Email from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Tableau Connector for Procore
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Mixpanel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mixpanel.
-
Access Live Azure DevOps Data in Coginiti Pro
Connect to and query live Azure DevOps from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Codat Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Codat replication to delimited files (CSV/TSV).
-
Build Apps with Live Lakebase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Lakebase into the Adalo platform and build custom mobile and web applications with real-time Lakebase.
-
Bridge ShipStation Connectivity with Apache NiFi
Access and process ShipStation in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live Cassandra 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 Apache Cassandra for you.
-
How to import Phoenix Data into Apache Solr
Use the CData Software JDBC Driver for Phoenix in Data Import Handler and create an automated import of Apache Phoenix to Apache Solr Enterprise Search platform.
-
Automated Continuous Google Sheets Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Sheets replication to Amazon S3.
-
Integrate Real-Time Access to Google Sheets in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Sheets in real time.
-
Integrating JDBC-ODBC Bridge Data in Talend Cloud Data Management Platform
Connect JDBC-ODBC Bridge Data with Talend Cloud Data Management Platform using the CData JDBC-ODBC Bridge.
-
Create Informatica Mappings From/To an ODBC Data Source for ConstantContact
Create an ODBC connection to ConstantContact in Informatica and browse and transfer ConstantContact.
-
Automated Continuous WordPress Replication to SQLite
Use CData Sync for automated, continuous, customizable WordPress replication to SQLite.
-
Create Datasets from Dotmailer in Domo Workbench and Build Visualizations of Dotmailer Data in Domo
Use the CData Software ODBC Driver for Dotmailer to create datasets from Dotmailer in Domo Workbench and then build visualizations in the Domo service.
-
Create Reports from Zoom Data in Looker Studio
Use CData Connect AI to gain access to live Zoom and create custom reports in Looker Studio.
-
Viewing Teamgate Data in RAD Studio Data Explorer
How to view Teamgate in RAD Studio Data Explorer using the CData ODBC Driver for Teamgate.
-
Integrate Figshare Data in Pentaho Data Integration
Build ETL pipelines based on Figshare in the Pentaho Data Integration tool.
-
How to Create Power BI Visual Reports with Real-Time Sybase IQ Data
Use CData Power BI Connectors to visualize Sybase IQ in Power BI.
-
Automated Continuous Klipfolio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Klipfolio replication to SQL Server.
-
Integrating OpenCode Terminal with AdRoll 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.
-
How to publish and share ZendeskSell Data dashboards with Tableau Server
The CData ODBC driver for ZendeskSell enables you integrate ZendeskSell into Tableau dashboards.
-
Create Dynamic Google Spanner Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Spanner to Infragistics XamDataGrid to build dynamic grids.
-
Build Semantic Layer Views for Rebilly Data in APOS Live Data Gateway
Use the CData Connector for Rebilly in APOS Live Data Gateway to build Semantic Layer Views for Rebilly.
-
Integrate with Bitly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bitly to a JSON file on disk.
-
Integrating Codex CLI with Timely 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.
-
Prepare, Blend, and Analyze ConvertAPI Data in Alteryx Designer (ODBC)
Build workflows to access live ConvertAPI for self-service data analytics.
-
Integrating Antigravity CLI with JDBC-ODBC Bridge via CData CLI
Connect JDBC-ODBC Bridge to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Rebilly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Rebilly using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access SharePoint Data Using Entity Framework
This article shows how to access Microsoft SharePoint using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Keap 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 Keap and work with Keap in your FileMaker application.
-
Automate Cosmos DB Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Cosmos DB replication to Couchbase.
-
Connect to Wave Financial Data in CloverDX (formerly CloverETL)
Transfer Wave Financial using the visual workflow in the CloverDX data integration tool.
-
Connect to Salesforce Data 360 from Asprova with CData Software ODBC Driver for Salesforce Data 360
This article shows how to connect faster to Salesforce Data 360 data from Asprova.
-
Connect to Microsoft Exchange Data in NetBeans
Connect to Microsoft Exchange in NetBeans with the data source configuration wizard.
-
Create Slack-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Slack Data from Klipfolio and build custom visualizations using live Slack.
-
Use the CData API Server to Access Marketo Data in Microsoft PowerPivot
Use the CData API Server to connect to live Marketo in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy Desktop
Connect to Google Tasks in MicroStrategy Desktop using the CData Software ODBC Driver for Google Tasks.
-
Choosing the Best Method to Connect Supabase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Supabase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live eBay Data in AWS Lambda (with IntelliJ IDEA)
Connect to live eBay in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Google Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Analytics, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Add HBase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HBase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Gorgias Replication to SingleStore
Use CData Sync for automated, continuous, customizable Gorgias replication to SingleStore.
-
Access Live Salesforce CRM Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce CRM Analytics from your Excel spreadsheets.
-
How to Connect to Workday Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Workday. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from Reckon to Google BigQuery using CData SSIS Components.
Easily push Reckon to Google BigQuery using the CData SSIS Tasks for Reckon and Google BigQuery.
-
Automated Continuous Email Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Email replication to delimited files (CSV/TSV).
-
Create Zoho Creator-Connected Dashboards in Grafana
Connect to Zoho Creator Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Creator.
-
Connect to Google Search Results as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Search as an External Source in Dremio.
-
Getting Started with the CData Power BI Connector for Freshservice
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Publish Front-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Front.
-
Connect to Discourse Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Discourse and work with Discourse in your FileMaker applications.
-
How to Connect to Aweber Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Aweber. Leverage the pyodbc module for ODBC in Python.
-
Analyze SAP Ariba Source Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Ariba Source in Microsoft R Open.
-
Connect to SharePoint Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint and the Script function in FileMaker Pro to connect to SharePoint and work with Microsoft SharePoint in your FileMaker application.
-
Access Live Stack Exchange Data in AWS Lambda
Connect to live Stack Exchange in AWS Lambda using the CData JDBC Driver.
-
Integrate Oracle Financials Cloud Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Financials Cloud in the Pentaho Data Integration tool.
-
Integrate with QuickBooks Time Data in JReport Designer
Create charts and reports based on QuickBooks Time in JReport Designer.
-
Create Pipeline CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pipeline CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Oracle Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle Database and perform CRUD operations on Oracle from Node.js.
-
Automate Clari Data Replication to Azure Synapse
Use CData Sync to customize and automate Clari replication to Azure Synapse.
-
Access Redis Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Redis from your Oracle system.
-
Connect to YouTube Analytics in SpagoBI
Create reports featuring live YouTube Analytics in SpagoBI Studio. Host YouTube Analytics reports on SpagoBI Server.
-
Automated Continuous Jira Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jira replication to AlloyDB.
-
Access Webflow Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Webflow from HeidiSQL.
-
Create SSAS Tabular Models from TigerGraph Data
How to build a SQL Server Analysis Service Tabular Model from TigerGraph using CData drivers.
-
Query ZarMoney Data in DataGrip
Create a Data Source for ZarMoney in DataGrip and use SQL to query live ZarMoney.
-
Visualize Quickbase Data in TIBCO Spotfire through OData
Integrate Quickbase into dashboards in TIBCO Spotfire.
-
Connect and Visualize Live MySQL Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MySQL into the Databricks platform and create visualization dashboards with real-time MySQL.
-
How to Design Amazon DynamoDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Amazon DynamoDB from mobile and tablet Power Apps.
-
Analyze Zoho CRM Data in Cognos Analytics
Use CData Connect AI to connect to Zoho CRM Data from Cognos Analytics and analyze live Zoho CRM.
-
Integrate Live Procore Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Rapidly Develop Bright Data-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 Bright Data.
-
Connect and Query Live Blackbaud FE NXT Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Blackbaud FE NXT into Databricks
-
Connect to Todoist Data in JRuby
Create a simple JRuby app with access to live Todoist.
-
Connect to SAP Hybris C4C Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Hybris C4C from Filemaker Pro on Mac.
-
Migrating data from Salesforce Marketing to Google BigQuery using CData SSIS Components.
Easily push Salesforce Marketing Cloud to Google BigQuery using the CData SSIS Tasks for Salesforce Marketing and Google BigQuery.
-
Explore Geographical Relationships in OneNote Data with Power Map
Create data visualizations with Microsoft OneNote in Power Map.
-
Getting Started with the CData ODBC Driver for Billsby
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Billsby.
-
Bidirectional Access to Salesforce Data 360 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Data 360 in Filemaker Pro for Mac or Windows.
-
How to Connect to Live Azure Table Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure Table Storage for you.
-
Automated Continuous Zoho Projects Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho Projects replication to OneLake in Microsoft Fabric.
-
Bind Live Zoho Inventory Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Inventory data
-
Connecting Mastra with Splunk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Splunk, no replication required.
-
How to connect and process Snowflake from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Snowflake.
-
Provide OData Services of Google Ad Manager Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Ad Manager by developing a WCF Service Application.
-
Getting Started with the CData Excel Add-In for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho Recruit.
-
Build Visualizations of Hubstaff Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Hubstaff in Birst.
-
Query Facebook Ads Data in DataGrip
Create a Data Source for Facebook Ads in DataGrip and use SQL to query live Facebook Ads.
-
How to use SQLAlchemy ORM to access Pushbullet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pushbullet.
-
How to connect to HBase Data from Spring Boot
Connect to HBase in a Spring Boot Application using the CData JDBC Driver for HBase
-
Connect Amazon Athena Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon Athena using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect Adobe Target Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Adobe Target using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
LINQ to HelloSign Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the HelloSign Data Provider.
-
Connect to NetSuite Data from Crystal Reports
Use CData Connect AI to connect to and report on live NetSuite CRM & ERP from Crystal Reports.