CData Software - Knowledge Base
Recent Articles
-
Integrate with Outreach.io Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Outreach.io to a JSON file on disk.
-
Connect to Greenhouse Data in DBeaver
Use the CData ODBC Driver to connect to Greenhouse in DBeaver.
-
How to Connect to Live Apollo 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 Apollo for you.
-
Create Apps from Google Cloud Storage Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Cloud Storage Data and build apps from live Google Cloud Storage in Qlik Sense Cloud.
-
Validate Confluence Data with QuerySurge
Access and validate Atlassian Confluence in QuerySurge using the CData JDBC Driver.
-
Add Intercom Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Intercom with the Informatica Enterprise Data Catalog to classify and organize data.
-
Validate Zendesk Data with QuerySurge
Access and validate Zendesk in QuerySurge using the CData JDBC Driver.
-
How to connect to Clockify Data in DBVisualizer
Integrate Clockify with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating OpenCode Terminal with Microsoft Ads 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 Nuclia Data from PowerBuilder via JDBC
This article demonstrates how to access Nuclia from PowerBuilder using the Nuclia JDBC Driver.
-
Use the CData Software ODBC Driver for Telegram in MicroStrategy Desktop
Connect to Telegram in MicroStrategy Desktop using the CData Software ODBC Driver for Telegram.
-
How to integrate Metabase with Redis Data
Use CData Connect AI to connect to live Redis and create an interactive dashboard in Metabase from Redis.
-
Import and Visualize Jira Assets Data in Power View
Create data visualizations based on Jira Assets in Excel.
-
Access Google Contacts 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 Google Contacts.
-
How to Query Teradata Data in MySQL Workbench
Execute MySQL queries against live Teradata from MySQL Workbench.
-
How to Use a Microsoft Access Database to Update SAP Ariba Source Data in Real Time
Update SAP Ariba Source data by creating a linked table in Microsoft Access with the CData SAP Ariba Source ODBC Driver.
-
Working with Sendwithus Data in LINQPad
Execute LINQ queries to Sendwithus in LINQPad.
-
Create Dynamic SAP Business Warehouse Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Business Warehouse to Infragistics XamDataGrid to build dynamic grids.
-
How to work with Dynamics NAV Data in Apache Spark using SQL
Access and process Dynamics NAV Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy Desktop
Connect to Sage Business Cloud Accounting in MicroStrategy Desktop using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Integrate Live Kintone Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Kintone and integrate live Kintone into apps built in Microsoft Power Apps.
-
Integrating Browserless Data in Talend Cloud Data Management Platform
Connect Browserless Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with SAP Netweaver Gateway Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Netweaver Gateway.
-
How to Connect to & Open Gumroad Data in Microsoft Excel
This article uses the CData ODBC driver for Gumroad to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Facebook Ads 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 Facebook Ads into TIBCO Spotfire.
-
DataBind Controls to Clockify Data in Delphi
DataBind to Clockify in Delphi with standard data access components and controls.
-
Create Datasets from Impala in Domo Workbench and Build Visualizations of Impala Data in Domo
Use the CData Software ODBC Driver for Impala to create datasets from Apache Impala in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Excel Replication to Snowflake
Use CData Sync for automated, continuous, customizable Excel replication to Snowflake.
-
How to connect to Browserless Data from Spring Boot
Connect to Browserless in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect to Google Analytics Data with Squirrel SQL client
Connect to Google Analytics and execute queries in the Squirrel SQL Client.
-
Integrate Phoenix Data in Pentaho Data Integration
Build ETL pipelines based on Apache Phoenix in the Pentaho Data Integration tool.
-
Build Visualizations of Vimeo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Vimeo in Birst.
-
LINQ to Humanity 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 Humanity Data Provider.
-
Work with Insightly Data in FoxPro
Load Insightly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Klaviyo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Klaviyo using standard SQL.
-
How to Query Live xBase Data in Perplexity MacOS Desktop
Connect to and query live xBase Data in Perplexity Desktop using CData MCP Server.
-
Connect to Raisers Edge NXT Data in RapidMiner
Integrate Raisers Edge NXT with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Apps with Live Google Drive Data Using the Low-Code Development Platform of Mendix
Connect Google Drive with Mendix to build apps using the CData JDBC Driver for Google Drive.
-
Connect to Spark Data in Claris FileMaker Pro
Use the CData ODBC Driver for Spark in FileMaker Pro to connect to Spark and work with Apache Spark SQL in your FileMaker applications.
-
Connect to Mode Data from a Connection Pool in Jetty
The Mode JDBC Driver supports connection pooling: This article shows how to connect faster to Mode from Web apps in Jetty.
-
How to connect to Act CRM Data from Spring Boot
Connect to Act CRM in a Spring Boot Application using the CData JDBC Driver for Act CRM
-
How to Access Live Paylocity Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Paylocity enables you to integrate Paylocity into workflows built using Microsoft Power Automate Desktop.
-
Import HubDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HubDB. In this article, you will use the OData format to import HubDB into Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for Freshdesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Freshdesk.
-
Getting Started with the CData Power BI Connector for Bugsnag
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Neo4J Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Neo4J replication to AlloyDB.
-
Operational Reporting on Mode Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mode.
-
Automated Continuous Aha! Replication to Snowflake
Use CData Sync for automated, continuous, customizable Aha! replication to Snowflake.
-
Build Jodoo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Jodoo and build web apps with connectivity to live Jodoo.
-
Connect to Everhour Data in DBeaver
Use the CData ODBC Driver to connect to Everhour in DBeaver.
-
Build Apps with Live ZendeskSell Data Using the Low-Code Development Platform of Mendix
Connect ZendeskSell with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect to Kafka Data from Spring Boot
Connect to Kafka in a Spring Boot Application using the CData JDBC Driver for Kafka
-
Connect to Microsoft Entra ID Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Entra ID and the Script function in FileMaker Pro to connect to Microsoft Entra ID and work with Microsoft Entra ID in your FileMaker application.
-
Object-Relational Mapping (ORM) with Google Search Results Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Search into a Java-based ORM framework, Hibernate.
-
Connect to CSV Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CSV to connect to CSV/TSV Files and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for NetSuite in SAS for Real-Time Reporting and Analytics
Connect to real-time NetSuite CRM & ERP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for NetSuite.
-
Migrating data from Close to Google BigQuery using CData SSIS Components.
Easily push Close to Google BigQuery using the CData SSIS Tasks for Close and Google BigQuery.
-
How to Connect to Live Google Directory 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 Google Directory for you.
-
Integrate Live Act-On Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Act-On and integrate live Act-On into apps built in Microsoft Power Apps.
-
How to Build an ETL App for HelloSign Data in Python with CData
Create ETL applications and real-time data pipelines for HelloSign in Python with petl.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage Cloud Accounting
Provide connectivity to Sage Business Cloud Accounting through an SAP BusinessObjects universe.
-
Visualize Google Ad Manager Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Ad Manager.
-
Use the CData Software JDBC Driver for Dropbox in MicroStrategy
Connect to Dropbox in MicroStrategy Developer using the CData Software JDBC Driver for Dropbox.
-
How to Query Live Deel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Deel data in natural language using Python.
-
Connect to ActiveCampaign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Power BI Reports on Real-Time SurveyMonkey Data
Use the CData ODBC Driver for SurveyMonkey to visualize SurveyMonkey in Power BI Desktop.
-
Integrate Cline with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live DocuSign from within your IDE.
-
Natively Connect to Productboard Data in PHP
The CData ODBC driver for Productboard enables you to create PHP applications with connectivity to Productboard. Leverage the native support for ODBC in PHP.
-
Query QuickBooks Online Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume QuickBooks Online entities in PHP by modeling them as objects.
-
How to Import Data from MYOB AccountRight into Google Sheets
Import MYOB AccountRight into a Google spreadsheet that is automatically refreshed.
-
Integrate with live Phoenix Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apache Phoenix in Jitterbit.
-
Integrate Live Trello Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Trello from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Trello.
-
Import Real-Time Trello Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Trello in ColdFusion.
-
Validate Simplesat Data with QuerySurge
Access and validate Simplesat in QuerySurge using the CData JDBC Driver.
-
Configure the CData JDBC Driver for MYOB AccountRight in a Connection Pool in Tomcat
Connect to MYOB AccountRight from a connection pool in Tomcat.
-
Connect to Workday Data from PowerBuilder via ADO.NET
This article demonstrates how to access Workday from Appeon PowerBuilder using the CData ADO.NET Provider for Workday.
-
Migrating data from Apify to Databricks using CData SSIS Components.
Easily push Apify to Databricks using the CData SSIS Tasks for Apify and Databricks.
-
Integrating Cursor CLI with Acumatica 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.
-
Build Agents in Relevance AI with Access to Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on FHIR within intelligent agent workflows.
-
Visualize Live Tally Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Tally ERP.
-
How to Visualize Oracle HCM Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle HCM Cloud in Python.
-
How to integrate Pipeline CRM with Apache Airflow
Access and process Pipeline CRM in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Couchbase 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 Couchbase for you.
-
Connect to Live Quickbase Data in MicroStrategy through CData Connect AI
Create a live connection to Quickbase Data in CData Connect AI and connect to your Quickbase from MicroStrategy.
-
Getting Started with the CData Excel Add-In for Webflow
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Webflow.
-
DataBind Vault CRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Vault CRM with the DevExpress Windows Forms and Web controls to provide Veeva Vault & Vault CRM to a chart.
-
Create Data Visualizations in Cognos BI with Slack Data
Access Slack as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Harvest-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Harvest.
-
LINQ to Paddle 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 Paddle Data Provider.
-
How to Seamlessly Import SFTP Data into IBM SPSS Modeler
Integrate SFTP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Excel Spreadsheet Automation on Google Spanner Data with the QUERY Formula
Pull data from Google Spanner, automate spreadsheets, and more with the QUERY formula.
-
How to Query CloudConvert Data in MySQL Workbench
Execute MySQL queries against live CloudConvert from MySQL Workbench.
-
Import Real-Time PostgreSQL Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PostgreSQL in ColdFusion.
-
SAP BusinessObjects BI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP BusinessObjects BI facts in real time.
-
Replicate Multiple Microsoft Ads Accounts via the CData Sync CLI
Replicate multiple Microsoft Ads accounts to one or many databases.
-
How to Build an ETL App for Authorize.Net Data in Python with CData Connect AI
Build ETL pipelines that read and write live Authorize.Net in Python with petl and the CData Connect AI Python SDK.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Odoo actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to create CockroachDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CockroachDB in MySQL .
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Monday.com using the Model Context Protocol.
-
Query Sendwithus Data in ColdFusion
Write standard ColdFusion data access code to connect to Sendwithus.