CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Google Calendar With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Calendar data using the CData Python Connector.
-
Create Google Contacts-Connected Nintex Workflows
Use CData Connect AI to connect to Google Contacts Data from Nintex Workflow Cloud and build custom workflows using live Google Contacts data.
-
How to Connect to & Open LeadDesk Data in Microsoft Excel
This article uses the CData ODBC driver for LeadDesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Explore Geographical Relationships in MariaDB Data with Power Map
Create data visualizations with MariaDB data in Power Map.
-
Connect to SparkPost from a Connection Pool in WebLogic
Use the CData JDBC Driver for SparkPost to connect to SparkPost data from Web applications running on WebLogic.
-
Integrating LangGraph with Typeform Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Typeform data within automated workflows.
-
Integrating Gumloop with Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Tally data within automated workflows.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy
Connect to NetSuite data in MicroStrategy Developer using the CData Software JDBC Driver for NetSuite.
-
Automated Continuous Templated Replication to Vertica
Use CData Sync for automated, continuous, customizable Templated replication to Vertica.
-
Build Oracle Eloqua Reporting-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Eloqua Reporting data.
-
How to connect and process SAP ByDesign data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP ByDesign data.
-
Replicate BigCommerce Data to Multiple Databases via the CData Sync CLI
Replicate BigCommerce data to disparate databases with a single configuration.
-
Automate SAP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP data from PowerShell? This article demonstrates how to utilize the SAP Cmdlets for tasks like connecting to SAP data, automating operations, downloading data, and more.
-
Integrate WordPress Data in the Pentaho Report Designer
Publish reports based on WordPress data in the Pentaho BI tool.
-
How to connect and process Google Analytics data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Analytics data.
-
Getting Started with the CData JDBC Driver for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SuiteCRM.
-
Moving Data from QuickBooks Time to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live QuickBooks Time data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect Microsoft Teams to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Teams with IBM WebSphere for seamless data integration and connectivity.
-
Use Microsoft Copilot Studio to talk to your TaxJar 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 TaxJar data for you.
-
Build Sybase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sybase data and build web apps with connectivity to live Sybase data.
-
Access Live eBay Data in TIBCO Data Virtualization
Use the eBay Tibco DV Adapter to create a eBay data data source in TIBCO Data Virtualization Studio and gain access to live eBay data from your TDV Server.
-
DataBind Controls to OnePageCrm Data in C++Builder
DataBind to OnePageCrm data in C++Builder with standard components and controls.
-
Use Manus AI to Talk to Your Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Authorize.Net data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Front
Provide connectivity to Front data through an SAP BusinessObjects universe.
-
Connect to MariaDB Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live MariaDB data.
-
How to Visualize Zoho CRM Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Zoho CRM data in Python.
-
Analyze Dynamics 365 Business Central Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Dynamics 365 Business Central data and visualize live Dynamics 365 Business Central data in Infragistics Reveal.
-
How to Connect SparkPost 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 SparkPost data in real time using natural language.
-
Query Live MySQL 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 MySQL data directly from the development environment.
-
How to Visualize Bannerbear Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bannerbear data in Python.
-
Use the CData Software ODBC Driver for Timely in MicroStrategy
Connect to Timely data in MicroStrategy Developer using the CData Software ODBC Driver for Timely.
-
Design BIRT Reports on Oracle SCM Data
Provide current Oracle SCM data to your embedded analytics.
-
Automated Continuous Typeform Replication to Oracle
Use CData Sync for automated, continuous, customizable Typeform replication to Oracle.
-
Automated Continuous Azure Data Lake Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to PostgreSQL.
-
Connect to Redis Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Redis data.
-
Model, Search, and Visualize Live Printify Data in ThoughtSpot
Use CData Connect AI to connect to live Printify data for modeling, searching, and visualizing.
-
How to Easily Query Zoho Projects Data in OpenOffice Base
Connect to Zoho Projects data in OpenOffice Base using the CData ODBC Driver for Zoho Projects and generate reports with live data insights.
-
Automated Continuous Wrike Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Wrike replication to Amazon Redshift.
-
Integrating Codex with Sage 300 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.
-
Load JobNimbus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load JobNimbus data to a database.
-
Connect to SAP Business Warehouse Data from a Connection Pool in JBoss
Integrate SAP Business Warehouse data into Java servlets: Use the Management Console in JBoss to install the SAP Business Warehouse JDBC Driver.
-
Create Data Visualizations Based On Coda Data in Mode
Use CData Connect AI to connect to Coda Data from Mode and build visualizations using live Coda data.
-
How to connect to ConvertAPI Data with Squirrel SQL client
Connect to ConvertAPI data and execute queries in the Squirrel SQL Client.
-
Integrating Codex with PolarTeamPro 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.
-
Query Humanity Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Humanity data from Node.js.
-
Dropbox Reporting in OBIEE with the Dropbox JDBC Driver
Deploy the Dropbox JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Jira Assets Replication to Oracle
Use CData Sync for automated, continuous, customizable Jira Assets replication to Oracle.
-
Connect SAP HANA XS Advanced to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP HANA XS Advanced data using the CData Python MCP Server.
-
Deploy the ADO.NET Provider for Xero on an SSRS Report Server
Connect to Xero data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect SAP Netweaver Gateway to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Netweaver Gateway with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SharePoint Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SharePoint data in the Denodo Virtual DataPort Administrator.
-
Extract, Transform, and Load Outlook Data in Informatica PowerCenter
Create a simple Workflow for Outlook data in Informatica PowerCenter.
-
Create Informatica Mappings From/To a JDBC Data Source for Todoist
Create Todoist data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Wistia Data Using Entity Framework
This article shows how to access Wistia data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Zuora-Connected Dashboards in Grafana
Connect to Zuora Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zuora data.
-
Create Informatica Mappings From/To a JDBC Data Source for Mistral AI
Create Mistral AI data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
View Reports on Real-Time MarkLogic Data in Power BI Report Server
Use the CData ODBC Driver for MarkLogic to visualize MarkLogic data in Power BI Desktop and then publish them to Power BI Report Server.
-
Rapidly Develop Timely-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 Timely.
-
Getting Started with the CData SSIS Components for Grafana
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Grafana.
-
Connect to Live Salesforce CRM Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce CRM Analytics Data in CData Connect AI and connect to your Salesforce CRM Analytics data from MicroStrategy.
-
Integrate Live Jira Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Jira data from within the IDE.
-
Consume Zoho Projects OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Projects data as OData feeds from PowerBuilder using the API Server.
-
Connect to Discord from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Discord data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Multiple Shopify Accounts
Replicate multiple Shopify accounts to one or many databases.
-
Stream Humanity Data into Apache Kafka Topics
Access and stream Humanity data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with Accelo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Accelo data to a JSON file on disk.
-
Connect to VWO Data from PowerBuilder via JDBC
This article demonstrates how to access VWO data from PowerBuilder using the VWO JDBC Driver.
-
Analyze Adobe Target Data in Cognos Analytics
Use CData Connect AI to connect to Adobe Target Data from Cognos Analytics and analyze live Adobe Target data.
-
Access Live Elasticsearch Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Elasticsearch data from your Excel spreadsheets.
-
Integrating Dataiku with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live eBay data.
-
How to Connect to Live AlloyDB Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your AlloyDB data for you.
-
Automated Continuous Paymo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paymo data replication to OneLake in Microsoft Fabric.
-
Automate Quaderno Data Replication to Couchbase
Use CData Sync to Customize and automate Quaderno data replication to Couchbase.
-
Integrating Gumloop with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Greenplum data within automated workflows.
-
Natively Connect to Splunk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Splunk data. Leverage the native support for ODBC in PHP.
-
Integrate Open WebUI with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Tally data from within the chat interface.
-
Create Data Visualizations Based On Sage 300 Data in Mode
Use CData Connect AI to connect to Sage 300 Data from Mode and build visualizations using live Sage 300 data.
-
View Reports on Real-Time Azure DevOps Data in Power BI Report Server
Use the CData ODBC Driver for Azure DevOps to visualize Azure DevOps data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Open WebUI with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Analytics data from within the chat interface.
-
A PostgreSQL Interface for EnterpriseDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the EnterpriseDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro with Anaplan 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.
-
Visualize Live Airtable Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Airtable data into custom reports in Power BI.
-
Access Live Excel Online Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Excel Online data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live Neo4J Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Neo4J data through natural language.
-
Using the CData Software ODBC Driver for Gumroad in PyCharm
Connect to Gumroad as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gumroad.
-
Integrating Claude Code CLI with SuiteCRM 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.
-
Visualize Live Snapchat Ads Data in the Power BI Service
Use CData Connect AI to connect to live Snapchat Ads data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Pipedrive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pipedrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DocuSign 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 DocuSign data in real time using natural language.
-
Integrating Kiro with xBase 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.
-
Query Live Amazon Athena 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 Amazon Athena data through a conversational interface.
-
Building Dynamic Web Pages with MariaDB Data Using AngularJS
Create single-page applications with live connectivity to MariaDB using the CData API Server.
-
Automated Continuous JotForm Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable JotForm data replication to OneLake in Microsoft Fabric.
-
Analyze Oracle Service Cloud Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Service Cloud data in Microsoft R Open.
-
Access Live Acumatica Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Acumatica data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query SAP HANA XS Advanced Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP HANA XS Advanced entities in PHP by modeling them as objects.
-
Build Apps with Live API data in Adalo using CData Connect AI
Use CData Connect AI to integrate live API data into the Adalo platform and build custom mobile and web applications with real-time API data.
-
Access LinkedIn Ads Data from MySQL in Amazon QuickSight
Connect to LinkedIn Ads and build visualizations of LinkedIn Ads data using a MySQL Connection in Amazon QuickSight.
-
Connect to and Visualize Live Shopify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shopify data.
-
Create Reports from Oracle Data in Looker Studio
Use CData Connect AI to gain access to live Oracle data and create custom reports in Looker Studio.