CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Zoho Projects Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Projects data. Leverage the native support for ODBC in PHP.
-
Access Live Mode Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Mode data from your Excel spreadsheets.
-
Connect to Real-Time ElevenLabs Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ElevenLabs data in Power Apps.
-
Import IBM Informix Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to IBM Informix Data and provide access to live IBM Informix data for custom reports in the Power BI Service.
-
Visualize Live Sage 300 Data in the Power BI Service
Use CData Connect AI to connect to live Sage 300 data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Back Up Google Sheets data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Sheets. In this article, we will employ an SSIS workflow to populate a database with Google Sheets data data.
-
iContact Reporting in OBIEE with the iContact JDBC Driver
Deploy the iContact JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Apps with Live Amazon Marketplace Data Using the Low-Code Development Platform of Mendix
Connect Amazon Marketplace data with Mendix to build apps using the CData JDBC Driver for Amazon Marketplace.
-
Build Apps with Live Bitbucket data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Bitbucket data into the Adalo platform and build custom mobile and web applications with real-time Bitbucket data.
-
Connect Suadeo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Suadeo data using the CData Python MCP Server.
-
How to Easily Query SpaceX Data in OpenOffice Base
Connect to SpaceX data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Cursor with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Analytics data from within the editor.
-
Connect to Azure Table Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Table data in Airbyte.
-
How to Connect to Anaplan Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Anaplan data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Confluence with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Confluence with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Confluence data.
-
Migrating data from Bitly to Google BigQuery using CData SSIS Components.
Easily push Bitly data to Google BigQuery using the CData SSIS Tasks for Bitly and Google BigQuery.
-
Migrating data from Parallel to Snowflake using CData SSIS Components.
Easily push Parallel data to Snowflake using the CData SSIS Tasks for Parallel and Snowflake.
-
Integrate Paddle with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paddle with External Services.
-
How to load Opsgenie data into Elasticsearch via Logstash
Introducing a simple method to load Opsgenie data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous ZohoSubscriptions Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SQLite.
-
Visualize Hubstaff Data in Sisense
Create an ElastiCube in Sisense app with access to Hubstaff data.
-
Write a Simple Go Application to work with SageHR Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SageHR data.
-
How to Create Power BI Visual Reports with Real-Time Instantly Data
Use CData Power BI Connectors to visualize Instantly data in Power BI.
-
Visualize Active Directory 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 Active Directory data into TIBCO Spotfire.
-
Build Semantic Layer Views for Google Spanner Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Spanner data.
-
Connect to Redis Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Redis data from Filemaker Pro on Mac.
-
Create Data Visualizations Based On Klaviyo Data in Mode
Use CData Connect AI to connect to Klaviyo Data from Mode and build visualizations using live Klaviyo data.
-
Integrate PayPal with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PayPal with External Services.
-
Build a Singer.io Tap for Highrise With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Highrise data using the CData Python Connector.
-
Connect to and Visualize Live Paddle Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paddle data.
-
Automated Continuous Shortcut Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shortcut replication to IBM DB2.
-
How to Work with Vault CRM Data in AWS Glue Jobs Using JDBC
Connect to Vault CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Teamgate Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teamgate replication to IBM DB2.
-
Integrate Aweber Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Aweber data and integrate live Aweber data into your Power Automate tasks.
-
Build an OLAP Cube in SSAS from Short.io Data
Establish a connection to Short.io data data from SQL Server Analysis Services, and use the Short.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Cosmos DB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Cosmos DB data and visualize live Cosmos DB data in Infragistics Reveal.
-
Getting Started with the CData JDBC Driver for Mouseflow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mouseflow.
-
Getting Started with the CData Excel Add-In for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP SuccessFactors LMS.
-
How to Connect Flowise AI Agents to Live Greenhouse Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Greenhouse data without replication.
-
Integrate with Retently Data in JReport Designer
Create charts and reports based on Retently data in JReport Designer.
-
Build Salesforce CRM Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce CRM Analytics data.
-
Integrating Codex with Google Analytics 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 with AlloyDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live AlloyDB data in SnapLogic.
-
How to Visualize FreshBooks Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live FreshBooks data in Python.
-
Getting Started with the CData Power BI Connector for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Mistral AI Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mistral AI to connect to Mistral AI data and execute queries in PowerBuilder.
-
How to create Mocean federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mocean data in MySQL .
-
Intercom Reporting in OBIEE with the Intercom JDBC Driver
Deploy the Intercom JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate Google Calendar with Apache Airflow
Access and process Google Calendar data in Apache Airflow using the CData JDBC Driver.
-
Connect to Snapchat Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Snapchat Ads data in the Denodo Virtual DataPort Administrator.
-
Object-Relational Mapping (ORM) with Google Calendar 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 Calendar data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Wistia Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wistia replication to SQL Server.
-
How to work with Facebook Ads Data in Apache Spark using SQL
Access and process Facebook Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Google Forms Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Forms replication to Apache Kafka.
-
How to work with Short.io Data in Apache Spark using SQL
Access and process Short.io Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for SAP Fieldglass from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Fieldglass data in Excel.
-
Access Auth0 Data from MySQL in PHP
Connect to Auth0 through the standard MySQL libraries in PHP.
-
Connect to Google Cloud Storage Data from a Connection Pool in JBoss
Integrate Google Cloud Storage data into Java servlets: Use the Management Console in JBoss to install the Google Cloud Storage JDBC Driver.
-
Model, Search, and Visualize Live SparkPost Data in ThoughtSpot
Use CData Connect AI to connect to live SparkPost data for modeling, searching, and visualizing.
-
Bridge Zoom Connectivity with Apache NiFi
Access and process Zoom data in Apache NiFi using the CData JDBC Driver.
-
Extract, Transform, and Load Sybase Data in Informatica PowerCenter
Create a simple Workflow for Sybase data in Informatica PowerCenter.
-
Build Agents in Relevance AI with Access to Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Timely data within intelligent agent workflows.
-
Connect to Live FTP Data in PostGresSQL Interface through CData Connect AI
Create a live connection to FTP in CData Connect AI and connect to your FTP data from PostgreSQL.
-
Work with Live BenchmarkEmail Data in Power Query
Use CData Connect AI to connect to BenchmarkEmail data and work with live BenchmarkEmail data in Microsoft Power Query.
-
Seamlessly Bring OneNote Data into Retool Using CData Connect AI
Integrate OneNote data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Kiro with Sybase 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 Semantic Layer Views for XML Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for XML data.
-
Choosing the Best Method to Connect Zuora to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zuora data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Accelo Replication to Oracle
Use CData Sync for automated, continuous, customizable Accelo replication to Oracle.
-
How to Connect Flowise AI Agents to Live HDFS Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live HDFS data without replication.
-
Manage CloudConvert Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CloudConvert.
-
Create Reports with Pipedrive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipedrive data.
-
Integrate with Live Facebook Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Facebook Ads from the MuleSoft Anypoint Platform to integrate live Facebook Ads data into custom reports and dashboards.
-
Integrate with Cloudflare Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Cloudflare data in SnapLogic.
-
Build a PostgreSQL Interface for Lakebase Data using the CData JDBC Driver
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect Amazon QuickSight to MYOB AccountRight Data
Create a connection to MYOB AccountRight data in CData Connect AI and insert MYOB AccountRight data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Tableau Connector for Zuora
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zuora.
-
Raisers Edge NXT Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Raisers Edge NXT facts in real time.
-
Create Kintone Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Kintone from PowerBI.com to create Power BI Dataflows with real-time data.
-
Working with SAP Hybris C4C Data in LINQPad
Execute LINQ queries to SAP Hybris C4C data in LINQPad.
-
Use the CData Software ODBC Driver for Couchbase in MicroStrategy Web
Connect to Couchbase data in MicroStrategy Web using the CData Software ODBC Driver for Couchbase.
-
Integrating Claude Code CLI with Jira 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.
-
Integrating LlamaIndex with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Couchbase data in real time.
-
Build Visualizations of Act-On Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Act-On data in Birst.
-
Enable the Access JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Access data.
-
Use the CData ODBC Driver for Splunk in Microsoft Power Query
You can use the CData Splunk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Splunk data into Microsoft Power Query.
-
Build Apps with Live SAP Business One Data Using the Low-Code Development Platform of Mendix
Connect SAP Business One data with Mendix to build apps using the CData JDBC Driver for SAP Business One.
-
Visualize Live Acumatica Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Acumatica data.
-
Automated Continuous Reckon Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Reckon replication to delimited files (CSV/TSV).
-
Connecting Agentforce with Amazon S3 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Amazon S3 data for you.
-
Automated Continuous Amazon S3 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon S3 replication to AlloyDB.
-
Automated Continuous Tavily Replication to SQL Server
Use CData Sync for automated, continuous, customizable Tavily replication to SQL Server.
-
Automated Continuous GraphQL Replication to Oracle
Use CData Sync for automated, continuous, customizable GraphQL replication to Oracle.
-
How to Connect DBeaver to Quickbase via a JDBC Driver
Manage Quickbase data with visual tools in DBeaver like the query browser.
-
Connect to Salesforce Data in Jaspersoft Studio
Execute SQL to remote Salesforce data in Jaspersoft Studio.
-
Automated Continuous Todoist Replication to MySQL
Use CData Sync for automated, continuous, customizable Todoist replication to MySQL.
-
Consume SuiteCRM OData Feeds in PowerBuilder
This article demonstrates how to consume SuiteCRM data as OData feeds from PowerBuilder using the API Server.
-
Build a Simple VCL Application for Supabase Data
How to build a simple VCL Application to view Supabase data in RAD Studio using the CData ODBC Driver for Supabase.
-
Replicate Multiple Insightly Accounts via the CData Sync CLI
Replicate multiple Insightly accounts to one or many databases.
-
Import and Visualize Intercom Data in Power View
Create data visualizations based on Intercom data in Excel.