CData Software - Knowledge Base
Recent Articles
-
Build AI/ML Models with Live MYOB AccountRight Data using Dataiku
Connect MYOB AccountRight Data with Dataiku using the CData JDBC Driver for MYOB AccountRight.
-
Visualize Stripe Data in Tableau
The CData ODBC driver for Stripe enables you integrate Stripe into Tableau dashboards.
-
Replicate Multiple Oracle SCM Accounts via the CData Sync CLI
Replicate multiple Oracle SCM accounts to one or many databases.
-
Migrating data from iContact to Snowflake using CData SSIS Components.
Easily push iContact to Snowflake using the CData SSIS Tasks for iContact and Snowflake.
-
Build Agents in Relevance AI with Access to Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAS XPORT within intelligent agent workflows.
-
Build Dashboards with Helpscout Data in DBxtra
Create dynamic dashboards and perform analytics based on Helpscout in DBxtra.
-
Use the CData Software ODBC Driver for Pipeline CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Pipeline CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pipeline CRM.
-
Connect and Visualize Live Zoho Books Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Books into the Databricks platform and create visualization dashboards with real-time Zoho Books.
-
DataBind Charts to Microsoft OneDrive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft OneDrive from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to SendInBlue Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to SendInBlue and work with SendInBlue in your FileMaker applications.
-
Create SSAS Tabular Models from Vimeo Data
How to build a SQL Server Analysis Service Tabular Model from Vimeo using CData drivers.
-
Use the CData Software JDBC Driver for ZeroBounce in MicroStrategy
Connect to ZeroBounce in MicroStrategy Developer using the CData Software JDBC Driver for ZeroBounce.
-
How to Work with Todoist Data in ETL Validator JDBC
Connect to Todoist from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Float from Asprova with CData Software ODBC Driver for Float
This article shows how to connect faster to Float data from Asprova.
-
Create SSAS Tabular Models from Zoho CRM Data
How to build a SQL Server Analysis Service Tabular Model from Zoho CRM using CData drivers.
-
Edit and Search CockroachDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of CockroachDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create CockroachDB objects that you can access from apps and the dashboard.
-
Integrate Adobe Experience Manager Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Experience Manager in the Pentaho Data Integration tool.
-
Integrating SAP Data in Talend Cloud Data Management Platform
Connect SAP Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP.
-
Integrate Salesforce Marketing Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Marketing Cloud from Informatica Cloud.
-
LINQ to GitLab 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 GitLab Data Provider.
-
Access Live WordPress Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live WordPress data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Build an ETL App for Odoo Data in Python with CData
Create ETL applications and real-time data pipelines for Odoo ERP in Python with petl.
-
Create Mode Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mode from PowerBI.com to create Power BI Dataflows with real-time data.
-
Establish a Live Connection with HBase Data using Tableau Bridge
The CData ODBC Driver for HBase enables you to integrate live Apache HBase into Tableau Cloud dashboards using the Tableau Bridge.
-
Access iContact Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access iContact from your Oracle system.
-
Integrating Codex CLI with ShipEngine 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 Seamlessly Import Salesforce CRM Analytics Data into IBM SPSS Modeler
Integrate Salesforce CRM Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData API Server to Access HDFS Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apache HDFS in the Power Pivot business intelligence tool.
-
Hubstaff Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Hubstaff facts in real time.
-
Publish Crystal Reports on Apollo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apollo.
-
Connect to and Query Microsoft Entra ID Data in QlikView over ODBC
Create data visualizations with Microsoft Entra ID in QlikView.
-
Use the CData Software JDBC Driver for RSS in MicroStrategy Desktop
Connect to RSS Feeds in MicroStrategy Desktop using the CData Software JDBC Driver for RSS.
-
How to connect and process Jodoo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Jodoo.
-
Connect to EnterpriseDB Data in ACL Analytics
Connect to EnterpriseDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to EnterpriseDB.
-
Connect to Excel Online Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Excel Online Data and connect to Microsoft Excel Online in Akorbi Digital RunMyProcess.
-
How to Query Live HDFS Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache HDFS data in natural language using Python.
-
Build Data Flows from Gorgias to SQL Server using SSIS
Easily back up Gorgias to SQL Server using the SSIS components for Gorgias.
-
Rapidly Develop Planio-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Planio.
-
Automate Asana Data Replication to Azure Synapse
Use CData Sync to customize and automate Asana replication to Azure Synapse.
-
How to Easily Query SAP Data in OpenOffice Base
Connect to SAP data in OpenOffice Base using the CData ODBC Driver for SAP and generate reports with live data insights.
-
Integrating Claude Code CLI with EmailOctopus 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.
-
Integrate Theia IDE with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Seamlessly Bring GraphQL Data into Retool Using CData Connect AI
Integrate GraphQL data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
A PostgreSQL Interface for Perigon Data using the CData ODBC Driver
Use the SQL Gateway and Perigon ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate WordPress Data from PowerShell
Write a quick PowerShell script to query WordPress. Use connectivity to the live data to replicate WordPress to SQL Server.
-
Access Amazon DynamoDB Data from MySQL in PHP
Connect to Amazon DynamoDB through the standard MySQL libraries in PHP.
-
Connect to Pipeline CRM Data from a Connection Pool in Jetty
The Pipeline CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Pipeline CRM from Web apps in Jetty.
-
Import Real-Time Google Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Ads in ColdFusion.
-
Using the CData Software ODBC Driver for Superchat in PyCharm
Connect to Superchat as an ODBC data source in PyCharm using the CData Software ODBC Driver for Superchat.
-
Excel Spreadsheet Automation on Dynamics CRM Data with the QUERY Formula
Pull data from Dynamics CRM, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Zoho Projects Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Amazon S3.
-
Add BambooHR Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for BambooHR with the Informatica Enterprise Data Catalog to classify and organize data.
-
Stream LionDesk Data into Apache Kafka Topics
Access and stream LionDesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Smartsheet-Connected Apps in Choreo
Use CData Connect AI to connect to Smartsheet Data from Choreo and build custom apps using live Smartsheet.
-
Access MongoDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MongoDB from your Oracle system.
-
Use Claude to Talk to Your Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Amazon Redshift for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Intercom
Provide connectivity to Intercom through an SAP BusinessObjects universe.
-
Visualize Email 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 Email into TIBCO Spotfire.
-
Create Square Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Square from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Build an ETL App for Klipfolio Data in Python with CData
Create ETL applications and real-time data pipelines for Klipfolio in Python with petl.
-
Connect to xBase Data from PowerBuilder via ADO.NET
This article demonstrates how to access xBase from Appeon PowerBuilder using the CData ADO.NET Provider for xBase.
-
Getting Started with the CData ADO.NET Provider for GitLab
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Snapchat Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Apache Cassandra.
-
Build a Singer.io Tap for Clockify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Clockify data using
-
Getting Started with the CData Tableau Connector for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP SuccessFactors.
-
Connect to Hacker News Data in RazorSQL
Connect to Hacker News from wizards and query Hacker News from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ODBC Driver for BigQuery
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for BigQuery.
-
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy Web
Connect to QuickBooks Desktop in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks.
-
How to Work with XML Data in ETL Validator JDBC
Connect to XML from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create an RPA flow for Unbounce Data in UiPath Studio
Use the Unbounce ODBC Driver to create workflows that access real-time Unbounce without any coding.
-
Easily Integrate MarkLogic Data in Lazarus Pascal IDE
Learn how to easily integrate live MarkLogic in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Ontraport Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Ontraport in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to integrate Metabase with Salesforce CRM Analytics Data
Use CData Connect AI to connect to live Salesforce CRM Analytics and create an interactive dashboard in Metabase from Salesforce CRM Analytics.
-
How to create Epicor Kinetic federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Epicor Kinetic in MySQL .
-
Use the CData Software ODBC Driver for ConstantContact in MicroStrategy
Connect to ConstantContact in MicroStrategy Developer using the CData Software ODBC Driver for ConstantContact.
-
Connect to SendGrid Data from PowerBuilder via JDBC
This article demonstrates how to access SendGrid from PowerBuilder using the SendGrid JDBC Driver.
-
How to update Zoho Creator from Excel
This article explains how to transfer data from Excel to Zoho Creator using the Excel Add-In for Zoho Creator.
-
How to load Supabase data into Elasticsearch via Logstash
Introducing a simple method to load Supabase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish GraphQL-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GraphQL.
-
Create a Data Access Object for Aircall Data using JDBI
A brief overview of creating a SQL Object API for Aircall in JDBI.
-
Use Dash to Build Web Apps on Google Contacts Data via CData Connect AI
Build interactive Dash web apps on live Google Contacts using pandas and the CData Connect AI Python SDK.
-
Connect to Bannerbear Data in RapidMiner
Integrate Bannerbear with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Dash to Build Web Apps on Tally Data via CData Connect AI
Build interactive Dash web apps on live Tally ERP using pandas and the CData Connect AI Python SDK.
-
Build Apps with Live Mailjet Data Using the Low-Code Development Platform of Mendix
Connect Mailjet with Mendix to build apps using the CData API Driver for JDBC.
-
Automate Humanity Data Replication to SAP HANA
Use CData Sync to customize and automate Humanity replication to SAP HANA.
-
Integrating Claude Code with CockroachDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on CockroachDB within assisted coding and automated development workflows.
-
Object-Relational Mapping (ORM) with AlloyDB Data 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 AlloyDB into a Java-based ORM framework, Hibernate.
-
Connect to Adobe Target Data from a Connection Pool in JBoss
Integrate Adobe Target into Java servlets: Use the Management Console in JBoss to install the Adobe Target JDBC Driver.
-
Integrate PostgreSQL Data in Pentaho Data Integration
Build ETL pipelines based on PostgreSQL in the Pentaho Data Integration tool.
-
Model, Search, and Visualize Live CockroachDB Data in ThoughtSpot
Use CData Connect AI to connect to live CockroachDB for modeling, searching, and visualizing.
-
Feed Planio Data into FineReport
How to set Planio as a JDBC data source in FineReport.
-
Import Google Drive Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Drive Data and provide access to live Google Drive for custom reports in the Power BI Service.
-
Connect to Vault CRM from Asprova with CData Software ODBC Driver for Vault CRM
This article shows how to connect faster to Vault CRM data from Asprova.
-
Connect to LDAP Objects in Aqua Data Studio
Access LDAP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Import Data from Parquet into Google Sheets
Import Apache Parquet into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous HDFS Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HDFS replication to Google BigQuery.
-
Excel Spreadsheet Automation on Customer.io Data with the QUERY Formula
Pull data from Customer.io, automate spreadsheets, and more with the QUERY formula.
-
Natively Connect to Stack Exchange Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Stack Exchange. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Wistia Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Wistia in Birst.
-
Build Apps with Live Marketo in Adalo using CData Connect AI
Use CData Connect AI to integrate live Marketo into the Adalo platform and build custom mobile and web applications with real-time Marketo.