CData Software - Knowledge Base
Recent Articles
-
Integrate Cline with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ADP from within your IDE.
-
Creating SAP Hybris C4C-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Hybris C4C to Unqork and build custom business apps.
-
Integrate Microsoft Dataverse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Dataverse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Dataverse (CDS).
-
Connect Humanity Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Humanity using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process Tavily from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tavily.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy Web
Connect to JDBC-ODBC Bridge in MicroStrategy Web using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Connect to Salesforce Marketing Data from a Connection Pool in JBoss
Integrate Salesforce Marketing Cloud into Java servlets: Use the Management Console in JBoss to install the Salesforce Marketing JDBC Driver.
-
How to Import Data from Twilio into Google Sheets
Import Twilio into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Mouseflow Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mouseflow replication to Snowflake.
-
Connecting Moonlit Workflow with DB2 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 IBM DB2 in real time.
-
Build a Singer.io Tap for JobNimbus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live JobNimbus data using
-
Integrate Real-Time Access to Gmail in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Gmail in real time.
-
Rapidly Develop JSON-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by JSON.
-
Integrating Codex CLI with Landbot 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 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.
-
Connect to Rebilly Data in Jaspersoft Studio
Execute SQL to remote Rebilly in Jaspersoft Studio.
-
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.
-
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.
-
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.
-
Use Dash to Build to Web Apps on Pinterest Data
Create Python applications that use pandas and Dash to build Pinterest-connected web apps.
-
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.
-
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.
-
Automated Continuous Pipedrive Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipedrive replication to Amazon Redshift.
-
Connect to and Visualize Live SAP ByDesign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Business ByDesign.
-
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.
-
Automated Continuous Google Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Directory replication to Azure SQL Database.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics 365
Provide connectivity to Microsoft Dynamics 365 through an SAP BusinessObjects universe.
-
Back Up Zoom to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Zoom data.
-
Connect to Live Azure Synapse Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure Synapse in CData Connect AI and connect to your Azure Synapse from PostgreSQL.
-
Connect to Zoho Projects Data in NetBeans
Connect to Zoho Projects in NetBeans with the data source configuration wizard.
-
Connect to JobNimbus Data in DBeaver
Use the CData ODBC Driver to connect to JobNimbus in DBeaver.
-
Use Agno to Talk to Your Facebook Ads 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 Facebook Ads for you.
-
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.
-
Getting Started with the CData Power BI Connector for AlloyDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for AlloyDB.
-
Visualize Xero Data in Tableau
The CData ODBC driver for Xero enables you integrate Xero Accounting into Tableau dashboards.
-
Integrating Claude Code CLI with Redshift 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.
-
Integrate ADP Data in the Pentaho Report Designer
Publish reports based on ADP in the Pentaho BI tool.
-
Connect to iContact Data in DBeaver
Use the CData ODBC Driver to connect to iContact in DBeaver.
-
Integrate with live Microsoft Dataverse Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Dataverse (CDS) in Jitterbit.
-
Connect to Trello Data in Claris FileMaker Pro
Use the CData ODBC Driver for Trello in FileMaker Pro to connect to Trello and work with Trello in your FileMaker applications.
-
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 .
-
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 a PostgreSQL Interface for Foursquare Data using the CData JDBC Driver
Use the Remoting features of the Foursquare JDBC Driver to create a PostgreSQL entry-point for data access.
-
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.
-
Manage Stripe Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Stripe.
-
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.
-
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.
-
Connect XML to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect XML with IBM WebSphere for seamless data integration and connectivity.
-
Build Dashboards with Recurly Data in DBxtra
Create dynamic dashboards and perform analytics based on Recurly in DBxtra.
-
Use the CData ODBC Driver for Toggl from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Toggl to connect to Toggl from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Toggl in Excel.
-
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.
-
Aha! Reporting in OBIEE with the Aha! JDBC Driver
Deploy the Aha! JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Microsoft Planner in MicroStrategy Desktop
Connect to Microsoft Planner in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Planner.
-
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.
-
DataBind ScrapingBee Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ScrapingBee to a chart.
-
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.
-
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.
-
Natively Connect to Klaviyo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Klaviyo. Leverage the native support for ODBC in PHP.
-
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.
-
Write a Simple Go Application to work with Clio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Clio.
-
Working with Twitter Ads Data in LINQPad
Execute LINQ queries to Twitter Ads in LINQPad.
-
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.
-
Validate Zuora Data with QuerySurge
Access and validate Zuora in QuerySurge using the CData JDBC Driver.
-
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.
-
Analyze Supabase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Supabase in Microsoft R Open.
-
Connect to Printify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Printify using standard SQL.
-
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.
-
Visualize Couchbase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Couchbase.
-
How to integrate Customer.io with Apache Airflow
Access and process Customer.io in Apache Airflow using the CData JDBC Driver.
-
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.
-
DataBind Controls to Slack Data in C++Builder
DataBind to Slack in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with PostgreSQL via CData CLI
Connect PostgreSQL to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Postmark Data in Aqua Data Studio
Access Postmark from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Goose with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live CockroachDB from within the local AI agent.
-
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.
-
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.
-
Manage Teamwork Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Teamwork.
-
Build Dashboards with Google Cloud Storage Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Cloud Storage in DBxtra.
-
Connect to MariaDB Data in Ruby
Connect to MariaDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Outreach.io Data to Multiple Databases
Replicate Outreach.io to disparate databases with a point-and-click configuration.