CData Software - Knowledge Base
Recent Articles
-
Analyze LinkedIn Data in Looker
Use CData Connect AI to connect to LinkedIn Data from Looker and build custom apps using live LinkedIn data.
-
How to connect and process YouTube Analytics data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live YouTube Analytics data.
-
Getting Started with the CData ODBC Driver for Snowflake
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Snowflake.
-
Connect and Visualize Live SAP Hybris C4C Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Hybris C4C data into the Databricks platform and create visualization dashboards with real-time SAP Hybris C4C data.
-
Analyze Klaviyo Data in Looker
Use CData Connect AI to connect to Klaviyo Data from Looker and build custom apps using live Klaviyo data.
-
Analyze SageHR Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SageHR data and visualize SageHR data in SAP Analytics Cloud.
-
Automate Azure Blob Storage Data Replication to SAP HANA
Use CData Sync to customize and automate Azure Blob Storage data replication to SAP HANA.
-
Natively Connect to Miro Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Miro data. Leverage the native support for ODBC in PHP.
-
Use Databricks Agent Bricks to Talk to Your Omnisend Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Omnisend data for you.
-
Connect to Google Directory Data in CloverDX (formerly CloverETL)
Transfer Google Directory data using the visual workflow in the CloverDX data integration tool.
-
Accessing the Tesla Fleet API
How to set up the Tesla Fleet API access and use the API in Postman.
-
How to Access Gorgias Data Using Entity Framework
This article shows how to access Gorgias data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Connect AI Python SDK for Teradata
Install the CData Connect AI Python SDK to read and write live Teradata data with standard DB-API 2.0 Python code.
-
Use Microsoft Copilot Studio to talk to your Quickbase 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 Quickbase data for you.
-
Connect to Placid Data in CloverDX (formerly CloverETL)
Transfer Placid data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous GetResponse Replication to Snowflake
Use CData Sync for automated, continuous, customizable GetResponse replication to Snowflake.
-
Automated SendInBlue Data Replication to Teradata
Use CData Sync to Customize and automate SendInBlue data replication to Teradata.
-
Build an OLAP Cube in SSAS from FHIR Data
Establish a connection to FHIR data data from SQL Server Analysis Services, and use the FHIR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Asana Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Asana data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query SingleStore Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SingleStore data from Node.js.
-
Create Power BI Reports on Real-Time Landbot Data
Use the CData ODBC Driver for Landbot to visualize Landbot data in Power BI Desktop.
-
Build Apps with Live HBase Data Using the Low-Code Development Platform of Mendix
Connect HBase data with Mendix to build apps using the CData JDBC Driver for HBase.
-
Provide OData Services of Slack Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Slack data by developing a WCF Service Application.
-
Create Dynamic Zoho Creator Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Creator to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with Live ZohoInvoice Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ZohoInvoice from the MuleSoft Anypoint Platform to integrate live ZohoInvoice data into custom reports and dashboards.
-
Bind Live SFTP Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SFTP data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automated Continuous FreshBooks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable FreshBooks replication to delimited files (CSV/TSV).
-
Build Charts with Spotify Data in Clear Analytics
Create dynamic charts and perform analytics based on Spotify data in Clear Analytics.
-
Query Live IBM Cloud Object Storage Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live IBM Cloud Object Storage data through a conversational interface.
-
Create Elasticsearch-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Elasticsearch Data from OutSystems and build custom enterprise apps using live Elasticsearch data.
-
DataBind Adobe Commerce Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Commerce with the DevExpress Windows Forms and Web controls to provide Adobe Commerce data to a chart.
-
Create SSAS Tabular Models from OneNote Data
How to build a SQL Server Analysis Service Tabular Model from OneNote data using CData drivers.
-
Connect to OneNote Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for OneNote Data and connect to OneNote data in Akorbi Digital RunMyProcess.
-
Build Semantic Layer Views for Tally Data in APOS Live Data Gateway
Use the CData Connector for Tally in APOS Live Data Gateway to build Semantic Layer Views for Tally data.
-
Visualize Jira 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 Jira data into TIBCO Spotfire.
-
How to use SQLAlchemy ORM to access Square Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Square data.
-
Getting Started with the CData Excel Add-In for Factorial
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Factorial.
-
Use the CData Software JDBC Driver for Microsoft Exchange in MicroStrategy
Connect to Microsoft Exchange data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Exchange.
-
Build AI/ML Models with Live Outreach.io Data using Dataiku
Connect Outreach.io Data with Dataiku using the CData JDBC Driver for Outreach.io.
-
Automated Continuous Unbounce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Unbounce replication to AlloyDB.
-
How to Connect the Power BI Service to Telegram: Complete Guide
Connect to the CData Software Power BI Connector for Telegram from PowerBI.com to provide real-time Telegram data across the organization.
-
Build Semantic Layer Views for ZohoInvoice Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoInvoice data.
-
Automated Continuous QuickBooks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable QuickBooks replication to Apache Cassandra.
-
Moving Data from Azure Table to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Table data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query, Visualize, and Share live Outreach.io Data in Redash
Use CData Connect AI to connect to live Outreach.io data in Redash for querying, visualizing, and sharing.
-
Build a PostgreSQL Interface for Google Cloud Storage Data using the CData JDBC Driver
Use the Remoting features of the Google Cloud Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Airtable Data in DataGrip
Create a Data Source for Airtable in DataGrip and use SQL to query live Airtable data.
-
Connect to and Query Sugar CRM Data in QlikView over ODBC
Create data visualizations with Sugar CRM data in QlikView.
-
Integrate with Access Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Access data to a JSON file on disk.
-
Use Biml to Build SSIS Tasks to Replicate HubSpot Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HubSpot data to SQL Server.
-
How to publish and share LeadDesk Data dashboards with Tableau Server
The CData ODBC driver for LeadDesk enables you integrate LeadDesk data into Tableau dashboards.
-
Build Pinterest-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Pinterest data without replication.
-
How to Work with eBay Analytics Data in ETL Validator JDBC
Connect to eBay Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Dashboards with Redshift Data in DBxtra
Create dynamic dashboards and perform analytics based on Redshift data in DBxtra.
-
Automated Continuous Workable Replication to Snowflake
Use CData Sync for automated, continuous, customizable Workable replication to Snowflake.
-
Build a Singer.io Tap for ZohoMarketingHub With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoMarketingHub data using the CData Python Connector.
-
Create Power BI Reports on Real-Time SAP SuccessFactors Data
Use the CData ODBC Driver for SAP SuccessFactors to visualize SAP SuccessFactors data in Power BI Desktop.
-
Getting Started with the CData Connect AI Python SDK for HubSpot
Install the CData Connect AI Python SDK to read and write live HubSpot data with standard DB-API 2.0 Python code.
-
Integrate ElevenLabs with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ElevenLabs with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ElevenLabs data.
-
Integrate OpenCode with Live SAS xpt Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAS xpt data from within your AI coding agent.
-
Build AI Agents with Pinterest 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 Pinterest data through CData Connect AI.
-
Create Apps from Databricks Data in Qlik Sense Cloud
Use CData Connect AI to connect to Databricks Data and build apps from live Databricks data in Qlik Sense Cloud.
-
Getting Started with the CData Power BI Connector for AgileCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect to SendPulse Data with Squirrel SQL client
Connect to SendPulse data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Python Connector for Clari
Learn to install and license the CData Python Connector and configure a connection to live Clari data.
-
Query Live Twilio Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Twilio data through a conversational interface.
-
Build a Simple VCL Application for Elorus Data
How to build a simple VCL Application to view Elorus data in RAD Studio using the CData ODBC Driver for Elorus.
-
Build a Simple VCL Application for Microsoft Dataverse Data
How to build a simple VCL Application to view Microsoft Dataverse data in RAD Studio using the CData ODBC Driver for Microsoft Dataverse.
-
Access Live Campaigner Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Campaigner data into the statistical analysis tools available in SAS JMP. This article shows how to use Campaigner data in the Graph Builder and Query Builder.
-
Access Live Box Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Box data from your Excel spreadsheets.
-
Connect to Aweber Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Aweber data using standard SQL.
-
Back Up Workable data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Workable data data.
-
Access ClickTime Data from MySQL in PHP
Connect to ClickTime through the standard MySQL libraries in PHP.
-
Stream HDFS Data into Apache Kafka Topics
Access and stream HDFS data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate Discord Data Replication to Azure Synapse
Use CData Sync to customize and automate Discord data replication to Azure Synapse.
-
Connect to Live Anaplan Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Anaplan in CData Connect AI and connect to your Anaplan data from PostgreSQL.
-
Automated Continuous ZarMoney Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZarMoney replication to SingleStore.
-
Integrate Theia IDE with Live Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Anaplan data from within the development environment.
-
Automated Continuous CSV Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CSV replication to Google BigQuery.
-
Access Live Wrike Data in Coginiti Pro
Connect to and query live Wrike data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automate Lakebase Data Replication to Azure Synapse
Use CData Sync to customize and automate Lakebase data replication to Azure Synapse.
-
How to integrate Wistia with Apache Airflow
Access and process Wistia data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Sentry Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sentry replication to delimited files (CSV/TSV).
-
Use ChatGPT to Talk to Your Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Mailgun data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ChargeOver
Provide connectivity to ChargeOver data through an SAP BusinessObjects universe.
-
How to Query Live Webex Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Webex data data in natural language using Python.
-
Connecting Agentforce with QuickBooks Time Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your QuickBooks Time data for you.
-
Access Live Factorial Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Factorial data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Databricks Agent Bricks to Talk to Your DB2 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your DB2 data for you.
-
Migrating data from PabblySubscriptions to Databricks using CData SSIS Components.
Easily push PabblySubscriptions data to Databricks using the CData SSIS Tasks for PabblySubscriptions and Databricks.
-
How to load Raisers Edge NXT data into Elasticsearch via Logstash
Introducing a simple method to load Raisers Edge NXT data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Sage Intacct Data in Looker
Use CData Connect AI to connect to Sage Intacct Data from Looker and build custom apps using live Sage Intacct data.
-
Viewing Aha! Data in RAD Studio Data Explorer
How to view Aha! data in RAD Studio Data Explorer using the CData ODBC Driver for Aha!.
-
Create SSAS Tabular Models from Procore Data
How to build a SQL Server Analysis Service Tabular Model from Procore data using CData drivers.
-
Connect to and Visualize Live Clockify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clockify data.
-
Connect to Cohere Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cohere and the SQL Gateway to access Cohere data from Google Apps Script.
-
Connect to SuiteCRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for SuiteCRM in FileMaker Pro to connect to SuiteCRM and work with SuiteCRM data in your FileMaker applications.
-
Visualize Live EnterpriseDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live EnterpriseDB data into custom reports in Power BI.
-
How to create Greenhouse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Greenhouse data in MySQL .
-
Analyze Google Contacts Data in Cognos Analytics
Use CData Connect AI to connect to Google Contacts Data from Cognos Analytics and analyze live Google Contacts data.