CData Software - Knowledge Base
Recent Articles
-
Connect to WooCommerce Data in RapidMiner
Integrate WooCommerce with standard components and data source configuration wizards in RapidMiner Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Rootly
Provide connectivity to Rootly through an SAP BusinessObjects universe.
-
Access Live Adobe Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Adobe Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate FreeAgent with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FreeAgent with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FreeAgent.
-
Access Live Google Contacts Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Contacts from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Visualize Shopify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Shopify in Python.
-
Integrate LibreChat with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Apache Avro from within the chat interface.
-
Create Greenplum-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Greenplum Data from Klipfolio and build custom visualizations using live Pivotal GreenPlum.
-
How to connect SharePoint with Jira Assets Data through external lists
Provide Jira Assets to SharePoint users as an external list.
-
How to Connect to Live SQL Analysis Services 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 SQL Analysis Services for you.
-
Query Sage Intacct Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Sage Intacct and perform CRUD operations on Sage Intacct from Node.js.
-
Connect to Cloudant Data in ACL Analytics
Connect to IBM Cloudant via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to IBM Cloudant.
-
Load ScrapingBee Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ScrapingBee to a database.
-
How to Connect to Live QuickBooks Online 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 QuickBooks Online for you.
-
Create Data Visualizations Based On Raisers Edge NXT Data in Mode
Use CData Connect AI to connect to Raisers Edge NXT Data from Mode and build visualizations using live
-
How to integrate Scrapfly with Apache Airflow
Access and process Scrapfly in Apache Airflow using the CData JDBC Driver.
-
Visualize Live HBase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache HBase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy Desktop
Connect to LightSpeedRetail in MicroStrategy Desktop using the CData Software ODBC Driver for LightSpeedRetail.
-
Use the CData Software JDBC Driver for Clockify in MicroStrategy Web
Connect to Clockify in MicroStrategy Web using the CData Software JDBC Driver for Clockify.
-
Connect to Vimeo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Work with Excel Online Data in AWS Glue Jobs Using JDBC
Connect to Excel Online from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Deploy the ADO.NET Provider for Microsoft Ads on an SSRS Report Server
Connect to Microsoft Ads 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.
-
Integrating OpenCode Terminal with IBM Informix 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.
-
Natively Connect to Intercom Data in PHP
The CData ODBC driver for Intercom enables you to create PHP applications with connectivity to Intercom. Leverage the native support for ODBC in PHP.
-
Connect to Twitter Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Twitter Ads in Airbyte.
-
Build Agents in Relevance AI with Access to Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Act-On within intelligent agent workflows.
-
Build Visualizations of Elorus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Elorus in Birst.
-
Getting Started with the CData ADO.NET Provider for ShipStation
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for ShipStation.
-
Extend Google Sheets with Epicor Kinetic Data
Make calls to Epicor Kinetic from Google Apps Script via the API Server.
-
Integrating Claude Code with Zuora Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zuora within assisted coding and automated development workflows.
-
Automate Klipfolio Data Replication to Azure Synapse
Use CData Sync to customize and automate Klipfolio replication to Azure Synapse.
-
Use the CData Software ODBC Driver for SAP ByDesign in MicroStrategy
Connect to SAP Business ByDesign in MicroStrategy Developer using the CData Software ODBC Driver for SAP ByDesign.
-
Connect to Jira Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Atlassian Jira.
-
Integrate JDBC-ODBC Bridge with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate JDBC-ODBC Bridge with External Services.
-
Automated Continuous Zoom Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoom replication to Databricks.
-
Migrating data from MarkLogic to Databricks using CData SSIS Components.
Easily push MarkLogic to Databricks using the CData SSIS Tasks for MarkLogic and Databricks.
-
Bind Live Shopify Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Shopify data
-
Automate Amplitude Data Replication to SAP HANA
Use CData Sync to customize and automate Amplitude replication to SAP HANA.
-
How to Visualize Salesforce 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 Salesforce & Force.com in Python.
-
Connect to SendGrid Data from PowerBuilder via ADO.NET
This article demonstrates how to access SendGrid from Appeon PowerBuilder using the CData ADO.NET Provider for SendGrid.
-
Automated Continuous LightSpeedRetail Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to PostgreSQL.
-
Automated Continuous Insightly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Insightly replication to Snowflake.
-
Connect to Snapchat Ads Data in HULFT Integrate
Connect to Snapchat Ads as a JDBC data source in HULFT Integrate
-
Integrate with live BambooHR Data in Jitterbit
Use CData Connect AI to connect to and integrate live BambooHR in Jitterbit.
-
Analyze Apollo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apollo in Microsoft R Open.
-
Connect to Kintone Data from a Connection Pool in Jetty
The Kintone JDBC Driver supports connection pooling: This article shows how to connect faster to Kintone from Web apps in Jetty.
-
Object-Relational Mapping (ORM) with Copper 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 Copper into a Java-based ORM framework, Hibernate.
-
Connect to SharePoint in SpagoBI
Create reports featuring live Microsoft SharePoint in SpagoBI Studio. Host SharePoint reports on SpagoBI Server.
-
Write a Simple Go Application to work with Teamgate Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teamgate.
-
Automated Continuous CSV Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CSV replication to Google Cloud SQL.
-
Connect to Outlook from a Connection Pool in WebLogic
Use the CData JDBC Driver for Outlook to connect to Outlook from Web applications running on WebLogic.
-
Connect to Oracle Sales Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Sales.
-
Connect to Strava from a Connection Pool in WebLogic
Use the CData JDBC Driver for Strava to connect to Strava from Web applications running on WebLogic.
-
Design BIRT Reports on HDFS Data
Provide current Apache HDFS to your embedded analytics.
-
Query Telegram Data in DataGrip
Create a Data Source for Telegram in DataGrip and use SQL to query live Telegram.
-
Connect to Twilio Data in DBeaver
Use the CData ODBC Driver to connect to Twilio in DBeaver.
-
Build a Singer.io Tap for FHIR With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FHIR data using
-
Access Live Teradata Data in AWS Lambda
Connect to live Teradata in AWS Lambda using the CData JDBC Driver.
-
Connect to Real-Time ShipStation Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ShipStation and Dataflow to import and use ShipStation in Power Apps.
-
Connect to Parquet from Asprova with CData Software ODBC Driver for Parquet
This article shows how to connect faster to Parquet data from Asprova.
-
Create a Data Access Object for SAP SuccessFactors LMS Data using JDBI
A brief overview of creating a SQL Object API for SAP SuccessFactors LMS in JDBI.
-
Use JayDeBeApi to access Suadeo Data in Python
Use standard Python scripting and the development environment of your choice to access live Suadeo.
-
Work with Nethunt Data in FoxPro
Load Nethunt into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Query Live CockroachDB Data in Claude Desktop
Connect to and query live CockroachDB Data in Claude Desktop using CData MCP Server.
-
Operational Reporting on Procore Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Procore.
-
Stream Azure Synapse Data into Apache Kafka Topics
Access and stream Azure Synapse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Outreach.io-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Outreach.io to explore live Outreach.io Data in Gemini Code Assist to assist with building Outreach.io-powered applications.
-
How to Build an ETL App for Pinterest Data in Python with CData
Create ETL applications and real-time data pipelines for Pinterest in Python with petl.
-
How to use SQLAlchemy ORM to access Omnisend Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Omnisend.
-
Getting Started with the CData Python Connector for Rebilly
Learn to install and license the CData Python Connector
-
Connect and Visualize Live LinkedIn Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live LinkedIn Ads into the Databricks platform and create visualization dashboards with real-time LinkedIn Ads.
-
How to Connect to & Open IBM Cloud Object Storage Data in Microsoft Excel
This article uses the CData ODBC driver for IBM Cloud Object Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
LINQ to Oracle 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 Oracle Data Provider.
-
Edit and Search External PayPal Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PayPal to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PayPal Data objects that you can access from apps and the dashboard.
-
DataBind Controls to Pipedrive Data in Delphi
DataBind to Pipedrive in Delphi with standard data access components and controls.
-
Automated Continuous SAP Hybris C4C Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Amazon S3.
-
Build CouchDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache CouchDB and build visualizations in Tableau.
-
Integrate with DocuSign Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy DocuSign to a JSON file on disk.
-
Extend Google Sheets with SAP ByDesign Data
Make calls to SAP ByDesign from Google Apps Script via the API Server.
-
Import and Visualize SendGrid Data in Power View
Create data visualizations based on SendGrid in Excel.
-
How to connect and process Spotify from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Spotify.
-
Automated Continuous PayPal Replication to MySQL
Use CData Sync for automated, continuous, customizable PayPal replication to MySQL.
-
Build Act-On-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Act-On.
-
Connect to IBM Informix Data in NetBeans
Connect to IBM Informix in NetBeans with the data source configuration wizard.
-
Build Semantic Layer Views for Pipedrive Data in APOS Live Data Gateway
Use the CData Connector for Pipedrive in APOS Live Data Gateway to build Semantic Layer Views for Pipedrive.
-
Connect to Google Directory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Directory and the SQL Gateway to access Google Directory from Google Apps Script.
-
Use Dash to Build Web Apps on Redis Data via CData Connect AI
Build interactive Dash web apps on live Redis using pandas and the CData Connect AI Python SDK.
-
Moving Data from Notion to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Notion data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Manage Mixpanel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mixpanel.
-
Visualize Workday Data in Tableau
The CData ODBC driver for Workday enables you integrate Workday into Tableau dashboards.
-
Load Sage 300 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage 300 to a database.
-
Validate CSV Data with QuerySurge
Access and validate CSV/TSV Files in QuerySurge using the CData JDBC Driver.
-
Connect to Neo4J Data in JRuby
Create a simple JRuby app with access to live Neo4J.
-
Integrate Live YouTube Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to YouTube Analytics and integrate live YouTube Analytics into apps built in Microsoft Power Apps.
-
How to Connect to & Open eBay Data in Microsoft Excel
This article uses the CData ODBC driver for eBay to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access ClickUp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ClickUp from HeidiSQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Fieldglass within intelligent workflows.
-
Integrating Claude Code with ADP Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ADP within assisted coding and automated development workflows.
-
How to Visualize Snowflake Data in Python with pandas
Use pandas and other modules to analyze and visualize live Snowflake in Python.
-
Connecting Agentforce with Apollo 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 Apollo for you.