CData Software - Knowledge Base
Recent Articles
-
DataBind Attio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Attio to a chart.
-
Connect to Freshteam Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshteam using standard SQL.
-
How to Connect DBeaver to Grafana via a JDBC Driver
Manage Grafana with visual tools in DBeaver like the query browser.
-
Moving Data from Microsoft Planner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Planner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build IBM Informix Visualizations in Tableau Cloud
Use CData Connect AI to connect to live IBM Informix and build visualizations in Tableau Cloud.
-
How to Connect to SAP ByDesign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business ByDesign. Leverage the pyodbc module for ODBC in Python.
-
Connecting Mastra with Jira Assets 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 Jira Assets, no replication required.
-
Import Real-Time Dynamics 365 Business Central Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Dynamics 365 Business Central in ColdFusion.
-
Connect to and Visualize Live Mouseflow Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mouseflow.
-
Integrate Cline with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zuora from within your IDE.
-
Automated Continuous Microsoft Dataverse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Apache Kafka.
-
A PostgreSQL Interface for JobNimbus Data using the CData ODBC Driver
Use the SQL Gateway and JobNimbus ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Avro Data from a Connection Pool in JBoss
Integrate Apache Avro into Java servlets: Use the Management Console in JBoss to install the Avro JDBC Driver.
-
Work with LeadDesk Data in FoxPro
Load LeadDesk into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP SuccessFactors LMS
Provide connectivity to SAP SuccessFactors LMS through an SAP BusinessObjects universe.
-
Automate MailerLite Data Replication to Azure Data Lake
Use CData Sync to customize and automate MailerLite replication to Azure Data Lake.
-
Publish Reports with Dynamics 365 Business Central Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics 365 Business Central.
-
Automated Continuous Salesforce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce replication to IBM DB2.
-
Integrating Antigravity CLI with Vimeo via CData CLI
Connect Vimeo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData ODBC Driver for FHIR
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FHIR.
-
Access Live Vimeo Data in AWS Lambda
Connect to live Vimeo in AWS Lambda using the CData JDBC Driver.
-
Provide OData Services of Tavily Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Tavily by developing a WCF Service Application.
-
Connect to SAP Ariba Source Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Ariba Source from PowerBuilder using the SAP Ariba Source JDBC Driver.
-
Create Reports from Facebook Data in Looker Studio
Use CData Connect AI to gain access to live Facebook and create custom reports in Looker Studio.
-
How to Access MailerLite Data Using Entity Framework
This article shows how to access MailerLite using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Kintone Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Kintone from PowerShell? This article demonstrates how to utilize the Kintone Cmdlets for tasks like connecting to Kintone, automating operations, downloading data, and more.
-
How to Visualize MailChimp Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live MailChimp in Python.
-
Build Voice Agents in ElevenLabs with access to Live Salesforce Pardot Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce Pardot.
-
Integrating GitHub Copilot CLI with Intercom 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.
-
Use Dash to Build to Web Apps on Scrapfly Data
Create Python applications that use pandas and Dash to build Scrapfly-connected web apps.
-
Integrating Gumloop with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ServiceNow within automated workflows.
-
How to Connect DBeaver to Contentful via a JDBC Driver
Manage Contentful with visual tools in DBeaver like the query browser.
-
Connect to Live Spark Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Spark in CData Connect AI and connect to your Apache Spark SQL from PostgreSQL.
-
How to create ZeroBounce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZeroBounce in MySQL .
-
Connect to FHIR Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with FHIR Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Antigravity CLI with Tally ERP via CData CLI
Connect Tally ERP to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dashboards and Visualize Live OneNote Data in Geckoboard
Use CData Connect AI to connect to live Microsoft OneNote and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Square Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Square in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Yelp Data in AWS Lambda
Connect to live Yelp in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Amplitude in SAS for Real-Time Reporting and Analytics
Connect to real-time Amplitude in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amplitude.
-
Automated Continuous QuickBooks Time Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Azure SQL Database.
-
Build MVC Applications with Connectivity to Discourse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Discourse from an ASP.NET MVC application.
-
Replicate Cvent Data in Heroku for Use in Salesforce Connect
Replicate Cvent to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build MVC Applications with Connectivity to Recurly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Recurly from an ASP.NET MVC application.
-
Analyze CircleCI Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CircleCI from Power Pivot. You will use the Table Import Wizard to load CircleCI. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Microsoft Exchange Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to IBM DB2.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Table Storage to Power BI dashboards. Simply drag and drop Azure Table Storage into data visuals on the Power BI canvas.
-
Integrating LangChain with Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Planner within automated workflows.
-
How to connect and process Outlook from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Outlook.
-
How to Build an ETL App for Zoho CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho CRM in Python with petl.
-
Integrating Codex CLI with ShipStation 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.
-
Use Dash to Build to Web Apps on REST Data
Create Python applications that use pandas and Dash to build REST-connected web apps.
-
Connect to JotForm Data in Ruby
Connect to JotForm in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create a Data Access Object for Short.io Data using JDBI
A brief overview of creating a SQL Object API for Short.io in JDBI.
-
Automate Jira Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Atlassian Jira and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build AI/ML Models with Live Intercom Data using Dataiku
Connect Intercom Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Asana Data in ACL Analytics
Connect to Asana via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Asana.
-
Replicate XML Data in Heroku for Use in Salesforce Connect
Replicate XML Files to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query Mouseflow Data in QlikView over ODBC
Create data visualizations with Mouseflow in QlikView.
-
Feed Microsoft OneDrive Data into FineReport
How to set Microsoft OneDrive as a JDBC data source in FineReport.
-
Getting Started with the CData Power BI Connector for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for IBM Cloud Object Storage.
-
Connecting Moonlit Workflow with SAS Data Sets 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 SAS Data Sets in real time.
-
Automated Continuous HubDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable HubDB replication to SingleStore.
-
Access Smartsheet Data from MySQL in Amazon QuickSight
Connect to Smartsheet and build visualizations of Smartsheet using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous BigCommerce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable BigCommerce replication to Amazon Redshift.
-
Build Voice Agents in ElevenLabs with access to Live Redis Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Redis.
-
Connect to BigQuery 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 Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CockroachDB
Provide connectivity to CockroachDB through an SAP BusinessObjects universe.
-
Seamlessly Bring ActiveCampaign Data into Retool Using CData Connect AI
Integrate ActiveCampaign data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Wrike Data in NetBeans
Connect to Wrike in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time Sentry Data
Use CData Power BI Connectors to visualize Sentry in Power BI.
-
Build an OLAP Cube in SSAS from Kintone Data
Establish a connection to Kintone data from SQL Server Analysis Services, and use the Kintone Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live CockroachDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live CockroachDB securely in real time.
-
Connect to Stack Exchange Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Stack Exchange and work with Stack Exchange in your FileMaker applications.
-
Query Google Translate Data as a MySQL Database in Node.js
Execute MySQL queries against Google Translate from Node.js.
-
DataBind Controls to Templated Data in C++Builder
DataBind to Templated in C++Builder with standard components and controls.
-
Automated Continuous QuickBooks Time Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to PostgreSQL.
-
Visualize Zoho CRM Data in TIBCO Spotfire through OData
Integrate Zoho CRM into dashboards in TIBCO Spotfire.
-
Replicate Lakebase Data to Multiple Databases via the CData Sync CLI
Replicate Lakebase to disparate databases with a single configuration.
-
Build AI Agents with Dynamics 365 Business Central 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 Dynamics 365 Business Central through CData Connect AI.
-
Use the CData ODBC Driver for ConvertKit from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ConvertKit to connect to ConvertKit from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ConvertKit in Excel.
-
Connect to SendPulse Data from PowerBuilder via JDBC
This article demonstrates how to access SendPulse from PowerBuilder using the SendPulse JDBC Driver.
-
Build Semantic Layer Views for Shopify Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Shopify.
-
Provide OData Services of Snapchat Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Snapchat Ads by developing a WCF Service Application.
-
How to Connect to Live Hive 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 Apache Hive for you.
-
Automate Optimizely Data Replication to Azure Synapse
Use CData Sync to customize and automate Optimizely replication to Azure Synapse.
-
Working with HelloSign Data in LINQPad
Execute LINQ queries to HelloSign in LINQPad.
-
Connect to SAP Netweaver Gateway 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 SAP Netweaver Gateway.
-
Provide OData Services of Certinia Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Certinia by developing a WCF Service Application.
-
Query SAP Ariba Procurement Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Ariba Procurement from Node.js.
-
Getting Started with the CData SSIS Components for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Cloud Storage.
-
Design BIRT Reports on GraphQL Data
Provide current GraphQL to your embedded analytics.
-
Connect to Zoom Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Zoom and work with Zoom in your FileMaker applications.
-
Access Strava Data from MySQL in PHP
Connect to Strava through the standard MySQL libraries in PHP.
-
Use Biml to Build SSIS Tasks to Replicate Nethunt Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Nethunt to SQL Server.
-
Build Visualizations of Google Drive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Drive in Birst.
-
How to Access Oracle Data Using Entity Framework
This article shows how to access Oracle Database using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect MailerSend to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MailerSend with IBM WebSphere for seamless data integration and connectivity.
-
Access Live JSON Services 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 JSON through MCP integration.
-
Publish Acumatica-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Acumatica ERP.