CData Software - Knowledge Base
Recent Articles
-
Working with LightSpeedRetail Data in LINQPad
Execute LINQ queries to LightSpeedRetail data in LINQPad.
-
How to connect to Freshservice Data with Squirrel SQL client
Connect to Freshservice data and execute queries in the Squirrel SQL Client.
-
Create Marketo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Marketo Data from Klipfolio and build custom visualizations using live Marketo data.
-
Add Oracle Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle with the Informatica Enterprise Data Catalog to classify and organize data.
-
A PostgreSQL Interface for Amazon DynamoDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon DynamoDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open WordPress Data in Microsoft Excel
This article uses the CData ODBC driver for WordPress to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Write a Simple Go Application to work with Adobe Commerce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Commerce data.
-
Connect to and Visualize Live PabblySubscriptions Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PabblySubscriptions data.
-
Automated Continuous ChargeOver Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ChargeOver replication to Apache Cassandra.
-
Connect to VWO from Asprova with CData Software ODBC Driver for VWO
This article shows how to connect faster to VWO data from Asprova.
-
Connect to Live WordPress Data in MicroStrategy through CData Connect AI
Create a live connection to WordPress Data in CData Connect AI and connect to your WordPress data from MicroStrategy.
-
Use the CData Software ODBC Driver for Google Contacts in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Contacts data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Contacts.
-
Natively Connect to Freshdesk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshdesk data. Leverage the native support for ODBC in PHP.
-
How to connect to Bitbucket Data from IntelliJ
Integrate connectivity to Bitbucket data with wizards in IntelliJ.
-
Use ChatGPT to Talk to Your Cloudflare 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 Cloudflare data for you.
-
How to integrate Mixpanel with Apache Airflow
Access and process Mixpanel data in Apache Airflow using the CData JDBC Driver.
-
Access Live Avaza Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Avaza data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build Web Apps on Printify Data via CData Connect AI
Build interactive Dash web apps on live Printify data using pandas and the CData Connect AI Python SDK.
-
A PostgreSQL Interface for SAP HANA Data using the CData ODBC Driver
Use the SQL Gateway and SAP HANA ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Cassandra Data in ETL Validator JDBC
Connect to Cassandra from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Perigon Replication to SQLite
Use CData Sync for automated, continuous, customizable Perigon replication to SQLite.
-
Create Data Visualizations Based On Azure DevOps Data in Mode
Use CData Connect AI to connect to Azure DevOps Data from Mode and build visualizations using live Azure DevOps data.
-
Prepare, Blend, and Analyze MariaDB Data in Alteryx Designer (ODBC)
Build workflows to access live MariaDB data for self-service data analytics.
-
Access Live Samanage Data in Excel 365 Online (Excel for the web)
Connect to Samanage data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Kafka Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Kafka.
-
Getting Started with the CData Power BI Connector for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Build an ETL App for Planio Data in Python with CData
Create ETL applications and real-time data pipelines for Planio data in Python with petl.
-
Visualize Live Tanda Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tanda data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect and process WordPress data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live WordPress data.
-
Integrate Live SAP Business One Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAP Business One data from within the IDE.
-
Use Microsoft Copilot Studio to talk to your Certinia 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 Certinia data for you.
-
Integrating Dataiku with Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Coda data.
-
Viewing Wave Financial Data in RAD Studio Data Explorer
How to view Wave Financial data in RAD Studio Data Explorer using the CData ODBC Driver for Wave Financial.
-
Automated Continuous ConvertKit Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ConvertKit replication to Apache Cassandra.
-
Connect to EmailOctopus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for EmailOctopus to connect to EmailOctopus data and execute queries in PowerBuilder.
-
Import Real-Time ServiceNow Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ServiceNow data in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Kintone
Provide connectivity to Kintone data through an SAP BusinessObjects universe.
-
How to load Azure DevOps data into Elasticsearch via Logstash
Introducing a simple method to load Azure DevOps data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Google Spanner in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Spanner data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Spanner.
-
Build Voice Agents in ElevenLabs with access to Live Google Calendar Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Calendar data.
-
Use Databricks Agent Bricks to Talk to Your Dynamics NAV Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dynamics NAV data for you.
-
Manage Google Search Results in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Search.
-
Replicate Multiple iContact Accounts via the CData Sync CLI
Replicate multiple iContact accounts to one or many databases.
-
Publish Reports with Onfleet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Onfleet data.
-
Validate QuickBooks Data with QuerySurge
Access and validate QuickBooks data in QuerySurge using the CData JDBC Driver.
-
Connect to ShipStation from Asprova with CData Software ODBC Driver for ShipStation
This article shows how to connect faster to ShipStation data from Asprova.
-
Publish Crystal Reports on Landbot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Landbot data.
-
Visualize Live SFTP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SFTP data.
-
Excel Spreadsheet Automation on SQL Server Data with the QUERY Formula
Pull data from SQL Server, automate spreadsheets, and more with the QUERY formula.
-
Connect to Outreach.io in SpagoBI
Create reports featuring live Outreach.io data in SpagoBI Studio. Host Outreach.io reports on SpagoBI Server.
-
DataBind Sage 200 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sage 200 with the DevExpress Windows Forms and Web controls to provide Sage 200 data to a chart.
-
Automated Continuous Reply.io Replication to MongoDB
Use CData Sync for automated, continuous, customizable Reply.io replication to MongoDB.
-
Analyze Unbounce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Unbounce data with the CData JDBC Driver for Unbounce.
-
Connect to MongoDB Data from a Connection Pool in JBoss
Integrate MongoDB data into Java servlets: Use the Management Console in JBoss to install the MongoDB JDBC Driver.
-
Use CData Connect AI to Access Timely Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Timely data in the Power Pivot business intelligence tool.
-
Connect to Adobe Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live Adobe Analytics data from HeidiSQL.
-
Connect to Telegram Data in RapidMiner
Integrate Telegram data with standard components and data source configuration wizards in RapidMiner Studio.
-
Using the CData Software ODBC Driver for Workday in PyCharm
Connect to Workday as an ODBC data source in PyCharm using the CData Software ODBC Driver for Workday.
-
Build NetSuite-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for NetSuite Data and create custom apps in Mendix.
-
Write a Simple Go Application to work with Oracle Eloqua Reporting Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Eloqua Reporting data.
-
Connect to Twilio Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Twilio Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query BigCommerce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume BigCommerce entities in PHP by modeling them as objects.
-
Build Dashboards with Splunk Data in DBxtra
Create dynamic dashboards and perform analytics based on Splunk data in DBxtra.
-
Replicate Discord Data from PowerShell
Write a quick PowerShell script to query Discord data. Use connectivity to the live data to replicate Discord data to SQL Server.
-
Import Paymo Data Using Azure Data Factory
Use CData Connect AI to connect to Paymo Data from Azure Data Factory and import live Paymo data.
-
Automate Office 365 Data Replication to Azure Synapse
Use CData Sync to customize and automate Office 365 data replication to Azure Synapse.
-
DataBind Charts to SAP Business One Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Business One data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Explore Geographical Relationships in Impala Data with Power Map
Create data visualizations with Impala data in Power Map.
-
How to Connect to Live OData Services 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 OData services without replication.
-
Use Biml to Build SSIS Tasks to Replicate SAP Fieldglass Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Fieldglass data to SQL Server.
-
Integrate Oracle Data in Pentaho Data Integration
Build ETL pipelines based on Oracle data in the Pentaho Data Integration tool.
-
Visualize Live MariaDB Data in the Power BI Service
Use CData Connect AI to connect to live MariaDB data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Semantic Layer Views for SurveyMonkey Data in APOS Live Data Gateway
Use the CData Connector for SurveyMonkey in APOS Live Data Gateway to build Semantic Layer Views for SurveyMonkey data.
-
Create Informatica Mappings From/To an ODBC Data Source for Shippo
Create an ODBC connection to Shippo in Informatica and browse and transfer Shippo data.
-
Analyze Azure Analysis Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Analysis Services from Power Pivot. You will use the Table Import Wizard to load Azure Analysis Services data. You can visually build the import query or use any SQL supported by the driver.
-
Create Datasets from Attio in Domo Workbench and Build Visualizations of Attio Data in Domo
Use the CData Software ODBC Driver for Attio to create datasets from Attio data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect Amazon QuickSight to Perplexity Data
Create a connection to Perplexity data in CData Connect AI and insert Perplexity data into Amazon QuickSight SPICE to build interactive dashboards.
-
Migrating data from Microsoft Entra ID to Databricks using CData SSIS Components.
Easily push Microsoft Entra ID data to Databricks using the CData SSIS Tasks for Microsoft Entra ID and Databricks.
-
Publish Crystal Reports on Oracle Eloqua Reporting Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Eloqua Reporting data.
-
How to Connect to Live Elasticsearch Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Elasticsearch data for you.
-
Use JayDeBeApi to access Cosmos DB Data in Python
Use standard Python scripting and the development environment of your choice to access live Cosmos DB data.
-
Getting Started with the CData ODBC Driver for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP BusinessObjects BI.
-
Use the CData Software ODBC Driver for Greenplum in SAS for Real-Time Reporting and Analytics
Connect to real-time Greenplum data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Greenplum.
-
Integrating Claude Code with Smartsheet Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Smartsheet data within assisted coding and automated development workflows.
-
Integrating Antigravity CLI with SendPulse data via CData CLI
Connect SendPulse data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Reckon Data in Ruby
Connect to Reckon data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to GitLab Data in Aqua Data Studio
Access GitLab data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Avalara AvaTax Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Avalara AvaTax data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to integrate PostgreSQL with Apache Airflow
Access and process PostgreSQL data in Apache Airflow using the CData JDBC Driver.
-
Replicate Reckon Data from PowerShell
Write a quick PowerShell script to query Reckon data. Use connectivity to the live data to replicate Reckon data to SQL Server.
-
Process & Analyze HCL Domino Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HCL Domino Data.
-
Connect to Excel Online Data in Jaspersoft Studio
Execute SQL to remote Excel Online data in Jaspersoft Studio.
-
Query, Visualize, and Share live ClickUp Data in Redash
Use CData Connect AI to connect to live ClickUp data in Redash for querying, visualizing, and sharing.
-
Access Live Hacker News Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Hacker News data into the statistical analysis tools available in SAS JMP. This article shows how to use Hacker News data in the Graph Builder and Query Builder.
-
Create SSAS Tabular Models from Azure Synapse Data
How to build a SQL Server Analysis Service Tabular Model from Azure Synapse data using CData drivers.
-
Automated Continuous ConvertAPI Replication to Vertica
Use CData Sync for automated, continuous, customizable ConvertAPI replication to Vertica.
-
How to Connect to Live Trello Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Trello data for you.
-
Connect to SAS Data Sets Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAS Data Sets and the SQL Gateway to access SAS Data Sets data from Google Apps Script.
-
Create Datasets from Figshare in Domo Workbench and Build Visualizations of Figshare Data in Domo
Use the CData Software ODBC Driver for Figshare to create datasets from Figshare data in Domo Workbench and then build visualizations in the Domo service.
-
Create Informatica Mappings From/To a JDBC Data Source for Clari
Create Clari data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.