CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with eBay Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to eBay Analytics data.
-
Publish Harvest-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Harvest data.
-
LINQ to Paddle 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 Paddle Data Provider.
-
Configure the CData JDBC Driver for Paymo in a Connection Pool in Tomcat
Connect to Paymo data from a connection pool in Tomcat.
-
Connect to Customer.io Data in JRuby
Create a simple JRuby app with access to live Customer.io data.
-
How to load Browserless data into Elasticsearch via Logstash
Introducing a simple method to load Browserless data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Semantic Layer Views for Azure Synapse Data in APOS Live Data Gateway
Use the CData Connector for Azure Synapse in APOS Live Data Gateway to build Semantic Layer Views for Azure Synapse data.
-
Automated Continuous Google Directory Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Directory replication to MySQL.
-
Automated Continuous Outreach.io Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Outreach.io data replication to OneLake in Microsoft Fabric.
-
Connect to PolarTeamPro Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for PolarTeamPro data in Airbyte.
-
Connecting Pipedream with Teradata Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Teradata data in real time.
-
Getting Started with the CData SSIS Components for SendGrid
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SendGrid.
-
How to Visualize Tally Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Tally data in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Suadeo
Provide connectivity to Suadeo data through an SAP BusinessObjects universe.
-
How to create CockroachDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CockroachDB data in MySQL .
-
Excel Spreadsheet Automation on Egnyte Data with the QUERY Formula
Pull data from Egnyte, automate spreadsheets, and more with the QUERY formula.
-
Integrating Codex 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.
-
Integrating LlamaIndex with ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ConstantContact data in real time.
-
Automated Continuous Aircall Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Aircall data replication to OneLake in Microsoft Fabric.
-
Bind Live Snapchat Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Snapchat Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automate Jira Assets Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Jira Assets data from PowerShell? This article demonstrates how to utilize the Jira Assets Cmdlets for tasks like connecting to Jira Assets data, automating operations, downloading data, and more.
-
Use Claude to Talk to Your Sage Intacct 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 Sage Intacct data for you.
-
Connect to Demio Data in DBeaver
Use the CData ODBC Driver to connect to Demio data in DBeaver.
-
How to integrate JotForm with Apache Airflow
Access and process JotForm data in Apache Airflow using the CData JDBC Driver.
-
Use Agno to Talk to Your Google Drive 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 Google Drive data for you.
-
Working with Tavily Data in LINQPad
Execute LINQ queries to Tavily data in LINQPad.
-
Getting Started with the CData SSIS Components for Google Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Ads.
-
How to Connect to Live Avro 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 Avro data for you.
-
Integrating GitHub Copilot with Keap 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 Connect to Live GraphQL 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 GraphQL data without replication.
-
Use Microsoft Copilot Studio to talk to your ConstantContact 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 ConstantContact data for you.
-
Visualize Live HubSpot Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HubSpot data into custom reports in Power BI.
-
How to Easily Query Microsoft Dataverse Data in OpenOffice Base
Connect to Microsoft Dataverse data in OpenOffice Base using the CData ODBC Driver for Microsoft Dataverse and generate reports with live data insights.
-
Process & Analyze Oracle Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Data.
-
Access Live Microsoft OneDrive Data in AWS Lambda
Connect to live Microsoft OneDrive data in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Quickbase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Quickbase data to Blue Prism using the CData ODBC Driver for Quickbase to create automated workflows for repetitive business tasks.
-
How to integrate Metabase with Zoho Books Data
Use CData Connect AI to connect to live Zoho Books data and create an interactive dashboard in Metabase from Zoho Books data.
-
Visualize Google Ads Data in Tableau
The CData ODBC driver for Google Ads enables you integrate Google Ads data into Tableau dashboards.
-
Using the CData Software ODBC Driver for Monday.com in PyCharm
Connect to Monday.com as an ODBC data source in PyCharm using the CData Software ODBC Driver for Monday.com.
-
Publish Authorize.Net-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Authorize.Net data.
-
How to Connect to Live JSON Services in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your JSON services for you.
-
How to connect and process Demio data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Demio data.
-
Getting Started with the CData ADO.NET Provider for Hive
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Hive.
-
How to Connect the Power BI Service to Oracle SCM: Complete Guide
Connect to the CData Software Power BI Connector for Oracle SCM from PowerBI.com to provide real-time Oracle SCM data across the organization.
-
Import Real-Time CircleCI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CircleCI data in ColdFusion.
-
Create Sybase IQ Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sybase IQ data access from reports, embedded analytics, and more.
-
Build Salesloft-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesloft data.
-
Getting Started with the CData SSIS Components for Typeform
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Typeform.
-
Access Live Zoho Books Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Books data from your Google Sheets.
-
Build BigQuery-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BigQuery data and build web apps with connectivity to live BigQuery data.
-
Connect to Google Search Results in CloverDX (formerly CloverETL)
Transfer Google Search results using the visual workflow in the CloverDX data integration tool.
-
Operational Reporting on ConvertKit Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ConvertKit data.
-
Automated Continuous Sentry Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sentry replication to Snowflake.
-
How to connect to Google Analytics Data from IntelliJ
Integrate connectivity to Google Analytics data with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Bugsnag in MicroStrategy Desktop
Connect to Bugsnag data in MicroStrategy Desktop using the CData Software ODBC Driver for Bugsnag.
-
Getting Started with the CData Excel Add-In for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce CRM Analytics.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy
Connect to Dropbox data in MicroStrategy Developer using the CData Software ODBC Driver for Dropbox.
-
Natively Connect to Microsoft OneDrive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft OneDrive data. Leverage the native support for ODBC in PHP.
-
Natively Connect to Microsoft Entra ID Data in PHP
The CData ODBC driver for Microsoft Entra ID enables you to create PHP applications with connectivity to Microsoft Entra ID data. Leverage the native support for ODBC in PHP.
-
How to Access Live HDFS Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HDFS enables you to integrate HDFS data into workflows built using Microsoft Power Automate Desktop.
-
Consume Marketo OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Marketo feeds that reflect any changes in SAP Lumira.
-
Connect to Adobe Commerce Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Commerce data from PowerBuilder using the Adobe Commerce JDBC Driver.
-
Connect to Shopify Data in JRuby
Create a simple JRuby app with access to live Shopify data.
-
Connect to Pinecone Data in HULFT Integrate
Connect to Pinecone as a JDBC data source in HULFT Integrate
-
How to Query Couchbase Data in MySQL Workbench
Execute MySQL queries against live Couchbase data from MySQL Workbench.
-
How to Connect DBeaver to Oracle via a JDBC Driver
Manage Oracle data with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for Airtable Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Airtable data.
-
Bridge Salesforce Pardot Connectivity with Apache NiFi
Access and process Salesforce Pardot data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous ConstantContact Replication to Oracle
Use CData Sync for automated, continuous, customizable ConstantContact replication to Oracle.
-
Integrating LangGraph with Kafka Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Kafka data within automated workflows.
-
Migrating data from ZohoInvoice to Google BigQuery using CData SSIS Components.
Easily push ZohoInvoice data to Google BigQuery using the CData SSIS Tasks for ZohoInvoice and Google BigQuery.
-
Excel Spreadsheet Automation on Parquet Data with the QUERY Formula
Pull data from Parquet, automate spreadsheets, and more with the QUERY formula.
-
How to Build an ETL App for LDAP Objects in Python with CData Connect AI
Build ETL pipelines that read and write live LDAP objects in Python with petl and the CData Connect AI Python SDK.
-
Connect to Clio Data in CloverDX (formerly CloverETL)
Transfer Clio data using the visual workflow in the CloverDX data integration tool.
-
Prepare, Blend, and Analyze BenchmarkEmail Data in Alteryx Designer (ODBC)
Build workflows to access live BenchmarkEmail data for self-service data analytics.
-
Create BigQuery Dataflows on PowerBI.com
Connect to the CData Power BI Connector for BigQuery from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect and Visualize Live Oracle Sales Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Sales data into the Databricks platform and create visualization dashboards with real-time Oracle Sales data.
-
Use Dash to Build Web Apps on Mailjet Data via CData Connect AI
Build interactive Dash web apps on live Mailjet data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous SendGrid Replication to Snowflake
Use CData Sync for automated, continuous, customizable SendGrid replication to Snowflake.
-
Publish Crystal Reports on Quickbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Quickbase data.
-
How to Work with PagerDuty Data in AWS Glue Jobs Using JDBC
Connect to PagerDuty from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build an OLAP Cube in SSAS from HDFS Data
Establish a connection to HDFS data data from SQL Server Analysis Services, and use the HDFS Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to SparkPost Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SparkPost data. Leverage the pyodbc module for ODBC in Python.
-
Establish a Live Connection with SAP Fieldglass Data using Tableau Bridge
The CData ODBC Driver for SAP Fieldglass enables you to integrate live SAP Fieldglass data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect Oracle Service Cloud 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 Oracle Service Cloud data in real time using natural language.
-
Link Zoom with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoom data in Filemaker Pro for Mac or Windows.
-
How to Connect to Live HBase 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 HBase data through natural language.
-
Connect to Zoom Data from a Connection Pool in Jetty
The Zoom JDBC Driver supports connection pooling: This article shows how to connect faster to Zoom data from Web apps in Jetty.
-
View Reports on Real-Time Impala Data in Power BI Report Server
Use the CData ODBC Driver for Impala to visualize Impala data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Reports with MailerSend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerSend data.
-
Build AI Agents with Amazon S3 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 Amazon S3 data through CData Connect AI.
-
Connect to Gorgias Data in JRuby
Create a simple JRuby app with access to live Gorgias data.
-
Integrate Trae with Live ShipEngine Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ShipEngine data from within the AI-powered IDE.
-
Visualize Live PagerDuty Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PagerDuty data.
-
Build Twitter Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Twitter Ads data.
-
Replicate Multiple Salesforce Accounts via the CData Sync CLI
Replicate multiple Salesforce accounts to one or many databases.
-
Visualize Google Sheets Data in Sisense
Create an ElastiCube in Sisense app with access to Google Sheets data.
-
Integrate LibreChat with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sybase IQ data from within the chat interface.
-
Automate ServiceNow Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ServiceNow data from PowerShell? This article demonstrates how to utilize the ServiceNow Cmdlets for tasks like connecting to ServiceNow data, automating operations, downloading data, and more.
-
Integrating GitHub Copilot with Deel 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.