CData Software - Knowledge Base
Recent Articles
-
Access Live Databricks Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Databricks data through MCP integration.
-
Integrate Front Data in the Pentaho Report Designer
Publish reports based on Front data in the Pentaho BI tool.
-
Access Webflow Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Webflow data from your Oracle system.
-
Getting Started with the CData Connect AI Python SDK for WooCommerce
Install the CData Connect AI Python SDK to read and write live WooCommerce data with standard DB-API 2.0 Python code.
-
Automated Continuous Telegram Replication to SingleStore
Use CData Sync for automated, continuous, customizable Telegram replication to SingleStore.
-
Connect Cvent to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Cvent data using the CData Python MCP Server.
-
How to use SQLAlchemy ORM to access Clio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clio data.
-
Integrate Copper Data in Pentaho Data Integration
Build ETL pipelines based on Copper data in the Pentaho Data Integration tool.
-
Connect to Google Ad Manager in SpagoBI
Create reports featuring live Google Ad Manager data in SpagoBI Studio. Host Google Ad Manager reports on SpagoBI Server.
-
Automated Continuous Sybase IQ Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SingleStore.
-
Integrate Live SharePoint 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 SharePoint data from within the IDE.
-
How to create an RPA flow for Microsoft Ads Data in UiPath Studio
Use the Microsoft Ads ODBC Driver to create workflows that access real-time Microsoft Ads data without any coding.
-
Use Dash to Build Web Apps on Sugar CRM Data via CData Connect AI
Build interactive Dash web apps on live Sugar CRM data using pandas and the CData Connect AI Python SDK.
-
How to connect to Microsoft Ads Data with Squirrel SQL client
Connect to Microsoft Ads data and execute queries in the Squirrel SQL Client.
-
Analyze Redshift Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redshift from Power Pivot. You will use the Table Import Wizard to load Redshift data. You can visually build the import query or use any SQL supported by the driver.
-
Build Pipelines with Live Bitbucket Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Bitbucket from Google Cloud Data Fusion, enabling the integration of live Bitbucket data into the building and management of effective data pipelines.
-
Explore Geographical Relationships in PDFMonkey Data with Power Map
Create data visualizations with PDFMonkey data in Power Map.
-
Build Semantic Layer Views for Wrike Data in APOS Live Data Gateway
Use the CData Connector for Wrike in APOS Live Data Gateway to build Semantic Layer Views for Wrike data.
-
How to Connect to & Open CapsuleCRM Data in Microsoft Excel
This article uses the CData ODBC driver for CapsuleCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Real-Time Google Campaign Manager 360 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Campaign Manager 360 data in ColdFusion.
-
Connect and Query Live Impala Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Impala data into Databricks and enable direct, live querying and analysis without replication.
-
Build Data Flows from Scrapfly to SQL Server using SSIS
Easily back up Scrapfly data to SQL Server using the SSIS components for Scrapfly.
-
Back Up Sage Intacct data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage Intacct. In this article, we will employ an SSIS workflow to populate a database with Sage Intacct data data.
-
How to Connect DBeaver to Moosend via a JDBC Driver
Manage Moosend data with visual tools in DBeaver like the query browser.
-
Build Pipelines with Live Microsoft Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Ads from Google Cloud Data Fusion, enabling the integration of live Microsoft Ads data into the building and management of effective data pipelines.
-
Visualize Aweber Data in Tableau
The CData ODBC driver for Aweber enables you integrate Aweber data into Tableau dashboards.
-
Create CouchDB-Connected Applications in Appsmith
Connect to CouchDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to CouchDB data.
-
Visualize Live PingOne Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PingOne data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access Flowlu Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Flowlu data.
-
Connect and Query Live Supabase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Supabase data into Databricks and enable direct, live querying and analysis without replication.
-
Back Up SAP SuccessFactors data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP SuccessFactors. In this article, we will employ an SSIS workflow to populate a database with SAP SuccessFactors data data.
-
Build MVC Applications with Connectivity to Azure DevOps Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure DevOps from an ASP.NET MVC application.
-
Use the CData ODBC Driver for Everhour in Microsoft Power Query
You can use the CData Everhour ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Everhour data into Microsoft Power Query.
-
Automated Continuous Paddle Replication to SQLite
Use CData Sync for automated, continuous, customizable Paddle replication to SQLite.
-
Use the CData Software JDBC Driver for Zendesk in MicroStrategy
Connect to Zendesk data in MicroStrategy Developer using the CData Software JDBC Driver for Zendesk.
-
Replicate XML Data to Multiple Databases
Replicate XML data to disparate databases with a point-and-click configuration.
-
Integrate with Nethunt Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Nethunt data to a JSON file on disk.
-
Replicate Multiple Unbounce Accounts via the CData Sync CLI
Replicate multiple Unbounce accounts to one or many databases.
-
Connect to Placid Data from a Connection Pool in JBoss
Integrate Placid data into Java servlets: Use the Management Console in JBoss to install the Placid JDBC Driver.
-
Integrating OpenCode with Foursquare 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 with Zuora Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zuora data to a JSON file on disk.
-
Connect to Sage Intacct Data in HULFT Integrate
Connect to Sage Intacct as a JDBC data source in HULFT Integrate
-
Create Datasets from Microsoft Planner in Domo Workbench and Build Visualizations of Microsoft Planner Data in Domo
Use the CData Software ODBC Driver for Microsoft Planner to create datasets from Microsoft Planner data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to ScrapingBee Data with Squirrel SQL client
Connect to ScrapingBee data and execute queries in the Squirrel SQL Client.
-
Integrate with Outreach.io Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Outreach.io data in SnapLogic.
-
Connect to Salesforce Pardot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce Pardot data using standard SQL.
-
Prepare, Blend, and Analyze Cassandra Data in Alteryx Designer (Connect AI)
Build workflows to access live Cassandra data for self-service data analytics.
-
Access Live MySQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MySQL data from your Google Sheets.
-
Integrating Codex with GetResponse 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 HBase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HBase with IBM WebSphere for seamless data integration and connectivity.
-
How to create Gorgias federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gorgias data in MySQL .
-
Connecting GenSpark with SAP Netweaver Gateway Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Netweaver Gateway data without any replication or custom integration required.
-
Automated Continuous Amazon Marketplace Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQLite.
-
Use the CData Software ODBC Driver for Datadog in MicroStrategy Desktop
Connect to Datadog data in MicroStrategy Desktop using the CData Software ODBC Driver for Datadog.
-
Create Apps from MongoDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to MongoDB Data and build apps from live MongoDB data in Qlik Sense Cloud.
-
Choosing the Best Method to Connect Teradata to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teradata data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Provide OData Services of eBay Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for eBay Analytics data by developing a WCF Service Application.
-
Build Semantic Layer Views for Simplesat Data in APOS Live Data Gateway
Use the CData Connector for Simplesat in APOS Live Data Gateway to build Semantic Layer Views for Simplesat data.
-
Build Agents in Relevance AI with Access to Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Redshift data within intelligent agent workflows.
-
Choosing the Best Method to Connect ZeroBounce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZeroBounce data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Sage 200 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage 200 data.
-
How to load Asana data into Elasticsearch via Logstash
Introducing a simple method to load Asana data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Dotmailer Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Dotmailer data from HeidiSQL.
-
Query ZohoPeople Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoPeople data.
-
Create a Data Access Object for Mode Data using JDBI
A brief overview of creating a SQL Object API for Mode data in JDBI.
-
Bridge OneNote Connectivity with Apache NiFi
Access and process OneNote data in Apache NiFi using the CData JDBC Driver.
-
Access Live Discourse Data in Coginiti Pro
Connect to and query live Discourse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Landbot Replication to Vertica
Use CData Sync for automated, continuous, customizable Landbot replication to Vertica.
-
How to integrate Highrise with Apache Airflow
Access and process Highrise data in Apache Airflow using the CData JDBC Driver.
-
Use Manus AI to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on LinkedIn Ads data.
-
Access Live Splunk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Splunk data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous eBay Replication to SQL Server
Use CData Sync for automated, continuous, customizable eBay replication to SQL Server.
-
Getting Started with the CData JDBC Driver for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics 365 Business Central.
-
Build Jira Assets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Jira Assets data.
-
Query Trello Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Trello entities in PHP by modeling them as objects.
-
LINQ to HDFS Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the HDFS Data Provider.
-
Integrate Phoenix Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Phoenix data from Informatica Cloud.
-
Automated Continuous SharePoint Excel Services Replication to SQLite
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SQLite.
-
Access Humanity 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 Humanity data.
-
How to Build an ETL App for Active Directory Data in Python with CData
Create ETL applications and real-time data pipelines for Active Directory data in Python with petl.
-
Visualize FTP Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load FTP data into TIBCO Spotfire.
-
Connecting Moonlit Workflow with ServiceDesk Plus 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 ServiceDesk Plus data in real time.
-
Analyze Superchat Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Superchat from Power Pivot. You will use the Table Import Wizard to load Superchat data. You can visually build the import query or use any SQL supported by the driver.
-
How to create Aweber federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aweber data in MySQL .
-
Integrate with Dynamics CRM Data in JReport Designer
Create charts and reports based on Dynamics CRM data in JReport Designer.
-
Visualize Email Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Email data.
-
Query SAP BusinessObjects BI Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP BusinessObjects BI data from Node.js.
-
How to Query Exact Online Data in MySQL Workbench
Execute MySQL queries against live Exact Online data from MySQL Workbench.
-
Access Sugar CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sugar CRM data from HeidiSQL.
-
Connect to Cloudant Data from a Connection Pool in JBoss
Integrate Cloudant data into Java servlets: Use the Management Console in JBoss to install the Cloudant JDBC Driver.
-
Integrate Redis Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Redis data from Informatica Cloud.
-
Trigger Google Directory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Directory with standard wizards in Logic Apps.
-
Connecting Moonlit Workflow with BenchmarkEmail 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 BenchmarkEmail data in real time.
-
Analyze SendPulse Data in Looker
Use CData Connect AI to connect to SendPulse Data from Looker and build custom apps using live SendPulse data.
-
Model Azure Data Catalog Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Data Catalog, enabling the direct import of real-time Azure Data Catalog data.
-
DataBind Controls to Timely Data in C++Builder
DataBind to Timely data in C++Builder with standard components and controls.
-
Automate Phoenix Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Phoenix data from PowerShell? This article demonstrates how to utilize the Phoenix Cmdlets for tasks like connecting to Phoenix data, automating operations, downloading data, and more.
-
How to Connect to & Open LDAP Objects in Microsoft Excel
This article uses the CData ODBC driver for LDAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import and Visualize MailerSend Data in Power View
Create data visualizations based on MailerSend data in Excel.
-
Build Charts with BigCommerce Data in Clear Analytics
Create dynamic charts and perform analytics based on BigCommerce data in Clear Analytics.