CData Software - Knowledge Base
Recent Articles
-
Work with Live Bullhorn CRM Data in Power Query
Use CData Connect AI to connect to Bullhorn CRM data and work with live Bullhorn CRM data in Microsoft Power Query.
-
Integrate with Clio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clio data to a JSON file on disk.
-
Access Live Snowflake Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Snowflake data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Sage 200 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage 200 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access Live Zuora Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zuora enables you to integrate Zuora data into workflows built using Microsoft Power Automate Desktop.
-
How to load REST data into Elasticsearch via Logstash
Introducing a simple method to load REST data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create a Data Access Object for Optimizely Data using JDBI
A brief overview of creating a SQL Object API for Optimizely data in JDBI.
-
Connect to Oracle Sales Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Sales data in DBeaver.
-
Visualize ZeroBounce Data in Sisense
Create an ElastiCube in Sisense app with access to ZeroBounce data.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy
Connect to Salesforce Pardot data in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Pardot.
-
Create Power BI Reports on Real-Time Act CRM Data
Use the CData ODBC Driver for Act CRM to visualize Act CRM data in Power BI Desktop.
-
Getting Started with the CData Excel Add-In for Quickbase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Quickbase.
-
Integrate Dify with Live ZohoDesk 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 ZohoDesk data.
-
Create Neo4J Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Neo4J from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a PostgreSQL Interface for Cassandra Data using the CData JDBC Driver
Use the Remoting features of the Cassandra JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for Clari
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clari.
-
Build Dashboards with Notion Data in DBxtra
Create dynamic dashboards and perform analytics based on Notion data in DBxtra.
-
Integrate Devin with Live SAS xpt Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAS xpt data.
-
Connect SQL Analysis Services Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SQL Analysis Services data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to & Open Impala Data in Microsoft Excel
This article uses the CData ODBC driver for Impala to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build MVC Applications with Connectivity to Miro Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Miro from an ASP.NET MVC application.
-
Build a PostgreSQL Interface for REST Data using the CData JDBC Driver
Use the Remoting features of the REST JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with SurveyMonkey Data in JReport Designer
Create charts and reports based on SurveyMonkey data in JReport Designer.
-
Automated Continuous HelloSign Replication to MySQL
Use CData Sync for automated, continuous, customizable HelloSign replication to MySQL.
-
Connect to Outlook Data in CloverDX (formerly CloverETL)
Transfer Outlook data using the visual workflow in the CloverDX data integration tool.
-
Access Live Amazon DynamoDB Data 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 Amazon DynamoDB data through MCP integration.
-
Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy Web
Connect to Microsoft Dataverse data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Dataverse.
-
Choosing the Best Method to Connect Stripe to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Stripe data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to work with SendInBlue Data in Apache Spark using SQL
Access and process SendInBlue Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData ODBC Driver for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dynamics CRM.
-
Integrate LibreChat with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Entra ID data from within the chat interface.
-
Connect to Dynamics CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dynamics CRM data.
-
Automated Continuous Reckon Accounts Hosted Replication to SingleStore
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SingleStore.
-
Integrate Devin with Live Toggl Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Toggl data.
-
Viewing Sentry Data in RAD Studio Data Explorer
How to view Sentry data in RAD Studio Data Explorer using the CData ODBC Driver for Sentry.
-
Integrate Cline with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Drive data from within your IDE.
-
Automate Eventbrite Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Eventbrite data from PowerShell? This article demonstrates how to utilize the Eventbrite Cmdlets for tasks like connecting to Eventbrite data, automating operations, downloading data, and more.
-
Access Live Cosmos DB Data 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 Cosmos DB data through MCP integration.
-
Automated Continuous ConvertAPI Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ConvertAPI replication to PostgreSQL.
-
Build Apps with Live Demio Data Using the Low-Code Development Platform of Mendix
Connect Demio data with Mendix to build apps using the CData API Driver for JDBC.
-
Build an OLAP Cube in SSAS from Missive Data
Establish a connection to Missive data data from SQL Server Analysis Services, and use the Missive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Float
Provide connectivity to Float data through an SAP BusinessObjects universe.
-
Build ZohoPeople Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ZohoPeople data and build visualizations in Tableau.
-
Access Live ConstantContact 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 ConstantContact data through MCP integration.
-
Bridge Anaplan Connectivity with Apache NiFi
Access and process Anaplan data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live SAP Business One 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 SAP Business One data for you.
-
Build MVC Applications with Connectivity to BigQuery Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigQuery from an ASP.NET MVC application.
-
A PostgreSQL Interface for ZeroBounce Data using the CData ODBC Driver
Use the SQL Gateway and ZeroBounce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Pipedrive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pipedrive data in ColdFusion.
-
Integrate Live ZohoDesk Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ZohoDesk data and integrate live ZohoDesk data into apps built in Microsoft Power Apps.
-
Automated Continuous Codat Replication to SQLite
Use CData Sync for automated, continuous, customizable Codat replication to SQLite.
-
Easily Integrate MySQL Data in Lazarus Pascal IDE
Learn how to easily integrate live MySQL data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Design BIRT Reports on Aweber Data
Provide current Aweber data to your embedded analytics.
-
Build Apollo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Apollo Data and create custom apps in Mendix.
-
Access Freshteam Data from MySQL in PHP
Connect to Freshteam through the standard MySQL libraries in PHP.
-
Choosing the Best Method to Connect Microsoft Exchange to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Exchange data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Adobe Experience Manager-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Adobe Experience Manager data without replication.
-
Analyze Live Oracle Eloqua Data in SAS Viya
Use CData Connect AI to connect to Oracle Eloqua data from SAS Viya and deploy self-service analytics using live Oracle Eloqua data.
-
How to Connect to HDFS Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to HDFS data. Leverage the pyodbc module for ODBC in Python.
-
Replicate RSS Feeds in Heroku for Use in Salesforce Connect
Replicate RSS feeds to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Validate Sendwithus Data with QuerySurge
Access and validate Sendwithus data in QuerySurge using the CData JDBC Driver.
-
Access Live Notion Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Notion data from your Excel spreadsheets.
-
Feed Sage Cloud Accounting Data into FineReport
How to set Sage Cloud Accounting data as a JDBC data source in FineReport.
-
How to connect and process Facebook data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook data.
-
Connect Recurly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Recurly with IBM WebSphere for seamless data integration and connectivity.
-
Design BIRT Reports on SAP Ariba Source Data
Provide current SAP Ariba Source data to your embedded analytics.
-
Automated Continuous CampaignMonitor Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Apache Kafka.
-
How to import Discourse Data into Apache Solr
Use the CData Software JDBC Driver for Discourse in Data Import Handler and create an automated import of Discourse data to Apache Solr Enterprise Search platform.
-
Analyze Google Ad Manager Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Ad Manager data and visualize Google Ad Manager data in SAP Analytics Cloud.
-
How to integrate Metabase with Typeform Data
Use CData Connect AI to connect to live Typeform data and create an interactive dashboard in Metabase from Typeform data.
-
Automated Continuous Oracle Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Stack Exchange Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Stack Exchange replication to PostgreSQL.
-
Getting Started with the CData Excel Add-In for Procore
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Procore.
-
Connect and Visualize Live Cloudant Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Cloudant data into the Databricks platform and create visualization dashboards with real-time Cloudant data.
-
Build Dashboards with Workday Data in Dundas BI
Create dynamic dashboards and perform analytics based on Workday data in Dundas BI.
-
Integrate with Discord Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Discord data in SnapLogic.
-
Build Semantic Layer Views for Microsoft Exchange Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Exchange in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Exchange data.
-
Use the CData Software ODBC Driver for Planio in MicroStrategy Desktop
Connect to Planio data in MicroStrategy Desktop using the CData Software ODBC Driver for Planio.
-
Analyze Discourse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Discourse data in Microsoft R Open.
-
Connect to Kintone Data in DBArtisan
Use wizards in DBArtisan to configure Kintone data as a data source.
-
Access Live Dynamics 365 Data 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 Dynamics 365 data through MCP integration.
-
Connect to Mode Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Mode Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect to MongoDB Data with Squirrel SQL client
Connect to MongoDB data and execute queries in the Squirrel SQL Client.
-
How to connect and process Testmonitor data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Testmonitor data.
-
Integrating OpenCode with Raisers Edge NXT 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.
-
Perform Batch Operations with Google Ad Manager Data in Apache NiFi
Connect to Google Ad Manager data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Query Mouseflow Data in MySQL Workbench
Execute MySQL queries against live Mouseflow data from MySQL Workbench.
-
Build Dashboards with MariaDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on MariaDB data in Dundas BI.
-
Build a PostgreSQL Interface for Printful Data using the CData JDBC Driver
Use the Remoting features of the Printful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Paylocity Replication to MySQL
Use CData Sync for automated, continuous, customizable Paylocity replication to MySQL.
-
Integrating Boomi Agentstudio with Phoenix Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Phoenix data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Apify Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apify data from your Excel spreadsheets.
-
Object-Relational Mapping (ORM) with Autopilot Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Autopilot data into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Snowflake Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snowflake data securely in real time.
-
Build QuickBooks Time-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for QuickBooks Time Data and create custom apps in Bubble.
-
Replicate Multiple Figshare Accounts via the CData Sync CLI
Replicate multiple Figshare accounts to one or many databases.
-
LINQ to Clio 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 Clio Data Provider.
-
How to Connect Flowise AI Agents to Live Microsoft Ads Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft Ads data without replication.
-
Using the CData Software ODBC Driver for Amazon Marketplace in PyCharm
Connect to Amazon Marketplace as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon Marketplace.
-
Use the CData ODBC Driver for BenchmarkEmail in Microsoft Power Query
You can use the CData BenchmarkEmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import BenchmarkEmail data into Microsoft Power Query.