CData Software - Knowledge Base
Recent Articles
-
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.
-
Build Visualizations of Facebook Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Facebook Ads in Birst.
-
DataBind Controls to Lakebase Data in C++Builder
DataBind to Lakebase in C++Builder with standard components and controls.
-
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.
-
Import and Visualize Contentful Data in Power View
Create data visualizations based on Contentful in Excel.
-
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.
-
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.
-
Operational Reporting on Demio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Demio.
-
Feed Teamgate Data into FineReport
How to set Teamgate as a JDBC data source in FineReport.
-
Access PolarTeamPro Data from MySQL in Amazon QuickSight
Connect to PolarTeamPro and build visualizations of PolarTeamPro using a MySQL Connection in Amazon QuickSight.
-
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.
-
How to Access Bannerbear Data Using Entity Framework
This article shows how to access Bannerbear using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
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.
-
Databricks Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Databricks through CData Connect AI using different applications and tools.
-
Automated Continuous MariaDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MariaDB replication to OneLake in Microsoft Fabric.
-
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 Build an ETL App for SAP Data in Python with CData
Create ETL applications and real-time data pipelines for SAP ERP/NetWeaver in Python with petl.
-
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.
-
Replicate Multiple Shippo Accounts
Replicate multiple Shippo accounts to one or many databases.
-
Manage Outlook Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Outlook.
-
How to Connect to PingOne Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PingOne. Leverage the pyodbc module for ODBC in Python.
-
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.
-
How to connect to Ontraport Data with Squirrel SQL client
Connect to Ontraport and execute queries in the Squirrel SQL Client.
-
Build Apps with Live PagerDuty Data Using the Low-Code Development Platform of Mendix
Connect PagerDuty with Mendix to build apps using the CData API Driver for JDBC.
-
Query HBase Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache HBase and perform CRUD operations on HBase from Node.js.
-
Automated Continuous Freshteam Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshteam replication to IBM DB2.
-
Easily Integrate Campaigner Data in Lazarus Pascal IDE
Learn how to easily integrate live Campaigner in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Apps with Live Tickspot Data Using the Low-Code Development Platform of Mendix
Connect Tickspot with Mendix to build apps using the CData API Driver for JDBC.
-
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.
-
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.
-
Build Dynamics 365 Business Central Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dynamics 365 Business Central and build visualizations in Tableau.
-
Using the CData Software ODBC Driver for Microsoft Exchange in PyCharm
Connect to Microsoft Exchange as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Exchange.
-
Operational Reporting on IBM Informix Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM Informix.
-
Load ZohoExpense Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoExpense to a database.
-
Query Microsoft Teams Data in DataGrip
Create a Data Source for Microsoft Teams in DataGrip and use SQL to query live Microsoft Teams.
-
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.
-
Viewing Google Translate Data in RAD Studio Data Explorer
How to view Google Translate in RAD Studio Data Explorer using the CData ODBC Driver for Google Translate.
-
Use the CData Software ODBC Driver for Scrapfly in MicroStrategy
Connect to Scrapfly in MicroStrategy Developer using the CData Software ODBC Driver for Scrapfly.
-
Operational Reporting on XML Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote XML Files.
-
Integrate Live Elorus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Elorus to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
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.
-
Building Dynamic Web Pages with Xero Data Using AngularJS
Create single-page applications with live connectivity to Xero using the CData API Server.
-
Integrate Live SAP Netweaver Gateway Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Netweaver Gateway to Blue Prism using the CData ODBC Driver for SAP Netweaver Gateway to create automated workflows for repetitive business tasks.
-
Analyze SQL Analysis Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SQL Analysis Services and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to and Visualize Live Authorize.Net Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Authorize.Net.
-
Connect to Salesforce Data in ACL Analytics
Connect to Salesforce & Force.com via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce & Force.com.
-
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.
-
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 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.
-
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 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.
-
Use the CData Software ODBC Driver for Redis in MicroStrategy Desktop
Connect to Redis in MicroStrategy Desktop using the CData Software ODBC Driver for Redis.
-
Connect to Bullhorn CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Bullhorn CRM from Crystal Reports.
-
Build a Simple VCL Application for Simplesat Data
How to build a simple VCL Application to view Simplesat in RAD Studio using the CData ODBC Driver for Simplesat.
-
Automated Continuous Microsoft Teams Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to IBM DB2.
-
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.
-
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.
-
Automated Continuous Google Forms Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Forms replication to Google BigQuery.
-
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.
-
Build Certinia-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Certinia to explore live Certinia Data in GitHub Copilot to assist with building Certinia-powered applications.
-
Connect to MySQL Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MySQL.
-
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.
-
Use the CData Software JDBC Driver for Billsby in MicroStrategy
Connect to Billsby in MicroStrategy Developer using the CData Software JDBC Driver for Billsby.
-
Connect to Reckon Accounts Hosted Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Reckon Accounts Hosted.
-
Migrating data from Moosend to Databricks using CData SSIS Components.
Easily push Moosend to Databricks using the CData SSIS Tasks for Moosend and Databricks.
-
How to connect PolyBase to PolarTeamPro
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PolarTeamPro.
-
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.
-
Automated Continuous OneNote Replication to Oracle
Use CData Sync for automated, continuous, customizable OneNote replication to Oracle.
-
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.
-
Prepare, Blend, and Analyze API Data in Alteryx Designer (Connect AI)
Build workflows to access live API for self-service data analytics.
-
Build Data Flows from SQL Server to Smartsheet through SSIS
Easily push SQL Server data to Smartsheet using the CData SSIS Tasks for Smartsheet.
-
How to Access Live Azure DevOps Data in Visual Studio Code via Cline
Run CData MCP Server for Azure DevOps on Windows Subsytem for Linux (WSL) and connect to live Azure DevOps from the Cline extension in Visual Studio Code.
-
Getting Started with the CData Tableau Connector for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData ODBC Driver for Yelp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Yelp.
-
Connect and Visualize Live Odoo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Odoo ERP into the Databricks platform and create visualization dashboards with real-time Odoo ERP.
-
Provide OData Services of SuiteCRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SuiteCRM by developing a WCF Service Application.
-
Automate Invoiced Data Replication to SAP HANA
Use CData Sync to customize and automate Invoiced replication to SAP HANA.
-
Analyze Oracle Service Cloud Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Service Cloud with the CData JDBC Driver for Oracle Service Cloud.
-
Connect to Factorial Data from PowerBuilder via JDBC
This article demonstrates how to access Factorial from PowerBuilder using the Factorial JDBC Driver.
-
Integrating LangGraph with Facebook Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Facebook within automated workflows.
-
Automated Continuous Cassandra Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cassandra replication to Snowflake.
-
How to Connect to Live AlloyDB 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 Google AlloyDB through natural language.
-
Automated Continuous Authorize.Net Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Authorize.Net replication to IBM DB2.
-
How to Connect Flowise AI Agents to Live Google Spanner 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 Google Spanner without replication.