CData Software - Knowledge Base
Recent Articles
-
How to load SAP Ariba Procurement data into Elasticsearch via Logstash
Introducing a simple method to load SAP Ariba Procurement data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Python Connector for Humanity
Learn to install and license the CData Python Connector
-
How to publish and share Moosend Data dashboards with Tableau Server
The CData ODBC driver for Moosend enables you integrate Moosend into Tableau dashboards.
-
Integrating Claude Code CLI with Shortcut 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.
-
Access Live Okta Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Okta from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Dashboards with OData Services in DBxtra
Create dynamic dashboards and perform analytics based on OData in DBxtra.
-
Integrating Kintone Data in Talend Cloud Data Management Platform
Connect Kintone Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Kintone.
-
Connect to Qualaroo in SpagoBI
Create reports featuring live Qualaroo in SpagoBI Studio. Host Qualaroo reports on SpagoBI Server.
-
Natively Connect to Pipeline CRM Data in PHP
The CData ODBC driver for Pipeline CRM enables you to create PHP applications with connectivity to Pipeline CRM. Leverage the native support for ODBC in PHP.
-
Automate ZohoExpense Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoExpense from PowerShell? This article demonstrates how to utilize the ZohoExpense Cmdlets for tasks like connecting to ZohoExpense, automating operations, downloading data, and more.
-
Import and Visualize Supabase Data in Power View
Create data visualizations based on Supabase in Excel.
-
Natively Connect to Jumpseller Data in PHP
The CData ODBC driver for Jumpseller enables you to create PHP applications with connectivity to Jumpseller. Leverage the native support for ODBC in PHP.
-
Build EnterpriseDB-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for EnterpriseDB to explore live EnterpriseDB Data in Claude Code to assist with building EnterpriseDB-powered applications.
-
Build Dashboards with Todoist Data in DBxtra
Create dynamic dashboards and perform analytics based on Todoist in DBxtra.
-
Access Live IBM Informix Data in AWS Lambda
Connect to live IBM Informix in AWS Lambda using the CData JDBC Driver.
-
Connecting Agentforce with Smartsheet 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 Smartsheet for you.
-
Access Live Kintone Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Kintone from your Excel spreadsheets.
-
How to Connect to Live Zoho CRM 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 Zoho CRM for you.
-
Rapidly Develop Klipfolio-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 Klipfolio.
-
Integrate ClickUp Data in the Pentaho Report Designer
Publish reports based on ClickUp in the Pentaho BI tool.
-
Connect to and Query ServiceDesk Plus Data in QlikView over ODBC
Create data visualizations with ServiceDesk Plus in QlikView.
-
A PostgreSQL Interface for Salesforce CRM Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce CRM Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze CockroachDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of CockroachDB and visualize live CockroachDB in Infragistics Reveal.
-
Integrate Dynamics 365 Data in the Pentaho Report Designer
Publish reports based on Microsoft Dynamics 365 in the Pentaho BI tool.
-
Migrating data from ServiceDesk Plus to Databricks using CData SSIS Components.
Easily push ServiceDesk Plus to Databricks using the CData SSIS Tasks for ServiceDesk Plus and Databricks.
-
Integrate Dropbox Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Dropbox from Informatica Cloud.
-
Integrate Salesforce CRM Analytics Data in the Pentaho Report Designer
Publish reports based on Salesforce CRM Analytics in the Pentaho BI tool.
-
Integrating LionDesk Data in Talend Cloud Data Management Platform
Connect LionDesk Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Apps with Live AdRoll Data Using the Low-Code Development Platform of Mendix
Connect AdRoll with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze Amplitude Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amplitude in Microsoft R Open.
-
Connect to Recurly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Oracle Eloqua Reporting Data in DataGrip
Create a Data Source for Oracle Eloqua Reporting in DataGrip and use SQL to query live Oracle Eloqua Reporting.
-
Natively Connect to LinkedIn Data in PHP
The CData ODBC driver for LinkedIn enables you to create PHP applications with connectivity to LinkedIn. Leverage the native support for ODBC in PHP.
-
Validate IBM Informix Data with QuerySurge
Access and validate IBM Informix in QuerySurge using the CData JDBC Driver.
-
Connect to Bullhorn CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bullhorn CRM in the Denodo Virtual DataPort Administrator.
-
Consume Sage Cloud Accounting OData Feeds in PowerBuilder
This article demonstrates how to consume Sage Business Cloud Accounting as OData feeds from PowerBuilder using the API Server.
-
How to Build an ETL App for YouTube Analytics Data in Python with CData Connect AI
Build ETL pipelines that read and write live YouTube Analytics in Python with petl and the CData Connect AI Python SDK.
-
Integrating LangGraph with Cassandra Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apache Cassandra within automated workflows.
-
Connect to Moosend Data in HULFT Integrate
Connect to Moosend as a JDBC data source in HULFT Integrate
-
Create Reports with ConvertAPI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConvertAPI.
-
Publish Reports with Mailjet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mailjet.
-
Work with Live Impala Data in Power Query
Use CData Connect AI to connect to Apache Impala and work with live Apache Impala in Microsoft Power Query.
-
Create Spotify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Spotify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Antigravity CLI with ZendeskSell via CData CLI
Connect ZendeskSell to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Prepare, Blend, and Analyze Klaviyo Data in Alteryx Designer (Connect AI)
Build workflows to access live Klaviyo for self-service data analytics.
-
Easily Integrate Dotmailer Data in Lazarus Pascal IDE
Learn how to easily integrate live Dotmailer in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect the Power BI Service to Snapchat Ads: Complete Guide
Connect to the CData Software Power BI Connector for Snapchat Ads from PowerBI.com to provide real-time Snapchat Ads across the organization.
-
Build a Simple VCL Application for SAP HANA Data
How to build a simple VCL Application to view SAP HANA in RAD Studio using the CData ODBC Driver for SAP HANA.
-
Create Data Visualizations in Cognos BI with Aweber Data
Access Aweber as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Live Blackbaud FE NXT Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Blackbaud FE NXT and integrate live Blackbaud FE NXT into apps built in Microsoft Power Apps.
-
Create Data Visualizations in Cognos BI with SageHR Data
Access SageHR as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind CapsuleCRM Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CapsuleCRM to a chart.
-
Automated Continuous SurveyMonkey Replication to SingleStore
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to SingleStore.
-
Extract, Transform, and Load ZohoInvoice Data in Informatica PowerCenter
Create a simple Workflow for ZohoInvoice in Informatica PowerCenter.
-
Connect Marketo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Marketo using the CData Python MCP Server.
-
Integrating LangChain with SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP SuccessFactors LMS within automated workflows.
-
Connect to Cassandra Data in NetBeans
Connect to Apache Cassandra in NetBeans with the data source configuration wizard.
-
Build AI/ML Models with Live Front Data using Dataiku
Connect Front Data with Dataiku using the CData API Driver for JDBC.
-
Create Reports with LinkedIn Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LinkedIn Ads.
-
Prepare, Blend, and Analyze SingleStore Data in Alteryx Designer (Connect AI)
Build workflows to access live SingleStore for self-service data analytics.
-
Create Google Campaign Manager 360-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Campaign Manager 360 Data from OutSystems and build custom enterprise apps using live Google Campaign Manager 360.
-
Access Live Phoenix Data in AWS Lambda
Connect to live Apache Phoenix in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Azure Data Lake Storage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Data Lake Storage to Blue Prism using the CData ODBC Driver for Azure Data Lake Storage to create automated workflows for repetitive business tasks.
-
Use JayDeBeApi to access ChargeOver Data in Python
Use standard Python scripting and the development environment of your choice to access live ChargeOver.
-
Connect to Google Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Ads.
-
How to Connect Flowise AI Agents to Live CSV 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 CSV/TSV Files without replication.
-
Automated Continuous Retently Replication to SQL Server
Use CData Sync for automated, continuous, customizable Retently replication to SQL Server.
-
Build Dropbox-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dropbox.
-
Create Data Visualizations Based On API Data in Mode
Use CData Connect AI to connect to API Data from Mode and build visualizations using live
-
Integrate with JobNimbus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy JobNimbus to a JSON file on disk.
-
OpenWeatherMap Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on OpenWeatherMap facts in real time.
-
Connect Pipeliner CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pipeliner CRM with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to Aircall Data in DBVisualizer
Integrate Aircall with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Reports with SendInBlue Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendInBlue.
-
Integrate Live ADP Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ADP from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ADP.
-
A PostgreSQL Interface for EmailOctopus Data using the CData ODBC Driver
Use the SQL Gateway and EmailOctopus ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Workflows with Live WordPress Data in Workato
Use CData Connect AI to connect to live WordPress and build automated workflows in Workato.
-
Build Voice Agents in ElevenLabs with access to Live SAP HANA Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP HANA.
-
How to Access Live Omnisend Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Omnisend enables you to integrate Omnisend into workflows built using Microsoft Power Automate Desktop.
-
Use the CData ODBC Driver for Amazon Marketplace from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon Marketplace to connect to Amazon Marketplace from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon Marketplace in Excel.
-
Deploy the ADO.NET Provider for Freshdesk on an SSRS Report Server
Connect to Freshdesk 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.
-
Integrate Cursor with Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache HBase from within the editor.
-
Publish Reports with Gorgias Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gorgias.
-
Import Real-Time Teradata Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Teradata in ColdFusion.
-
How to Connect to Live SQL Server Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft SQL Server securely in real time.
-
Getting Started with the CData Excel Add-In for IBM Informix
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for IBM Informix.
-
How to use SQLAlchemy ORM to access MariaDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MariaDB.
-
Import Real-Time Yelp Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Yelp in ColdFusion.
-
Connect BigQuery Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google BigQuery using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Timely
Learn to install and license the CData Python Connector
-
Validate Cohere Data with QuerySurge
Access and validate Cohere in QuerySurge using the CData JDBC Driver.
-
Build Visualizations of HBase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache HBase in Birst.
-
Deploy the ADO.NET Provider for Google Forms on an SSRS Report Server
Connect to Google Forms 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.
-
Automated Continuous YouTube Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to SQL Server.
-
Create Act-On-Connected Applications in Appsmith
Connect to Act-On Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Act-On.
-
Automated Continuous EmailOctopus Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Amazon Redshift.
-
Use the CData SSIS Components to Insert New or Update Existing GitHub Records from SQL Server
Easily push SQL Server data to GitHub using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into GitHub or update existing records with data from a SQL Server database.
-
How to create Oracle Sales federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Sales in MySQL .
-
How to Build an ETL App for DocuSign Data in Python with CData Connect AI
Build ETL pipelines that read and write live DocuSign in Python with petl and the CData Connect AI Python SDK.
-
Connect to Insightly Data in DBeaver
Use the CData ODBC Driver to connect to Insightly in DBeaver.