CData Software - Knowledge Base
Recent Articles
-
Connect to Google Search Results as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Search results.
-
How to Easily Query Couchbase Data in OpenOffice Base
Connect to Couchbase data in OpenOffice Base using the CData ODBC Driver for Couchbase and generate reports with live data insights.
-
Automated Continuous Elorus Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Elorus replication to IBM DB2.
-
Integrating Oracle Eloqua Data in Talend Cloud Data Management Platform
Connect Oracle Eloqua Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Eloqua.
-
Connect to and Visualize Live Workday Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Workday data.
-
Visualize Templated Data in TIBCO Spotfire through ADO.NET
Integrate Templated data into dashboards in TIBCO Spotfire.
-
How to create Aircall federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aircall data in MySQL .
-
Access Live Google Cloud Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Cloud Storage data from your Excel spreadsheets.
-
Publish Cvent-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cvent data.
-
Automated Continuous Exa Replication to SQLite
Use CData Sync for automated, continuous, customizable Exa replication to SQLite.
-
Use Microsoft Copilot Studio to talk to your Google Calendar 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 Google Calendar data for you.
-
Connect to Live Avalara AvaTax Data in MicroStrategy through CData Connect AI
Create a live connection to Avalara AvaTax Data in CData Connect AI and connect to your Avalara AvaTax data from MicroStrategy.
-
How to Connect to Live CouchDB Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live CouchDB data without replication.
-
Query JotForm Data as a MySQL Database in Node.js
Execute MySQL queries against JotForm data from Node.js.
-
Migrating data from Mocean to Databricks using CData SSIS Components.
Easily push Mocean data to Databricks using the CData SSIS Tasks for Mocean and Databricks.
-
Connect to Instagram Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instagram to connect to Instagram data and execute queries in PowerBuilder.
-
Integrating Claude Code CLI with HubSpot 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.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks data in MicroStrategy Web using the CData Software ODBC Driver for Google Tasks.
-
DataBind Controls to TigerGraph Data in Delphi
DataBind to TigerGraph data in Delphi with standard data access components and controls.
-
How to create Harvest federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Harvest data in MySQL .
-
Automated Continuous Google Spanner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Spanner replication to Apache Cassandra.
-
Build Automated Zoho CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho CRM data and build automated workflows in Zapier.
-
Connect to Square Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Square Data and connect to Square data in Akorbi Digital RunMyProcess.
-
Integrate Live Wistia Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Wistia data and integrate live Wistia data into apps built in Microsoft Power Apps.
-
Connect to HBase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HBase data in the Denodo Virtual DataPort Administrator.
-
How to use SQLAlchemy ORM to access Google Search Results in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Search results.
-
Connect to ShipStation Data in HULFT Integrate
Connect to ShipStation as a JDBC data source in HULFT Integrate
-
Analyze Azure Data Catalog Data in Cognos Analytics
Use CData Connect AI to connect to Azure Data Catalog Data from Cognos Analytics and analyze live Azure Data Catalog data.
-
Establish a Live Connection with OData Services using Tableau Bridge
The CData ODBC Driver for OData enables you to integrate live OData services into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Act-On Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Act-On replication to Google Cloud SQL.
-
Replicate Gumroad Data from PowerShell
Write a quick PowerShell script to query Gumroad data. Use connectivity to the live data to replicate Gumroad data to SQL Server.
-
Integrate Google's Vertex AI Agent with Live PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live PolarTeamPro data within intelligent workflows.
-
Access Live PhantomBuster Data in AWS Lambda
Connect to live PhantomBuster data in AWS Lambda using the CData JDBC Driver.
-
Automate Pipedrive Data Replication to Couchbase
Use CData Sync to Customize and automate Pipedrive data replication to Couchbase.
-
Integrating LangChain with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Email data within automated workflows.
-
How to Connect to Live Cloudflare Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Cloudflare data securely in real time.
-
Use the CData Software JDBC Driver for VWO in MicroStrategy Desktop
Connect to VWO data in MicroStrategy Desktop using the CData Software JDBC Driver for VWO.
-
Automated Continuous Mailjet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mailjet replication to AlloyDB.
-
How to Work with ZarMoney Data in ETL Validator JDBC
Connect to ZarMoney from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Manus AI to Talk to Your Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Forms data.
-
ETL Omnisend in Oracle Data Integrator
This article shows how to transfer Omnisend data into a data warehouse using Oracle Data Integrator.
-
Build a PostgreSQL Interface for QuickBooks Online Data using the CData JDBC Driver
Use the Remoting features of the QuickBooks Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Paylocity Data into Apache Solr
Use the CData Software JDBC Driver for Paylocity in Data Import Handler and create an automated import of Paylocity data to Apache Solr Enterprise Search platform.
-
Integrate Live Nuclia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Nuclia data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Sage 200 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage 200 data from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 200.
-
Integrate Zendesk Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zendesk data and integrate live Zendesk data into your Power Automate tasks.
-
Create Freshsales Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshsales data access from reports, embedded analytics, and more.
-
Connect to Strava Data from PowerBuilder via ADO.NET
This article demonstrates how to access Strava data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live eBay Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate eBay data into the statistical analysis tools available in SAS JMP. This article shows how to use eBay data in the Graph Builder and Query Builder.
-
Create Reports from OData Services in Looker Studio
Use CData Connect AI to gain access to live OData services and create custom reports in Looker Studio.
-
Build Semantic Layer Views for Dynamics CRM Data in APOS Live Data Gateway
Use the CData Connector for Dynamics CRM in APOS Live Data Gateway to build Semantic Layer Views for Dynamics CRM data.
-
Connect to Couchbase Data in JRuby
Create a simple JRuby app with access to live Couchbase data.
-
Connect to Attio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Attio as an External Source in Dremio.
-
How to Easily Query Office 365 Data in OpenOffice Base
Connect to Office 365 data in OpenOffice Base using the CData ODBC Driver for Office 365 and generate reports with live data insights.
-
Build a PostgreSQL Interface for Beeminder Data using the CData JDBC Driver
Use the Remoting features of the Beeminder JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Pinecone Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pinecone data in Dundas BI.
-
Create Reports with Certinia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Certinia data.
-
Validate Onfleet Data with QuerySurge
Access and validate Onfleet data in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Copper
Create an ODBC connection to Copper in Informatica and browse and transfer Copper data.
-
Automated Continuous Act-On Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Act-On replication to delimited files (CSV/TSV).
-
Provide OData Services of Smartsheet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Smartsheet data by developing a WCF Service Application.
-
How to publish and share Vault CRM Data dashboards with Tableau Server
The CData ODBC driver for Vault CRM enables you integrate Vault CRM data into Tableau dashboards.
-
Connect to HDFS Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live HDFS data.
-
How to Connect the Power BI Service to Tanda: Complete Guide
Connect to the CData Software Power BI Connector for Tanda from PowerBI.com to provide real-time Tanda data across the organization.
-
Automated Continuous Snapchat Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Snowflake.
-
Migrating data from Google Search to Databricks using CData SSIS Components.
Easily push Google Search results to Databricks using the CData SSIS Tasks for Google Search and Databricks.
-
Create a Data Access Object for Box Data using JDBI
A brief overview of creating a SQL Object API for Box data in JDBI.
-
Connect to Okta Data in JRuby
Create a simple JRuby app with access to live Okta data.
-
View Reports on Real-Time SharePoint Data in Power BI Report Server
Use the CData ODBC Driver for SharePoint to visualize SharePoint data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Exact Online Data from Spring Boot
Connect to Exact Online in a Spring Boot Application using the CData JDBC Driver for Exact Online
-
Connect to Stripe Data from AWS Glue
Use CData Connect AI to gain access to live Stripe data from your AWS Glue jobs.
-
How to connect PolyBase to Salesforce Pardot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce Pardot data.
-
Use Azure AI Foundry to Talk to Your Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Azure Data Catalog data for you.
-
Hugging Face Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Hugging Face facts in real time.
-
Connect to Zoho Inventory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Inventory and the SQL Gateway to access Zoho Inventory data from Google Apps Script.
-
Integrate Trae with Live Quickbase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Quickbase data from within the AI-powered IDE.
-
Use the CData Software ODBC Driver for Bitly in MicroStrategy
Connect to Bitly data in MicroStrategy Developer using the CData Software ODBC Driver for Bitly.
-
Build Data Flows from SQL Server to REST through SSIS
Easily push SQL Server data to REST using the CData SSIS Tasks for REST.
-
Query SendInBlue Data in DataGrip
Create a Data Source for SendInBlue in DataGrip and use SQL to query live SendInBlue data.
-
Connect to Procore Data in CloverDX (formerly CloverETL)
Transfer Procore data using the visual workflow in the CloverDX data integration tool.
-
Access Live SuiteCRM 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 SuiteCRM data through MCP integration.
-
Build Apps with Live Gmail Data Using the Low-Code Development Platform of Mendix
Connect Gmail data with Mendix to build apps using the CData JDBC Driver for Gmail.
-
Access Live Zoho Books Data in Coginiti Pro
Connect to and query live Zoho Books data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Salesforce Marketing-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce Marketing data.
-
How to load ShipEngine data into Elasticsearch via Logstash
Introducing a simple method to load ShipEngine data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to SAP Ariba Procurement from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement data from Web applications running on WebLogic.
-
Integrate OpenCode with Live QuickBooks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live QuickBooks data from within your AI coding agent.
-
Provide OData Services of Epicor Kinetic Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Epicor Kinetic data by developing a WCF Service Application.
-
Connecting Moonlit Workflow with SparkPost 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 SparkPost data in real time.
-
Automated Continuous Qualaroo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Qualaroo replication to delimited files (CSV/TSV).
-
DataBind Shopify Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Shopify with the DevExpress Windows Forms and Web controls to provide Shopify data to a chart.
-
Automated Continuous Freshsales Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Freshsales replication to PostgreSQL.
-
Create Data Visualizations in Cognos BI with Guru Data
Access Guru data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to SparkPost Data from HeidiSQL
Use CData Connect AI to connect to and query live SparkPost data from HeidiSQL.
-
Getting Started with the CData SSIS Components for Dotmailer
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dotmailer.
-
Access Live Email Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Email data from your Excel spreadsheets.
-
Connect and Visualize Live Tally Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Tally data into the Databricks platform and create visualization dashboards with real-time Tally data.
-
Publish Crystal Reports on SendInBlue Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SendInBlue data.
-
Automated Continuous Aha! Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aha! replication to Google Cloud SQL.
-
How to connect to Billsby Data with Squirrel SQL client
Connect to Billsby data and execute queries in the Squirrel SQL Client.