CData Software - Knowledge Base
Recent Articles
-
Integrate Cline with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP ByDesign data from within your IDE.
-
Build a Singer.io Tap for Opsgenie With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Opsgenie data using the CData Python Connector.
-
Integrate with PolarTeamPro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PolarTeamPro data to a JSON file on disk.
-
How to Work with CSV Data in ETL Validator JDBC
Connect to CSV from ETL Validator jobs using the CData Software JDBC Driver.
-
Build OData-Connected Apps in Choreo
Use CData Connect AI to connect to OData Services from Choreo and build custom apps using live OData services.
-
Replicate Coinbase Data to Multiple Databases via the CData Sync CLI
Replicate Coinbase data to disparate databases with a single configuration.
-
Connect to Superchat in SpagoBI
Create reports featuring live Superchat data in SpagoBI Studio. Host Superchat reports on SpagoBI Server.
-
Access Files in Box Accounts with Nested Folders
A step-by-step guide on retrieving data files within sub-folders of a Box account using CData Box Drivers for seamless data access and integration.
-
Integrate SAP Business One Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Business One data from Informatica Cloud.
-
DataBind Salesforce Marketing Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Salesforce Marketing with the DevExpress Windows Forms and Web controls to provide Salesforce Marketing data to a chart.
-
Build Data Flows from SQL Server to MongoDB through SSIS
Easily push SQL Server data to MongoDB using the CData SSIS Tasks for MongoDB.
-
Connect to OneNote Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for OneNote data in the Denodo Virtual DataPort Administrator.
-
Create Datasets from Mailjet in Domo Workbench and Build Visualizations of Mailjet Data in Domo
Use the CData Software ODBC Driver for Mailjet to create datasets from Mailjet data in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live ZohoExpense Data in the Power BI Service
Use CData Connect AI to connect to live ZohoExpense data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Stream xBase Data into Apache Kafka Topics
Access and stream xBase data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous SQL Server Replication to Vertica
Use CData Sync for automated, continuous, customizable SQL Server replication to Vertica.
-
Connect to and Query Elorus Data in QlikView over ODBC
Create data visualizations with Elorus data in QlikView.
-
How to Connect DBeaver to ZohoSubscriptions via a JDBC Driver
Manage ZohoSubscriptions data with visual tools in DBeaver like the query browser.
-
Moving Data from OpenWeatherMap to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OpenWeatherMap data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous MessageBird Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MessageBird replication to PostgreSQL.
-
Connect to Salesforce Data 360 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce Data 360 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Object-Relational Mapping (ORM) with OnePageCrm 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 OnePageCrm data into a Java-based ORM framework, Hibernate.
-
Connect to Cvent Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Cvent data.
-
Create Reports with Azure Data Lake Storage Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Lake Storage data.
-
Connect to MariaDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MariaDB to connect to MariaDB data and execute queries in PowerBuilder.
-
Access Live iContact Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live iContact data from your Google Sheets.
-
Analyze Oracle Service Cloud Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Service Cloud data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to load FHIR data into Elasticsearch via Logstash
Introducing a simple method to load FHIR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Google Forms-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Forms data.
-
Rapidly Develop Front-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 Front.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted data for you.
-
Connecting Mastra with IBM Informix 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 IBM Informix data, no replication required.
-
Query Perplexity Data as a SQL Server Database in Node.js
Execute SQL Server queries against Perplexity data from Node.js.
-
Integrating Kiro with Pingdom 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.
-
Integrating Cursor with Suadeo 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.
-
Getting Started with the CData Connect AI Python SDK for Google Drive
Install the CData Connect AI Python SDK to read and write live Google Drive data with standard DB-API 2.0 Python code.
-
Operational Reporting on HDFS Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HDFS data.
-
Connect to Google Forms Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Forms Data and connect to Google Forms data in Akorbi Digital RunMyProcess.
-
Connect to Omnisend Data from PowerBuilder via JDBC
This article demonstrates how to access Omnisend data from PowerBuilder using the Omnisend JDBC Driver.
-
Access CircleCI Data from MySQL in PHP
Connect to CircleCI through the standard MySQL libraries in PHP.
-
Automate QuickBooks Online Data Replication to Couchbase
Use CData Sync to Customize and automate QuickBooks Online data replication to Couchbase.
-
Use Grok to Talk to Your Sage 200 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 Sage 200 data for you.
-
Use Biml to Build SSIS Tasks to Replicate SendGrid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendGrid data to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Aha! Data
Use CData Power BI Connectors to visualize Aha! data in Power BI.
-
How to integrate Accelo with Apache Airflow
Access and process Accelo data in Apache Airflow using the CData JDBC Driver.
-
Connect to Scrapfly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Scrapfly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Query Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data through a conversational interface.
-
Connect to Parquet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Parquet data from Appeon PowerBuilder using the CData ADO.NET Provider for Parquet.
-
How to Seamlessly Import Bannerbear Data into IBM SPSS Modeler
Integrate Bannerbear data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Working with Perplexity Data in LINQPad
Execute LINQ queries to Perplexity data in LINQPad.
-
Work with Live Epicor Kinetic Data in Power Query
Use CData Connect AI to connect to Epicor Kinetic data and work with live Epicor Kinetic data in Microsoft Power Query.
-
Access Live Reckon Accounts Hosted Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Reckon Accounts Hosted data from your Excel spreadsheets.
-
Moving Data from Clockify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Clockify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Salesloft Data to Multiple Databases via the CData Sync CLI
Replicate Salesloft data to disparate databases with a single configuration.
-
Create Dashboards and Visualize Live Klaviyo Data in Geckoboard
Use CData Connect AI to connect to live Klaviyo data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Live Exact Online Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Exact Online enables you to integrate Exact Online data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData SSIS Components for Superchat
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Superchat.
-
Query MariaDB Data in DataGrip
Create a Data Source for MariaDB in DataGrip and use SQL to query live MariaDB data.
-
How to Query Live Clockify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Clockify data data in natural language using Python.
-
How to Connect to Live Azure Table Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Azure Table data for you.
-
Integrate LibreChat with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Data Lake Storage data from within the chat interface.
-
Migrating data from Parquet to Snowflake using CData SSIS Components.
Easily push Parquet data to Snowflake using the CData SSIS Tasks for Parquet and Snowflake.
-
How to connect to Jumpseller Data with Squirrel SQL client
Connect to Jumpseller data and execute queries in the Squirrel SQL Client.
-
Create Apps from Greenhouse Data in Qlik Sense Cloud
Use CData Connect AI to connect to Greenhouse Data and build apps from live Greenhouse data in Qlik Sense Cloud.
-
Excel Spreadsheet Automation on Dropbox Data with the QUERY Formula
Pull data from Dropbox, automate spreadsheets, and more with the QUERY formula.
-
Deploy the ADO.NET Provider for Calendly on an SSRS Report Server
Connect to Calendly 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.
-
Operational Reporting on Avalara AvaTax Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Avalara AvaTax data.
-
Add SAP BusinessObjects BI Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP BusinessObjects BI with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Semantic Layer Views for MailChimp Data in APOS Live Data Gateway
Use the CData Connector for MailChimp in APOS Live Data Gateway to build Semantic Layer Views for MailChimp data.
-
Connect to Google Forms Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Forms.
-
Connect to AdRoll Data as an External Source in Dremio
Use the CData JDBC Driver to connect to AdRoll as an External Source in Dremio.
-
Use the CData ODBC Driver for ServiceNow in Microsoft Power Query
You can use the CData ServiceNow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceNow data into Microsoft Power Query.
-
Dynamics 365 Reporting in OBIEE with the Dynamics 365 JDBC Driver
Deploy the Dynamics 365 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Google Sheets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Sheets to connect to Google Sheets data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Sheets data in Excel.
-
How to create Visio diagrams from MySQL Data
Automatically update MySQL data with the changes you make to Visio master shapes.
-
Manage Sentry Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sentry.
-
Connecting Pipedream with YouTube Analytics 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 YouTube Analytics data in real time.
-
Connect and Query Live Pipedrive Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Pipedrive data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Devin with Live Microsoft Dataverse Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Microsoft Dataverse data.
-
Use the CData Software ODBC Driver for Front in MicroStrategy Desktop
Connect to Front data in MicroStrategy Desktop using the CData Software ODBC Driver for Front.
-
Access Live Oracle Sales Data in AWS Lambda
Connect to live Oracle Sales data in AWS Lambda using the CData JDBC Driver.
-
How to Visualize Okta 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 Okta data in Python.
-
A PostgreSQL Interface for PayPal Data using the CData ODBC Driver
Use the SQL Gateway and PayPal ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Python Connector for ShipStation
Learn to install and license the CData Python Connector and configure a connection to live ShipStation data.
-
Process & Analyze PabblySubscriptions Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PabblySubscriptions Data.
-
Getting Started with the CData Power BI Connector for Parquet
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Parquet.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zendesk
Provide connectivity to Zendesk data through an SAP BusinessObjects universe.
-
Integrate Adobe Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Analytics data in the Pentaho Data Integration tool.
-
Getting Started with the CData Tableau Connector for Pingdom
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use Azure AI Foundry to Talk to Your Samanage 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 Samanage data for you.
-
Visualize Freshdesk 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 Freshdesk data into TIBCO Spotfire.
-
Bind Live Authorize.Net Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Authorize.Net data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate Live Tickspot Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tickspot data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous GetResponse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GetResponse data replication to OneLake in Microsoft Fabric.
-
Connect to Mocean Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mocean data using standard SQL.
-
Analyze Microsoft Planner Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Planner from Power Pivot. You will use the Table Import Wizard to load Microsoft Planner data. You can visually build the import query or use any SQL supported by the driver.
-
Query Shippo Data in ColdFusion
Write standard ColdFusion data access code to connect to Shippo data.
-
Integrate Goose with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Gong data from within the local AI agent.
-
How to connect to FreeAgent Data from IntelliJ
Integrate connectivity to FreeAgent data with wizards in IntelliJ.
-
Getting Started with the CData ODBC Driver for LinkedIn
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LinkedIn.