CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to FTP data without any replication or custom integration required.
-
View Reports on Real-Time ScrapingBee Data in Power BI Report Server
Use the CData ODBC Driver for ScrapingBee to visualize ScrapingBee data in Power BI Desktop and then publish them to Power BI Report Server.
-
Establish a Live Connection with ZohoDesk Data using Tableau Bridge
The CData ODBC Driver for ZohoDesk enables you to integrate live ZohoDesk data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create an RPA flow for Brex Data in UiPath Studio
Use the Brex ODBC Driver to create workflows that access real-time Brex data without any coding.
-
Use the CData Software ODBC Driver for MailerSend in SAS for Real-Time Reporting and Analytics
Connect to real-time MailerSend data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MailerSend.
-
Rapidly Develop Clockify-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 Clockify.
-
Connect to Real-Time Bitly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bitly data in Power Apps.
-
Create Dynamic ShipEngine Grids Using the Infragistics XamDataGrid
Learn how you can connect ShipEngine to Infragistics XamDataGrid to build dynamic grids.
-
Connect and Visualize Live SAP SuccessFactors LMS Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors LMS data into the Databricks platform and create visualization dashboards with real-time SAP SuccessFactors LMS data.
-
Automated Continuous SAS xpt Replication to MySQL
Use CData Sync for automated, continuous, customizable SAS xpt replication to MySQL.
-
Automated Continuous Moosend Replication to Vertica
Use CData Sync for automated, continuous, customizable Moosend replication to Vertica.
-
Access Close Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Close data from your Oracle system.
-
Use ChatGPT to Talk to Your Amazon DynamoDB 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 Amazon DynamoDB data for you.
-
Visualize SAS xpt Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS xpt data.
-
Connect to Freshdesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshdesk data using standard SQL.
-
Configure the CData JDBC Driver for Wave Financial in a Connection Pool in Tomcat
Connect to Wave Financial data from a connection pool in Tomcat.
-
Access Live Dynamics NAV Data in Coginiti Pro
Connect to and query live Dynamics NAV data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Accelo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Accelo data from HeidiSQL.
-
Natively Connect to Insightly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Insightly data. Leverage the native support for ODBC in PHP.
-
Stream Impala Data into Apache Kafka Topics
Access and stream Impala data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Seamlessly Import Instagram Data into IBM SPSS Modeler
Integrate Instagram data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI Agents with SAP Hybris C4C Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Hybris C4C data through CData Connect AI.
-
Getting Started with the CData SSIS Components for Coda
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Coda.
-
Automate GitHub Data Replication to Azure Data Lake
Use CData Sync to customize and automate GitHub data replication to Azure Data Lake.
-
Access Humanity Data from MySQL in PHP
Connect to Humanity through the standard MySQL libraries in PHP.
-
How to Connect to Live Freshservice Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Freshservice data without replication.
-
How to work with Paddle Data in Apache Spark using SQL
Access and process Paddle Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Oracle Eloqua Reporting Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to SQLite.
-
DataBind Jira Assets Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Jira Assets with the DevExpress Windows Forms and Web controls to provide Jira Assets data to a chart.
-
Build Data Flows from HCL Domino to SQL Server using SSIS
Easily back up HCL Domino data to SQL Server using the SSIS components for HCL Domino.
-
Use the CData Software JDBC Driver for Outreach.io in MicroStrategy Desktop
Connect to Outreach.io data in MicroStrategy Desktop using the CData Software JDBC Driver for Outreach.io.
-
Choosing the Best Method to Connect PingOne to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PingOne data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed Codat Data into FineReport
How to set Codat data as a JDBC data source in FineReport.
-
How to Access MariaDB Data Using Entity Framework
This article shows how to access MariaDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live PingOne 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 PingOne data for you.
-
Import Presto Data Using Azure Data Factory
Use CData Connect AI to connect to Presto Data from Azure Data Factory and import live Presto data.
-
Migrating data from Telegram to Google BigQuery using CData SSIS Components.
Easily push Telegram data to Google BigQuery using the CData SSIS Tasks for Telegram and Google BigQuery.
-
Integrate Dify with Live Zoho Projects Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Zoho Projects data.
-
Automated Continuous SAP Ariba Procurement Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to AlloyDB.
-
Integrate ChartMogul Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ChartMogul data from Informatica Cloud.
-
How to Visualize Acumatica Data in Python with pandas
Use pandas and other modules to analyze and visualize live Acumatica data in Python.
-
Build AdRoll-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live AdRoll data.
-
Use JayDeBeApi to access Bright Data Data in Python
Use standard Python scripting and the development environment of your choice to access live Bright Data data.
-
Build Data Flows from Jumpseller to SQL Server using SSIS
Easily back up Jumpseller data to SQL Server using the SSIS components for Jumpseller.
-
Getting Started with the CData Python Connector for Sybase IQ
Learn to install and license the CData Python Connector and configure a connection to live Sybase IQ data.
-
Connect to Redis Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Redis and the Script function in FileMaker Pro to connect to Redis and work with Redis data in your FileMaker application.
-
Query Aha! Data as a MySQL Database in Node.js
Execute MySQL queries against Aha! data from Node.js.
-
Connecting Moonlit Workflow with Paylocity Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Paylocity data in real time.
-
Access Live Bitly Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Bitly data from your Excel spreadsheets.
-
Replicate Jumpseller Data in Heroku for Use in Salesforce Connect
Replicate Jumpseller data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query Live Exact Online Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Exact Online data data in natural language using Python.
-
Integrating Claude Code with Dynamics NAV Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Dynamics NAV data within assisted coding and automated development workflows.
-
Viewing SendGrid Data in RAD Studio Data Explorer
How to view SendGrid data in RAD Studio Data Explorer using the CData ODBC Driver for SendGrid.
-
Build Mode-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mode data.
-
Connect SAS Data Sets Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAS Data Sets data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Write a Simple Go Application to work with Supabase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Supabase data.
-
Explore Geographical Relationships in Confluence Data with Power Map
Create data visualizations with Confluence data in Power Map.
-
Access Live Tally Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Tally data from your Excel spreadsheets.
-
Integrating Claude Code CLI with SAP Fieldglass 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.
-
Connect to Paddle Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Paddle as an External Source in Dremio.
-
Integrating Codex with Webflow 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.
-
Integrate FreshBooks with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FreshBooks with External Services.
-
Automated Continuous Shortcut Replication to MySQL
Use CData Sync for automated, continuous, customizable Shortcut replication to MySQL.
-
Create Reports with Typeform Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Typeform data.
-
Use the CData Software ODBC Driver for Aircall in MicroStrategy Web
Connect to Aircall data in MicroStrategy Web using the CData Software ODBC Driver for Aircall.
-
Bind Live Excel Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Excel data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate OpenCode with Live Sybase IQ Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sybase IQ data from within your AI coding agent.
-
Access Live Databricks Data in AWS Lambda
Connect to live Databricks data in AWS Lambda using the CData JDBC Driver.
-
Bidirectional Access to QuickBooks Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks data in Filemaker Pro for Mac or Windows.
-
Use Claude to Talk to Your Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Twilio data for you.
-
DataBind Charts to Slack Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Slack data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
ETL SAP Netweaver Gateway in Oracle Data Integrator
This article shows how to transfer SAP Netweaver Gateway data into a data warehouse using Oracle Data Integrator.
-
Visualize Live Mocean Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mocean data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Oracle Service Cloud Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Service Cloud data to a database.
-
Connect to Salesforce Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce and the Script function in FileMaker Pro to connect to Salesforce and work with Salesforce data in your FileMaker application.
-
Create SAP Ariba Source Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Ariba Source from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Deel in MicroStrategy
Connect to Deel data in MicroStrategy Developer using the CData Software JDBC Driver for Deel.
-
Connect to Mistral AI Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Mistral AI and work with Mistral AI data in your FileMaker application.
-
Automated Continuous YouTube Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Azure SQL Database.
-
How to Connect to Live Bitbucket Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Bitbucket data without replication.
-
Extract, Transform, and Load Adobe Target Data in Informatica PowerCenter
Create a simple Workflow for Adobe Target data in Informatica PowerCenter.
-
Integrate Google Drive Data in the Pentaho Report Designer
Publish reports based on Google Drive data in the Pentaho BI tool.
-
Integrating Boomi Agentstudio with Cosmos DB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Cosmos DB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to PagerDuty Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to PagerDuty and work with PagerDuty data in your FileMaker application.
-
How to Visualize Sage 200 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage 200 data in Python.
-
How to Connect BambooHR 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 BambooHR data in real time using natural language.
-
Build Dashboards with ChargeOver Data in DBxtra
Create dynamic dashboards and perform analytics based on ChargeOver data in DBxtra.
-
How to connect to Zuora Data in DBVisualizer
Integrate Zuora data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Charts with Retently Data in Clear Analytics
Create dynamic charts and perform analytics based on Retently data in Clear Analytics.
-
Getting Started with the CData Connect AI Python SDK for Amazon Athena
Install the CData Connect AI Python SDK to read and write live Amazon Athena data with standard DB-API 2.0 Python code.
-
Integrate PayPal Data in the Pentaho Report Designer
Publish reports based on PayPal data in the Pentaho BI tool.
-
Connect to Mailgun Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Mailgun Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Publish Reports with Certinia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Certinia data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Box
Provide connectivity to Box data through an SAP BusinessObjects universe.
-
Automated Continuous Hacker News Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Hacker News data replication to OneLake in Microsoft Fabric.
-
Explore Geographical Relationships in MailerLite Data with Power Map
Create data visualizations with MailerLite data in Power Map.
-
Getting Started with the CData Python Connector for GraphQL
Learn to install and license the CData Python Connector and configure a connection to live GraphQL data.
-
How to connect and process Gorgias data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gorgias data.
-
Build MVC Applications with Connectivity to Amazon Athena Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon Athena from an ASP.NET MVC application.
-
Build ActiveCampaign-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ActiveCampaign Data from Zoho Analytics and import live ActiveCampaign data.