CData Software - Knowledge Base
Recent Articles
-
Access Live Azure Synapse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Synapse from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Live Klaviyo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Klaviyo into custom reports in Power BI.
-
Prepare, Blend, and Analyze SAP BusinessObjects BI Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP BusinessObjects BI for self-service data analytics.
-
DataBind Controls to Lakebase Data in C++Builder
DataBind to Lakebase in C++Builder with standard components and controls.
-
Build Miro-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Miro Data in Cursor to assist with building Miro-powered applications.
-
Create MessageBird Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MessageBird from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Claude Code CLI with SAP ByDesign 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 Reports with Wave Financial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wave Financial.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon Athena using the Model Context Protocol.
-
Automate EmailOctopus Integration Tasks from PowerShell
Are you in search of a quick and easy way to access EmailOctopus from PowerShell? This article demonstrates how to utilize the EmailOctopus Cmdlets for tasks like connecting to EmailOctopus, automating operations, downloading data, and more.
-
Automated Continuous Typeform Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Typeform replication to delimited files (CSV/TSV).
-
How to Access Live SAP Hybris C4C Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Hybris C4C enables you to integrate SAP Hybris C4C into workflows built using Microsoft Power Automate Desktop.
-
Integrate HubDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HubDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to HubDB.
-
Automated Continuous Confluence Replication to MongoDB
Use CData Sync for automated, continuous, customizable Confluence replication to MongoDB.
-
Connect and Visualize Live SAP ByDesign Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Business ByDesign into the Databricks platform and create visualization dashboards with real-time SAP Business ByDesign.
-
DataBind Controls to Amazon S3 Data in Delphi
DataBind to Amazon S3 in Delphi with standard data access components and controls.
-
Using the CData Software ODBC Driver for Discord in PyCharm
Connect to Discord as an ODBC data source in PyCharm using the CData Software ODBC Driver for Discord.
-
Integrating Boomi Agentstudio with SQL Server Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft SQL Server, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with Dynamics 365 Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Dynamics 365 in DBxtra.
-
Automated Continuous MariaDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MariaDB replication to OneLake in Microsoft Fabric.
-
How to Query Live Bright Data Data in Perplexity MacOS Desktop
Connect to and query live Bright Data Data in Perplexity Desktop using CData MCP Server.
-
Integrating Claude Code CLI with Google Calendar 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 work with ConvertAPI Data in Apache Spark using SQL
Access and process ConvertAPI Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate LibreChat with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon Athena from within the chat interface.
-
Build Microsoft Entra ID-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Entra ID.
-
Explore Geographical Relationships in FTP Data with Power Map
Create data visualizations with FTP Servers in Power Map.
-
Connect to Google Drive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Drive.
-
Connect to FreeAgent 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 FreeAgent and work with FreeAgent in your FileMaker application.
-
Replicate Multiple Shippo Accounts
Replicate multiple Shippo accounts to one or many databases.
-
Validate Discord Data with QuerySurge
Access and validate Discord in QuerySurge using the CData JDBC Driver.
-
Manage Outlook Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Outlook.
-
A PostgreSQL Interface for Gmail Data using the CData ODBC Driver
Use the SQL Gateway and Gmail ODBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for Greenplum in PyCharm
Connect to Greenplum as an ODBC data source in PyCharm using the CData Software ODBC Driver for Greenplum.
-
How to connect to Ontraport Data with Squirrel SQL client
Connect to Ontraport and execute queries in the Squirrel SQL Client.
-
Build Automated Freshservice-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshservice and build automated workflows in Zapier.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Bullhorn CRM using the Model Context Protocol.
-
Automated Continuous Freshteam Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshteam replication to IBM DB2.
-
Automated Continuous iContact Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable iContact replication to Azure SQL Database.
-
How to connect SharePoint with Close Data through external lists
Provide Close to SharePoint users as an external list.
-
How to connect to Adobe Experience Manager Data with Squirrel SQL client
Connect to Adobe Experience Manager and execute queries in the Squirrel SQL Client.
-
Integrating Boomi Agentstudio with Google Spanner Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Spanner, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Presto Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Presto and build visualizations in Tableau.
-
Integrating Kiro CLI with Cassandra 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.
-
Build Semantic Layer Views for Mode Data in APOS Live Data Gateway
Use the CData Connector for Mode in APOS Live Data Gateway to build Semantic Layer Views for Mode.
-
Connect to Missive Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Missive to connect to Missive and execute queries in PowerBuilder.
-
Automated Continuous Copper Replication to SingleStore
Use CData Sync for automated, continuous, customizable Copper replication to SingleStore.
-
LINQ to Tally 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 Tally Data Provider.
-
Automated Continuous Excel Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Excel replication to PostgreSQL.
-
How to integrate Metabase with Sybase Data
Use CData Connect AI to connect to live Sybase and create an interactive dashboard in Metabase from Sybase.
-
Connect to Avaza Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Avaza using standard SQL.
-
How to connect SharePoint with Shippo Data through external lists
Provide Shippo to SharePoint users as an external list.
-
How to Connect to Live Sugar CRM 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 Sugar CRM through natural language.
-
Consume Odoo OData Feeds in PowerBuilder
This article demonstrates how to consume Odoo ERP as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous SharePoint Excel Services Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Google Cloud SQL.
-
Operational Reporting on XML Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote XML Files.
-
Publish YouTube Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live YouTube Analytics.
-
Manage Excel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Excel.
-
Extend Google Sheets with Wrike Data
Make calls to Wrike from Google Apps Script via the API Server.
-
Building Dynamic Web Pages with Xero Data Using AngularJS
Create single-page applications with live connectivity to Xero using the CData API Server.
-
Automated Continuous SAP ByDesign Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQL Server.
-
Visualize Live ZohoMarketingHub Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoMarketingHub using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create a Data Access Object for ScrapingBee Data using JDBI
A brief overview of creating a SQL Object API for ScrapingBee in JDBI.
-
Connect to and Visualize Live Authorize.Net Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Authorize.Net.
-
Visualize FormSite Data in TIBCO Spotfire through ADO.NET
Integrate FormSite into dashboards in TIBCO Spotfire.
-
Import and Visualize Bannerbear Data in Power View
Create data visualizations based on Bannerbear in Excel.
-
Connect to WooCommerce Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live WooCommerce.
-
Automated Continuous Redis Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Redis replication to OneLake in Microsoft Fabric.
-
Integrating Kiro CLI with Exact Online 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 update Dynamics CRM from Excel
This article explains how to transfer data from Excel to Dynamics CRM using the Excel Add-In for Dynamics CRM.
-
How to Easily Query Delighted Data in OpenOffice Base
Connect to Delighted data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Live Bullhorn CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Bullhorn CRM Data in CData Connect AI and connect to your Bullhorn CRM from MicroStrategy.
-
Access Google Contacts Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Contacts from HeidiSQL.
-
DataBind Controls to ZohoInvoice Data in Delphi
DataBind to ZohoInvoice in Delphi with standard data access components and controls.
-
Use JayDeBeApi to access Salesforce Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesforce & Force.com.
-
How to connect to Simplesat Data with Squirrel SQL client
Connect to Simplesat and execute queries in the Squirrel SQL Client.
-
How to connect and process ZarMoney from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZarMoney.
-
Process & Analyze TigerGraph Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live TigerGraph Data.
-
Getting Started with the CData Power BI Connector for Placid
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live Google Sheets Data in AWS Lambda
Connect to live Google Sheets in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Clockify Replication to Oracle
Use CData Sync for automated, continuous, customizable Clockify replication to Oracle.
-
Connecting Mastra with ServiceNow 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 ServiceNow, no replication required.
-
Automated Continuous Asana Replication to MySQL
Use CData Sync for automated, continuous, customizable Asana replication to MySQL.
-
How to Work with Office 365 Data in ETL Validator JDBC
Connect to Office 365 from ETL Validator jobs using the CData Software JDBC Driver.
-
Provide OData Services of Oracle SCM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle SCM by developing a WCF Service Application.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Pushbullet to Power BI dashboards. Simply drag and drop Pushbullet into data visuals on the Power BI canvas.
-
How to connect to Front Data in DBVisualizer
Integrate Front with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Azure AI Foundry to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your JSON for you.
-
Publish Crystal Reports on Moosend Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Moosend.
-
Integrate with Hive Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Hive to a JSON file on disk.
-
Connect to Customer.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Cursor with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live LinkedIn from within the editor.
-
Connect to Codat Data from PowerBuilder via ADO.NET
This article demonstrates how to access Codat from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Establish a Live Connection with Authorize.Net Data using Tableau Bridge
The CData ODBC Driver for Authorize.Net enables you to integrate live Authorize.Net into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to CouchDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache CouchDB from Appeon PowerBuilder using the CData ADO.NET Provider for CouchDB.
-
Extract, Transform, and Load GraphQL Data in Informatica PowerCenter
Create a simple Workflow for GraphQL in Informatica PowerCenter.
-
Import Dynamics CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Dynamics CRM Data from Azure Data Factory and import live Microsoft Dynamics CRM.
-
Integrating OpenCode Terminal with Drip 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.
-
Choosing the Best Method to Connect Dynamics CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Dynamics CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Twitter Ads-Connected Dashboards in Grafana
Connect to Twitter Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twitter Ads.
-
Use JayDeBeApi to access MailChimp Data in Python
Use standard Python scripting and the development environment of your choice to access live MailChimp.