CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Foursquare in MicroStrategy Web
Connect to Foursquare data in MicroStrategy Web using the CData Software JDBC Driver for Foursquare.
-
Write a Simple Go Application to work with Teamwork Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teamwork data.
-
DataBind Controls to ZohoPeople Data in Delphi
DataBind to ZohoPeople data in Delphi with standard data access components and controls.
-
Connect to LDAP Objects in Jaspersoft Studio
Execute SQL to remote LDAP objects in Jaspersoft Studio.
-
SAP Drivers Overview
In this entry, you will find an overview of the SAP products supported by CData as well as the interfaces used to surface their data.
-
Stream ADP Data into Apache Kafka Topics
Access and stream ADP data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Azure Data Lake Storage Data in MySQL Workbench
Execute MySQL queries against live Azure Data Lake Storage data from MySQL Workbench.
-
Integrate Cursor with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live HubSpot data from within the editor.
-
How to Access ConstantContact Data Using Entity Framework
This article shows how to access ConstantContact data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Vertica Data as a SQL Server Database in Node.js
Execute SQL Server queries against Vertica data from Node.js.
-
Integrate Google's Vertex AI Agent with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Entra ID data within intelligent workflows.
-
LINQ to SAP Business One 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 SAP Business One Data Provider.
-
Connect Adobe Commerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Commerce with IBM WebSphere for seamless data integration and connectivity.
-
Automate NetSuite SuiteAnalytics Data Replication to Couchbase
Use CData Sync to Customize and automate NetSuite SuiteAnalytics data replication to Couchbase.
-
How to publish and share Smartsheet Data dashboards with Tableau Server
The CData ODBC driver for Smartsheet enables you integrate Smartsheet data into Tableau dashboards.
-
Integrate Cline with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Cosmos DB data from within your IDE.
-
Connect to Billsby in SpagoBI
Create reports featuring live Billsby data in SpagoBI Studio. Host Billsby reports on SpagoBI Server.
-
Connect to LightSpeedRetail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LightSpeedRetail and the SQL Gateway to access LightSpeedRetail data from Google Apps Script.
-
Use the CData Software ODBC Driver for Accelo in MicroStrategy
Connect to Accelo data in MicroStrategy Developer using the CData Software ODBC Driver for Accelo.
-
Build Visualizations of ScrapingBee Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ScrapingBee data in Birst.
-
Use Dash to Build to Web Apps on Foursquare Data
Create Python applications that use pandas and Dash to build Foursquare-connected web apps.
-
Viewing Parquet Data in RAD Studio Data Explorer
How to view Parquet data in RAD Studio Data Explorer using the CData ODBC Driver for Parquet.
-
Build Voice Agents in ElevenLabs with access to Live Marketo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Marketo data.
-
Visualize Live eBay Data in the Power BI Service
Use CData Connect AI to connect to live eBay data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live PingOne Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PingOne data into the statistical analysis tools available in SAS JMP. This article shows how to use PingOne data in the Graph Builder and Query Builder.
-
Integrating Gumloop with Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Greenhouse data within automated workflows.
-
Create Power BI Reports on Real-Time Dynamics 365 Business Central Data
Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central data in Power BI Desktop.
-
Connect and Visualize Live Microsoft Exchange Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Exchange data into the Databricks platform and create visualization dashboards with real-time Microsoft Exchange data.
-
Automated Continuous Splunk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Splunk replication to Google Cloud SQL.
-
Integrating Codex with Bitbucket 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.
-
Connect to FreshBooks Data in DBeaver
Use the CData ODBC Driver to connect to FreshBooks data in DBeaver.
-
Link Vercel with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vercel data in Filemaker Pro for Mac or Windows.
-
Explore Geographical Relationships in ConstantContact Data with Power Map
Create data visualizations with ConstantContact data in Power Map.
-
Automated Continuous Odoo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Odoo replication to Google Cloud SQL.
-
Automated Continuous QuickBooks Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to MongoDB.
-
Connect to ConstantContact Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ConstantContact Data and connect to ConstantContact data in Akorbi Digital RunMyProcess.
-
Automated Continuous Planio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Planio replication to SingleStore.
-
Integrating Codex with WooCommerce 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.
-
Build an OLAP Cube in SSAS from Epicor Kinetic Data
Establish a connection to Epicor Kinetic data data from SQL Server Analysis Services, and use the Epicor Kinetic Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Controls to Autopilot Data in C++Builder
DataBind to Autopilot data in C++Builder with standard components and controls.
-
Automated Continuous Microsoft Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Amazon Redshift.
-
Feed Elorus Data into FineReport
How to set Elorus data as a JDBC data source in FineReport.
-
Automate SAP Ariba Source Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Ariba Source data replication to Couchbase.
-
Process & Analyze Mode Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mode Data.
-
Connect to Samanage Data from a Connection Pool in Jetty
The Samanage JDBC Driver supports connection pooling: This article shows how to connect faster to Samanage data from Web apps in Jetty.
-
Build a Singer.io Tap for PayPal With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PayPal data using the CData Python Connector.
-
Add Oracle HCM Cloud Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle HCM Cloud with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load Zoom Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoom data to a database.
-
How to Connect to Live Snapchat Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snapchat Ads data securely in real time.
-
Getting Started with the CData Tableau Connector for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Google Translate 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 Google Translate data into TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for VWO
Complete guide to installing, licensing, and connecting with the CData SSIS Components for VWO.
-
Connect to and Visualize Live CouchDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CouchDB data.
-
Access Wrike Data from MySQL in PHP
Connect to Wrike through the standard MySQL libraries in PHP.
-
Automated Continuous ZeroBounce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZeroBounce replication to IBM DB2.
-
Build Agents in Relevance AI with Access to Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zendesk data within intelligent agent workflows.
-
Replicate Sage 200 Data from PowerShell
Write a quick PowerShell script to query Sage 200 data. Use connectivity to the live data to replicate Sage 200 data to SQL Server.
-
Import and Visualize Spark Data in Power View
Create data visualizations based on Spark data in Excel.
-
Integrating Antigravity CLI with Bright Data data via CData CLI
Connect Bright Data data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Missive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Missive data.
-
Integrating Twilio Data in Talend Cloud Data Management Platform
Connect Twilio Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twilio.
-
How to connect to MongoDB Data in DBVisualizer
Integrate MongoDB data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Anaplan Data in APOS Live Data Gateway
Use the CData Connector for Anaplan in APOS Live Data Gateway to build Semantic Layer Views for Anaplan data.
-
Automated Continuous MongoDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MongoDB replication to SingleStore.
-
DataBind Controls to IBM Cloud Object Storage Data in Delphi
DataBind to IBM Cloud Object Storage data in Delphi with standard data access components and controls.
-
Automate Short.io Data Replication to SAP HANA
Use CData Sync to customize and automate Short.io data replication to SAP HANA.
-
Integrate TigerGraph Data in Pentaho Data Integration
Build ETL pipelines based on TigerGraph data in the Pentaho Data Integration tool.
-
Operational Reporting on SAP SuccessFactors Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP SuccessFactors data.
-
Automated Continuous Xero Replication to MySQL
Use CData Sync for automated, continuous, customizable Xero replication to MySQL.
-
Extract, Transform, and Load Bugsnag Data in Informatica PowerCenter
Create a simple Workflow for Bugsnag data in Informatica PowerCenter.
-
Build Pipelines with Live Oracle Financials Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Financials Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle Financials Cloud data into the building and management of effective data pipelines.
-
How to Access Live QuickBooks Time Data in Power Automate Desktop via ODBC
The CData ODBC Driver for QuickBooks Time enables you to integrate QuickBooks Time data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft Planner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Planner and the SQL Gateway to access Microsoft Planner data from Google Apps Script.
-
How to Connect to Live HBase Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your HBase data for you.
-
Getting Started with the CData SSIS Components for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LaunchDarkly.
-
Integrate Google's Vertex AI Agent with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live PayPal data within intelligent workflows.
-
Integrate Open WebUI with Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Aweber data from within the chat interface.
-
How to work with Clockify Data in Apache Spark using SQL
Access and process Clockify Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with SAS xpt Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAS xpt data to a JSON file on disk.
-
Connect to and Visualize Live Twitter Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Twitter Ads data.
-
Integrate Instantly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Instantly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Instantly data.
-
DataBind Controls to Attio Data in Delphi
DataBind to Attio data in Delphi with standard data access components and controls.
-
Integrate Google's Antigravity Agent with Live Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Teradata data using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy Web
Connect to Unbounce data in MicroStrategy Web using the CData Software ODBC Driver for Unbounce.
-
Build a Simple VCL Application for ZohoPeople Data
How to build a simple VCL Application to view ZohoPeople data in RAD Studio using the CData ODBC Driver for ZohoPeople.
-
Integrating LangChain with Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Kafka data within automated workflows.
-
Connect to Exact Online Data from PowerBuilder via JDBC
This article demonstrates how to access Exact Online data from PowerBuilder using the Exact Online JDBC Driver.
-
Use the CData ODBC Driver for QuickBooks in Microsoft Power Query
You can use the CData QuickBooks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import QuickBooks data into Microsoft Power Query.
-
Publish Crystal Reports on SFTP Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SFTP data.
-
Query Live Azure Data Catalog Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Azure Data Catalog data through a conversational interface.
-
Visualize Live Eventbrite Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Eventbrite data.
-
Natively Connect to Cohere Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cohere data. Leverage the native support for ODBC in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing Cvent Records from SQL Server
Easily push SQL Server data to Cvent using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cvent or update existing records with data from a SQL Server database.
-
How to work with Outlook Data in Apache Spark using SQL
Access and process Outlook Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Cursor with Snapchat Ads 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.
-
Use Grok to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Outreach.io data for you.
-
Perform Batch Operations with Dynamics CRM Data in Apache NiFi
Connect to Dynamics CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Work with Xero Data in ETL Validator JDBC
Connect to Xero from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Zendesk Data in DBVisualizer
Integrate Zendesk data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Live Bitbucket Data in MicroStrategy through CData Connect AI
Create a live connection to Bitbucket Data in CData Connect AI and connect to your Bitbucket data from MicroStrategy.