CData Software - Knowledge Base
Recent Articles
-
Automated Epicor Kinetic Data Replication to Teradata
Use CData Sync to Customize and automate Epicor Kinetic data replication to Teradata.
-
Process & Analyze Greenhouse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Greenhouse Data.
-
Connect and Visualize Live Procore Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Procore data into the Databricks platform and create visualization dashboards with real-time Procore data.
-
Write a Simple Go Application to work with Hive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Hive data.
-
Build Salesforce Data 360-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Data 360 Data from Choreo and build custom apps using live Salesforce Data 360 data.
-
Import Real-Time Gmail Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Gmail data in ColdFusion.
-
Choosing the Best Method to Connect Notion to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Notion data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Parallel Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Parallel data to a chart.
-
Link Microsoft OneDrive with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft OneDrive data in Filemaker Pro for Mac or Windows.
-
Publish Reports with Greenhouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Greenhouse data.
-
Use Databricks Agent Bricks to Talk to Your Redshift Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Redshift data for you.
-
Work with Live Adobe Analytics Data in Power Query
Use CData Connect AI to connect to Adobe Analytics data and work with live Adobe Analytics data in Microsoft Power Query.
-
Explore Geographical Relationships in Azure Synapse Data with Power Map
Create data visualizations with Azure Synapse data in Power Map.
-
Integrate Google's Vertex AI Agent with Live Smartsheet 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 Smartsheet data within intelligent workflows.
-
Query Instagram Data as a MySQL Database in Node.js
Execute MySQL queries against Instagram data from Node.js.
-
Working with Eventbrite Data in LINQPad
Execute LINQ queries to Eventbrite data in LINQPad.
-
Connect to Sendwithus Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sendwithus Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData JDBC Driver for Recurly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Recurly.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendGrid
Provide connectivity to SendGrid data through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze Foursquare Data in Alteryx Designer (ODBC)
Build workflows to access live Foursquare data for self-service data analytics.
-
Choosing the Best Method to Connect Reckon Accounts Hosted to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Reckon Accounts Hosted data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Bugsnag Data to Multiple Databases via the CData Sync CLI
Replicate Bugsnag data to disparate databases with a single configuration.
-
Use Claude to Talk to Your Wistia 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 Wistia data for you.
-
Visualize Workable Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Workable data.
-
Working with Zoho Recruit Data in LINQPad
Execute LINQ queries to Zoho Recruit data in LINQPad.
-
Integrate Wave Financial Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wave Financial data from Informatica Cloud.
-
Manage Demio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Demio.
-
Use the CData Software ODBC Driver for Square in MicroStrategy Web
Connect to Square data in MicroStrategy Web using the CData Software ODBC Driver for Square.
-
How to Connect the Power BI Service to Zoho CRM: Complete Guide
Connect to the CData Software Power BI Connector for Zoho CRM from PowerBI.com to provide real-time Zoho CRM data across the organization.
-
Build Automated Workflows with Live xBase Data in Workato
Use CData Connect AI to connect to live xBase data and build automated workflows in Workato.
-
Visualize Live Bullhorn CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Bullhorn CRM data into custom reports in Power BI.
-
How to Create Power BI Visual Reports with Real-Time RabbitMQ Data
Use CData Power BI Connectors to visualize RabbitMQ data in Power BI.
-
Getting Started with the CData Connect AI Python SDK for ZohoMarketingHub
Install the CData Connect AI Python SDK to read live ZohoMarketingHub data with standard DB-API 2.0 Python code.
-
Integrate OpenCode with Live Google Campaign Manager 360 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Campaign Manager 360 data from within your AI coding agent.
-
LinkedIn Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to LinkedIn Ads data through CData Connect AI using different applications and tools.
-
Use Dash to Build Web Apps on CapsuleCRM Data via CData Connect AI
Build interactive Dash web apps on live CapsuleCRM data using pandas and the CData Connect AI Python SDK.
-
ETL Float in Oracle Data Integrator
This article shows how to transfer Float data into a data warehouse using Oracle Data Integrator.
-
Natively Connect to ConvertAPI Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ConvertAPI data. Leverage the native support for ODBC in PHP.
-
How to Build an ETL App for Attio Data in Python with CData
Create ETL applications and real-time data pipelines for Attio data in Python with petl.
-
DataBind Charts to Wistia Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Wistia 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.
-
View Reports on Real-Time iContact Data in Power BI Report Server
Use the CData ODBC Driver for iContact to visualize iContact data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Claude Code CLI with Stack Exchange 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.
-
Query Sage Intacct Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage Intacct data.
-
Use CData Connect AI to Access Salesforce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce data in the Power Pivot business intelligence tool.
-
Access Vercel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Vercel data from your Oracle system.
-
Automate Shippo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shippo data replication to Azure Data Lake.
-
Build Cosmos DB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Cosmos DB data and build visualizations in Tableau Cloud.
-
Connect to Real-Time Basecamp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Basecamp and Dataflow to import and use Basecamp data in Power Apps.
-
Access Live ClickTime Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ClickTime data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Visualize Eventbrite Data in Python with pandas
Use pandas and other modules to analyze and visualize live Eventbrite data in Python.
-
Automated Continuous Printify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Printify replication to Apache Cassandra.
-
How to connect to MySQL Data from IntelliJ
Integrate connectivity to MySQL data with wizards in IntelliJ.
-
Integrating Codex with Optimizely 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.
-
Publish Reports with SendPulse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendPulse data.
-
Integrate Live Google Campaign Manager 360 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Campaign Manager 360 data to Blue Prism using the CData ODBC Driver for Google Campaign Manager 360 to create automated workflows for repetitive business tasks.
-
DataBind Controls to Square Data in Delphi
DataBind to Square data in Delphi with standard data access components and controls.
-
Integrate Google's Antigravity Agent with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Calendar data using the Model Context Protocol.
-
Access TaxJar Data from MySQL in PHP
Connect to TaxJar through the standard MySQL libraries in PHP.
-
Work with Live Azure Synapse Data in Power Query
Use CData Connect AI to connect to Azure Synapse data and work with live Azure Synapse data in Microsoft Power Query.
-
How to Easily Query DB2 Data in OpenOffice Base
Connect to DB2 data in OpenOffice Base using the CData ODBC Driver for DB2 and generate reports with live data insights.
-
Connect to ZohoDesk Data in ACL Analytics
Connect to ZohoDesk data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ZohoDesk data.
-
How to Connect DBeaver to Apollo via a JDBC Driver
Manage Apollo data with visual tools in DBeaver like the query browser.
-
Connect to Flowlu Data from PowerBuilder via ADO.NET
This article demonstrates how to access Flowlu data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Migrating data from Salesforce to Databricks using CData SSIS Components.
Easily push Salesforce data to Databricks using the CData SSIS Tasks for Salesforce and Databricks.
-
Build Data Flows from Perplexity to SQL Server using SSIS
Easily back up Perplexity data to SQL Server using the SSIS components for Perplexity.
-
Integrating OpenCode with Quickbase 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.
-
Configure the CData JDBC Driver for ServiceDesk Plus in a Connection Pool in Tomcat
Connect to ServiceDesk Plus data from a connection pool in Tomcat.
-
How to Build an ETL App for Microsoft Dataverse Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dataverse data in Python with petl.
-
Connect to Sybase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sybase to connect to Sybase data from Web applications running on WebLogic.
-
Connect to Miro Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Miro as an External Source in Dremio.
-
How to Easily Query EnterpriseDB Data in OpenOffice Base
Connect to EnterpriseDB data in OpenOffice Base using the CData ODBC Driver for EnterpriseDB and generate reports with live data insights.
-
Integrate with Act-On Data in JReport Designer
Create charts and reports based on Act-On data in JReport Designer.
-
Import Oracle Service Cloud Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Service Cloud Data from Azure Data Factory and import live Oracle Service Cloud data.
-
Integrate with live Perplexity Data in Jitterbit
Use CData Connect AI to connect to and integrate live Perplexity data in Jitterbit.
-
Consume Sage Intacct OData Feeds in PowerBuilder
This article demonstrates how to consume Sage Intacct data as OData feeds from PowerBuilder using the API Server.
-
Create Authorize.Net Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Authorize.Net from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Charts to HubDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HubDB 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.
-
How to load Telegram data into Elasticsearch via Logstash
Introducing a simple method to load Telegram data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating LlamaIndex with BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BambooHR data in real time.
-
A PostgreSQL Interface for Coinbase Data using the CData ODBC Driver
Use the SQL Gateway and Coinbase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to FormSite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FormSite to connect to FormSite data and execute queries in PowerBuilder.
-
Publish Reports with Pinterest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinterest data.
-
Visualize iContact Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to iContact data.
-
Connect to Neo4J Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Neo4J as an External Source in Dremio.
-
Use the CData ODBC Driver for Quickbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Quickbase to connect to Quickbase data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Quickbase data in Excel.
-
Build a Simple VCL Application for Azure Data Lake Storage Data
How to build a simple VCL Application to view Azure Data Lake Storage data in RAD Studio using the CData ODBC Driver for Azure Data Lake Storage.
-
How to Visualize Facebook 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 Facebook data in Python.
-
Excel Spreadsheet Automation on Freshservice Data with the QUERY Formula
Pull data from Freshservice, automate spreadsheets, and more with the QUERY formula.
-
Access Live SAP Business Warehouse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business Warehouse data from your Google Sheets.
-
Build Visualizations of Drip Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Drip data in Birst.
-
Manage Webex Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Webex.
-
Connect to Vimeo Data in Jaspersoft Studio
Execute SQL to remote Vimeo data in Jaspersoft Studio.
-
Connect to Mixpanel Data in Jaspersoft Studio
Execute SQL to remote Mixpanel data in Jaspersoft Studio.
-
Replicate Paylocity Data to Multiple Databases via the CData Sync CLI
Replicate Paylocity data to disparate databases with a single configuration.
-
Viewing AdRoll Data in RAD Studio Data Explorer
How to view AdRoll data in RAD Studio Data Explorer using the CData ODBC Driver for AdRoll.
-
Integrating GitHub Copilot with Chargebee 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 SQL Analysis Services Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SQL Analysis Services data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple TaxJar Accounts
Replicate multiple TaxJar accounts to one or many databases.
-
LINQ to SFTP 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 SFTP Data Provider.
-
Replicate Qualaroo Data from PowerShell
Write a quick PowerShell script to query Qualaroo data. Use connectivity to the live data to replicate Qualaroo data to SQL Server.