CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Rebilly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Rebilly replication to Snowflake.
-
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.
-
Prepare, Blend, and Analyze Procore Data in Alteryx Designer (ODBC)
Build workflows to access live Procore data for self-service data analytics.
-
Build Apps with Live CapsuleCRM Data Using the Low-Code Development Platform of Mendix
Connect CapsuleCRM data with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live Toggl Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Toggl data through MCP integration.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy
Connect to Harvest data in MicroStrategy Developer using the CData Software ODBC Driver for Harvest.
-
Integrating OpenCode with Testmonitor 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 Zoho Books Data from Spring Boot
Connect to Zoho Books in a Spring Boot Application using the CData JDBC Driver for Zoho Books
-
How to connect to Guru Data with Squirrel SQL client
Connect to Guru data and execute queries in the Squirrel SQL Client.
-
Build Google Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Ads data and build Google Ads-connected web apps with Axios.
-
Deploy the ADO.NET Provider for Teamgate on an SSRS Report Server
Connect to Teamgate data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Access BenchmarkEmail Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BenchmarkEmail data from HeidiSQL.
-
Analyze Postmark Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Postmark from Power Pivot. You will use the Table Import Wizard to load Postmark data. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to TigerGraph Data with Squirrel SQL client
Connect to TigerGraph data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Highrise Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Highrise data without replication.
-
Create Dynamic Azure Synapse Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Synapse to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Codex with Jira Assets 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 Live Zoho Projects Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Projects data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Consume Epicor Kinetic OData Feeds in PowerBuilder
This article demonstrates how to consume Epicor Kinetic data as OData feeds from PowerBuilder using the API Server.
-
How to create Campaigner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Campaigner data in MySQL .
-
Create a Data Access Object for Oracle Sales Data using JDBI
A brief overview of creating a SQL Object API for Oracle Sales data in JDBI.
-
Bidirectional Access to Bullhorn CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bullhorn CRM data in Filemaker Pro for Mac or Windows.
-
How to connect to Everhour Data with Squirrel SQL client
Connect to Everhour data and execute queries in the Squirrel SQL Client.
-
Access Live Grafana Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Grafana data from your Excel spreadsheets.
-
How to Connect BenchmarkEmail Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live BenchmarkEmail data in real time using natural language.
-
DataBind Controls to Oracle Eloqua Reporting Data in Delphi
DataBind to Oracle Eloqua Reporting data in Delphi with standard data access components and controls.
-
Integrate OpenCode with Live Trello Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Trello data from within your AI coding agent.
-
A PostgreSQL Interface for Microsoft Dataverse Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Dataverse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Google Forms in MicroStrategy Desktop
Connect to Google Forms data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Forms.
-
Integrating Cursor with OneNote 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 JotForm Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JotForm data with the CData JDBC Driver for JotForm.
-
Integrate Onfleet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Onfleet with External Services.
-
Build Dashboards with Yelp Data in DBxtra
Create dynamic dashboards and perform analytics based on Yelp data in DBxtra.
-
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 Amazon Athena Data from AWS Glue
Use CData Connect AI to gain access to live Amazon Athena data from your AWS Glue jobs.
-
Integrating LangChain with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Search results within automated workflows.
-
Connect to SharePoint Excel Services Data from PowerBuilder via ADO.NET
This article demonstrates how to access SharePoint Excel Services data from Appeon PowerBuilder using the CData ADO.NET Provider for SharePoint Excel Services.
-
Automate Confluence Data Replication to Azure Synapse
Use CData Sync to customize and automate Confluence data replication to Azure Synapse.
-
Create a Data Access Object for Todoist Data using JDBI
A brief overview of creating a SQL Object API for Todoist data in JDBI.
-
How to Build an ETL App for Redis Data in Python with CData
Create ETL applications and real-time data pipelines for Redis data in Python with petl.
-
Viewing Google Ads Data in RAD Studio Data Explorer
How to view Google Ads data in RAD Studio Data Explorer using the CData ODBC Driver for Google Ads.
-
Connect to Google Cloud Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Cloud Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Informatica Mappings From/To an ODBC Data Source for Amplitude
Create an ODBC connection to Amplitude in Informatica and browse and transfer Amplitude data.
-
Establish a Live Connection with Spotify Data using Tableau Bridge
The CData ODBC Driver for Spotify enables you to integrate live Spotify data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Easily Query Certinia Data in OpenOffice Base
Connect to Certinia data in OpenOffice Base using the CData ODBC Driver for Certinia and generate reports with live data insights.
-
Use CData Connect AI to Access Cosmos DB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Cosmos DB data in the Power Pivot business intelligence tool.
-
Build Apps with Live Databricks Data Using the Low-Code Development Platform of Mendix
Connect Databricks data with Mendix to build apps using the CData JDBC Driver for Databricks.
-
Use Dash to Build to Web Apps on SharePoint Data
Create Python applications that use pandas and Dash to build SharePoint-connected web apps.
-
Automated Continuous Vimeo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Vimeo replication to Google Cloud SQL.
-
Connect to Yelp Data in DBeaver
Use the CData ODBC Driver to connect to Yelp data in DBeaver.
-
How to integrate Slack with Apache Airflow
Access and process Slack data in Apache Airflow using the CData JDBC Driver.
-
Connect to Tickspot Data in RapidMiner
Integrate Tickspot data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Snowflake Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Snowflake data. Leverage the pyodbc module for ODBC in Python.
-
Design BIRT Reports on Perigon Data
Provide current Perigon data to your embedded analytics.
-
Process & Analyze Hacker News Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hacker News Data.
-
Query, Visualize, and Share live Slack Data in Redash
Use CData Connect AI to connect to live Slack data in Redash for querying, visualizing, and sharing.
-
Visualize Live Dynamics CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dynamics CRM data.
-
Integrate Azure Analysis Services Data in the Pentaho Report Designer
Publish reports based on Azure Analysis Services data in the Pentaho BI tool.
-
Create Informatica Mappings From/To an ODBC Data Source for QuickBooks
Create an ODBC connection to QuickBooks in Informatica and browse and transfer QuickBooks data.
-
Analyze Microsoft Planner Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Planner data and visualize Microsoft Planner data in SAP Analytics Cloud.
-
Access Live Guru Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Guru data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Square Data in NetBeans
Connect to Square data in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy Web
Connect to Parquet data in MicroStrategy Web using the CData Software JDBC Driver for Parquet.
-
Connect to Sage 200 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage 200 and the Script function in FileMaker Pro to connect to Sage 200 and work with Sage 200 data in your FileMaker application.
-
Migrating data from Google Contacts to Snowflake using CData SSIS Components.
Easily push Google Contacts data to Snowflake using the CData SSIS Tasks for Google Contacts and Snowflake.
-
Excel Spreadsheet Automation on Neo4J Data with the QUERY Formula
Pull data from Neo4J, automate spreadsheets, and more with the QUERY formula.
-
Import Real-Time WordPress Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use WordPress data in ColdFusion.
-
Integrating LangGraph with Salesforce Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce data within automated workflows.
-
Visualize Live Zendesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zendesk data.
-
Build Apps with Live GitLab data in Adalo using CData Connect AI
Use CData Connect AI to integrate live GitLab data into the Adalo platform and build custom mobile and web applications with real-time GitLab data.
-
Build Google Drive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Drive Data and create custom apps in Bubble.
-
Build Dashboards with MailerLite Data in DBxtra
Create dynamic dashboards and perform analytics based on MailerLite data in DBxtra.
-
Access Live LinkedIn Ads Data in AWS Lambda
Connect to live LinkedIn Ads data in AWS Lambda using the CData JDBC Driver.
-
Integrate Workday with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Workday with External Services.
-
Use the CData Software JDBC Driver for Intercom in MicroStrategy Web
Connect to Intercom data in MicroStrategy Web using the CData Software JDBC Driver for Intercom.
-
Use the CData Software ODBC Driver for AfterShip in SAS for Real-Time Reporting and Analytics
Connect to real-time AfterShip data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for AfterShip.
-
Work with PagerDuty Data in FoxPro
Load PagerDuty data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live Oracle Sales Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Sales data into custom reports in Power BI.
-
Bridge PayPal Connectivity with Apache NiFi
Access and process PayPal data in Apache NiFi using the CData JDBC Driver.
-
Connect to Real-Time ChargeOver Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ChargeOver data in Power Apps.
-
Operational Reporting on Klaviyo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Klaviyo data.
-
PostgreSQL Reporting in OBIEE with the PostgreSQL JDBC Driver
Deploy the PostgreSQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Choosing the Best Method to Connect Sybase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sybase data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Toggl Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Toggl Data and connect to Toggl data in Akorbi Digital RunMyProcess.
-
Design BIRT Reports on Vault CRM Data
Provide current Vault CRM data to your embedded analytics.
-
Connecting Pipedream with FreshBooks 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 FreshBooks data in real time.
-
How to Query Live Attio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Attio data data in natural language using Python.
-
Automated Continuous VWO Replication to SQLite
Use CData Sync for automated, continuous, customizable VWO replication to SQLite.
-
Replicate Multiple ZohoMarketingHub Accounts via the CData Sync CLI
Replicate multiple ZohoMarketingHub accounts to one or many databases.
-
How to load Quaderno data into Elasticsearch via Logstash
Introducing a simple method to load Quaderno data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live SAS xpt 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 SAS xpt data for you.
-
Create Datasets from SQL Server in Domo Workbench and Build Visualizations of SQL Server Data in Domo
Use the CData Software ODBC Driver for SQL Server to create datasets from SQL Server data in Domo Workbench and then build visualizations in the Domo service.
-
Consume Amazon Athena OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon Athena data as OData feeds from PowerBuilder using the API Server.
-
Connect SuiteCRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SuiteCRM with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Insightly Replication to MongoDB
Use CData Sync for automated, continuous, customizable Insightly replication to MongoDB.
-
Use the CData Software JDBC Driver for AgileCRM in MicroStrategy Desktop
Connect to AgileCRM data in MicroStrategy Desktop using the CData Software JDBC Driver for AgileCRM.
-
Use Manus AI to Talk to Your Shortcut 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 Shortcut data.
-
How to import SAP Netweaver Gateway Data into Apache Solr
Use the CData Software JDBC Driver for SAP Netweaver Gateway in Data Import Handler and create an automated import of SAP Netweaver Gateway data to Apache Solr Enterprise Search platform.
-
Use JayDeBeApi to access TaxJar Data in Python
Use standard Python scripting and the development environment of your choice to access live TaxJar data.
-
Connect to Workday Data from a Connection Pool in JBoss
Integrate Workday data into Java servlets: Use the Management Console in JBoss to install the Workday JDBC Driver.