CData Software - Knowledge Base
Recent Articles
-
Feed Couchbase Data into FineReport
How to set Couchbase data as a JDBC data source in FineReport.
-
Feed PhantomBuster Data into FineReport
How to set PhantomBuster data as a JDBC data source in FineReport.
-
Automated Continuous Avalara AvaTax Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avalara AvaTax data replication to OneLake in Microsoft Fabric.
-
How to Work with Reckon Accounts Hosted Data in ETL Validator JDBC
Connect to Reckon Accounts Hosted from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect Google Ad Manager to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Ad Manager data using the CData Python MCP Server.
-
Process & Analyze Printful Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Printful Data.
-
Analyze Live Azure Table Data in SAS Viya
Use CData Connect AI to connect to Azure Table data from SAS Viya and deploy self-service analytics using live Azure Table data.
-
Query Basecamp Data as a SQL Server Database in Node.js
Execute SQL Server queries against Basecamp data from Node.js.
-
How to connect SharePoint with Parquet Data through external lists
Provide Parquet data to SharePoint users as an external list.
-
How to Create Power BI Visual Reports with Real-Time CockroachDB Data
Use CData Power BI Connectors to visualize CockroachDB data in Power BI.
-
Query Mailjet Data in DataGrip
Create a Data Source for Mailjet in DataGrip and use SQL to query live Mailjet data.
-
Automated Continuous PabblySubscriptions Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to PostgreSQL.
-
Automated Continuous SQL Server Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SQL Server replication to Amazon Redshift.
-
How to create MarkLogic federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MarkLogic data in MySQL .
-
Access Live Odoo Data in Coginiti Pro
Connect to and query live Odoo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Edit and Search External DB2 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of DB2 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create DB2 Data objects that you can access from apps and the dashboard.
-
Deploy the ADO.NET Provider for xBase on an SSRS Report Server
Connect to xBase 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.
-
Connect to HubSpot Data in Aqua Data Studio
Access HubSpot data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Datasets from Google Calendar in Domo Workbench and Build Visualizations of Google Calendar Data in Domo
Use the CData Software ODBC Driver for Google Calendar to create datasets from Google Calendar data in Domo Workbench and then build visualizations in the Domo service.
-
Build a PostgreSQL Interface for eBay Analytics Data using the CData JDBC Driver
Use the Remoting features of the eBay Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Cassandra Data from PowerShell
Write a quick PowerShell script to query Cassandra data. Use connectivity to the live data to replicate Cassandra data to SQL Server.
-
Publish Reports with Eventbrite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Eventbrite data.
-
Create SAP Concur-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Concur Data from OutSystems and build custom enterprise apps using live SAP Concur data.
-
Query Humanity Data in ColdFusion
Write standard ColdFusion data access code to connect to Humanity data.
-
Integrate Live Mailjet Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Mailjet from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Mailjet data.
-
Excel Spreadsheet Automation on PagerDuty Data with the QUERY Formula
Pull data from PagerDuty, automate spreadsheets, and more with the QUERY formula.
-
How to Work with CouchDB Data in ETL Validator JDBC
Connect to CouchDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Nethunt with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Nethunt with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Nethunt data.
-
Build Visualizations of Eventbrite Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Eventbrite data in Birst.
-
Connect to Gumroad in SpagoBI
Create reports featuring live Gumroad data in SpagoBI Studio. Host Gumroad reports on SpagoBI Server.
-
Getting Started with the CData Power BI Connector for FHIR
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for FHIR.
-
Automate Sybase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sybase data replication to Azure Data Lake.
-
Connect to SAS xpt Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAS xpt data in Google Apps Script.
-
Create Paddle Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Paddle from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Microsoft Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Ads data.
-
How to integrate AlloyDB with Apache Airflow
Access and process AlloyDB data in Apache Airflow using the CData JDBC Driver.
-
Integrating GitHub Copilot with Rebilly 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics NAV
Provide connectivity to Dynamics NAV data through an SAP BusinessObjects universe.
-
Connecting Mastra with IBM Cloud Object Storage 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 Cloud Object Storage data, no replication required.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Postmark
Provide connectivity to Postmark data through an SAP BusinessObjects universe.
-
Automated Continuous CouchDB Replication to Oracle
Use CData Sync for automated, continuous, customizable CouchDB replication to Oracle.
-
Connect to Placid Data from PowerBuilder via ADO.NET
This article demonstrates how to access Placid data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live GitLab Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GitLab data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automate Zoho Recruit Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Recruit data replication to Azure Data Lake.
-
How to Connect DBeaver to Planio via a JDBC Driver
Manage Planio data with visual tools in DBeaver like the query browser.
-
How to Connect to Live Google Directory 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 Google Directory data without replication.
-
How to Visualize Phoenix 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 Phoenix data in Python.
-
Integrate Goose with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure DevOps data from within the local AI agent.
-
Connect to Cosmos DB Data in Google Apps Script via Connect AI
Use CData Connect AI to access Cosmos DB data in Google Apps Script.
-
Integrate Dify with Live Zoho Books 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 Books data.
-
Integrate Live Mailjet Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Mailjet data from within the IDE.
-
Connect to MariaDB Data in RazorSQL
Connect to MariaDB from wizards and query MariaDB data from the GUI in the RazorSQL database management tool.
-
Query Suadeo Data as a MySQL Database in Node.js
Execute MySQL queries against Suadeo data from Node.js.
-
How to Access Active Directory Data Using Entity Framework
This article shows how to access Active Directory data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live SFTP 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 SFTP data for you.
-
Create a Data Access Object for HubDB Data using JDBI
A brief overview of creating a SQL Object API for HubDB data in JDBI.
-
Stream AdRoll Data into Apache Kafka Topics
Access and stream AdRoll data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Vercel Data from PowerBuilder via JDBC
This article demonstrates how to access Vercel data from PowerBuilder using the Vercel JDBC Driver.
-
Excel Spreadsheet Automation on Snowflake Data with the QUERY Formula
Pull data from Snowflake, automate spreadsheets, and more with the QUERY formula.
-
Use the CData SSIS Components to Insert New or Update Existing HubDB Records from SQL Server
Easily push SQL Server data to HubDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into HubDB or update existing records with data from a SQL Server database.
-
Getting Started with the CData Excel Add-In for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Elasticsearch.
-
How to import Retently Data into Apache Solr
Use the CData Software JDBC Driver for Retently in Data Import Handler and create an automated import of Retently data to Apache Solr Enterprise Search platform.
-
Build Visualizations of Square Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Square data in Birst.
-
Connect to Onfleet from Asprova with CData Software ODBC Driver for Onfleet
This article shows how to connect faster to Onfleet data from Asprova.
-
Create Informatica Mappings From/To an ODBC Data Source for Xero
Create an ODBC connection to Xero in Informatica and browse and transfer Xero data.
-
Integrate Dify with Live Exact Online 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 Exact Online data.
-
Building Dynamic Web Pages with Neo4J Data Using AngularJS
Create single-page applications with live connectivity to Neo4J using the CData API Server.
-
Working with SendInBlue Data in LINQPad
Execute LINQ queries to SendInBlue data in LINQPad.
-
Access Live Printful Data in Coginiti Pro
Connect to and query live Printful data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Query Live Aha! Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Aha! data data in natural language using Python.
-
Create Power BI Reports on Real-Time Customer.io Data
Use the CData ODBC Driver for Customer.io to visualize Customer.io data in Power BI Desktop.
-
Bind Live SAP Business Warehouse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Business Warehouse data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Viewing Optimizely Data in RAD Studio Data Explorer
How to view Optimizely data in RAD Studio Data Explorer using the CData ODBC Driver for Optimizely.
-
Connect to Real-Time JSON Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for JSON and Dataflow to import and use JSON services in Power Apps.
-
How to use SQLAlchemy ORM to access Mouseflow Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mouseflow data.
-
Work with MessageBird Data in FoxPro
Load MessageBird data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Nuclia Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Nuclia replication to Azure SQL Database.
-
Use JayDeBeApi to access Unbounce Data in Python
Use standard Python scripting and the development environment of your choice to access live Unbounce data.
-
Use the CData Software ODBC Driver for Harvest in SAS for Real-Time Reporting and Analytics
Connect to real-time Harvest data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Harvest.
-
Connect Reckon Accounts Hosted Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon Accounts Hosted data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use CData Connect AI to Access GetResponse Data in Microsoft Power Pivot
Use CData Connect AI to connect to live GetResponse data in the Power Pivot business intelligence tool.
-
Using the CData Software ODBC Driver for Google Sheets in PyCharm
Connect to Google Sheets as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Sheets.
-
Model, Search, and Visualize Live Salesforce CRM Analytics Data in ThoughtSpot
Use CData Connect AI to connect to live Salesforce CRM Analytics data for modeling, searching, and visualizing.
-
Connect to Sage Intacct Data in ACL Analytics
Connect to Sage Intacct data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage Intacct data.
-
Connect to Zuora Data from a Connection Pool in JBoss
Integrate Zuora data into Java servlets: Use the Management Console in JBoss to install the Zuora JDBC Driver.
-
How to Easily Query Yelp Data in OpenOffice Base
Connect to Yelp data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Sybase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sybase data replication to OneLake in Microsoft Fabric.
-
Automate Sendwithus Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sendwithus data from PowerShell? This article demonstrates how to utilize the Sendwithus Cmdlets for tasks like connecting to Sendwithus data, automating operations, downloading data, and more.
-
Visualize Live Microsoft Dataverse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Dataverse data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Hubstaff Data in RapidMiner
Integrate Hubstaff data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate LibreChat with Live SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Business Warehouse data from within the chat interface.
-
Work with Teamgate Data in FoxPro
Load Teamgate data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Wistia-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Wistia data and build Wistia-connected web apps with Axios.
-
Connect to Amazon S3 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon S3 and the SQL Gateway to access Amazon S3 data from Google Apps Script.
-
How to create Visio diagrams from EnterpriseDB Data
Automatically update EnterpriseDB data with the changes you make to Visio master shapes.
-
How to Connect to Live Dropbox 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 Dropbox data for you.
-
Connect to Browserless Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Browserless data in the Denodo Virtual DataPort Administrator.
-
Use Dash to Build Web Apps on Microsoft Dataverse Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Dataverse data using pandas and the CData Connect AI Python SDK.
-
Connect to Salesforce CRM Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce CRM Analytics data.
-
A PostgreSQL Interface for Humanity Data (MySQL Remoting via JDBC)
Use the Remoting features of the Humanity JDBC Driver to create a PostgreSQL entry-point for data access.