CData Software - Knowledge Base
Recent Articles
-
Query JSON Services in DataGrip
Create a Data Source for JSON in DataGrip and use SQL to query live JSON services.
-
Working with QuickBooks using LINQPad
The CData ADO.NET Providers can be used from many applications and development environments. This article shows how to use the CData ADO.NET Provider for QuickBooks to connect to QuickBooks in LINQPad. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.
-
Use CData Connect AI to Access Confluence Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Confluence data in the Power Pivot business intelligence tool.
-
SAP Reporting in OBIEE with the SAP JDBC Driver
Deploy the SAP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use CData Connect AI to Access Salesloft Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesloft data in the Power Pivot business intelligence tool.
-
Build Zoho Creator-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Creator Data and create custom apps in Mendix.
-
Integrate Sage 200 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sage 200 data from Informatica Cloud.
-
ETL Pipeliner CRM in Oracle Data Integrator
This article shows how to transfer Pipeliner CRM data into a data warehouse using Oracle Data Integrator.
-
Integrate LibreChat with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live GitLab data from within the chat interface.
-
YouTube Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to YouTube Analytics data through CData Connect AI using different applications and tools.
-
Connect to Oracle Service Cloud Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Service Cloud data from HeidiSQL.
-
Analyze Pipeline CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pipeline CRM data in Microsoft R Open.
-
Trigger eBay IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for eBay with standard wizards in Logic Apps.
-
Analyze Sybase IQ Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sybase IQ data and visualize live Sybase IQ data in Infragistics Reveal.
-
Connect to ZohoMarketingHub Data in Aqua Data Studio
Access ZohoMarketingHub data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Add QuickBooks Time Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks Time with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Tableau Connector for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build an OLAP Cube in SSAS from Webex Data
Establish a connection to Webex data data from SQL Server Analysis Services, and use the Webex Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Excel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Excel data using the CData Python MCP Server.
-
Create VWO-Connected Nintex Workflows
Use CData Connect AI to connect to VWO Data from Nintex Workflow Cloud and build custom workflows using live VWO data.
-
Create Data Visualizations Based On PingOne Data in Mode
Use CData Connect AI to connect to PingOne Data from Mode and build visualizations using live PingOne data.
-
How to Visualize Google Tasks Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Tasks data in Python.
-
Analyze OnePageCrm Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for OnePageCrm from Power Pivot. You will use the Table Import Wizard to load OnePageCrm data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Teradata Data in RapidMiner
Integrate Teradata data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Apps from Amazon Athena Data in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon Athena Data and build apps from live Amazon Athena data in Qlik Sense Cloud.
-
Enable the OData JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OData services.
-
Model, Search, and Visualize Live Microsoft Teams Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Teams data for modeling, searching, and visualizing.
-
Access Live SAS xpt Data in AWS Lambda
Connect to live SAS xpt data in AWS Lambda using the CData JDBC Driver.
-
Connect to ADP Data from AWS Glue
Use CData Connect AI to gain access to live ADP data from your AWS Glue jobs.
-
How to Work with Stripe Data in AWS Glue Jobs Using JDBC
Connect to Stripe from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build a Simple VCL Application for SharePoint Excel Services Data
How to build a simple VCL Application to view SharePoint Excel Services data in RAD Studio using the CData ODBC Driver for SharePoint Excel Services.
-
Build Data Flows from SQL Server to Dynamics 365 through SSIS
Easily push SQL Server data to Dynamics 365 using the CData SSIS Tasks for Dynamics 365.
-
Work with Aha! Data in FoxPro
Load Aha! data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Freshsales Data in HULFT Integrate
Connect to Freshsales as a JDBC data source in HULFT Integrate
-
Connect to Real-Time MongoDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MongoDB and Dataflow to import and use MongoDB data in Power Apps.
-
Visualize CockroachDB Data in TIBCO Spotfire through OData
Integrate CockroachDB data into dashboards in TIBCO Spotfire.
-
How to use SQLAlchemy ORM to access Intercom Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Intercom data.
-
How to Query eBay Analytics Data in MySQL Workbench
Execute MySQL queries against live eBay Analytics data from MySQL Workbench.
-
Integrating Claude Code with Salesforce Data 360 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce Data 360 data within assisted coding and automated development workflows.
-
Create BigCommerce-Connected Nintex Workflows
Use CData Connect AI to connect to BigCommerce Data from Nintex Workflow Cloud and build custom workflows using live BigCommerce data.
-
Using the CData Software ODBC Driver for ActiveCampaign in PyCharm
Connect to ActiveCampaign as an ODBC data source in PyCharm using the CData Software ODBC Driver for ActiveCampaign.
-
How to connect to Adobe Analytics Data from Spring Boot
Connect to Adobe Analytics in a Spring Boot Application using the CData JDBC Driver for Adobe Analytics
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Hybris C4C
Provide connectivity to SAP Hybris C4C data through an SAP BusinessObjects universe.
-
Build Automated Workflows with Live Splunk Data in Workato
Use CData Connect AI to connect to live Splunk data and build automated workflows in Workato.
-
Getting Started with the CData JDBC Driver for CircleCI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CircleCI.
-
Replicate Sendwithus Data to Multiple Databases
Replicate Sendwithus data to disparate databases with a point-and-click configuration.
-
Build Apps with Live Paylocity Data Using the Low-Code Development Platform of Mendix
Connect Paylocity data with Mendix to build apps using the CData JDBC Driver for Paylocity.
-
Integrate OpenCode with Live Odoo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Odoo data from within your AI coding agent.
-
Automated Continuous Snapchat Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Google Cloud SQL.
-
Publish Crystal Reports on Kintone Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Kintone data.
-
Prepare, Blend, and Analyze Cvent Data in Alteryx Designer (ODBC)
Build workflows to access live Cvent data for self-service data analytics.
-
Operational Reporting on Pingdom Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pingdom data.
-
Connect to Basecamp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Basecamp.
-
Create Datasets from ZohoPeople in Domo Workbench and Build Visualizations of ZohoPeople Data in Domo
Use the CData Software ODBC Driver for ZohoPeople to create datasets from ZohoPeople data in Domo Workbench and then build visualizations in the Domo service.
-
Avro Reporting in OBIEE with the Avro JDBC Driver
Deploy the Avro JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Teamwork Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Teamwork to connect to Teamwork data and execute queries in PowerBuilder.
-
Connecting Pipedream with Sybase IQ Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Sybase IQ data in real time.
-
Analyze SAP Hybris C4C Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Hybris C4C from Power Pivot. You will use the Table Import Wizard to load SAP Hybris C4C data. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Controls to Access Data in Delphi
DataBind to Access data in Delphi with standard data access components and controls.
-
Moving Data from Snowflake to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Snowflake data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Voice Agents in ElevenLabs with access to Live Azure Table Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Table data.
-
Replicate Multiple HubSpot Accounts via the CData Sync CLI
Replicate multiple HubSpot accounts to one or many databases.
-
Build a Singer.io Tap for SAP Ariba Source With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Ariba Source data using the CData Python Connector.
-
Analyze Live CSV Data in SAS Viya
Use CData Connect AI to connect to CSV data from SAS Viya and deploy self-service analytics using live CSV data.
-
Explore Geographical Relationships in Discourse Data with Power Map
Create data visualizations with Discourse data in Power Map.
-
ETL Monday.com in Oracle Data Integrator
This article shows how to transfer Monday.com data into a data warehouse using Oracle Data Integrator.
-
Access Live Odoo Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Odoo data through MCP integration.
-
Getting Started with the CData Tableau Connector for REST
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for REST.
-
Use Microsoft Copilot Studio to talk to your Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Basecamp data for you.
-
Import Real-Time Parallel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Parallel data in ColdFusion.
-
Create Apps from Microsoft Planner Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Planner Data and build apps from live Microsoft Planner data in Qlik Sense Cloud.
-
Access Live Testmonitor Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Testmonitor data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Boomi Agentstudio with Azure Data Lake Storage Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Data Lake Storage data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use Microsoft Copilot Studio to talk to your Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Guru data for you.
-
How to Connect to Live Google Ad Manager Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Ad Manager data securely in real time.
-
Automated Continuous SparkPost Replication to SingleStore
Use CData Sync for automated, continuous, customizable SparkPost replication to SingleStore.
-
ETL Qualaroo in Oracle Data Integrator
This article shows how to transfer Qualaroo data into a data warehouse using Oracle Data Integrator.
-
Automate Egnyte Data Replication to Azure Data Lake
Use CData Sync to customize and automate Egnyte data replication to Azure Data Lake.
-
Connect to YouTube Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for YouTube Analytics and the Script function in FileMaker Pro to connect to YouTube Analytics and work with YouTube Analytics data in your FileMaker application.
-
Create Informatica Mappings From/To an ODBC Data Source for Egnyte
Create an ODBC connection to Egnyte in Informatica and browse and transfer Egnyte data.
-
Getting Started with the CData Excel Add-In for BigQuery
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BigQuery.
-
Connect to and Visualize Live Browserless Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Browserless data.
-
Automated Continuous MarkLogic Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to PostgreSQL.
-
Build Semantic Layer Views for Eventbrite Data in APOS Live Data Gateway
Use the CData Connector for Eventbrite in APOS Live Data Gateway to build Semantic Layer Views for Eventbrite data.
-
Migrating data from Grafana to Snowflake using CData SSIS Components.
Easily push Grafana data to Snowflake using the CData SSIS Tasks for Grafana and Snowflake.
-
Query Google Contacts Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Contacts entities in PHP by modeling them as objects.
-
Create Informatica Mappings From/To an ODBC Data Source for SurveyMonkey
Create an ODBC connection to SurveyMonkey in Informatica and browse and transfer SurveyMonkey data.
-
Publish Teamwork-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Teamwork data.
-
Connect to Dotmailer Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Dotmailer and work with Dotmailer data in your FileMaker application.
-
Analyze Deel Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Deel from Power Pivot. You will use the Table Import Wizard to load Deel data. You can visually build the import query or use any SQL supported by the driver.
-
Publish PolarTeamPro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PolarTeamPro data.
-
How to load Perplexity data into Elasticsearch via Logstash
Introducing a simple method to load Perplexity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Certinia Data in Ruby
Connect to Certinia data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google's Antigravity Agent with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Tally data using the Model Context Protocol.
-
Getting Started with the CData Tableau Connector for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Elasticsearch.
-
Connecting Pipedream with ZohoExpense Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ZohoExpense data in real time.
-
Connect to Rootly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Rootly data in the Denodo Virtual DataPort Administrator.
-
Create Data Visualizations Based On HubSpot Data in Mode
Use CData Connect AI to connect to HubSpot Data from Mode and build visualizations using live HubSpot data.
-
Use the CData Software ODBC Driver for Oracle Sales in MicroStrategy Web
Connect to Oracle Sales data in MicroStrategy Web using the CData Software ODBC Driver for Oracle Sales.
-
How to publish and share Everhour Data dashboards with Tableau Server
The CData ODBC driver for Everhour enables you integrate Everhour data into Tableau dashboards.