CData Software - Knowledge Base
Recent Articles
-
Automate eBay Analytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate eBay Analytics data replication to Azure Data Lake.
-
Consume Shopify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Shopify feeds that reflect any changes in SAP Lumira.
-
Bridge Mistral AI Connectivity with Apache NiFi
Access and process Mistral AI data in Apache NiFi using the CData JDBC Driver.
-
Integrate Google Drive Data in the Pentaho Report Designer
Publish reports based on Google Drive data in the Pentaho BI tool.
-
Automated Continuous Hubstaff Replication to SingleStore
Use CData Sync for automated, continuous, customizable Hubstaff replication to SingleStore.
-
Integrating Antigravity CLI with Google Spanner data via CData CLI
Connect Google Spanner data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect and process SQL Server data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SQL Server data.
-
Integrate Google's Vertex AI Agent with Live Mode 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 Mode data within intelligent workflows.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy
Connect to Klaviyo data in MicroStrategy Developer using the CData Software ODBC Driver for Klaviyo.
-
Automated Continuous Landbot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Landbot replication to PostgreSQL.
-
Process & Analyze Superchat Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Superchat Data.
-
Query Instagram Data in DataGrip
Create a Data Source for Instagram in DataGrip and use SQL to query live Instagram data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Typeform
Provide connectivity to Typeform data through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to Twilio: Complete Guide
Connect to the CData Software Power BI Connector for Twilio from PowerBI.com to provide real-time Twilio data across the organization.
-
A PostgreSQL Interface for Front Data using the CData ODBC Driver
Use the SQL Gateway and Front ODBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with DB2 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to DB2 data.
-
Connect to Strava Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Strava data using standard SQL.
-
How to Connect to Live FreshBooks Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live FreshBooks data securely in real time.
-
Use the CData ODBC Driver for Freshdesk in Microsoft Power Query
You can use the CData Freshdesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshdesk data into Microsoft Power Query.
-
Getting Started with the CData Connect AI Python SDK for Amazon Athena
Install the CData Connect AI Python SDK to read and write live Amazon Athena data with standard DB-API 2.0 Python code.
-
Integrating OpenCode with Dropbox 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 Access Chargebee Data Using Entity Framework
This article shows how to access Chargebee data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Mistral AI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mistral AI and work with Mistral AI data in your FileMaker applications.
-
Connect to Quickbase Data in DBArtisan
Use wizards in DBArtisan to configure Quickbase data as a data source.
-
Getting Started with the CData SSIS Components for Perigon
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Perigon.
-
Excel Spreadsheet Automation on Monday.com Data with the QUERY Formula
Pull data from Monday.com, automate spreadsheets, and more with the QUERY formula.
-
Use Dash to Build Web Apps on Cvent Data via CData Connect AI
Build interactive Dash web apps on live Cvent data using pandas and the CData Connect AI Python SDK.
-
How to integrate Metabase with Active Directory Data
Use CData Connect AI to connect to live Active Directory data and create an interactive dashboard in Metabase from Active Directory data.
-
Getting Started with the CData Python Connector for Landbot
Learn to install and license the CData Python Connector and configure a connection to live Landbot data.
-
Design BIRT Reports on SAP Concur Data
Provide current SAP Concur data to your embedded analytics.
-
Access Perplexity Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Perplexity data from your Oracle system.
-
Moving Data from Adobe Target to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Target data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build a Singer.io Tap for SAP HANA XS Advanced With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP HANA XS Advanced data using the CData Python Connector.
-
Replicate TaxJar Data from PowerShell
Write a quick PowerShell script to query TaxJar data. Use connectivity to the live data to replicate TaxJar data to SQL Server.
-
Connect to Avro Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Avro data from Filemaker Pro on Mac.
-
How to publish and share OnePageCrm Data dashboards with Tableau Server
The CData ODBC driver for OnePageCrm enables you integrate OnePageCrm data into Tableau dashboards.
-
Connect to ClickUp Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ClickUp data in the Denodo Virtual DataPort Administrator.
-
Replicate Multiple Pinecone Accounts
Replicate multiple Pinecone accounts to one or many databases.
-
Automated Exa Data Replication to Teradata
Use CData Sync to Customize and automate Exa data replication to Teradata.
-
Getting Started with the CData ODBC Driver for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bullhorn CRM.
-
Create Power BI Reports on Real-Time Autopilot Data
Use the CData ODBC Driver for Autopilot to visualize Autopilot data in Power BI Desktop.
-
How to Query Bitly Data in MySQL Workbench
Execute MySQL queries against live Bitly data from MySQL Workbench.
-
Create Zendesk-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zendesk Data from OutSystems and build custom enterprise apps using live Zendesk data.
-
Integrate Cline with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Ariba Source data from within your IDE.
-
Getting Started with the CData Power BI Connector for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Process & Analyze ChargeOver Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ChargeOver Data.
-
Getting Started with the CData SSIS Components for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for IBM Cloud Object Storage.
-
Build Automated Supabase-Connected Workflows in Zapier
Use CData Connect AI to connect to live Supabase data and build automated workflows in Zapier.
-
Create Zoho Projects-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Projects Data from Nintex Workflow Cloud and build custom workflows using live Zoho Projects data.
-
Integrate AgileCRM Data in the Pentaho Report Designer
Publish reports based on AgileCRM data in the Pentaho BI tool.
-
Getting Started with the CData Excel Add-In for Placid
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Placid.
-
Connect to Auth0 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Auth0 data using standard SQL.
-
Access Live Workday Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Workday data from your Google Sheets.
-
Integrating Kiro with Zoom 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.
-
Automated Continuous Avro Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Avro replication to Amazon Redshift.
-
Integrate LibreChat with Live Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Supabase data from within the chat interface.
-
Query Microsoft Entra ID Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Entra ID data.
-
Build Data Flows from SQL Server to Elasticsearch through SSIS
Easily push SQL Server data to Elasticsearch using the CData SSIS Tasks for Elasticsearch.
-
Automate Google Directory Data Replication to Couchbase
Use CData Sync to Customize and automate Google Directory data replication to Couchbase.
-
Publish ElevenLabs-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ElevenLabs data.
-
Build Apps with Live Templated Data Using the Low-Code Development Platform of Mendix
Connect Templated data with Mendix to build apps using the CData API Driver for JDBC.
-
Enable the HubSpot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HubSpot data.
-
Connect to Coda Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Coda.
-
Query Superchat Data in ColdFusion
Write standard ColdFusion data access code to connect to Superchat data.
-
Connect Office 365 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Office 365 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Adobe Target Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Target data in Airbyte.
-
How to connect and process RabbitMQ data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live RabbitMQ data.
-
Getting Started with the CData SSIS Components for Slack
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Slack.
-
Connect to Live Facebook Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Facebook Ads in CData Connect AI and connect to your Facebook Ads data from PostgreSQL.
-
Connect to Chargebee Data from PowerBuilder via JDBC
This article demonstrates how to access Chargebee data from PowerBuilder using the Chargebee JDBC Driver.
-
Build Visualizations of Klaviyo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Klaviyo data in Birst.
-
How to create an RPA flow for Pipedrive Data in UiPath Studio
Use the Pipedrive ODBC Driver to create workflows that access real-time Pipedrive data without any coding.
-
How to Connect the Power BI Service to SurveyMonkey: Complete Guide
Connect to the CData Software Power BI Connector for SurveyMonkey from PowerBI.com to provide real-time SurveyMonkey data across the organization.
-
Getting Started with the CData ADO.NET Provider for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for QuickBooks Online.
-
How to work with Salesloft Data in Apache Spark using SQL
Access and process Salesloft Data in Apache Spark using the CData Software JDBC Driver.
-
Query AlloyDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against AlloyDB data from Node.js.
-
Replicate Microsoft OneLake Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft OneLake data to disparate databases with a single configuration.
-
Interact with Live Dropbox Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Dropbox data.
-
Migrating data from EnterpriseDB to Google BigQuery using CData SSIS Components.
Easily push EnterpriseDB data to Google BigQuery using the CData SSIS Tasks for EnterpriseDB and Google BigQuery.
-
Connect to Keap in SpagoBI
Create reports featuring live Keap data in SpagoBI Studio. Host Keap reports on SpagoBI Server.
-
Natively Connect to Pinterest Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pinterest data. Leverage the native support for ODBC in PHP.
-
Publish Oracle Financials Cloud-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Financials Cloud data.
-
Back Up Google Calendar data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Calendar. In this article, we will employ an SSIS workflow to populate a database with Google Calendar data data.
-
How to Connect DBeaver to QuickBooks Time via a JDBC Driver
Manage QuickBooks Time data with visual tools in DBeaver like the query browser.
-
Automate MailerLite Data Replication to Azure Synapse
Use CData Sync to customize and automate MailerLite data replication to Azure Synapse.
-
Create Apps from Jira Assets Data in Qlik Sense Cloud
Use CData Connect AI to connect to Jira Assets Data and build apps from live Jira Assets data in Qlik Sense Cloud.
-
Access Live Aircall Data in AWS Lambda
Connect to live Aircall data in AWS Lambda using the CData JDBC Driver.
-
How to Build an ETL App for GetResponse Data in Python with CData Connect AI
Extract and transform live GetResponse data in Python with petl and the CData Connect AI Python SDK.
-
Visualize Live MariaDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MariaDB data into custom reports in Power BI.
-
Use the CData Software ODBC Driver for MailerLite in MicroStrategy Web
Connect to MailerLite data in MicroStrategy Web using the CData Software ODBC Driver for MailerLite.
-
Build MVC Applications with Connectivity to SAP Business Warehouse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Business Warehouse from an ASP.NET MVC application.
-
Analyze Dynamics NAV Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dynamics NAV data with the CData JDBC Driver for Dynamics NAV.
-
Migrating data from Perplexity to Databricks using CData SSIS Components.
Easily push Perplexity data to Databricks using the CData SSIS Tasks for Perplexity and Databricks.
-
How to connect to MessageBird Data with Squirrel SQL client
Connect to MessageBird data and execute queries in the Squirrel SQL Client.
-
Analyze Databricks Data in Cognos Analytics
Use CData Connect AI to connect to Databricks Data from Cognos Analytics and analyze live Databricks data.
-
Design BIRT Reports on CapsuleCRM Data
Provide current CapsuleCRM data to your embedded analytics.
-
Trigger Salesforce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce with standard wizards in Logic Apps.
-
Integrate with live Azure Table Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Table data in Jitterbit.
-
Connect to Harvest Data in HULFT Integrate
Connect to Harvest as a JDBC data source in HULFT Integrate
-
Connect to Google Campaign Manager 360 Data in Jaspersoft Studio
Execute SQL to remote Google Campaign Manager 360 data in Jaspersoft Studio.