CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for EmailOctopus
Learn to install and license the CData Python Connector
-
How to Connect to & Open Anaplan Data in Microsoft Excel
This article uses the CData ODBC driver for Anaplan to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Configure the CData JDBC Driver for SFTP in a Connection Pool in Tomcat
Connect to SFTP from a connection pool in Tomcat.
-
Integrating Kiro CLI with Timely 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 Build an ETL App for Billsby Data in Python with CData
Create ETL applications and real-time data pipelines for Billsby in Python with petl.
-
Automated Continuous Microsoft Exchange Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Databricks.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Dynamics 365 Business Central using the Model Context Protocol.
-
Integrate with live Zoho Books Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho Books in Jitterbit.
-
Use CData Connect AI to Access Microsoft Teams Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Teams in the Power Pivot business intelligence tool.
-
Create SAP Fieldglass-Connected Business Apps in AppSheet
Connect to SAP Fieldglass Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Fieldglass.
-
How to Connect to Live Zoom Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zoom through natural language.
-
Getting Started with the CData Power BI Connector for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesforce Data 360.
-
Connect to HubDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HubDB using standard SQL.
-
How to connect Amazon QuickSight to Sugar CRM Data
Create a connection to Sugar CRM in CData Connect AI and insert Sugar CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live Placid Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Placid using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to YouTube Analytics Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time YouTube Analytics using standard SQL.
-
Edit and Search External Google Spanner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Spanner to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Spanner Data objects that you can access from apps and the dashboard.
-
Integrating Codex CLI with ClickUp 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.
-
Import Real-Time Jira Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Atlassian Jira in ColdFusion.
-
Integrating Mode Data in Talend Cloud Data Management Platform
Connect Mode Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query Live Salesforce Data 360 Data in Perplexity MacOS Desktop
Connect to and query live Salesforce Data 360 Data in Perplexity Desktop using CData MCP Server.
-
Replicate ActiveCampaign Data to Multiple Databases
Replicate ActiveCampaign to disparate databases with a point-and-click configuration.
-
Automate Todoist Data Replication to Azure Synapse
Use CData Sync to customize and automate Todoist replication to Azure Synapse.
-
How to Connect to Live Raisers Edge NXT 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 Raisers Edge NXT for you.
-
How to Seamlessly Import RabbitMQ Data into IBM SPSS Modeler
Integrate RabbitMQ data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Wistia Data in Sisense
Create an ElastiCube in Sisense app with access to Wistia.
-
Consume MarkLogic OData Feeds in PowerBuilder
This article demonstrates how to consume MarkLogic as OData feeds from PowerBuilder using the API Server.
-
Connect MYOB AccountRight to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MYOB AccountRight with IBM WebSphere for seamless data integration and connectivity.
-
How to create Visio diagrams from SFTP Data
Automatically update SFTP with the changes you make to Visio master shapes.
-
Integrating Dataiku with Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Procore.
-
Automated Continuous Chargebee Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Chargebee replication to OneLake in Microsoft Fabric.
-
How to Work with Oracle HCM Cloud Data in AWS Glue Jobs Using JDBC
Connect to Oracle HCM Cloud from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Microsoft Exchange Data from a Connection Pool in Jetty
The Microsoft Exchange JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Exchange from Web apps in Jetty.
-
Connect to Tally Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Tally as an External Source in Dremio.
-
Getting Started with the CData ODBC Driver for Facebook
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Facebook.
-
Use ChatGPT to Talk to Your Cloudant 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 IBM Cloudant for you.
-
Automate Timely Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Timely from PowerShell? This article demonstrates how to utilize the Timely Cmdlets for tasks like connecting to Timely, automating operations, downloading data, and more.
-
Deploy the ADO.NET Provider for Hive on an SSRS Report Server
Connect to Apache Hive 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 Monday.com Data in RapidMiner
Integrate Monday.com with standard components and data source configuration wizards in RapidMiner Studio.
-
Build an OLAP Cube in SSAS from MailChimp Data
Establish a connection to MailChimp data from SQL Server Analysis Services, and use the MailChimp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze LinkedIn Ads Data in Cognos Analytics
Use CData Connect AI to connect to LinkedIn Ads Data from Cognos Analytics and analyze live LinkedIn Ads.
-
Automated Continuous Optimizely Replication to SQL Server
Use CData Sync for automated, continuous, customizable Optimizely replication to SQL Server.
-
Publish Crystal Reports on Cloudant Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM Cloudant.
-
Creating DocuSign-Connected Applications in Unqork
You can use CData Connect AI to feed DocuSign to Unqork and build custom business apps.
-
Connect to SAP Concur Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Concur in Google Apps Script.
-
Automate Mode Data Replication to Azure Synapse
Use CData Sync to customize and automate Mode replication to Azure Synapse.
-
Integrating Codex CLI with FormSite 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 OnePageCrm with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate OnePageCrm with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to OnePageCrm.
-
Connect to Bright Data Data in RazorSQL
Connect to Bright Data from wizards and query Bright Data from the GUI in the RazorSQL database management tool.
-
Integrate Bugsnag with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bugsnag with External Services.
-
Connect to IBM Informix Data in RapidMiner
Integrate IBM Informix with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed LinkedIn to Power BI dashboards. Simply drag and drop LinkedIn into data visuals on the Power BI canvas.
-
Visualize Adobe Analytics Data in TIBCO Spotfire through ADO.NET
Integrate Adobe Analytics into dashboards in TIBCO Spotfire.
-
How to Query Live Microsoft Dataverse Data in Perplexity MacOS Desktop
Connect to and query live Microsoft Dataverse Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Unbounce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Unbounce replication to IBM DB2.
-
Automated Continuous Reckon Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Reckon replication to Azure SQL Database.
-
How to import ElevenLabs Data into Apache Solr
Use the CData Software JDBC Driver for ElevenLabs in Data Import Handler and create an automated import of ElevenLabs to Apache Solr Enterprise Search platform.
-
Connect Mode to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mode using the CData Python MCP Server.
-
Automated Continuous Acumatica Replication to Oracle
Use CData Sync for automated, continuous, customizable Acumatica replication to Oracle.
-
Automate Microsoft Entra ID Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Entra ID replication to Azure Data Lake.
-
Moving Data from Supabase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Supabase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Real-Time Access to JSON in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to JSON in real time.
-
Automate PolarTeamPro Data Replication to Azure Synapse
Use CData Sync to customize and automate PolarTeamPro replication to Azure Synapse.
-
How to integrate Apollo with Apache Airflow
Access and process Apollo in Apache Airflow using the CData JDBC Driver.
-
Build Dashboards with Sage 300 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage 300 in Dundas BI.
-
Access Brex Data from MySQL in PHP
Connect to Brex through the standard MySQL libraries in PHP.
-
Explore Geographical Relationships in PhantomBuster Data with Power Map
Create data visualizations with PhantomBuster in Power Map.
-
Build Dashboards with Microsoft Teams Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Teams in DBxtra.
-
Automate Gorgias Data Replication to Azure Data Lake
Use CData Sync to customize and automate Gorgias replication to Azure Data Lake.
-
Automate ConstantContact Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ConstantContact from PowerShell? This article demonstrates how to utilize the ConstantContact Cmdlets for tasks like connecting to ConstantContact, automating operations, downloading data, and more.
-
Getting Started with the CData ODBC Driver for ChartMogul
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ChartMogul.
-
Integrating Codex CLI with MessageBird 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 Avaza Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Avaza replication to Google Cloud SQL.
-
Automated Continuous Asana Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Asana replication to Apache Cassandra.
-
Automated Continuous Clio Replication to SQLite
Use CData Sync for automated, continuous, customizable Clio replication to SQLite.
-
Automated Continuous Epicor Kinetic Replication to SingleStore
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to SingleStore.
-
Automated Continuous Teamwork Replication to MySQL
Use CData Sync for automated, continuous, customizable Teamwork replication to MySQL.
-
Use Biml to Build SSIS Tasks to Replicate Webex Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Webex to SQL Server.
-
Integrate Cursor with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live IBM DB2 from within the editor.
-
Build AI Agents with DocuSign 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 DocuSign through CData Connect AI.
-
Connect to NetSuite Data as an External Source in Dremio
Use the CData JDBC Driver to connect to NetSuite as an External Source in Dremio.
-
Connect to and Query REST Data in QlikView over ODBC
Create data visualizations with REST in QlikView.
-
Query Shippo Data as a MySQL Database in Node.js
Execute MySQL queries against Shippo from Node.js.
-
Connect to Splunk Data in NetBeans
Connect to Splunk in NetBeans with the data source configuration wizard.
-
Visualize Live ZohoSubscriptions Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoSubscriptions.
-
Build Data Flows from Amazon Marketplace to SQL Server using SSIS
Easily back up Amazon Marketplace to SQL Server using the SSIS components for Amazon Marketplace.
-
Rapidly Develop Gong-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 Gong.
-
How to connect to Retently Data in DBVisualizer
Integrate Retently with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Exact Online Data from MySQL in PHP
Connect to Exact Online through the standard MySQL libraries in PHP.
-
Build a PostgreSQL Interface for PayPal Data using the CData JDBC Driver
Use the Remoting features of the PayPal JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with Zoho Recruit via CData CLI
Connect Zoho Recruit to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live ServiceDesk Plus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ServiceDesk Plus into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceDesk Plus in the Graph Builder and Query Builder.
-
Connect to OData Services in the Denodo Platform
Use CData driver technologies to create a virtual data source for OData in the Denodo Virtual DataPort Administrator.
-
Connect to Zuora Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zuora Data and connect to Zuora in Akorbi Digital RunMyProcess.
-
Access Live Google Search Results 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 Google Search through MCP integration.
-
Connect to Demio 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 Demio and work with Demio in your FileMaker application.
-
Choosing the Best Method to Connect SageHR to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SageHR from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access Live Pushbullet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pushbullet enables you to integrate Pushbullet into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Facebook Data in Python with CData Connect AI
Build ETL pipelines that read and write live Facebook in Python with petl and the CData Connect AI Python SDK.
-
Use Agno to Talk to Your CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your CSV/TSV Files for you.