CData Software - Knowledge Base
Recent Articles
-
Process & Analyze ClickUp Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ClickUp Data.
-
Natively Connect to PagerDuty Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PagerDuty. Leverage the native support for ODBC in PHP.
-
How to Query Bright Data Data in MySQL Workbench
Execute MySQL queries against live Bright Data from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pingdom
Provide connectivity to Pingdom through an SAP BusinessObjects universe.
-
Stream Azure Analysis Services Data into Apache Kafka Topics
Access and stream Azure Analysis Services in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Reckon Replication to Snowflake
Use CData Sync for automated, continuous, customizable Reckon replication to Snowflake.
-
Connect to Marketo Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Marketo in Airbyte.
-
Migrating data from Kintone to Google BigQuery using CData SSIS Components.
Easily push Kintone to Google BigQuery using the CData SSIS Tasks for Kintone and Google BigQuery.
-
Integrating Azure Table Data in Talend Cloud Data Management Platform
Connect Azure Table Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Table.
-
How to work with Perigon Data in Apache Spark using SQL
Access and process Perigon Data in Apache Spark using the CData Software JDBC Driver.
-
Use JayDeBeApi to access Eventbrite Data in Python
Use standard Python scripting and the development environment of your choice to access live Eventbrite.
-
Analyze Zoho Books Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Books from Power Pivot. You will use the Table Import Wizard to load Zoho Books. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Gumloop with GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on GitLab within automated workflows.
-
Migrating data from SparkPost to Snowflake using CData SSIS Components.
Easily push SparkPost to Snowflake using the CData SSIS Tasks for SparkPost and Snowflake.
-
Build Data Flows from Certinia to SQL Server using SSIS
Easily back up Certinia to SQL Server using the SSIS components for Certinia.
-
Visualize Live Helpscout Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Helpscout.
-
Connect to Amazon DynamoDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon DynamoDB and the SQL Gateway to access Amazon DynamoDB from Google Apps Script.
-
Import Zoho Inventory Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho Inventory Data and provide access to live Zoho Inventory for custom reports in the Power BI Service.
-
Create Reports with CloudConvert Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CloudConvert.
-
Creating Hive-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Hive to Unqork and build custom business apps.
-
Connect to Dynamics 365 Business Central 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 Dynamics 365 Business Central.
-
Automated Continuous Sybase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sybase replication to delimited files (CSV/TSV).
-
DataBind Controls to SAP Ariba Procurement Data in C++Builder
DataBind to SAP Ariba Procurement in C++Builder with standard components and controls.
-
Publish Browserless-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Browserless.
-
Integrating Kiro CLI with HCL Domino 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.
-
Explore Geographical Relationships in Google Ads Data with Power Map
Create data visualizations with Google Ads in Power Map.
-
Automated Continuous Trello Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Trello replication to Apache Cassandra.
-
Build a Singer.io Tap for DB2 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live DB2 data using
-
Bridge Cloudflare Connectivity with Apache NiFi
Access and process Cloudflare in Apache NiFi using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Nethunt Data
Use CData Power BI Connectors to visualize Nethunt in Power BI.
-
Build Optimizely-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Optimizely and build web apps with connectivity to live Optimizely.
-
Access Sage 200 Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Sage 200.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace for you.
-
Automated Continuous Ontraport Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Ontraport replication to Amazon Redshift.
-
How to Work with FormSite Data in AWS Glue Jobs Using JDBC
Connect to FormSite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Drip Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Drip.
-
Enable the Teradata JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Teradata.
-
Build a PostgreSQL Interface for Azure DevOps Data using the CData JDBC Driver
Use the Remoting features of the Azure DevOps JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Create Power BI Visual Reports with Real-Time Gong Data
Use CData Power BI Connectors to visualize Gong in Power BI.
-
Connect to Facebook Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Facebook and the Script function in FileMaker Pro to connect to Facebook and work with Facebook in your FileMaker application.
-
How to Design SAP Concur Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAP Concur from mobile and tablet Power Apps.
-
Automate Shopify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Shopify from PowerShell? This article demonstrates how to utilize the Shopify Cmdlets for tasks like connecting to Shopify, automating operations, downloading data, and more.
-
Visualize Live Email Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Email.
-
Build Foursquare-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Foursquare and build web apps with connectivity to live Foursquare.
-
Connect Klipfolio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Klipfolio using the CData Python MCP Server.
-
Import and Visualize Adobe Target Data in Power View
Create data visualizations based on Adobe Target in Excel.
-
Build Redis-Connected Apps in Choreo
Use CData Connect AI to connect to Redis Data from Choreo and build custom apps using live Redis.
-
How to Query Live NetSuite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live NetSuite CRM & ERP data in natural language using Python.
-
Integrate with SharePoint Data in JReport Designer
Create charts and reports based on Microsoft SharePoint in JReport Designer.
-
Viewing Guru Data in RAD Studio Data Explorer
How to view Guru in RAD Studio Data Explorer using the CData ODBC Driver for Guru.
-
Build Apps with Live Oracle Eloqua in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Eloqua into the Adalo platform and build custom mobile and web applications with real-time Oracle Eloqua.
-
Integrating GitHub Copilot CLI with EnterpriseDB 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.
-
How to Connect Flowise AI Agents to Live JSON Services via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live JSON without replication.
-
How to Visualize Quaderno Data in Python with pandas
Use pandas and other modules to analyze and visualize live Quaderno in Python.
-
Object-Relational Mapping (ORM) with Paddle 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 Paddle into a Java-based ORM framework, Hibernate.
-
Working with ADP Data in LINQPad
Execute LINQ queries to ADP in LINQPad.
-
Connect to Real-Time Parquet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Parquet and Dataflow to import and use Apache Parquet in Power Apps.
-
Design BIRT Reports on Nuclia Data
Provide current Nuclia to your embedded analytics.
-
Visualize Live Amazon S3 Data in the Power BI Service
Use CData Connect AI to connect to live Amazon S3 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous PostgreSQL Replication to SQL Server
Use CData Sync for automated, continuous, customizable PostgreSQL replication to SQL Server.
-
Use ChatGPT to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Dynamics CRM for you.
-
Connect to and Visualize Live Aircall Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Aircall.
-
Automated Continuous Oracle SCM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Apache Cassandra.
-
Create MySQL-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MySQL Data from Klipfolio and build custom visualizations using live MySQL.
-
Automate Oracle Eloqua Reporting Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Eloqua Reporting from PowerShell? This article demonstrates how to utilize the Oracle Eloqua Reporting Cmdlets for tasks like connecting to Oracle Eloqua Reporting, automating operations, downloading data, and more.
-
Integrate Coinbase Data in the Pentaho Report Designer
Publish reports based on Coinbase in the Pentaho BI tool.
-
Getting Started with the CData ADO.NET Provider for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to XML Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to XML Files. Leverage the pyodbc module for ODBC in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Discord
Provide connectivity to Discord through an SAP BusinessObjects universe.
-
Using the CData Software ODBC Driver for Sugar CRM in PyCharm
Connect to Sugar CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sugar CRM.
-
Connect to Adobe Experience Manager from Asprova with CData Software ODBC Driver for Adobe Experience Manager
This article shows how to connect faster to Adobe Experience Manager data from Asprova.
-
Integrating Codex CLI with Eventbrite 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 Keap Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Keap replication to Azure SQL Database.
-
Natively Connect to HelloSign Data in PHP
The CData ODBC driver for HelloSign enables you to create PHP applications with connectivity to HelloSign. Leverage the native support for ODBC in PHP.
-
Connect to HCL Domino Data in DBeaver
Use the CData ODBC Driver to connect to HCL Domino in DBeaver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cosmos DB
Provide connectivity to Azure Cosmos DB through an SAP BusinessObjects universe.
-
How to use SQLAlchemy ORM to access Salesforce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce & Force.com.
-
Connect to PostgreSQL Data in Google Apps Script via Connect AI
Use CData Connect AI to access PostgreSQL in Google Apps Script.
-
Integrating Ontraport Data in Talend Cloud Data Management Platform
Connect Ontraport Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to BigQuery from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google BigQuery, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to Front Data from IntelliJ
Integrate connectivity to Front with wizards in IntelliJ.
-
Query Kintone Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Kintone and perform CRUD operations on Kintone from Node.js.
-
Build Blackbaud FE NXT-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Blackbaud FE NXT to explore live Blackbaud FE NXT Data in Cursor to assist with building Blackbaud FE NXT-powered applications.
-
Natively Connect to Xero Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Xero Accounting. Leverage the native support for ODBC in PHP.
-
Connect to Mode Data in DBeaver
Use the CData ODBC Driver to connect to Mode in DBeaver.
-
Choosing the Best Method to Connect Impala to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Impala from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Hugging Face with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hugging Face with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Hugging Face.
-
Getting Started with the CData Python Connector for Aircall
Learn to install and license the CData Python Connector
-
How to Connect Flowise AI Agents to Live SAP HANA 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 SAP HANA without replication.
-
Process & Analyze JobNimbus Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live JobNimbus Data.
-
Import Real-Time AdRoll Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use AdRoll in ColdFusion.
-
Provide OData Services of OpenWeatherMap Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for OpenWeatherMap by developing a WCF Service Application.
-
Connect to Google Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Analytics from Appeon PowerBuilder using the CData ADO.NET Provider for Google Analytics.
-
Build Jira Assets-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Jira Assets to explore live Jira Assets Data in Claude Code to assist with building Jira Assets-powered applications.
-
Use the CData ODBC Driver for Mixpanel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mixpanel to connect to Mixpanel from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mixpanel in Excel.
-
Automated Continuous Jumpseller Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Jumpseller replication to Apache Cassandra.
-
Explore Geographical Relationships in Drip Data with Power Map
Create data visualizations with Drip in Power Map.
-
Access Live Zoho Books Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Books into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Books in the Graph Builder and Query Builder.
-
Query HubDB Data from Node.js
Use the OData endpoint of the CData API Server to connect to your HubDB and perform CRUD operations on HubDB from Node.js.
-
Visualize Avaza Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Avaza.