CData Software - Knowledge Base
Recent Articles
-
Connect and Visualize Live Redis Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Redis data into the Databricks platform and create visualization dashboards with real-time Redis data.
-
How to use SQLAlchemy ORM to access Cassandra Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Cassandra data.
-
How to update Instagram from Excel
This article explains how to transfer data from Excel to Instagram using the Excel Add-In for Instagram.
-
Connecting GenSpark with Quickbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Quickbase data without any replication or custom integration required.
-
Visualize Live Amazon DynamoDB Data in the Power BI Service
Use CData Connect AI to connect to live Amazon DynamoDB data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to xBase Data from a Connection Pool in JBoss
Integrate xBase data into Java servlets: Use the Management Console in JBoss to install the xBase JDBC Driver.
-
Access Float Data from MySQL in PHP
Connect to Float through the standard MySQL libraries in PHP.
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy Web
Connect to Vault CRM data in MicroStrategy Web using the CData Software JDBC Driver for Vault CRM.
-
Build MVC Applications with Connectivity to WooCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access WooCommerce from an ASP.NET MVC application.
-
How to Access Cassandra Data Using Entity Framework
This article shows how to access Cassandra data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live Klipfolio Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Klipfolio data securely in real time.
-
A PostgreSQL Interface for Simplesat Data (MySQL Remoting via JDBC)
Use the Remoting features of the Simplesat JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage Amazon Athena Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon Athena.
-
How to connect Amazon QuickSight to SharePoint Data
Create a connection to SharePoint data in CData Connect AI and insert SharePoint data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to LinkedIn Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LinkedIn Ads data.
-
Model AgileCRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and AgileCRM, enabling the direct import of real-time AgileCRM data.
-
Integrate Theia IDE with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Microsoft OneDrive data from within the development environment.
-
Publish Crystal Reports on EnterpriseDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date EnterpriseDB data.
-
Automated PDFMonkey Data Replication to Teradata
Use CData Sync to Customize and automate PDFMonkey data replication to Teradata.
-
Connect and Query Live Guru Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Guru data into Databricks and enable direct, live querying and analysis without replication.
-
Build Google Spanner-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Spanner data and build Google Spanner-connected web apps with Axios.
-
Access Live Azure Synapse Data in Excel 365 Online (Excel for the web)
Connect to Azure Synapse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live RSS Feeds in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live RSS feeds through MCP integration.
-
Connect ClickTime Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ClickTime data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Visualize Azure Data Lake Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Data Lake Storage data in Python.
-
Natively Connect to JobNimbus Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to JobNimbus data. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Zendesk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zendesk data by developing a WCF Service Application.
-
How to connect to Browserless Data in DBVisualizer
Integrate Browserless data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Real-Time Cloudant Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Cloudant and Dataflow to import and use Cloudant data in Power Apps.
-
Integrate Power BI XMLA Data in the Pentaho Report Designer
Publish reports based on Power BI XMLA data in the Pentaho BI tool.
-
Connect to Epicor Kinetic Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Epicor Kinetic and the Script function in FileMaker Pro to connect to Epicor Kinetic and work with Epicor Kinetic data in your FileMaker application.
-
Build Dashboards with Foursquare Data in Dundas BI
Create dynamic dashboards and perform analytics based on Foursquare data in Dundas BI.
-
Integrating OpenCode with Factorial 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.
-
How to Connect the Power BI Service to Teamgate: Complete Guide
Connect to the CData Software Power BI Connector for Teamgate from PowerBI.com to provide real-time Teamgate data across the organization.
-
A PostgreSQL Interface for ActiveCampaign Data using the CData ODBC Driver
Use the SQL Gateway and ActiveCampaign ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Chargebee Data in ColdFusion
Write standard ColdFusion data access code to connect to Chargebee data.
-
Connect to Rebilly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Rebilly data using standard SQL.
-
Connect to Pinecone Data from a Connection Pool in JBoss
Integrate Pinecone data into Java servlets: Use the Management Console in JBoss to install the Pinecone JDBC Driver.
-
Connect to CampaignMonitor 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 CampaignMonitor and work with CampaignMonitor data in your FileMaker application.
-
Use Biml to Build SSIS Tasks to Replicate Box Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Box data to SQL Server.
-
Seamlessly Bring Twilio Data into Retool Using CData Connect AI
Integrate Twilio data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build AI Agents with SAP Netweaver Gateway 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 Netweaver Gateway data through CData Connect AI.
-
How to Connect to Live Azure Data Lake Storage 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 Azure Data Lake Storage data for you.
-
How to Seamlessly Import Access Data into IBM SPSS Modeler
Integrate Access data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Real-Time Oracle SCM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle SCM and Dataflow to import and use Oracle SCM data in Power Apps.
-
Getting Started with the CData Tableau Connector for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Excel Spreadsheet Automation on Gorgias Data with the QUERY Formula
Pull data from Gorgias, automate spreadsheets, and more with the QUERY formula.
-
Create Apps from HubDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to HubDB Data and build apps from live HubDB data in Qlik Sense Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for Greenhouse
Create Greenhouse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy
Connect to Microsoft Dataverse data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Dataverse.
-
Automated Continuous PostgreSQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PostgreSQL replication to IBM DB2.
-
Build Paylocity-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Paylocity data.
-
Connect to Teamwork Data in RapidMiner
Integrate Teamwork data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Calendly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Calendly and work with Calendly data in your FileMaker applications.
-
How to connect PolyBase to Cloudant
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Cloudant data.
-
Visualize AdRoll Data in TIBCO Spotfire through ADO.NET
Integrate AdRoll data into dashboards in TIBCO Spotfire.
-
A Comparison of Drivers for Amazon DynamoDB
An article comparing the read performance, client-side resource usage, and read capacity consumption of different JDBC drivers for Amazon DynamoDB.
-
Use Microsoft Copilot Studio to talk to your PolarTeamPro 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 PolarTeamPro data for you.
-
How to Work with Miro Data in AWS Glue Jobs Using JDBC
Connect to Miro from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect PolyBase to AdRoll
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AdRoll data.
-
Query Mailgun Data as a SQL Server Database in Node.js
Execute SQL Server queries against Mailgun data from Node.js.
-
Create Datasets from Oracle Eloqua Reporting in Domo Workbench and Build Visualizations of Oracle Eloqua Reporting Data in Domo
Use the CData Software ODBC Driver for Oracle Eloqua Reporting to create datasets from Oracle Eloqua Reporting data in Domo Workbench and then build visualizations in the Domo service.
-
Natively Connect to Spotify Data in PHP
The CData ODBC driver for Spotify enables you to create PHP applications with connectivity to Spotify data. Leverage the native support for ODBC in PHP.
-
Visualize Live Egnyte Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Egnyte data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Cursor with Coda 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.
-
Automated Continuous Power BI XMLA Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Amazon S3.
-
Automated Continuous Mode Replication to SQLite
Use CData Sync for automated, continuous, customizable Mode replication to SQLite.
-
Integrate Outlook with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Outlook with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Outlook data.
-
Integrate Twitter Ads Data in the Pentaho Report Designer
Publish reports based on Twitter Ads data in the Pentaho BI tool.
-
How to Seamlessly Import Reckon Accounts Hosted Data into IBM SPSS Modeler
Integrate Reckon Accounts Hosted data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Claude Code CLI with Flowlu 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.
-
Automated Continuous DB2 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable DB2 replication to Apache Kafka.
-
Work with SAP BusinessObjects BI Data in FoxPro
Load SAP BusinessObjects BI data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Sendwithus Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sendwithus data and visualize Sendwithus data in SAP Analytics Cloud.
-
Integrate Goose with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sugar CRM data from within the local AI agent.
-
Automated Continuous Egnyte Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Egnyte replication to Apache Kafka.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy Desktop
Connect to JDBC-ODBC Bridge data in MicroStrategy Desktop using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Integrate Oracle Eloqua Data into Power Automate Desktop using CData Connect
CData Connect for Oracle Eloqua Data enables you to integrate Oracle Eloqua data into workflows built using Microsoft Power Automate Desktop.
-
Connect and Visualize Live OData Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live OData services into the Databricks platform and create visualization dashboards with real-time OData services.
-
Connect to JotForm Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for JotForm data.
-
Connect to Google Search Results as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Search results.
-
Connect to ZohoPeople Data from HeidiSQL
Use CData Connect AI to connect to and query live ZohoPeople data from HeidiSQL.
-
Integrate Zoho Recruit Data in Pentaho Data Integration
Build ETL pipelines based on Zoho Recruit data in the Pentaho Data Integration tool.
-
Connect and Query Live SAP SuccessFactors Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors data into Databricks and enable direct, live querying and analysis without replication.
-
Getting Started with the CData JDBC Driver for Jira
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jira.
-
Bidirectional Access to Snapchat Ads Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Snapchat Ads data in Filemaker Pro for Mac or Windows.
-
Viewing Nethunt Data in RAD Studio Data Explorer
How to view Nethunt data in RAD Studio Data Explorer using the CData ODBC Driver for Nethunt.
-
Connect to Yelp Data in Google Apps Script via Connect AI
Use CData Connect AI to access Yelp data in Google Apps Script.
-
Integrate LibreChat with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Twitter Ads data from within the chat interface.
-
Migrating data from Salesforce CRM Analytics to Databricks using CData SSIS Components.
Easily push Salesforce CRM Analytics data to Databricks using the CData SSIS Tasks for Salesforce CRM Analytics and Databricks.
-
Build Agents in Relevance AI with Access to Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sage Intacct data within intelligent agent workflows.
-
Build AI Agents with GitHub 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 GitHub data through CData Connect AI.
-
Replicate Zoom Data to Multiple Databases via the CData Sync CLI
Replicate Zoom data to disparate databases with a single configuration.
-
Provide OData Services of SAP SuccessFactors Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP SuccessFactors data by developing a WCF Service Application.
-
Work with Google Cloud Storage Data in FoxPro
Load Google Cloud Storage data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Claude Code with BigQuery Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on BigQuery data within assisted coding and automated development workflows.
-
How to Query Postmark Data in MySQL Workbench
Execute MySQL queries against live Postmark data from MySQL Workbench.
-
A PostgreSQL Interface for Oracle HCM Cloud Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle HCM Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Sage 200 Data in Talend Cloud Data Management Platform
Connect Sage 200 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage 200.
-
Excel Spreadsheet Automation on CapsuleCRM Data with the QUERY Formula
Pull data from CapsuleCRM, automate spreadsheets, and more with the QUERY formula.