CData Software - Knowledge Base
Recent Articles
-
Build Reply.io-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Reply.io and build web apps with connectivity to live Reply.io.
-
Replicate Multiple ActiveCampaign Accounts via the CData Sync CLI
Replicate multiple ActiveCampaign accounts to one or many databases.
-
Connect to Zoho CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous LeadDesk Replication to Oracle
Use CData Sync for automated, continuous, customizable LeadDesk replication to Oracle.
-
How to use SQLAlchemy ORM to access QuickBooks Time Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Time.
-
Integrating GitHub Copilot CLI with Exact Online 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.
-
Use the CData Software ODBC Driver for Paddle in MicroStrategy
Connect to Paddle in MicroStrategy Developer using the CData Software ODBC Driver for Paddle.
-
Getting Started with the CData Connect AI Python SDK for Azure Table
Install the CData Connect AI Python SDK to read and write live Azure Table Storage with standard DB-API 2.0 Python code.
-
Build Marketo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Marketo Data and create custom apps in Mendix.
-
Query Neo4J Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Neo4J from Node.js.
-
How to publish and share Quickbase Data dashboards with Tableau Server
The CData ODBC driver for Quickbase enables you integrate Quickbase into Tableau dashboards.
-
Connect to ADP Data in Claris FileMaker Pro
Use the CData ODBC Driver for ADP in FileMaker Pro to connect to ADP and work with ADP in your FileMaker applications.
-
Automated Continuous HubSpot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HubSpot replication to Apache Kafka.
-
Connect to QuickBooks Time Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for QuickBooks Time and the SQL Gateway to access QuickBooks Time from Google Apps Script.
-
Build Google Sheets-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Sheets.
-
Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy Desktop
Connect to SuiteCRM in MicroStrategy Desktop using the CData Software JDBC Driver for SuiteCRM.
-
Design BIRT Reports on Moosend Data
Provide current Moosend to your embedded analytics.
-
Easily Integrate JotForm Data in Lazarus Pascal IDE
Learn how to easily integrate live JotForm in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to FHIR Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live FHIR.
-
Integrate with Mouseflow Data in JReport Designer
Create charts and reports based on Mouseflow in JReport Designer.
-
Operational Reporting on SAP Fieldglass Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Fieldglass.
-
Moving Data from Google Spanner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Spanner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Power BI Reports on Real-Time iContact Data
Use the CData ODBC Driver for iContact to visualize iContact in Power BI Desktop.
-
Connect to Odoo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Odoo ERP from Appeon PowerBuilder using the CData ADO.NET Provider for Odoo.
-
Integrating Claude Code CLI with Blackbaud FE NXT 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.
-
Migrating data from Outreach.io to Snowflake using CData SSIS Components.
Easily push Outreach.io to Snowflake using the CData SSIS Tasks for Outreach.io and Snowflake.
-
Integrate Couchbase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Couchbase and integrate live Couchbase into your Power Automate tasks.
-
LINQ to Customer.io 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 Customer.io Data Provider.
-
Access SQL Server Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft SQL Server from your Oracle system.
-
Deploy the ADO.NET Provider for Amazon DynamoDB on an SSRS Report Server
Connect to Amazon DynamoDB 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.
-
Getting Started with the CData Excel Add-In for Codat
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Codat.
-
Integrating Cursor CLI with Workday 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 create an RPA flow for Azure Data Lake Storage Data in UiPath Studio
Use the Azure Data Lake Storage ODBC Driver to create workflows that access real-time Azure Data Lake Storage without any coding.
-
Use the CData Software ODBC Driver for Paymo in SAS for Real-Time Reporting and Analytics
Connect to real-time Paymo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paymo.
-
Rapidly Develop Cvent-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 Cvent.
-
Connect to ZeroBounce Data in Aqua Data Studio
Access ZeroBounce from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Avalara AvaTax Data in Coginiti Pro
Connect to and query live Avalara AvaTax from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live Sybase IQ Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sybase IQ into custom reports in Power BI.
-
Connect to SAP Fieldglass Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Fieldglass.
-
Integrate SAP HANA Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP HANA and integrate live SAP HANA into your Power Automate tasks.
-
Integrate Cursor with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live CSV/TSV Files from within the editor.
-
Access SharePoint Excel Services 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 SharePoint Excel Services.
-
Natively Connect to Email Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Email. Leverage the native support for ODBC in PHP.
-
Replicate ZohoExpense Data to Multiple Databases
Replicate ZohoExpense to disparate databases with a point-and-click configuration.
-
Connect to Instantly Data in RazorSQL
Connect to Instantly from wizards and query Instantly from the GUI in the RazorSQL database management tool.
-
How to use SQLAlchemy ORM to access ShipEngine Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ShipEngine.
-
DataBind Ontraport Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Ontraport to a chart.
-
Integrate with live EnterpriseDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live EnterpriseDB in Jitterbit.
-
Query GraphQL Data in DataGrip
Create a Data Source for GraphQL in DataGrip and use SQL to query live GraphQL.
-
Connect to Optimizely Data from PowerBuilder via ADO.NET
This article demonstrates how to access Optimizely from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automate Everhour Data Replication to SAP HANA
Use CData Sync to customize and automate Everhour replication to SAP HANA.
-
Visualize ConvertKit Data in Sisense
Create an ElastiCube in Sisense app with access to ConvertKit.
-
How to Connect DBeaver to Browserless via a JDBC Driver
Manage Browserless with visual tools in DBeaver like the query browser.
-
Create Zuora Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zuora from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize ZendeskSell Data in Tableau
The CData ODBC driver for ZendeskSell enables you integrate ZendeskSell into Tableau dashboards.
-
How to Visualize Wave Financial Data in Python with pandas
Use pandas and other modules to analyze and visualize live Wave Financial in Python.
-
How to Access ZendeskSell Data Using Entity Framework
This article shows how to access ZendeskSell using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Redshift Data Replication to SAP HANA
Use CData Sync to customize and automate Amazon Redshift replication to SAP HANA.
-
Analyze Hugging Face Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Hugging Face with the CData JDBC Driver for Hugging Face.
-
How to load Drip data into Elasticsearch via Logstash
Introducing a simple method to load Drip data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Airtable-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Airtable to explore live Airtable Data in Cursor to assist with building Airtable-powered applications.
-
Build Charts with MailChimp Data in Clear Analytics
Create dynamic charts and perform analytics based on MailChimp in Clear Analytics.
-
Integrate with Figshare Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Figshare to a JSON file on disk.
-
Build a PostgreSQL Interface for Google Campaign Manager 360 Data using the CData JDBC Driver
Use the Remoting features of the Google Campaign Manager 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize HelloSign Data in TIBCO Spotfire through ADO.NET
Integrate HelloSign into dashboards in TIBCO Spotfire.
-
How to Connect to & Open Outreach.io Data in Microsoft Excel
This article uses the CData ODBC driver for Outreach.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
View Reports on Real-Time Quickbase Data in Power BI Report Server
Use the CData ODBC Driver for Quickbase to visualize Quickbase in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Live Insightly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Insightly data in natural language using Python.
-
Consume Anaplan OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Anaplan feeds that reflect any changes in SAP Lumira.
-
Use the CData Software ODBC Driver for Shippo in SAS for Real-Time Reporting and Analytics
Connect to real-time Shippo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Shippo.
-
How to Connect the Power BI Service to Google Ads: Complete Guide
Connect to the CData Software Power BI Connector for Google Ads from PowerBI.com to provide real-time Google Ads across the organization.
-
Connect to Dotmailer from Asprova with CData Software ODBC Driver for Dotmailer
This article shows how to connect faster to Dotmailer data from Asprova.
-
Getting Started with the CData JDBC Driver for SAP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP.
-
Access PostgreSQL Data from MySQL in PHP
Connect to PostgreSQL through the standard MySQL libraries in PHP.
-
Integrate with live Amazon S3 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon S3 in Jitterbit.
-
Create Data Visualizations in Cognos BI with Google Cloud Storage Data
Access Google Cloud Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Cassandra Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Excel Add-In for Monday.com
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Monday.com.
-
Connect and Visualize Live Workday Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Workday into the Databricks platform and create visualization dashboards with real-time Workday.
-
Getting Started with the CData ADO.NET Provider for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate with live Zoom Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoom in Jitterbit.
-
Viewing Gorgias Data in RAD Studio Data Explorer
How to view Gorgias in RAD Studio Data Explorer using the CData ODBC Driver for Gorgias.
-
Getting Started with the CData JDBC Driver for Flowlu
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Flowlu.
-
Import and Visualize Missive Data in Power View
Create data visualizations based on Missive in Excel.
-
Getting Started with the CData ODBC Driver for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle Service Cloud.
-
Access MailerLite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MailerLite from HeidiSQL.
-
A PostgreSQL Interface for PayPal Data (MySQL Remoting via JDBC)
Use the Remoting features of the PayPal JDBC Driver to create a PostgreSQL entry-point for data access.
-
Extract, Transform, and Load ClickUp Data in Informatica PowerCenter
Create a simple Workflow for ClickUp in Informatica PowerCenter.
-
Integrating GitHub Copilot CLI with LeadDesk 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 Google Ad Manager Data into IBM SPSS Modeler
Integrate Google Ad Manager data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Access Salesforce Pardot Data Using Entity Framework
This article shows how to access Salesforce Pardot using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Claude Code CLI with Wistia 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.
-
Getting Started with the CData Power BI Connector for VWO
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software ODBC Driver for Optimizely in MicroStrategy Web
Connect to Optimizely in MicroStrategy Web using the CData Software ODBC Driver for Optimizely.
-
Visualize Greenhouse 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 Greenhouse into TIBCO Spotfire.
-
Getting Started with the CData Tableau Connector for Typeform
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Unbounce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Unbounce from Informatica Cloud.
-
Moving Data from Auth0 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Auth0 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Crystal Reports on Sage 300 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 300.
-
Access Live Greenplum Data in Coginiti Pro
Connect to and query live Pivotal GreenPlum from the GUI in the Coginiti Pro: SQL Analytics Tool.