CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load ZohoMarketingHub Data in Informatica PowerCenter
Create a simple Workflow for ZohoMarketingHub in Informatica PowerCenter.
-
Excel Spreadsheet Automation on Mode Data with the QUERY Formula
Pull data from Mode, automate spreadsheets, and more with the QUERY formula.
-
Visualize AdRoll Data in Tableau
The CData ODBC driver for AdRoll enables you integrate AdRoll into Tableau dashboards.
-
LINQ to Basecamp 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 Basecamp Data Provider.
-
Prepare, Blend, and Analyze BenchmarkEmail Data in Alteryx Designer (ODBC)
Build workflows to access live BenchmarkEmail for self-service data analytics.
-
Access Live Elasticsearch Data in Excel 365 Online (Excel for the web)
Connect to Elasticsearch from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Dynamic Amplitude Grids Using the Infragistics XamDataGrid
Learn how you can connect Amplitude to Infragistics XamDataGrid to build dynamic grids.
-
Create GitHub-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GitHub Data from Klipfolio and build custom visualizations using live GitHub.
-
Use Dash to Build to Web Apps on ZohoExpense Data
Create Python applications that use pandas and Dash to build ZohoExpense-connected web apps.
-
How to Connect to SparkPost Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SparkPost. Leverage the pyodbc module for ODBC in Python.
-
How to connect Amazon QuickSight to API Data
Create a connection to API in CData Connect AI and insert API into Amazon QuickSight SPICE to build interactive dashboards.
-
Migrating data from QuickBooks Time to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Time to Google BigQuery using the CData SSIS Tasks for QuickBooks Time and Google BigQuery.
-
How to connect to Reply.io Data with Squirrel SQL client
Connect to Reply.io and execute queries in the Squirrel SQL Client.
-
Access YouTube Analytics Data from MySQL in Amazon QuickSight
Connect to YouTube Analytics and build visualizations of YouTube Analytics using a MySQL Connection in Amazon QuickSight.
-
How to Query Azure DevOps Data in MySQL Workbench
Execute MySQL queries against live Azure DevOps from MySQL Workbench.
-
Create Power BI Reports on Real-Time Timely Data
Use the CData ODBC Driver for Timely to visualize Timely in Power BI Desktop.
-
Connect to Live Gmail Data in MicroStrategy through CData Connect AI
Create a live connection to Gmail Data in CData Connect AI and connect to your Gmail from MicroStrategy.
-
Integrating Claude Code CLI with Avalara AvaTax 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.
-
Connect to Epicor Kinetic from Asprova with CData Software ODBC Driver for Epicor Kinetic
This article shows how to connect faster to Epicor Kinetic data from Asprova.
-
Create Dynamic Salesforce Data 360 Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesforce Data 360 to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Datadog in SAS for Real-Time Reporting and Analytics
Connect to real-time Datadog in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Datadog.
-
Query Google Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Ads entities in PHP by modeling them as objects.
-
Analyze Klaviyo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Klaviyo with the CData JDBC Driver for Klaviyo.
-
How to Access Live Couchbase Data in Visual Studio Code via Cline
Run CData MCP Server for Couchbase on Windows Subsytem for Linux (WSL) and connect to live Couchbase from the Cline extension in Visual Studio Code.
-
Connect to and Visualize Live ScrapingBee Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ScrapingBee.
-
Query Live Oracle Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle Database directly from the development environment.
-
Analyze Raisers Edge NXT Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Raisers Edge NXT with the CData JDBC Driver for Raisers Edge NXT.
-
Connect to Square Data in Ruby
Connect to Square in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Adobe Experience Manager Data from MySQL in Amazon QuickSight
Connect to Adobe Experience Manager and build visualizations of Adobe Experience Manager using a MySQL Connection in Amazon QuickSight.
-
Build Automated Zendesk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zendesk and build automated workflows in Zapier.
-
Access Google Tasks Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Tasks.
-
Integrate with Tavily Data in JReport Designer
Create charts and reports based on Tavily in JReport Designer.
-
Create Azure Table-Connected Nintex Workflows
Use CData Connect AI to connect to Azure Table Data from Nintex Workflow Cloud and build custom workflows using live Azure Table Storage.
-
Configure the CData JDBC Driver for GitHub in a Connection Pool in Tomcat
Connect to GitHub from a connection pool in Tomcat.
-
How to Create Power BI Visual Reports with Real-Time Basecamp Data
Use CData Power BI Connectors to visualize Basecamp in Power BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Planio
Provide connectivity to Planio through an SAP BusinessObjects universe.
-
Connect to Telegram Data from a Connection Pool in Jetty
The Telegram JDBC Driver supports connection pooling: This article shows how to connect faster to Telegram from Web apps in Jetty.
-
Analyze Power BI XMLA Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Power BI XMLA in Microsoft R Open.
-
Build a Simple VCL Application for Odoo Data
How to build a simple VCL Application to view Odoo ERP in RAD Studio using the CData ODBC Driver for Odoo.
-
Integrating Kiro CLI with CampaignMonitor 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.
-
Replicate Jira Assets Data in Heroku for Use in Salesforce Connect
Replicate Jira Assets to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect and process Printful from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Printful.
-
Create Informatica Mappings From/To a JDBC Data Source for Avalara AvaTax
Create Avalara AvaTax data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to Zoho Recruit 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 Zoho Recruit Data Provider.
-
Use Claude to Talk to Your Cvent 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 Cvent for you.
-
Analyze Kintone Data in Looker
Use CData Connect AI to connect to Kintone Data from Looker and build custom apps using live Kintone.
-
Extend Google Sheets with EnterpriseDB Data
Make calls to EnterpriseDB from Google Apps Script via the API Server.
-
Automated Continuous Google Search Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Search replication to SQL Server.
-
Publish Pingdom-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pingdom.
-
Use the CData ODBC Driver for Eventbrite from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Eventbrite to connect to Eventbrite from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Eventbrite in Excel.
-
Automate Pipedrive Data Replication to Azure Synapse
Use CData Sync to customize and automate Pipedrive replication to Azure Synapse.
-
Use Dash to Build to Web Apps on GitLab Data
Create Python applications that use pandas and Dash to build GitLab-connected web apps.
-
Connect to Amazon S3 from Asprova with CData Software ODBC Driver for Amazon S3
This article shows how to connect faster to Amazon S3 data from Asprova.
-
Connect to Vimeo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Vimeo as an External Source in Dremio.
-
Create Data Visualizations in Cognos BI with Beeminder Data
Access Beeminder as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Provide OData Services of SendInBlue Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SendInBlue by developing a WCF Service Application.
-
Connect to Oracle Data in NetBeans
Connect to Oracle Database in NetBeans with the data source configuration wizard.
-
Build Charts with Snapchat Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on Snapchat Ads in Clear Analytics.
-
Use Claude to Talk to Your Kintone 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 Kintone for you.
-
Access JobNimbus Data from MySQL in PHP
Connect to JobNimbus through the standard MySQL libraries in PHP.
-
Validate ClickTime Data with QuerySurge
Access and validate ClickTime in QuerySurge using the CData JDBC Driver.
-
Connect to SageHR Data from a Connection Pool in Jetty
The SageHR JDBC Driver supports connection pooling: This article shows how to connect faster to SageHR from Web apps in Jetty.
-
Create Snapchat Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Snapchat Ads Data from Klipfolio and build custom visualizations using live Snapchat Ads.
-
Build a PostgreSQL Interface for Outlook Data using the CData JDBC Driver
Use the Remoting features of the Outlook JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Hubstaff Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Hubstaff. Leverage the native support for ODBC in PHP.
-
Replicate Yelp Data to Multiple Databases via the CData Sync CLI
Replicate Yelp to disparate databases with a single configuration.
-
A PostgreSQL Interface for Google Contacts Data using the CData ODBC Driver
Use the SQL Gateway and Google Contacts ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate BigCommerce Data Replication to Azure Synapse
Use CData Sync to customize and automate BigCommerce replication to Azure Synapse.
-
Connect to SQL Analysis Services Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SQL Analysis Services as an External Source in Dremio.
-
Replicate ZendeskSell Data from PowerShell
Write a quick PowerShell script to query ZendeskSell. Use connectivity to the live data to replicate ZendeskSell to SQL Server.
-
Integrating Antigravity CLI with Adobe Analytics via CData CLI
Connect Adobe Analytics to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Coinbase Data in Ruby
Connect to Coinbase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Onfleet Data from PowerBuilder via JDBC
This article demonstrates how to access Onfleet from PowerBuilder using the Onfleet JDBC Driver.
-
How to import REST Data into Apache Solr
Use the CData Software JDBC Driver for REST in Data Import Handler and create an automated import of REST to Apache Solr Enterprise Search platform.
-
Integrating Cursor CLI with Amazon S3 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Ad Manager
Provide connectivity to Google Ad Manager through an SAP BusinessObjects universe.
-
Create Data Visualizations in Cognos BI with Smartsheet Data
Access Smartsheet as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Biml to Build SSIS Tasks to Replicate LeadDesk Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LeadDesk to SQL Server.
-
How to work with Bugsnag Data in Apache Spark using SQL
Access and process Bugsnag Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Crystal Reports on Aircall Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Aircall.
-
How to publish and share Shippo Data dashboards with Tableau Server
The CData ODBC driver for Shippo enables you integrate Shippo into Tableau dashboards.
-
Use Dash to Build to Web Apps on Sage Intacct Data
Create Python applications that use pandas and Dash to build Sage Intacct-connected web apps.
-
Build AI/ML Models with Live Vimeo Data using Dataiku
Connect Vimeo Data with Dataiku using the CData API Driver for JDBC.
-
Replicate Klaviyo Data to Multiple Databases via the CData Sync CLI
Replicate Klaviyo to disparate databases with a single configuration.
-
Build Teradata-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Teradata.
-
Manage SAS Data Sets Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAS Data Sets.
-
Automated Continuous JotForm Replication to Databricks
Use CData Sync for automated, continuous, customizable JotForm replication to Databricks.
-
Connect to GraphQL Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with GraphQL Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Sybase IQ Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sybase IQ as an External Source in Dremio.
-
Automated Continuous SAP SuccessFactors Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to delimited files (CSV/TSV).
-
Use Dash to Build Web Apps on Snapchat Ads Data via CData Connect AI
Build interactive Dash web apps on live Snapchat Ads using pandas and the CData Connect AI Python SDK.
-
How to Visualize Avalara AvaTax 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 Avalara AvaTax in Python.
-
How to load Google Translate data into Elasticsearch via Logstash
Introducing a simple method to load Google Translate data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Design Oracle Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Oracle from mobile and tablet Power Apps.
-
Getting Started with the CData Power BI Connector for Phoenix
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Phoenix.
-
Automated Continuous Vertica Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Vertica replication to IBM DB2.
-
Integrate Open WebUI with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Workday from within the chat interface.
-
Access CircleCI Data from MySQL in Amazon QuickSight
Connect to CircleCI and build visualizations of CircleCI using a MySQL Connection in Amazon QuickSight.
-
Object-Relational Mapping (ORM) with Missive Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Missive into a Java-based ORM framework, Hibernate.
-
Visualize CSV Data in Tableau
The CData ODBC driver for CSV enables you integrate CSV/TSV Files into Tableau dashboards.