CData Software - Knowledge Base
Recent Articles
-
Connect to Freshdesk Data in DBeaver
Use the CData ODBC Driver to connect to Freshdesk in DBeaver.
-
Use the CData Software JDBC Driver for Box in MicroStrategy Web
Connect to Box in MicroStrategy Web using the CData Software JDBC Driver for Box.
-
Integrating Boomi Agentstudio with Presto Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Presto, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Add Klipfolio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Klipfolio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Oracle Sales Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Sales in the Denodo Virtual DataPort Administrator.
-
How to Create Power BI Visual Reports with Real-Time Snapchat Ads Data
Use CData Power BI Connectors to visualize Snapchat Ads in Power BI.
-
Integrating Cursor CLI with Perplexity 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.
-
Bidirectional Access to Salesloft Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesloft in Filemaker Pro for Mac or Windows.
-
Access Live Oracle SCM Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Oracle SCM through MCP integration.
-
Connect to Freshsales Data in RazorSQL
Connect to Freshsales from wizards and query Freshsales from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData SSIS Components for Redshift
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Redshift.
-
Import SAP HANA Data Using Azure Data Factory
Use CData Connect AI to connect to SAP HANA Data from Azure Data Factory and import live SAP HANA.
-
Integrate with live Zoho Creator Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho Creator in Jitterbit.
-
Import AlloyDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to AlloyDB Data and provide access to live Google AlloyDB for custom reports in the Power BI Service.
-
Perform Batch Operations with Cassandra Data in Apache NiFi
Connect to Apache Cassandra and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automate DocuSign Data Replication to Couchbase
Use CData Sync to Customize and automate DocuSign replication to Couchbase.
-
Model, Search, and Visualize Live Bullhorn CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Bullhorn CRM for modeling, searching, and visualizing.
-
Integrate Live Okta Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Okta from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Okta.
-
How to connect to Square Data from Spring Boot
Connect to Square in a Spring Boot Application using the CData JDBC Driver for Square
-
How to Easily Query SAP HANA Data in OpenOffice Base
Connect to SAP HANA data in OpenOffice Base using the CData ODBC Driver for SAP HANA and generate reports with live data insights.
-
Build Azure Analysis Services-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Analysis Services and build web apps with connectivity to live Azure Analysis Services.
-
Use the CData Software ODBC Driver for Google Drive in MicroStrategy Desktop
Connect to Google Drive in MicroStrategy Desktop using the CData Software ODBC Driver for Google Drive.
-
How to publish and share Klipfolio Data dashboards with Tableau Server
The CData ODBC driver for Klipfolio enables you integrate Klipfolio into Tableau dashboards.
-
How to connect PolyBase to Twilio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Twilio.
-
A PostgreSQL Interface for SendInBlue Data (MySQL Remoting via JDBC)
Use the Remoting features of the SendInBlue JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Humanity Data from MySQL in Amazon QuickSight
Connect to Humanity and build visualizations of Humanity using a MySQL Connection in Amazon QuickSight.
-
How to Query Live JotForm Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live JotForm data in natural language using Python.
-
Use CData Connect AI to Access Active Directory Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Active Directory in the Power Pivot business intelligence tool.
-
Connect to RSS Feeds as an External Source in Dremio
Use the CData JDBC Driver to connect to RSS as an External Source in Dremio.
-
Use Dash to Build to Web Apps on Zoho Creator Data
Create Python applications that use pandas and Dash to build Zoho Creator-connected web apps.
-
Manage RSS Feeds in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for RSS.
-
How to Build an ETL App for ZeroBounce Data in Python with CData
Create ETL applications and real-time data pipelines for ZeroBounce in Python with petl.
-
Automated Continuous Delighted Replication to Databricks
Use CData Sync for automated, continuous, customizable Delighted replication to Databricks.
-
How to Connect to Live Gong 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 Gong for you.
-
Use JayDeBeApi to access Microsoft OneDrive Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft OneDrive.
-
Connect to Microsoft Planner Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Planner as an External Source in Dremio.
-
Integrate Okta Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Okta from Informatica Cloud.
-
Connect to Postmark Data in DBeaver
Use the CData ODBC Driver to connect to Postmark in DBeaver.
-
Integrate Spark Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache Spark SQL and integrate live Apache Spark SQL into your Power Automate tasks.
-
Create Impala-Connected Business Apps in AppSheet
Connect to Impala Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Impala.
-
Connect to Dynamics CRM Data in Ruby
Connect to Microsoft Dynamics CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Clari 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 Clari into TIBCO Spotfire.
-
Use Manus AI to Talk to Your Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Acumatica ERP.
-
Connect to TaxJar from a Connection Pool in WebLogic
Use the CData JDBC Driver for TaxJar to connect to TaxJar from Web applications running on WebLogic.
-
How to Connect to Live Confluence Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Atlassian Confluence for you.
-
How to Connect to TigerGraph Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to TigerGraph. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Avaza Data from IntelliJ
Integrate connectivity to Avaza with wizards in IntelliJ.
-
Automated Continuous Stripe Replication to Databricks
Use CData Sync for automated, continuous, customizable Stripe replication to Databricks.
-
Automated Continuous Calendly Replication to MySQL
Use CData Sync for automated, continuous, customizable Calendly replication to MySQL.
-
Create Datasets from Intercom in Domo Workbench and Build Visualizations of Intercom Data in Domo
Use the CData Software ODBC Driver for Intercom to create datasets from Intercom in Domo Workbench and then build visualizations in the Domo service.
-
Operational Reporting on Adobe Commerce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Adobe Commerce.
-
Build Pipelines with Live EnterpriseDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to EnterpriseDB from Google Cloud Data Fusion, enabling the integration of live EnterpriseDB into the building and management of effective data pipelines.
-
Query Live Gmail 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 Gmail directly from the development environment.
-
How to load FormSite data into Elasticsearch via Logstash
Introducing a simple method to load FormSite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Onfleet Data in AWS Lambda
Connect to live Onfleet in AWS Lambda using the CData JDBC Driver.
-
Integrating Kiro CLI with Zoho Projects 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 Crystal Reports on Miro Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Miro.
-
Build AI/ML Models with Live Close Data using Dataiku
Connect Close Data with Dataiku using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with Google Cloud Storage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Cloud Storage.
-
How to work with Oracle Sales Data in Apache Spark using SQL
Access and process Oracle Sales Data in Apache Spark using the CData Software JDBC Driver.
-
Build Apps with Live Microsoft OneDrive Data Using the Low-Code Development Platform of Mendix
Connect Microsoft OneDrive with Mendix to build apps using the CData JDBC Driver for Microsoft OneDrive.
-
Automated Continuous Zoho Creator Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Azure SQL Database.
-
Build Zoho Projects-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho Projects Data and create custom apps in Bubble.
-
How to Create Power BI Visual Reports with Real-Time Coinbase Data
Use CData Power BI Connectors to visualize Coinbase in Power BI.
-
Use the CData ODBC Driver for Zoho Inventory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Inventory to connect to Zoho Inventory from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Inventory in Excel.
-
Build a Simple VCL Application for Act CRM Data
How to build a simple VCL Application to view Act CRM in RAD Studio using the CData ODBC Driver for Act CRM.
-
Connect and Query Live Asana Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Asana into Databricks
-
Automate Odoo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Odoo ERP replication to Azure Data Lake.
-
Bind Live Blackbaud FE NXT Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Blackbaud FE NXT data
-
Build Apps with Live Google Analytics in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Analytics into the Adalo platform and build custom mobile and web applications with real-time Google Analytics.
-
How to Build an ETL App for Teamwork Data in Python with CData
Create ETL applications and real-time data pipelines for Teamwork in Python with petl.
-
Query Discord Data in DataGrip
Create a Data Source for Discord in DataGrip and use SQL to query live Discord.
-
Replicate Facebook Ads Data to Multiple Databases
Replicate Facebook Ads to disparate databases with a point-and-click configuration.
-
Connect to Snapchat Ads Data in NetBeans
Connect to Snapchat Ads in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Tableau Connector for Google Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Ads.
-
Build Apps with Live Microsoft Dataverse Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Dataverse (CDS) with Mendix to build apps using the CData JDBC Driver for Microsoft Dataverse.
-
Connect to Quaderno Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Quaderno using standard SQL.
-
Excel Spreadsheet Automation on NetSuite Data with the QUERY Formula
Pull data from NetSuite, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous SAS xpt Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAS xpt replication to Google Cloud SQL.
-
Connect to TigerGraph Data in DBeaver
Use the CData ODBC Driver to connect to TigerGraph in DBeaver.
-
Create Avalara AvaTax-Connected Dashboards in Grafana
Connect to Avalara AvaTax Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Avalara AvaTax.
-
DataBind Controls to Helpscout Data in Delphi
DataBind to Helpscout in Delphi with standard data access components and controls.
-
Extract, Transform, and Load Microsoft OneDrive Data in Informatica PowerCenter
Create a simple Workflow for Microsoft OneDrive in Informatica PowerCenter.
-
Integrating Claude Code CLI with CircleCI 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 work with PabblySubscriptions Data in Apache Spark using SQL
Access and process PabblySubscriptions Data in Apache Spark using the CData Software JDBC Driver.
-
How to Access Live OData Services in Visual Studio Code via Cline
Run CData MCP Server for OData on Windows Subsytem for Linux (WSL) and connect to live OData from the Cline extension in Visual Studio Code.
-
Query Tickspot Data as a MySQL Database in Node.js
Execute MySQL queries against Tickspot from Node.js.
-
How to Connect DBeaver to Cassandra via a JDBC Driver
Manage Apache Cassandra with visual tools in DBeaver like the query browser.
-
Create a Data Access Object for Spotify Data using JDBI
A brief overview of creating a SQL Object API for Spotify in JDBI.
-
How to create an RPA flow for Bitly Data in UiPath Studio
Use the Bitly ODBC Driver to create workflows that access real-time Bitly without any coding.
-
Working with Google Ads Data in LINQPad
Execute LINQ queries to Google Ads in LINQPad.
-
Analyze Live Zendesk Data in SAS Viya
Use CData Connect AI to connect to Zendesk from SAS Viya and deploy self-service analytics using live Zendesk.
-
Create Dashboards and Visualize Live Zoho Books Data in Geckoboard
Use CData Connect AI to connect to live Zoho Books and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Claude Code with IBM Cloud Object Storage Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM Cloud Object Storage within assisted coding and automated development workflows.
-
Connect to SAP Fieldglass Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Fieldglass.
-
Moving Data from Jira Assets to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Jira Assets data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Redshift
Provide connectivity to Amazon Redshift through an SAP BusinessObjects universe.
-
Automated Continuous Testmonitor Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Testmonitor replication to AlloyDB.
-
Build an OLAP Cube in SSAS from ZohoInvoice Data
Establish a connection to ZohoInvoice data from SQL Server Analysis Services, and use the ZohoInvoice Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Snowflake-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Snowflake Data from Klipfolio and build custom visualizations using live Snowflake.