CData Software - Knowledge Base
Recent Articles
-
Use Grok to Talk to Your SAP ByDesign 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 SAP ByDesign data for you.
-
Factorial Reporting in OBIEE with the Factorial JDBC Driver
Deploy the Factorial JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to use SQLAlchemy ORM to access Webex Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Webex data.
-
Create Oracle Service Cloud-Connected Applications in Appsmith
Connect to Oracle Service Cloud Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Service Cloud data.
-
Using the CData Software ODBC Driver for Flowlu in PyCharm
Connect to Flowlu as an ODBC data source in PyCharm using the CData Software ODBC Driver for Flowlu.
-
Integrate with live WordPress Data in Jitterbit
Use CData Connect AI to connect to and integrate live WordPress data in Jitterbit.
-
Create Reports with Invoiced Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Invoiced data.
-
How to Connect to Live Raisers Edge NXT Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Raisers Edge NXT data for you.
-
Access Wrike Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Wrike data from HeidiSQL.
-
Connect to Elasticsearch Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Elasticsearch data.
-
Connect to Live Bitbucket Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Bitbucket in CData Connect AI and connect to your Bitbucket data from PostgreSQL.
-
Connect to SparkPost Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SparkPost and the SQL Gateway to access SparkPost data from Google Apps Script.
-
Connect to HBase Data from a Connection Pool in Jetty
The HBase JDBC Driver supports connection pooling: This article shows how to connect faster to HBase data from Web apps in Jetty.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendPulse
Provide connectivity to SendPulse data through an SAP BusinessObjects universe.
-
Automated Continuous Exact Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable Exact Online replication to MongoDB.
-
Build Automated Avro-Connected Workflows in Zapier
Use CData Connect AI to connect to live Avro data and build automated workflows in Zapier.
-
Connecting Mastra with Zuora 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 Zuora data, no replication required.
-
How to Build an ETL App for Act-On Data in Python with CData
Create ETL applications and real-time data pipelines for Act-On data in Python with petl.
-
Analyze Figshare Data in Cognos Analytics
Use CData Connect AI to connect to Figshare Data from Cognos Analytics and analyze live Figshare data.
-
Validate GetResponse Data with QuerySurge
Access and validate GetResponse data in QuerySurge using the CData JDBC Driver.
-
Query Live OneNote 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 OneNote data through a conversational interface.
-
Connect to Highrise Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Highrise data using standard SQL.
-
Access Basecamp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Basecamp data from HeidiSQL.
-
Integrate with live BigQuery Data in Jitterbit
Use CData Connect AI to connect to and integrate live BigQuery data in Jitterbit.
-
How to Work with Kintone Data in ETL Validator JDBC
Connect to Kintone from ETL Validator jobs using the CData Software JDBC Driver.
-
Using the CData Software ODBC Driver for eBay Analytics in PyCharm
Connect to eBay Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for eBay Analytics.
-
Create Data Visualizations in Cognos BI with CouchDB Data
Access CouchDB data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Optimizely
Provide connectivity to Optimizely data through an SAP BusinessObjects universe.
-
Connect to Certinia from Asprova with CData Software ODBC Driver for Certinia
This article shows how to connect faster to Certinia data from Asprova.
-
Use the CData SSIS Components to Insert New or Update Existing Email Records from SQL Server
Easily push SQL Server data to Email using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Email or update existing records with data from a SQL Server database.
-
Bind Live eBay Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live eBay Analytics data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Query, Visualize, and Share live GitHub Data in Redash
Use CData Connect AI to connect to live GitHub data in Redash for querying, visualizing, and sharing.
-
Manage Shortcut Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Shortcut.
-
Extract, Transform, and Load Vercel Data in Informatica PowerCenter
Create a simple Workflow for Vercel data in Informatica PowerCenter.
-
Connect iContact to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live iContact data using the CData Python MCP Server.
-
How to Connect the Power BI Service to Spark: Complete Guide
Connect to the CData Software Power BI Connector for Spark from PowerBI.com to provide real-time Spark data across the organization.
-
Connect to Freshteam Data in HULFT Integrate
Connect to Freshteam as a JDBC data source in HULFT Integrate
-
Visualize Live Foursquare Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Foursquare data.
-
Use Microsoft Copilot Studio to talk to your Exact Online 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 Exact Online data for you.
-
Getting Started with the CData JDBC Driver for Copper
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Copper.
-
Publish VWO-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live VWO data.
-
Create SSAS Tabular Models from TaxJar Data
How to build a SQL Server Analysis Service Tabular Model from TaxJar data using CData drivers.
-
How to Connect Blackbaud FE NXT 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 Blackbaud FE NXT data in real time using natural language.
-
Explore Geographical Relationships in SAP Business One Data with Power Map
Create data visualizations with SAP Business One data in Power Map.
-
Automate Bitly Data Replication to Azure Synapse
Use CData Sync to customize and automate Bitly data replication to Azure Synapse.
-
Access Live Oracle HCM Cloud Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Oracle HCM Cloud data through MCP integration.
-
Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy
Connect to Google Campaign Manager 360 data in MicroStrategy Developer using the CData Software JDBC Driver for Google Campaign Manager 360.
-
Visualize Live ADP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ADP data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple Ontraport Accounts via the CData Sync CLI
Replicate multiple Ontraport accounts to one or many databases.
-
Integrating Claude Code with Apollo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Apollo data within assisted coding and automated development workflows.
-
Connect to Redshift Data in RazorSQL
Connect to Redshift from wizards and query Redshift data from the GUI in the RazorSQL database management tool.
-
Write a Simple Go Application to work with Autopilot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Autopilot data.
-
Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy Web
Connect to OnePageCrm data in MicroStrategy Web using the CData Software JDBC Driver for OnePageCrm.
-
Publish Reports with SageHR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SageHR data.
-
Replicate Pipeliner CRM Data to Multiple Databases
Replicate Pipeliner CRM data to disparate databases with a point-and-click configuration.
-
Natively Connect to HubDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HubDB data. Leverage the native support for ODBC in PHP.
-
Natively Connect to Clockify Data in PHP
The CData ODBC driver for Clockify enables you to create PHP applications with connectivity to Clockify data. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for Short.io in a Connection Pool in Tomcat
Connect to Short.io data from a connection pool in Tomcat.
-
Query DB2 Data as a SQL Server Database in Node.js
Execute SQL Server queries against DB2 data from Node.js.
-
How to import Drip Data into Apache Solr
Use the CData Software JDBC Driver for Drip in Data Import Handler and create an automated import of Drip data to Apache Solr Enterprise Search platform.
-
How to Connect Flowise AI Agents to Live Tavily 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 Tavily data without replication.
-
How to use SQLAlchemy ORM to access SAP Business Warehouse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Business Warehouse data.
-
Integrate Real-Time Access to Zuora in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zuora data in real time.
-
Connect to and Visualize Live ShipEngine Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ShipEngine data.
-
Query Live Salesforce Marketing Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Salesforce Marketing data directly from the development environment.
-
Create Beeminder Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Beeminder data access from reports, embedded analytics, and more.
-
Connect to HDFS Data in HULFT Integrate
Connect to HDFS as a JDBC data source in HULFT Integrate
-
Integrating Kiro with SAP Business One 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.
-
Natively Connect to Missive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Missive data. Leverage the native support for ODBC in PHP.
-
Visualize NASA Data in Sisense
Create an ElastiCube in Sisense app with access to NASA data.
-
Use the CData Software JDBC Driver for Shopify in MicroStrategy Web
Connect to Shopify data in MicroStrategy Web using the CData Software JDBC Driver for Shopify.
-
Automated Continuous Adobe Target Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Adobe Target replication to Amazon S3.
-
Build Shippo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Shippo Data and create custom apps in Mendix.
-
Publish ChargeOver-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ChargeOver data.
-
Integrating Dataiku with LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live LinkedIn Ads data.
-
Replicate Multiple Google Search Accounts
Replicate multiple Google Search accounts to one or many databases.
-
Migrating data from Spark to Snowflake using CData SSIS Components.
Easily push Spark data to Snowflake using the CData SSIS Tasks for Spark and Snowflake.
-
Use Dash to Build to Web Apps on Tavily Data
Create Python applications that use pandas and Dash to build Tavily-connected web apps.
-
Replicate Apify Data to Multiple Databases
Replicate Apify data to disparate databases with a point-and-click configuration.
-
How to Connect to Live Google Drive Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Drive data for you.
-
Access Live AdRoll Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AdRoll data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate LibreChat with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon DynamoDB data from within the chat interface.
-
Visualize Salesforce CRM Analytics Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce CRM Analytics data.
-
Publish Reports with Everhour Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Everhour data.
-
Operational Reporting on FreeAgent Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FreeAgent data.
-
Connect to Keap Data in RapidMiner
Integrate Keap data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to OData Services from PowerBuilder via ADO.NET
This article demonstrates how to access OData services from Appeon PowerBuilder using the CData ADO.NET Provider for OData.
-
Process & Analyze Yelp Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Yelp Data.
-
How to Seamlessly Import GitHub Data into IBM SPSS Modeler
Integrate GitHub data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Strava Replication to Oracle
Use CData Sync for automated, continuous, customizable Strava replication to Oracle.
-
Integrate Live SAP Business One Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Business One data to Blue Prism using the CData ODBC Driver for SAP Business One to create automated workflows for repetitive business tasks.
-
Analyze HBase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HBase from Power Pivot. You will use the Table Import Wizard to load HBase data. You can visually build the import query or use any SQL supported by the driver.
-
Using the CData Software ODBC Driver for Grafana in PyCharm
Connect to Grafana as an ODBC data source in PyCharm using the CData Software ODBC Driver for Grafana.
-
Migrating data from OnePageCrm to Google BigQuery using CData SSIS Components.
Easily push OnePageCrm data to Google BigQuery using the CData SSIS Tasks for OnePageCrm and Google BigQuery.
-
Analyze VWO Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze VWO data in Microsoft R Open.
-
Rapidly Develop Google Calendar-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 Google Calendar.
-
Query Act-On Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Act-On data from Node.js.
-
Build Visualizations of Pingdom Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pingdom data in Birst.
-
Query Perigon Data in ColdFusion
Write standard ColdFusion data access code to connect to Perigon data.
-
Create Power BI Reports on Real-Time SAP Fieldglass Data
Use the CData ODBC Driver for SAP Fieldglass to visualize SAP Fieldglass data in Power BI Desktop.