CData Software - Knowledge Base
Recent Articles
-
Connect to Zoho CRM in SpagoBI
Create reports featuring live Zoho CRM in SpagoBI Studio. Host Zoho CRM reports on SpagoBI Server.
-
Connect to Dynamics CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics CRM.
-
Create Smartsheet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Smartsheet data access from reports, embedded analytics, and more.
-
How to Query Campaigner Data in MySQL Workbench
Execute MySQL queries against live Campaigner from MySQL Workbench.
-
Integrate Live Reckon Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reckon to Blue Prism using the CData ODBC Driver for Reckon to create automated workflows for repetitive business tasks.
-
Feed ActiveCampaign Data into FineReport
How to set ActiveCampaign as a JDBC data source in FineReport.
-
How to connect PolyBase to Square
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Square.
-
How to Query Live LinkedIn Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn data in natural language using Python.
-
Build Visualizations of Tavily Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tavily in Birst.
-
Integrating OpenCode Terminal with ADP 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 Paddle Data in Ruby
Connect to Paddle in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Float Data as a MySQL Database in Node.js
Execute MySQL queries against Float from Node.js.
-
How to Connect DBeaver to Salesforce Pardot via a JDBC Driver
Manage Salesforce Pardot with visual tools in DBeaver like the query browser.
-
How to connect and process Browserless from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Browserless.
-
Getting Started with the CData Python Connector for eBay Analytics
Learn to install and license the CData Python Connector
-
How to Work with Calendly Data in AWS Glue Jobs Using JDBC
Connect to Calendly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Build an ETL App for Cloudant Data in Python with CData
Create ETL applications and real-time data pipelines for IBM Cloudant in Python with petl.
-
Integrating Boomi Agentstudio with Sage Cloud Accounting Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage Business Cloud Accounting, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Parquet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Parquet replication to SingleStore.
-
Integrating OpenCode Terminal with Google Translate 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.
-
Getting Started with the CData JDBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MailChimp.
-
Migrating data from Paddle to Databricks using CData SSIS Components.
Easily push Paddle to Databricks using the CData SSIS Tasks for Paddle and Databricks.
-
Connect Square to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Square with IBM WebSphere for seamless data integration and connectivity.
-
Work with Twilio Data in FoxPro
Load Twilio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Procore Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Procore to a JSON file on disk.
-
Integrate Sage Cloud Accounting Data into Power Automate Desktop using CData Connect
CData Connect for Sage Cloud Accounting Data enables you to integrate Sage Business Cloud Accounting into workflows built using Microsoft Power Automate Desktop.
-
Consume ElevenLabs OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ElevenLabs feeds that reflect any changes in SAP Lumira.
-
Create Power BI Reports on Real-Time HubSpot Data
Use the CData ODBC Driver for HubSpot to visualize HubSpot in Power BI Desktop.
-
Connect to SendGrid Data in RapidMiner
Integrate SendGrid with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Box Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Box and perform CRUD operations on Box from Node.js.
-
Edit and Search Stack Exchange External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Stack Exchange to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Stack Exchange objects that you can access from apps and the dashboard.
-
Analyze MYOB AccountRight Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MYOB AccountRight in Microsoft R Open.
-
Getting Started with the CData Excel Add-In for Redshift
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Redshift.
-
Access Live Reckon Accounts Hosted Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Reckon Accounts Hosted in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate CouchDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CouchDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache CouchDB.
-
Working with Close Data in LINQPad
Execute LINQ queries to Close in LINQPad.
-
Migrating data from Microsoft Dataverse to Databricks using CData SSIS Components.
Easily push Microsoft Dataverse (CDS) to Databricks using the CData SSIS Tasks for Microsoft Dataverse and Databricks.
-
Design BIRT Reports on SuiteCRM Data
Provide current SuiteCRM to your embedded analytics.
-
Consume SAP OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP feeds that reflect any changes in SAP Lumira.
-
Build Stripe-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Stripe Data and create custom apps in Bubble.
-
Edit and Search External Smartsheet Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Smartsheet to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Smartsheet Data objects that you can access from apps and the dashboard.
-
Migrating data from CapsuleCRM to Snowflake using CData SSIS Components.
Easily push CapsuleCRM to Snowflake using the CData SSIS Tasks for CapsuleCRM and Snowflake.
-
Build Data Flows from Tavily to SQL Server using SSIS
Easily back up Tavily to SQL Server using the SSIS components for Tavily.
-
How to connect to Retently Data with Squirrel SQL client
Connect to Retently and execute queries in the Squirrel SQL Client.
-
Configure the CData JDBC Driver for Cosmos DB in a Connection Pool in Tomcat
Connect to Azure Cosmos DB from a connection pool in Tomcat.
-
DataBind Controls to Oracle Data in Delphi
DataBind to Oracle Database in Delphi with standard data access components and controls.
-
Query Live Google Analytics 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 Google Analytics directly from the development environment.
-
Publish Reports with Parallel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Parallel.
-
Access Live Outlook Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Outlook into the statistical analysis tools available in SAS JMP. This article shows how to use Outlook in the Graph Builder and Query Builder.
-
Excel Spreadsheet Automation on BigQuery Data with the QUERY Formula
Pull data from BigQuery, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData SSIS Components for Teamwork
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teamwork.
-
Create Dashboards and Visualize Live LinkedIn Data in Geckoboard
Use CData Connect AI to connect to live LinkedIn and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to integrate Cosmos DB with Apache Airflow
Access and process Azure Cosmos DB in Apache Airflow using the CData JDBC Driver.
-
Provide OData Services of Rebilly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Rebilly by developing a WCF Service Application.
-
Build Visualizations of Monday.com Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Monday.com in Birst.
-
Connect Aweber to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Aweber using the CData Python MCP Server.
-
How to Connect to Live Oracle Sales 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 Oracle Sales for you.
-
Integrating Claude Code with SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAS Data Sets within assisted coding and automated development workflows.
-
How to Import Data from Act-On into Google Sheets
Import Act-On into a Google spreadsheet that is automatically refreshed.
-
Establish a Live Connection with Shippo Data using Tableau Bridge
The CData ODBC Driver for Shippo enables you to integrate live Shippo into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Raisers Edge NXT Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Raisers Edge NXT for you.
-
Getting Started with the CData Tableau Connector for OData
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for OData.
-
Integrating OpenCode Terminal with ClickTime 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.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through OData
Integrate Blackbaud FE NXT into dashboards in TIBCO Spotfire.
-
Integrating Codex CLI with Microsoft Office 365 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.
-
Automated Continuous Rebilly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Rebilly replication to Snowflake.
-
Explore Geographical Relationships in Oracle Service Cloud Data with Power Map
Create data visualizations with Oracle Service Cloud in Power Map.
-
Create Lakebase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Lakebase data access from reports, embedded analytics, and more.
-
Build Apps with Live CapsuleCRM Data Using the Low-Code Development Platform of Mendix
Connect CapsuleCRM with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Google Calendar Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to MySQL.
-
Query Live BigQuery 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 Google BigQuery directly from the development environment.
-
Perform Batch Operations with Dynamics NAV Data in Apache NiFi
Connect to Microsoft Dynamics NAV and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect SharePoint with SAP Fieldglass Data through external lists
Provide SAP Fieldglass to SharePoint users as an external list.
-
How to Work with Amplitude Data in AWS Glue Jobs Using JDBC
Connect to Amplitude from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Codex CLI with Oracle Eloqua 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.
-
Use the CData API Server to Access Google Tasks Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Tasks in the Power Pivot business intelligence tool.
-
Automate GitHub Integration Tasks from PowerShell
Are you in search of a quick and easy way to access GitHub from PowerShell? This article demonstrates how to utilize the GitHub Cmdlets for tasks like connecting to GitHub, automating operations, downloading data, and more.
-
Query, Visualize, and Share live Epicor Kinetic Data in Redash
Use CData Connect AI to connect to live Epicor Kinetic in Redash for querying, visualizing, and sharing.
-
Access BenchmarkEmail Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BenchmarkEmail from HeidiSQL.
-
How to connect to Procore Data from IntelliJ
Integrate connectivity to Procore with wizards in IntelliJ.
-
How to Connect to Live Highrise Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Highrise CRM without replication.
-
Integrating Codex CLI with Jira Assets 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.
-
Build Amazon Marketplace-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon Marketplace and build web apps with connectivity to live Amazon Marketplace.
-
Automate Apollo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apollo from PowerShell? This article demonstrates how to utilize the Apollo Cmdlets for tasks like connecting to Apollo, automating operations, downloading data, and more.
-
View Reports on Real-Time Close Data in Power BI Report Server
Use the CData ODBC Driver for Close to visualize Close in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Oracle HCM Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle HCM Cloud from Filemaker Pro on Mac.
-
How to connect to Everhour Data with Squirrel SQL client
Connect to Everhour and execute queries in the Squirrel SQL Client.
-
Build Data Flows from Short.io to SQL Server using SSIS
Easily back up Short.io to SQL Server using the SSIS components for Short.io.
-
Manage Freshservice Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Freshservice.
-
Use the CData Software ODBC Driver for Google Forms in MicroStrategy Desktop
Connect to Google Forms in MicroStrategy Desktop using the CData Software ODBC Driver for Google Forms.
-
Use the CData API Server to Access Blackbaud FE NXT Data in Microsoft PowerPivot
Use the CData API Server to connect to live Blackbaud FE NXT in the Power Pivot business intelligence tool.
-
Use JayDeBeApi to access CouchDB Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache CouchDB.
-
Connecting Agentforce with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zendesk for you.
-
Integrating Codex CLI with Apache Spark SQL 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.
-
A PostgreSQL Interface for Quaderno Data using the CData ODBC Driver
Use the SQL Gateway and Quaderno ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Campaign Manager 360 Data in Ruby
Connect to Google Campaign Manager 360 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Amazon Athena Data from AWS Glue
Use CData Connect AI to gain access to live Amazon Athena from your AWS Glue jobs.
-
Use the CData Software ODBC Driver for ScrapingBee in SAS for Real-Time Reporting and Analytics
Connect to real-time ScrapingBee in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ScrapingBee.
-
Integrating LangGraph with Salesforce Pardot Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Pardot within automated workflows.
-
Extend Google Sheets with Factorial Data
Make calls to Factorial from Google Apps Script via the API Server.