CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Marketo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Marketo data. Leverage the native support for ODBC in PHP.
-
Connect to Live Twitter Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Twitter Ads Data in CData Connect AI and connect to your Twitter Ads data from MicroStrategy.
-
Validate Codat Data with QuerySurge
Access and validate Codat data in QuerySurge using the CData JDBC Driver.
-
Stream Access Data into Apache Kafka Topics
Access and stream Access data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Claude Code CLI with Elorus 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 Dropbox Data in Talend Cloud Data Management Platform
Connect Dropbox Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dropbox.
-
Excel Spreadsheet Automation on GraphQL Data with the QUERY Formula
Pull data from GraphQL, automate spreadsheets, and more with the QUERY formula.
-
ETL Oracle SCM in Oracle Data Integrator
This article shows how to transfer Oracle SCM data into a data warehouse using Oracle Data Integrator.
-
Connect to REST Data in NetBeans
Connect to REST data in NetBeans with the data source configuration wizard.
-
How to Connect the Power BI Service to Keap: Complete Guide
Connect to the CData Software Power BI Connector for Keap from PowerBI.com to provide real-time Keap data across the organization.
-
Automated Miro Data Replication to Teradata
Use CData Sync to Customize and automate Miro data replication to Teradata.
-
Bridge SendInBlue Connectivity with Apache NiFi
Access and process SendInBlue data in Apache NiFi using the CData JDBC Driver.
-
Analyze Live SAP SuccessFactors Data in SAS Viya
Use CData Connect AI to connect to SAP SuccessFactors data from SAS Viya and deploy self-service analytics using live SAP SuccessFactors data.
-
Manage Gorgias Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Gorgias.
-
Connect to Twilio Data in Ruby
Connect to Twilio data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Query Live BigCommerce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BigCommerce data data in natural language using Python.
-
Extract, Transform, and Load ZarMoney Data in Informatica PowerCenter
Create a simple Workflow for ZarMoney data in Informatica PowerCenter.
-
Query Confluence Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Confluence entities in PHP by modeling them as objects.
-
Visualize SAP Concur 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 SAP Concur data into TIBCO Spotfire.
-
Use Agno to Talk to Your MariaDB 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 MariaDB data for you.
-
Import Airtable Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Airtable Data and provide access to live Airtable data for custom reports in the Power BI Service.
-
How to Connect the Power BI Service to Perplexity: Complete Guide
Connect to the CData Software Power BI Connector for Perplexity from PowerBI.com to provide real-time Perplexity data across the organization.
-
How to Connect the Power BI Service to ZohoSubscriptions: Complete Guide
Connect to the CData Software Power BI Connector for ZohoSubscriptions from PowerBI.com to provide real-time ZohoSubscriptions data across the organization.
-
Connect to Grafana Data from PowerBuilder via ADO.NET
This article demonstrates how to access Grafana data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Microsoft Entra ID Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Entra ID data with the CData JDBC Driver for Microsoft Entra ID.
-
How to Connect to Microsoft Planner Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Planner data. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from Snapchat Ads to Snowflake using CData SSIS Components.
Easily push Snapchat Ads data to Snowflake using the CData SSIS Tasks for Snapchat Ads and Snowflake.
-
Publish Reports with CapsuleCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CapsuleCRM data.
-
Getting Started with the CData Connect AI Python SDK for Guru
Install the CData Connect AI Python SDK to read live Guru data with standard DB-API 2.0 Python code.
-
Getting Started with the CData ADO.NET Provider for Lakebase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Lakebase.
-
How to create an RPA flow for SageHR Data in UiPath Studio
Use the SageHR ODBC Driver to create workflows that access real-time SageHR data without any coding.
-
Create Dynamic Rebilly Grids Using the Infragistics XamDataGrid
Learn how you can connect Rebilly to Infragistics XamDataGrid to build dynamic grids.
-
Create SSAS Tabular Models from CloudConvert Data
How to build a SQL Server Analysis Service Tabular Model from CloudConvert data using CData drivers.
-
Analyze Microsoft Exchange Data in Looker
Use CData Connect AI to connect to Microsoft Exchange Data from Looker and build custom apps using live Microsoft Exchange data.
-
Build Apps with Live Adobe Experience Manager data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Experience Manager data into the Adalo platform and build custom mobile and web applications with real-time Adobe Experience Manager data.
-
Rapidly Develop Twitter Ads-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Twitter Ads.
-
Getting Started with the CData Python Connector for ADP
Learn to install and license the CData Python Connector and configure a connection to live ADP data.
-
Visualize SendPulse Data in Sisense
Create an ElastiCube in Sisense app with access to SendPulse data.
-
Connect Printful Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Printful data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Odoo Data Replication to Teradata
Use CData Sync to Customize and automate Odoo data replication to Teradata.
-
Design BIRT Reports on Short.io Data
Provide current Short.io data to your embedded analytics.
-
Getting Started with the CData SSIS Components for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData SSIS Components for BenchmarkEmail.
-
Automated Continuous Authorize.Net Replication to SingleStore
Use CData Sync for automated, continuous, customizable Authorize.Net replication to SingleStore.
-
Import and Visualize Redis Data in Power View
Create data visualizations based on Redis data in Excel.
-
Design BIRT Reports on Sage 200 Data
Provide current Sage 200 data to your embedded analytics.
-
Feed REST Data into FineReport
How to set REST data as a JDBC data source in FineReport.
-
Connect to VWO from a Connection Pool in WebLogic
Use the CData JDBC Driver for VWO to connect to VWO data from Web applications running on WebLogic.
-
How to Work with SendInBlue Data in AWS Glue Jobs Using JDBC
Connect to SendInBlue from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Webex Data from PowerBuilder via JDBC
This article demonstrates how to access Webex data from PowerBuilder using the Webex JDBC Driver.
-
Choosing the Best Method to Connect Snowflake to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Snowflake data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Work with Front Data in ETL Validator JDBC
Connect to Front from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live SAP HANA Data 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 SAP HANA data for you.
-
LINQ to ConvertKit 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 ConvertKit Data Provider.
-
How to connect to Pinterest Data from Spring Boot
Connect to Pinterest in a Spring Boot Application using the CData JDBC Driver for Pinterest
-
Connect to PostgreSQL Data in RazorSQL
Connect to PostgreSQL from wizards and query PostgreSQL data from the GUI in the RazorSQL database management tool.
-
Access Sentry Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sentry data from HeidiSQL.
-
How to Use a Microsoft Access Database to Update Zendesk Data in Real Time
Update Zendesk data by creating a linked table in Microsoft Access with the CData Zendesk ODBC Driver.
-
How to work with Sage 200 Data in Apache Spark using SQL
Access and process Sage 200 Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Salesforce CRM Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live Salesforce CRM Analytics data for self-service data analytics.
-
Automated Excel Online Data Replication to Teradata
Use CData Sync to Customize and automate Excel Online data replication to Teradata.
-
Automate Ontraport Data Replication to Couchbase
Use CData Sync to Customize and automate Ontraport data replication to Couchbase.
-
Integrating Claude Code CLI with Mocean 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 SSAS Tabular Models from Freshteam Data
How to build a SQL Server Analysis Service Tabular Model from Freshteam data using CData drivers.
-
Access Live Apify Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apify data from your Google Sheets.
-
Connect to GitLab Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GitLab to connect to GitLab data and execute queries in PowerBuilder.
-
Automated Continuous OpenWeatherMap Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to Azure SQL Database.
-
Publish Copper-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Copper data.
-
How to connect to Apollo Data with Squirrel SQL client
Connect to Apollo data and execute queries in the Squirrel SQL Client.
-
Build Dashboards with Google Translate Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Translate data in DBxtra.
-
Integrating Antigravity CLI with Dynamics 365 Business Central data via CData CLI
Connect Dynamics 365 Business Central data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Viewing Keap Data in RAD Studio Data Explorer
How to view Keap data in RAD Studio Data Explorer using the CData ODBC Driver for Keap.
-
Connect to Google Cloud Storage Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Cloud Storage data from HeidiSQL.
-
Operational Reporting on Billsby Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Billsby data.
-
Connect to ShipStation Data in Google Apps Script via Connect AI
Use CData Connect AI to access ShipStation data in Google Apps Script.
-
Integrate OpenCode with Live Azure Synapse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Azure Synapse data from within your AI coding agent.
-
Getting Started with the CData Python Connector for Zoho Projects
Learn to install and license the CData Python Connector and configure a connection to live Zoho Projects data.
-
Connect to Outreach.io Data in ACL Analytics
Connect to Outreach.io data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Outreach.io data.
-
How to Connect the Power BI Service to Office 365: Complete Guide
Connect to the CData Software Power BI Connector for Office 365 from PowerBI.com to provide real-time Office 365 data across the organization.
-
Connecting Pipedream with Bright Data 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 Bright Data data in real time.
-
Integrating GitHub Copilot with Zoho Creator 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 CSV 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 CSV data through natural language.
-
Perform Batch Operations with Greenplum Data in Apache NiFi
Connect to Greenplum data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Coinbase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Coinbase replication to Google BigQuery.
-
Analyze Placid Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Placid data in Microsoft R Open.
-
Access Microsoft Entra ID Data from MySQL in PHP
Connect to Microsoft Entra ID through the standard MySQL libraries in PHP.
-
Access Live QuickBooks Time Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Time data from your Excel spreadsheets.
-
Visualize Bright Data Data in Tableau
The CData ODBC driver for Bright Data enables you integrate Bright Data data into Tableau dashboards.
-
Build Dashboards with Oracle Service Cloud Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Service Cloud data in DBxtra.
-
Query Smartsheet Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Smartsheet data from Node.js.
-
Automated Continuous Jira Assets Replication to SQL Server
Use CData Sync for automated, continuous, customizable Jira Assets replication to SQL Server.
-
Provide OData Services of FormSite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FormSite data by developing a WCF Service Application.
-
How to Connect to & Open OpenWeatherMap Data in Microsoft Excel
This article uses the CData ODBC driver for OpenWeatherMap to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to MailerSend Data with Squirrel SQL client
Connect to MailerSend data and execute queries in the Squirrel SQL Client.
-
Connect to and Query Avaza Data in QlikView over ODBC
Create data visualizations with Avaza data in QlikView.
-
Integrating Boomi Agentstudio with SAP Netweaver Gateway Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Netweaver Gateway data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Invoiced Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Invoiced replication to Apache Cassandra.
-
Use the CData ODBC Driver for SAP Ariba Procurement in Microsoft Power Query
You can use the CData SAP Ariba Procurement ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Ariba Procurement data into Microsoft Power Query.
-
Visualize Egnyte Data in Tableau
The CData ODBC driver for Egnyte enables you integrate Egnyte data into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for Avro
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Avro.
-
Import Real-Time Microsoft Exchange Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Exchange data in ColdFusion.