CData Software - Knowledge Base

Recent Articles

---

• «
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• »

• ETL Grafana in Oracle Data Integrator

  This article shows how to transfer Grafana into a data warehouse using Oracle Data Integrator.

• Work with Avaza Data in FoxPro

  Load Avaza into a FoxPro database. This article includes full code and a walk-through of the process.

• DataBind Discourse Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Discourse to a chart.

• Build Data Flows from Google Calendar to SQL Server using SSIS

  Easily back up Google Calendar to SQL Server using the SSIS components for Google Calendar.

• How to Import Data from Cvent into Google Sheets

  Import Cvent into a Google spreadsheet that is automatically refreshed.

• How to Connect DBeaver to ClickUp via a JDBC Driver

  Manage ClickUp with visual tools in DBeaver like the query browser.

• Integrating Codex CLI with Printify 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.

• Natively Connect to SAP Netweaver Gateway Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to SAP Netweaver Gateway. Leverage the native support for ODBC in PHP.

• Use the CData Software JDBC Driver for Exact Online in MicroStrategy

  Connect to Exact Online in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.

• Build Pipelines with Live Cloudant Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Cloudant from Google Cloud Data Fusion, enabling the integration of live IBM Cloudant into the building and management of effective data pipelines.

• Automate Vertica Data Replication to Couchbase

  Use CData Sync to Customize and automate Vertica replication to Couchbase.

• Integrating OpenCode Terminal with Zoho Projects 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.

• Create Datasets from GraphQL in Domo Workbench and Build Visualizations of GraphQL Data in Domo

  Use the CData Software ODBC Driver for GraphQL to create datasets from GraphQL in Domo Workbench and then build visualizations in the Domo service.

• Getting Started with the CData Python Connector for Asana

  Learn to install and license the CData Python Connector

• Build a Singer.io Tap for eBay Analytics With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live eBay Analytics data using

• Prepare, Blend, and Analyze ZohoInvoice Data in Alteryx Designer (ODBC)

  Build workflows to access live ZohoInvoice for self-service data analytics.

• Use JayDeBeApi to access Shopify Data in Python

  Use standard Python scripting and the development environment of your choice to access live Shopify.

• Access Live Databricks Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Databricks from your Excel spreadsheets.

• Automated Continuous Paylocity Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Paylocity replication to Snowflake.

• Visualize Dotmailer Data in Tableau

  The CData ODBC driver for Dotmailer enables you integrate Dotmailer into Tableau dashboards.

• Connecting Mastra with SAP Concur 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 SAP Concur, no replication required.

• Automated Continuous QuickBooks Online Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google Cloud SQL.

• DataBind Charts to CircleCI Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to CircleCI from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Integrate Hive Data in Pentaho Data Integration

  Build ETL pipelines based on Apache Hive in the Pentaho Data Integration tool.

• Operational Reporting on Excel Online Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Excel Online.

• Stream Freshteam Data into Apache Kafka Topics

  Access and stream Freshteam in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Acumatica Data in CloverDX (formerly CloverETL)

  Transfer Acumatica ERP using the visual workflow in the CloverDX data integration tool.

• Access Live Aweber Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Aweber data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Build MVC Applications with Connectivity to Microsoft Ads Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Ads from an ASP.NET MVC application.

• Automated Continuous Snapchat Ads Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Snapchat Ads replication to IBM DB2.

• Validate XML Data with QuerySurge

  Access and validate XML Files in QuerySurge using the CData JDBC Driver.

• Explore Geographical Relationships in Zuora Data with Power Map

  Create data visualizations with Zuora in Power Map.

• Use the CData Software ODBC Driver for Hubstaff in SAS for Real-Time Reporting and Analytics

  Connect to real-time Hubstaff in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hubstaff.

• How to Query Live SendPulse Data in Claude Desktop

  Connect to and query live SendPulse Data in Claude Desktop using CData MCP Server.

• How to integrate Facebook with Apache Airflow

  Access and process Facebook in Apache Airflow using the CData JDBC Driver.

• Create Data Visualizations in Cognos BI with Mocean Data

  Access Mocean as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Query ServiceNow Data as a SQL Server Database in Node.js

  Execute SQL Server queries against ServiceNow from Node.js.

• Import and Visualize Coda Data in Power View

  Create data visualizations based on Coda in Excel.

• Build HubSpot-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for HubSpot to explore live HubSpot Data in Cursor to assist with building HubSpot-powered applications.

• Access Adobe Target Data from MySQL in PHP

  Connect to Adobe Target through the standard MySQL libraries in PHP.

• Analyze Pinecone Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Pinecone and visualize live Pinecone in Infragistics Reveal.

• Build Okta-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Okta Data and create custom apps in Bubble.

• Connect to Couchbase from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Couchbase to connect to Couchbase from Web applications running on WebLogic.

• Working with Reckon Accounts Hosted Data in LINQPad

  Execute LINQ queries to Reckon Accounts Hosted in LINQPad.

• How to Query Live Google Search Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Google Search data in natural language using Python.

• Automated Continuous Google Ad Manager Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Google Ad Manager replication to delimited files (CSV/TSV).

• Getting Started with the CData Power BI Connector for Calendly

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• Access Live Trello Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Trello from your Excel spreadsheets.

• Connecting Agentforce with eBay 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 eBay for you.

• Build MarkLogic-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for MarkLogic Data and create custom apps in Mendix.

• Connect to Shopify Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Shopify.

• Create Informatica Mappings From/To a JDBC Data Source for Humanity

  Create Humanity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Replicate Teamwork Data from PowerShell

  Write a quick PowerShell script to query Teamwork. Use connectivity to the live data to replicate Teamwork to SQL Server.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Google Campaign Manager 360 to Power BI dashboards. Simply drag and drop Google Campaign Manager 360 into data visuals on the Power BI canvas.

• Build Salesforce CRM Analytics-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Salesforce CRM Analytics and build Salesforce CRM Analytics-connected web apps with Axios.

• Connect to TigerGraph Data in JRuby

  Create a simple JRuby app with access to live TigerGraph.

• Connect to ChartMogul Data in JRuby

  Create a simple JRuby app with access to live ChartMogul.

• Connect Foursquare to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Foursquare using the CData Python MCP Server.

• Moving Data from Aircall to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Aircall data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Build Keap-Powered Applications in Cursor with CData MCP Server

  Use the CData API Driver for MCP Server to explore live Keap Data in Cursor to assist with building Keap-powered applications.

• Visualize Live Amazon Athena Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Amazon Athena using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Quaderno Data in Aqua Data Studio

  Access Quaderno from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Access Quaderno Data from MySQL in PHP

  Connect to Quaderno through the standard MySQL libraries in PHP.

• Build Data Flows from Microsoft Teams to SQL Server using SSIS

  Easily back up Microsoft Teams to SQL Server using the SSIS components for Microsoft Teams.

• Analyze PayPal Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for PayPal from Power Pivot. You will use the Table Import Wizard to load PayPal. You can visually build the import query or use any SQL supported by the driver.

• DataBind Controls to Pushbullet Data in C++Builder

  DataBind to Pushbullet in C++Builder with standard components and controls.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Projects within intelligent workflows.

• How to work with Monday.com Data in Apache Spark using SQL

  Access and process Monday.com Data in Apache Spark using the CData Software JDBC Driver.

• Automated Continuous Cassandra Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Cassandra replication to SQL Server.

• How to load Paddle data into Elasticsearch via Logstash

  Introducing a simple method to load Paddle data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• How to Access Live Paymo Data in Visual Studio Code via Cline

  Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Paymo from the Cline extension in Visual Studio Code.

• Connect to Amplitude Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Amplitude and work with Amplitude in your FileMaker applications.

• Automated Continuous ClickTime Replication to Oracle

  Use CData Sync for automated, continuous, customizable ClickTime replication to Oracle.

• Connecting Moonlit Workflow with Sybase IQ 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 Sybase IQ in real time.

• How to Query Live Mailgun Data in Perplexity MacOS Desktop

  Connect to and query live Mailgun Data in Perplexity Desktop using CData MCP Server.

• Using the CData Software ODBC Driver for Cosmos DB in PyCharm

  Connect to Cosmos DB as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cosmos DB.

• Integrate Real-Time Access to ShipEngine in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ShipEngine in real time.

• Access Live Access Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft Access in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• View Reports on Real-Time Microsoft Teams Data in Power BI Report Server

  Use the CData ODBC Driver for Microsoft Teams to visualize Microsoft Teams in Power BI Desktop and then publish them to Power BI Report Server.

• Automated Continuous Smartsheet Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Smartsheet replication to Amazon S3.

• Integrating Kiro CLI with Adobe Target 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.

• Automated Continuous HCL Domino Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable HCL Domino replication to AlloyDB.

• Query Active Directory Data in ColdFusion

  Write standard ColdFusion data access code to connect to Active Directory.

• Access Live Gmail Data in Coginiti Pro

  Connect to and query live Gmail from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Build Automated Workflows with Live MySQL Data in Workato

  Use CData Connect AI to connect to live MySQL and build automated workflows in Workato.

• DataBind SendInBlue Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SendInBlue to a chart.

• Access Paddle Data from MySQL in Amazon QuickSight

  Connect to Paddle and build visualizations of Paddle using a MySQL Connection in Amazon QuickSight.

• Connect to Dynamics 365 Business Central Data from HeidiSQL

  Use CData Connect AI to connect to and query live Dynamics 365 Business Central from HeidiSQL.

• Connect to Accelo Data from a Connection Pool in JBoss

  Integrate Accelo into Java servlets: Use the Management Console in JBoss to install the Accelo JDBC Driver.

• Import Real-Time Tavily Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Tavily in ColdFusion.

• Getting Started with the CData SSIS Components for Jira Assets

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jira Assets.

• Build Pipelines with Live Active Directory Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Active Directory from Google Cloud Data Fusion, enabling the integration of live Active Directory into the building and management of effective data pipelines.

• Know Your LLMs: Grok

  An in-depth enterprise overview of xAI Grok models, covering architecture, multimodal intelligence, agentic tool use, benchmarks, security, and CData Connect AI integration.

• Analyze Authorize.Net Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Authorize.Net in Microsoft R Open.

• Access SAP HANA Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAP HANA from HeidiSQL.

• Access Live Templated Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Templated data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Access Live Active Directory 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 Active Directory through MCP integration.

• Connect to Live SAS xpt Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to SAS xpt in CData Connect AI and connect to your SAS XPORT from PostgreSQL.

• Manage CircleCI Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for CircleCI.

• Visualize Live Microsoft Entra ID Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Microsoft Entra ID using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• «
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• »