CData Software - Knowledge Base
Recent Articles
-
Enable the ZohoSubscriptions JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoSubscriptions.
-
Manage Excel Online Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Excel Online.
-
Build API Visualizations in Tableau Cloud
Use CData Connect AI to connect to live API and build visualizations in Tableau Cloud.
-
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.
-
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.
-
Use the CData Software ODBC Driver for Optimizely in SAS for Real-Time Reporting and Analytics
Connect to real-time Optimizely in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Optimizely.
-
Query PhantomBuster Data in DataGrip
Create a Data Source for PhantomBuster in DataGrip and use SQL to query live PhantomBuster.
-
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 and process Browserless from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Browserless.
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy Desktop
Connect to Cvent in MicroStrategy Desktop using the CData Software JDBC Driver for Cvent.
-
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.
-
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.
-
How to load SharePoint data into Elasticsearch via Logstash
Introducing a simple method to load SharePoint data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData JDBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MailChimp.
-
How to connect to Xero Data in DBVisualizer
Integrate Xero Accounting with visual data analysis tools and data connection wizards in DBVisualizer
-
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.
-
Publish Reports with xBase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date xBase.
-
Automated Continuous Oracle HCM Cloud Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Apache Kafka.
-
Create Power BI Reports on Real-Time HubSpot Data
Use the CData ODBC Driver for HubSpot to visualize HubSpot in Power BI Desktop.
-
Publish Monday.com-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Monday.com.
-
Connect to SendGrid Data in RapidMiner
Integrate SendGrid with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Cursor CLI with ScrapingBee 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.
-
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.
-
Build a Singer.io Tap for Mouseflow With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mouseflow data using
-
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.
-
Access Close 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 Close.
-
Build a Simple VCL Application for Paylocity Data
How to build a simple VCL Application to view Paylocity in RAD Studio using the CData ODBC Driver for Paylocity.
-
How to connect to Retently Data with Squirrel SQL client
Connect to Retently and execute queries in the Squirrel SQL Client.
-
DataBind Controls to Oracle Data in Delphi
DataBind to Oracle Database in Delphi with standard data access components and controls.
-
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.
-
Automated Continuous Bullhorn CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Snowflake.
-
Edit and Search External Shopify Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Shopify to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Shopify Data objects that you can access from apps and the dashboard.
-
Excel Spreadsheet Automation on BigQuery Data with the QUERY Formula
Pull data from BigQuery, automate spreadsheets, and more with the QUERY formula.
-
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 Visualize Shortcut Data in Python with pandas
Use pandas and other modules to analyze and visualize live Shortcut in Python.
-
Create Dynamic Teamwork Grids Using the Infragistics XamDataGrid
Learn how you can connect Teamwork to Infragistics XamDataGrid to build dynamic grids.
-
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.
-
Create Dynamic LaunchDarkly Grids Using the Infragistics XamDataGrid
Learn how you can connect LaunchDarkly to Infragistics XamDataGrid to build dynamic grids.
-
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 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.
-
Automate Clio Data Replication to Couchbase
Use CData Sync to Customize and automate Clio replication to Couchbase.
-
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.
-
Replicate Lakebase Data to Multiple Databases
Replicate Lakebase to disparate databases with a point-and-click configuration.
-
Automated Continuous Google Calendar Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to MySQL.
-
How to publish and share iContact Data dashboards with Tableau Server
The CData ODBC driver for iContact enables you integrate iContact into Tableau dashboards.
-
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.
-
Connecting Moonlit Workflow with Oracle HCM Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle HCM Cloud in real time.
-
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.
-
DataBind Controls to ClickUp Data in C++Builder
DataBind to ClickUp in C++Builder with standard components and controls.
-
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.
-
How to use SQLAlchemy ORM to access DB2 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM DB2.
-
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.
-
Build Outreach.io-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Outreach.io to explore live Outreach.io Data in Cursor to assist with building Outreach.io-powered applications.
-
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.
-
Connect to Trello Data in Aqua Data Studio
Access Trello from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Easily Integrate Outreach.io Data in Lazarus Pascal IDE
Learn how to easily integrate live Outreach.io in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
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.
-
Build Semantic Layer Views for SingleStore Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SingleStore.
-
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.
-
Automated Continuous Office 365 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Office 365 replication to Apache Kafka.
-
Integrating Cursor CLI with AlloyDB 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.
-
Use the CData Software JDBC Driver for FreeAgent in MicroStrategy
Connect to FreeAgent in MicroStrategy Developer using the CData Software JDBC Driver for FreeAgent.
-
Migrating data from LeadDesk to Databricks using CData SSIS Components.
Easily push LeadDesk to Databricks using the CData SSIS Tasks for LeadDesk and Databricks.
-
Integrate ClickTime Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ClickTime from Informatica Cloud.
-
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.
-
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.
-
Connect to Amazon Athena Data from AWS Glue
Use CData Connect AI to gain access to live Amazon Athena from your AWS Glue jobs.
-
How to Access Act CRM Data Using Entity Framework
This article shows how to access Act CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
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.
-
Connect SAP Fieldglass to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Fieldglass using the CData Python MCP Server.
-
Visualize Zoho Books Data in TIBCO Spotfire through OData
Integrate Zoho Books into dashboards in TIBCO Spotfire.
-
Analyze Float Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Float from Power Pivot. You will use the Table Import Wizard to load Float. You can visually build the import query or use any SQL supported by the driver.
-
How to integrate Foursquare with Apache Airflow
Access and process Foursquare in Apache Airflow using the CData JDBC Driver.
-
Explore Geographical Relationships in Retently Data with Power Map
Create data visualizations with Retently in Power Map.
-
Automated Continuous Keap Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Keap replication to delimited files (CSV/TSV).
-
Create Dashboards and Visualize Live Phoenix Data in Geckoboard
Use CData Connect AI to connect to live Apache Phoenix and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze SAS xpt Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS XPORT and visualize live SAS XPORT in Infragistics Reveal.
-
Build Automated Workflows with Live Azure DevOps Data in Workato
Use CData Connect AI to connect to live Azure DevOps and build automated workflows in Workato.
-
Integrating Highrise Data in Talend Cloud Data Management Platform
Connect Highrise Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Highrise.
-
Connect to Live AlloyDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to AlloyDB in CData Connect AI and connect to your Google AlloyDB from PostgreSQL.
-
Write a Simple Go Application to work with HDFS Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache HDFS.