CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Scrapfly Data
Create Python applications that use pandas and Dash to build Scrapfly-connected web apps.
-
Build Microsoft OneDrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft OneDrive Data and create custom apps in Bubble.
-
Analyze Salesforce CRM Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce CRM Analytics and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Jira-Connected Dashboards in Grafana
Connect to Jira Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Atlassian Jira.
-
Automated Continuous GraphQL Replication to SQL Server
Use CData Sync for automated, continuous, customizable GraphQL replication to SQL Server.
-
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.
-
How to Connect to Teradata Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teradata. Leverage the pyodbc module for ODBC in Python.
-
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.
-
Automated Continuous Spark Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Spark replication to AlloyDB.
-
Automate Perplexity Data Replication to Azure Data Lake
Use CData Sync to customize and automate Perplexity replication to Azure Data Lake.
-
Query AfterShip Data in DataGrip
Create a Data Source for AfterShip in DataGrip and use SQL to query live AfterShip.
-
Trigger Facebook IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Facebook with standard wizards in Logic Apps.
-
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.
-
Automated Continuous Microsoft Exchange Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to IBM DB2.
-
Access Live Teradata Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Teradata data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
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.
-
Working with LinkedIn Data in LINQPad
Execute LINQ queries to LinkedIn in LINQPad.
-
Replicate Outreach.io Data to Multiple Databases via the CData Sync CLI
Replicate Outreach.io to disparate databases with a single configuration.
-
How to connect and process Outlook from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Outlook.
-
Use Dash to Build to Web Apps on REST Data
Create Python applications that use pandas and Dash to build REST-connected web apps.
-
Extend Google Sheets with JDBC-ODBC Bridge Data
Make calls to JDBC-ODBC Bridge from Google Apps Script via the API Server.
-
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.
-
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.
-
Access Live IBM Cloud Object Storage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live IBM Cloud Object Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to and Query Mouseflow Data in QlikView over ODBC
Create data visualizations with Mouseflow in QlikView.
-
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.
-
Connect to Zoho Projects Data in NetBeans
Connect to Zoho Projects in NetBeans with the data source configuration wizard.
-
How to connect and process Zoho CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho CRM.
-
Automated Continuous Tally Replication to Databricks
Use CData Sync for automated, continuous, customizable Tally replication to Databricks.
-
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.
-
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.
-
Integrate with live Microsoft Dataverse Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Dataverse (CDS) in Jitterbit.
-
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.
-
DataBind Controls to Templated Data in C++Builder
DataBind to Templated in C++Builder with standard components and controls.
-
How to create Tanda federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Tanda in MySQL .
-
Replicate Lakebase Data to Multiple Databases via the CData Sync CLI
Replicate Lakebase to disparate databases with a single configuration.
-
Choosing the Best Method to Connect Hubstaff to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Hubstaff from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Spotify-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Spotify Data in Claude Code to assist with building Spotify-powered applications.
-
Replicate Multiple MySQL Accounts
Replicate multiple MySQL accounts to one or many databases.
-
How to import SAP Business Warehouse Data into Apache Solr
Use the CData Software JDBC Driver for SAP Business Warehouse in Data Import Handler and create an automated import of SAP Business Warehouse to Apache Solr Enterprise Search platform.
-
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.
-
Integrating LlamaIndex with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Exchange in real time.
-
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.
-
Integrate Float with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Float with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Float.
-
Build Dashboards with Recurly Data in DBxtra
Create dynamic dashboards and perform analytics based on Recurly in DBxtra.
-
Automated Continuous SAS xpt Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAS XPORT replication to OneLake in Microsoft Fabric.
-
Provide OData Services of Contentful Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Contentful by developing a WCF Service Application.
-
Connect and Visualize Live Basecamp Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Basecamp into the Databricks platform and create visualization dashboards with real-time Basecamp.
-
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.
-
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.
-
Aha! Reporting in OBIEE with the Aha! JDBC Driver
Deploy the Aha! JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Strava Data from MySQL in PHP
Connect to Strava through the standard MySQL libraries in PHP.
-
Stream Sugar CRM Data into Apache Kafka Topics
Access and stream Sugar CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Manus AI to Talk to Your Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Amazon DynamoDB.
-
Connecting Mastra with Greenplum 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 Pivotal GreenPlum, no replication required.
-
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.
-
Integrate Azure Analysis Services Data in Pentaho Data Integration
Build ETL pipelines based on Azure Analysis Services in the Pentaho Data Integration tool.
-
Automated Continuous PabblySubscriptions Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Amazon S3.
-
Connect to Elorus Data from PowerBuilder via JDBC
This article demonstrates how to access Elorus from PowerBuilder using the Elorus JDBC Driver.
-
Automated Continuous Nethunt Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Nethunt replication to Amazon S3.
-
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.
-
Bridge LinkedIn Connectivity with Apache NiFi
Access and process LinkedIn in Apache NiFi using the CData JDBC Driver.
-
How to create an RPA flow for Google Spanner Data in UiPath Studio
Use the Google Spanner ODBC Driver to create workflows that access real-time Google Spanner without any coding.
-
Automated Continuous Facebook Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Databricks.
-
Integrating Claude Code CLI with Amplitude 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.
-
Connect to SAP HANA Data in HULFT Integrate
Connect to SAP HANA as a JDBC data source in HULFT Integrate
-
Build Phoenix-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Phoenix to explore live Phoenix Data in Claude Code to assist with building Phoenix-powered applications.
-
Build Agents in Relevance AI with Access to Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon DynamoDB within intelligent agent workflows.
-
Build Shopify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shopify.
-
Visualize HelloSign Data in TIBCO Spotfire through OData
Integrate HelloSign into dashboards in TIBCO Spotfire.
-
Connect to Printify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Printify using standard SQL.
-
Use CData Connect AI to Access Epicor Kinetic Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Epicor Kinetic in the Power Pivot business intelligence tool.
-
Connect to Dynamics CRM Data from a Connection Pool in Jetty
The Dynamics CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dynamics CRM from Web apps in Jetty.
-
Integrating LangChain with MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MariaDB within automated workflows.
-
Connect ZohoExpense Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoExpense using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData ODBC Driver for SAP Hybris C4C in Microsoft Power Query
You can use the CData SAP Hybris C4C ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Hybris C4C into Microsoft Power Query.
-
Creating SQL Analysis Services-Connected Applications in Unqork
You can use CData Connect AI to feed SQL Analysis Services to Unqork and build custom business apps.
-
Integrate Real-Time Access to Gumroad in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Gumroad in real time.
-
How to Query Live Mocean Data in Claude Desktop
Connect to and query live Mocean Data in Claude Desktop using CData MCP Server.
-
Explore Geographical Relationships in WooCommerce Data with Power Map
Create data visualizations with WooCommerce in Power Map.
-
Viewing Aircall Data in RAD Studio Data Explorer
How to view Aircall in RAD Studio Data Explorer using the CData ODBC Driver for Aircall.
-
Build Visualizations of Brex Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Brex in Birst.
-
Query Oracle SCM Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle SCM from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate Kintone Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Kintone to SQL Server.
-
Create Dynamics CRM-Connected Dashboards in Grafana
Connect to Dynamics CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Dynamics CRM.
-
Publish Pushbullet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pushbullet.
-
Query Microsoft OneDrive Data in DataGrip
Create a Data Source for Microsoft OneDrive in DataGrip and use SQL to query live Microsoft OneDrive.
-
Bidirectional Access to Discord Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Discord in Filemaker Pro for Mac or Windows.
-
Use Agno to Talk to Your YouTube Analytics 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 YouTube Analytics for you.