CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Email Replication to Vertica
Use CData Sync for automated, continuous, customizable Email replication to Vertica.
-
Bind Live Zoom Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoom data
-
Visualize Facebook 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 into TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Klipfolio
Create an ODBC connection to Klipfolio in Informatica and browse and transfer Klipfolio.
-
Integrate Pipeline CRM Data in the Pentaho Report Designer
Publish reports based on Pipeline CRM in the Pentaho BI tool.
-
Getting Started with the CData Python Connector for MessageBird
Learn to install and license the CData Python Connector
-
Connect to Todoist Data from a Connection Pool in JBoss
Integrate Todoist into Java servlets: Use the Management Console in JBoss to install the Todoist JDBC Driver.
-
Connecting GenSpark with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Atlassian Jira without any replication or custom integration required.
-
Create Datasets from PivotalTracker in Domo Workbench and Build Visualizations of PivotalTracker Data in Domo
Use the CData Software ODBC Driver for PivotalTracker to create datasets from PivotalTracker in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Snapchat Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Snapchat Ads.
-
Access Live Oracle Eloqua Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Eloqua from your Google Sheets.
-
Use the CData Software ODBC Driver for Zoho CRM in MicroStrategy Web
Connect to Zoho CRM in MicroStrategy Web using the CData Software ODBC Driver for Zoho CRM.
-
Integrate with Hive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache Hive in SnapLogic.
-
Build MailChimp-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MailChimp.
-
Rapidly Develop Power BI XMLA-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 Power BI XMLA.
-
Publish Cohere-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cohere.
-
Connect to Microsoft Teams Data in HULFT Integrate
Connect to Microsoft Teams as a JDBC data source in HULFT Integrate
-
Build MVC Applications with Connectivity to Clari Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clari from an ASP.NET MVC application.
-
How to Query Live Freshdesk Data in Perplexity MacOS Desktop
Connect to and query live Freshdesk Data in Perplexity Desktop using CData MCP Server.
-
Connect to CampaignMonitor Data in Aqua Data Studio
Access CampaignMonitor from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Choosing the Best Method to Connect Campaigner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Campaigner from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to create Egnyte federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Egnyte in MySQL .
-
Create Datasets from Short.io in Domo Workbench and Build Visualizations of Short.io Data in Domo
Use the CData Software ODBC Driver for Short.io to create datasets from Short.io in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData ODBC Driver for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks Time.
-
Use the CData Software ODBC Driver for Neo4J in SAS for Real-Time Reporting and Analytics
Connect to real-time Neo4J in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Neo4J.
-
Connect to Facebook 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 Facebook.
-
Bridge Figshare Connectivity with Apache NiFi
Access and process Figshare in Apache NiFi using the CData JDBC Driver.
-
Import and Visualize FreshBooks Data in Power View
Create data visualizations based on FreshBooks in Excel.
-
Integrating GitHub Copilot CLI with ZohoPeople 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.
-
Bridge XML Connectivity with Apache NiFi
Access and process XML Files in Apache NiFi using the CData JDBC Driver.
-
Query ZendeskSell Data in ColdFusion
Write standard ColdFusion data access code to connect to ZendeskSell.
-
Access NetSuite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NetSuite CRM & ERP from your Oracle system.
-
Use Agno to Talk to Your Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Azure DevOps for you.
-
ETL HelloSign in Oracle Data Integrator
This article shows how to transfer HelloSign into a data warehouse using Oracle Data Integrator.
-
Replicate Stripe Data in Heroku for Use in Salesforce Connect
Replicate Stripe to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query ConstantContact Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ConstantContact entities in PHP by modeling them as objects.
-
Consume NetSuite OData Feeds in SAP Lumira
Use the API Server to create data visualizations on NetSuite feeds that reflect any changes in SAP Lumira.
-
Design BIRT Reports on Typeform Data
Provide current Typeform to your embedded analytics.
-
Getting Started with the CData Tableau Connector for Airtable
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Airtable.
-
Rapidly Develop Access-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 Access.
-
Connect to and Query Google Contacts Data in QlikView over ODBC
Create data visualizations with Google Contacts in QlikView.
-
ETL NASA in Oracle Data Integrator
This article shows how to transfer NASA into a data warehouse using Oracle Data Integrator.
-
How to Connect to ChartMogul Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ChartMogul. Leverage the pyodbc module for ODBC in Python.
-
How to Work with SAP Business Warehouse Data in AWS Glue Jobs Using JDBC
Connect to SAP Business Warehouse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for Shortcut
Create Shortcut data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build a Singer.io Tap for Reply.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Reply.io data using
-
Getting Started with the CData Power BI Connector for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Epicor Kinetic.
-
How to connect to Bitbucket Data from Spring Boot
Connect to Bitbucket in a Spring Boot Application using the CData JDBC Driver for Bitbucket
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Entra ID to Power BI dashboards. Simply drag and drop Microsoft Entra ID into data visuals on the Power BI canvas.
-
Migrating data from Tickspot to Databricks using CData SSIS Components.
Easily push Tickspot to Databricks using the CData SSIS Tasks for Tickspot and Databricks.
-
Automated Continuous Campaigner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Campaigner replication to Apache Cassandra.
-
Automated Continuous Cvent Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cvent replication to Apache Kafka.
-
How to Access Live Google Sheets Data in Visual Studio Code via Cline
Run CData MCP Server for Google Spreadsheets on Windows Subsytem for Linux (WSL) and connect to live Google Sheets from the Cline extension in Visual Studio Code.
-
How to create an RPA flow for Dotmailer Data in UiPath Studio
Use the Dotmailer ODBC Driver to create workflows that access real-time Dotmailer without any coding.
-
Automated Continuous MessageBird Replication to SingleStore
Use CData Sync for automated, continuous, customizable MessageBird replication to SingleStore.
-
Connect to Testmonitor Data in JRuby
Create a simple JRuby app with access to live Testmonitor.
-
Prepare, Blend, and Analyze Azure Synapse Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Synapse for self-service data analytics.
-
Load Microsoft Teams Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Teams to a database.
-
Connect to SAP BusinessObjects BI Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP BusinessObjects BI in FileMaker Pro to connect to SAP BusinessObjects BI and work with SAP BusinessObjects BI in your FileMaker applications.
-
Automated Continuous Zendesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zendesk replication to OneLake in Microsoft Fabric.
-
Connect to Zoho Creator Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Creator.
-
How to Connect the Power BI Service to Float: Complete Guide
Connect to the CData Software Power BI Connector for Float from PowerBI.com to provide real-time Float across the organization.
-
Connecting Agentforce with Oracle Sales 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 Oracle Sales for you.
-
Explore Geographical Relationships in LDAP Objects with Power Map
Create data visualizations with LDAP in Power Map.
-
Build Charts with Pinterest Data in Clear Analytics
Create dynamic charts and perform analytics based on Pinterest in Clear Analytics.
-
Build Pipelines with Live Jira Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Jira from Google Cloud Data Fusion, enabling the integration of live Atlassian Jira into the building and management of effective data pipelines.
-
Natively Connect to eBay Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to eBay Analytics. Leverage the native support for ODBC in PHP.
-
How to connect to Azure Table Data with Squirrel SQL client
Connect to Azure Table Storage and execute queries in the Squirrel SQL Client.
-
How to Access Live Authorize.Net Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Authorize.Net enables you to integrate Authorize.Net into workflows built using Microsoft Power Automate Desktop.
-
Analyze Salesforce Pardot Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce Pardot and visualize Salesforce Pardot in SAP Analytics Cloud.
-
Migrating data from SAP Ariba Procurement to Snowflake using CData SSIS Components.
Easily push SAP Ariba Procurement to Snowflake using the CData SSIS Tasks for SAP Ariba Procurement and Snowflake.
-
Access Live Monday.com Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Monday.com from your Excel spreadsheets.
-
How to Connect the Power BI Service to Rebilly: Complete Guide
Connect to the CData Software Power BI Connector for Rebilly from PowerBI.com to provide real-time Rebilly across the organization.
-
Stream Kintone Data into Apache Kafka Topics
Access and stream Kintone in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Avalara AvaTax Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Avalara AvaTax into the statistical analysis tools available in SAS JMP. This article shows how to use Avalara AvaTax in the Graph Builder and Query Builder.
-
Connecting Mastra with MongoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time MongoDB, no replication required.
-
Getting Started with the CData JDBC Driver for GetResponse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GetResponse.
-
Consume Beeminder OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Beeminder feeds that reflect any changes in SAP Lumira.
-
Integrate Theia IDE with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Getting Started with the CData SSIS Components for Okta
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Okta.
-
Connect to Dropbox Data from a Connection Pool in Jetty
The Dropbox JDBC Driver supports connection pooling: This article shows how to connect faster to Dropbox from Web apps in Jetty.
-
Integrate with Presto Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Presto to a JSON file on disk.
-
Rapidly Develop Strava-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 Strava.
-
Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy Desktop
Connect to Pipeliner CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Pipeliner CRM.
-
Connect to SAP Hybris C4C from Asprova with CData Software ODBC Driver for SAP Hybris C4C
This article shows how to connect faster to SAP Hybris C4C data from Asprova.
-
Automated Continuous Testmonitor Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Testmonitor replication to Google Cloud SQL.
-
How to Connect Flowise AI Agents to Live Salesforce Marketing 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 Salesforce Marketing Cloud without replication.
-
Import Salesforce CRM Analytics Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Salesforce CRM Analytics. In this article, you will use the OData format to import Salesforce CRM Analytics into Microsoft Power Query.
-
Build Visualizations of CampaignMonitor Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CampaignMonitor in Birst.
-
Adobe Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Adobe Analytics through CData Connect AI using different applications and tools.
-
Visualize Cassandra Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Cassandra.
-
Build Charts with Aircall Data in Clear Analytics
Create dynamic charts and perform analytics based on Aircall in Clear Analytics.
-
How to Visualize Zoom Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoom in Python.
-
Build Semantic Layer Views for FTP Data in APOS Live Data Gateway
Use the CData Connector for FTP in APOS Live Data Gateway to build Semantic Layer Views for FTP Servers.
-
Integrate Open WebUI with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Box from within the chat interface.
-
Design BIRT Reports on CouchDB Data
Provide current Apache CouchDB to your embedded analytics.
-
Rapidly Develop Keap-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 Keap.
-
How to Query Live SAP Ariba Source Data in Perplexity MacOS Desktop
Connect to and query live SAP Ariba Source Data in Perplexity Desktop using CData MCP Server.
-
How to Connect Oracle SCM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Oracle SCM data in real time using natural language.
-
Build Google Search Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Search and build visualizations in Tableau Cloud.