CData Software - Knowledge Base
Recent Articles
-
Choosing the Best Method to Connect SparkPost to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SparkPost data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate OpenCode with Live Redis Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Redis data from within your AI coding agent.
-
DataBind Bitly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Bitly data to a chart.
-
Connect to eBay Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access eBay Analytics data from Appeon PowerBuilder using the CData ADO.NET Provider for eBay Analytics.
-
Integrate with Humanity Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Humanity data to a JSON file on disk.
-
Connecting Moonlit Workflow with PayPal Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your PayPal data in real time.
-
Getting Started with the CData Tableau Connector for JSON
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for JSON.
-
Extract, Transform, and Load Couchbase Data in Informatica PowerCenter
Create a simple Workflow for Couchbase data in Informatica PowerCenter.
-
Integrate Theia IDE with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live BigQuery data from within the development environment.
-
Webflow Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Webflow facts in real time.
-
Access Live Google Sheets Data in TIBCO Data Virtualization
Use the Google Sheets Tibco DV Adapter to create a Google Sheets data data source in TIBCO Data Virtualization Studio and gain access to live Google Sheets data from your TDV Server.
-
Publish Paddle-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Paddle data.
-
Connect to Real-Time TaxJar Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for TaxJar and Dataflow to import and use TaxJar data in Power Apps.
-
Connect to SAP Ariba Procurement Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Ariba Procurement and the SQL Gateway to access SAP Ariba Procurement data from Google Apps Script.
-
A PostgreSQL Interface for Presto Data (MySQL Remoting via JDBC)
Use the Remoting features of the Presto JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from MySQL Data in Qlik Sense Cloud
Use CData Connect AI to connect to MySQL Data and build apps from live MySQL data in Qlik Sense Cloud.
-
Work with Live QuickBooks Data in Power Query
Use CData Connect AI to connect to QuickBooks data and work with live QuickBooks data in Microsoft Power Query.
-
Import and Visualize BigCommerce Data in Power View
Create data visualizations based on BigCommerce data in Excel.
-
Bridge AfterShip Connectivity with Apache NiFi
Access and process AfterShip data in Apache NiFi using the CData JDBC Driver.
-
Integrate Cline with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Shortcut data from within your IDE.
-
Automated Continuous Customer.io Replication to Snowflake
Use CData Sync for automated, continuous, customizable Customer.io replication to Snowflake.
-
Integrate with Flowlu Data in JReport Designer
Create charts and reports based on Flowlu data in JReport Designer.
-
Publish Copper-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Copper data.
-
Visualize Live Adobe Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Analytics data into custom reports in Power BI.
-
Connect to Flowlu Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Flowlu and work with Flowlu data in your FileMaker applications.
-
Build PayPal-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to PayPal Data from Zoho Analytics and import live PayPal data.
-
Back Up Mailjet data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Mailjet data data.
-
Use Azure AI Foundry to Talk to Your Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Tavily data for you.
-
Access Live Redis Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Redis data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build AI/ML Models with Live Sage 300 Data using Dataiku
Connect Sage 300 Data with Dataiku using the CData JDBC Driver for Sage 300.
-
Create Reports with SingleStore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SingleStore data.
-
Integrating Claude Code CLI with SAS xpt 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.
-
Access Live Avro 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 Avro data through MCP integration.
-
Stream Greenplum Data into Apache Kafka Topics
Access and stream Greenplum data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Agents in Relevance AI with Access to Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Elasticsearch data within intelligent agent workflows.
-
Build Data Flows from HubSpot to SQL Server using SSIS
Easily back up HubSpot data to SQL Server using the SSIS components for HubSpot.
-
Automated Continuous Qualaroo Replication to Vertica
Use CData Sync for automated, continuous, customizable Qualaroo replication to Vertica.
-
Automated Continuous Toggl Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Toggl replication to Azure SQL Database.
-
Visualize Jira Data in Tableau
The CData ODBC driver for Jira enables you integrate Jira data into Tableau dashboards.
-
Analyze Factorial Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Factorial data in Microsoft R Open.
-
Build Semantic Layer Views for Factorial Data in APOS Live Data Gateway
Use the CData Connector for Factorial in APOS Live Data Gateway to build Semantic Layer Views for Factorial data.
-
Interact with Live Dynamics 365 Business Central Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Dynamics 365 Business Central data.
-
Connect to Access Data in Claris FileMaker Pro
Use the CData ODBC Driver for Access in FileMaker Pro to connect to Access and work with Access data in your FileMaker applications.
-
Visualize Accelo Data in TIBCO Spotfire through ADO.NET
Integrate Accelo data into dashboards in TIBCO Spotfire.
-
How to Connect to Live ShipStation Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ShipStation data securely in real time.
-
Analyze Scrapfly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Scrapfly data in Microsoft R Open.
-
Build Automated Workflows with Live Zoho CRM Data in Workato
Use CData Connect AI to connect to live Zoho CRM data and build automated workflows in Workato.
-
How to Work with Databricks Data in ETL Validator JDBC
Connect to Databricks from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect and Query Live Gong Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Gong data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Microsoft Dataverse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Dataverse data from PowerShell? This article demonstrates how to utilize the Microsoft Dataverse Cmdlets for tasks like connecting to Microsoft Dataverse data, automating operations, downloading data, and more.
-
Integrate Cursor with Live Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Wave Financial data from within the editor.
-
Connect to and Query QuickBooks Data in QlikView over ODBC
Create data visualizations with QuickBooks data in QlikView.
-
Analyze ZohoDesk Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoDesk data in Microsoft R Open.
-
Publish Ontraport-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Ontraport data.
-
Build Zoho Creator Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Creator data and build visualizations in Tableau.
-
Connect to IBM Informix Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with IBM Informix Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Printify Replication to Databricks
Use CData Sync for automated, continuous, customizable Printify replication to Databricks.
-
Connect to ADP Data in ACL Analytics
Connect to ADP data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ADP data.
-
Moving Data from SAP Concur to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Concur data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to MailChimp Data from HeidiSQL
Use CData Connect AI to connect to and query live MailChimp data from HeidiSQL.
-
Build a Singer.io Tap for Salesforce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce data using the CData Python Connector.
-
Work with Live Kintone Data in Power Query
Use CData Connect AI to connect to Kintone data and work with live Kintone data in Microsoft Power Query.
-
Access Microsoft Entra ID 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 Microsoft Entra ID data.
-
Replicate Google Contacts Data in Heroku for Use in Salesforce Connect
Replicate Google Contacts data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build AI/ML Models with Live Anaplan Data using Dataiku
Connect Anaplan Data with Dataiku using the CData JDBC Driver for Anaplan.
-
How to Seamlessly Import ServiceNow Data into IBM SPSS Modeler
Integrate ServiceNow data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Consume SAP Netweaver Gateway OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Netweaver Gateway data as OData feeds from PowerBuilder using the API Server.
-
How to import Aha! Data into Apache Solr
Use the CData Software JDBC Driver for Aha! in Data Import Handler and create an automated import of Aha! data to Apache Solr Enterprise Search platform.
-
Query Access Data in DataGrip
Create a Data Source for Access in DataGrip and use SQL to query live Access data.
-
Getting Started with the CData ADO.NET Provider for Strava
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Query Facebook Data in MySQL Workbench
Execute MySQL queries against live Facebook data from MySQL Workbench.
-
Connect to Real-Time Figshare Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Figshare data in Power Apps.
-
Connect to Marketo Data from PowerBuilder via JDBC
This article demonstrates how to access Marketo data from PowerBuilder using the Marketo JDBC Driver.
-
Extract, Transform, and Load Spotify Data in Informatica PowerCenter
Create a simple Workflow for Spotify data in Informatica PowerCenter.
-
ETL Lakebase in Oracle Data Integrator
This article shows how to transfer Lakebase data into a data warehouse using Oracle Data Integrator.
-
How to work with Telegram Data in Apache Spark using SQL
Access and process Telegram Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Crystal Reports on Facebook Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Facebook Ads data.
-
How to connect Amazon QuickSight to FreshBooks Data
Create a connection to FreshBooks data in CData Connect AI and insert FreshBooks data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Okta Data from MySQL in Amazon QuickSight
Connect to Okta and build visualizations of Okta data using a MySQL Connection in Amazon QuickSight.
-
Access Freshdesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshdesk data from HeidiSQL.
-
Replicate ZohoInvoice Data in Heroku for Use in Salesforce Connect
Replicate ZohoInvoice data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting Pipedream with Azure Synapse 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 Azure Synapse data in real time.
-
Connect to Exact Online Data from AWS Glue
Use CData Connect AI to gain access to live Exact Online data from your AWS Glue jobs.
-
Connect to Anaplan Data in NetBeans
Connect to Anaplan data in NetBeans with the data source configuration wizard.
-
Build Charts with Shopify Data in Clear Analytics
Create dynamic charts and perform analytics based on Shopify data in Clear Analytics.
-
Connect Oracle Service Cloud Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Service Cloud data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect Gumroad to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gumroad data using the CData Python MCP Server.
-
Automated Continuous Google Search Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Search replication to Apache Kafka.
-
Build Dashboards with FHIR Data in DBxtra
Create dynamic dashboards and perform analytics based on FHIR data in DBxtra.
-
Automated Continuous Xero Replication to Oracle
Use CData Sync for automated, continuous, customizable Xero replication to Oracle.
-
Getting Started with the CData Power BI Connector for GitHub
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for GitHub.
-
Working with Instagram Data in LINQPad
Execute LINQ queries to Instagram data in LINQPad.
-
How to Create Power BI Visual Reports with Real-Time Workable Data
Use CData Power BI Connectors to visualize Workable data in Power BI.
-
How to Easily Query Zoho Books Data in OpenOffice Base
Connect to Zoho Books data in OpenOffice Base using the CData ODBC Driver for Zoho Books and generate reports with live data insights.
-
Connect to Adobe Target Data in HULFT Integrate
Connect to Adobe Target as a JDBC data source in HULFT Integrate
-
Integrate Dynamics 365 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics 365 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dynamics 365 data.
-
Object-Relational Mapping (ORM) with CloudConvert 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 CloudConvert data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Oracle Sales Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle Sales replication to SingleStore.
-
Build Dashboards with Exact Online Data in DBxtra
Create dynamic dashboards and perform analytics based on Exact Online data in DBxtra.
-
Working with Float Data in LINQPad
Execute LINQ queries to Float data in LINQPad.