CData Software - Knowledge Base
Recent Articles
-
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 data 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 data.
-
Trigger Facebook IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Facebook with standard wizards in Logic Apps.
-
Create Optimizely-Connected Business Apps in AppSheet
Connect to Optimizely Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Optimizely data.
-
Access Live Bitbucket Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Bitbucket data through MCP integration.
-
Use Dash to Build to Web Apps on Pinterest Data
Create Python applications that use pandas and Dash to build Pinterest-connected web apps.
-
Working with LinkedIn Data in LINQPad
Execute LINQ queries to LinkedIn data in LINQPad.
-
Replicate Outreach.io Data to Multiple Databases via the CData Sync CLI
Replicate Outreach.io data to disparate databases with a single configuration.
-
Analyze Bannerbear Data in Cognos Analytics
Use CData Connect AI to connect to Bannerbear Data from Cognos Analytics and analyze live Bannerbear data.
-
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 ByDesign data.
-
Access Live iContact Data 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 iContact data through MCP integration.
-
Access Live IBM Cloud Object Storage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live IBM Cloud Object Storage data 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 Dynamics 365 data through an SAP BusinessObjects universe.
-
Back Up Zoom data 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 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 data from PostgreSQL.
-
Connect to Zoho Projects Data in NetBeans
Connect to Zoho Projects data in NetBeans with the data source configuration wizard.
-
Connect to JobNimbus Data in DBeaver
Use the CData ODBC Driver to connect to JobNimbus data 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 data for you.
-
How to connect and process Zoho CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho CRM data.
-
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 data 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 data in the Pentaho BI tool.
-
Connect to iContact Data in DBeaver
Use the CData ODBC Driver to connect to iContact data in DBeaver.
-
Integrate with live Microsoft Dataverse Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Dataverse data 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 data 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 data in MySQL .
-
Choosing the Best Method to Connect Hubstaff to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Hubstaff data 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 data 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 data 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 data.
-
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 data 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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Toggl data in Excel.
-
Automated Continuous SAS xpt Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAS xpt data 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 data by developing a WCF Service Application.
-
Automated Continuous Factorial Replication to SingleStore
Use CData Sync for automated, continuous, customizable Factorial replication to SingleStore.
-
Connect and Visualize Live Basecamp Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Basecamp data into the Databricks platform and create visualization dashboards with real-time Basecamp data.
-
Aha! Reporting in OBIEE with the Aha! JDBC Driver
Deploy the Aha! JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Mode Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Mode data for you.
-
Use the CData Software ODBC Driver for Microsoft Planner in MicroStrategy Desktop
Connect to Microsoft Planner data 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 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Suadeo-Connected Business Apps in AppSheet
Connect to Suadeo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Suadeo data.
-
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 data 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 data.
-
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 Greenplum data, no replication required.
-
Integrate Azure Analysis Services Data in Pentaho Data Integration
Build ETL pipelines based on Azure Analysis Services data 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 data. Leverage the native support for ODBC in PHP.
-
Connect to Elorus Data from PowerBuilder via JDBC
This article demonstrates how to access Elorus data 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 data.
-
Working with Twitter Ads Data in LINQPad
Execute LINQ queries to Twitter Ads data 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 data 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 data in QuerySurge using the CData JDBC Driver.
-
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 data within intelligent agent workflows.
-
Analyze Supabase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Supabase data in Microsoft R Open.
-
Connect to Printify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Printify data 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 Dynamics CRM data from Web apps in Jetty.
-
Visualize Couchbase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Couchbase data.
-
How to integrate Customer.io with Apache Airflow
Access and process Customer.io data 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 data into Microsoft Power Query.
-
Creating SQL Analysis Services-Connected Applications in Unqork
You can use CData Connect AI to feed SQL Analysis Services data to Unqork and build custom business apps.
-
DataBind Controls to Slack Data in C++Builder
DataBind to Slack data in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with PostgreSQL data via CData CLI
Connect PostgreSQL data 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 data 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 data from within the local AI agent.
-
Query Oracle SCM Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle SCM data 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 data 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 Dynamics CRM data.
-
Publish Pushbullet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pushbullet data.
-
Query Microsoft OneDrive Data in DataGrip
Create a Data Source for Microsoft OneDrive in DataGrip and use SQL to query live Microsoft OneDrive data.
-
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 data for you.
-
Query Live Paymo Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Paymo data directly from the development environment.
-
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 data in DBxtra.
-
Connect to MariaDB Data in Ruby
Connect to MariaDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Outreach.io Data to Multiple Databases
Replicate Outreach.io data to disparate databases with a point-and-click configuration.
-
Connect Demio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Demio with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Live Oracle SCM Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle SCM Data in CData Connect AI and connect to your Oracle SCM data from MicroStrategy.
-
How to Connect to Live Acumatica Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Acumatica data for you.
-
Connect to Live FreshBooks Data in PostGresSQL Interface through CData Connect AI
Create a live connection to FreshBooks in CData Connect AI and connect to your FreshBooks data from PostgreSQL.
-
Replicate Oracle Eloqua Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Eloqua data to disparate databases with a single configuration.
-
How to Connect to Live Google Contacts Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Contacts data for you.
-
Connect to Real-Time Copper Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Copper data in Power Apps.
-
Use ChatGPT to Talk to Your Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Pinterest data for you.
-
Prepare, Blend, and Analyze Kintone Data in Alteryx Designer (Connect AI)
Build workflows to access live Kintone data for self-service data analytics.
-
Query Live Sendwithus Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Sendwithus data through a conversational interface.
-
How to connect to Airtable Data from Spring Boot
Connect to Airtable in a Spring Boot Application using the CData JDBC Driver for Airtable
-
How to Build an ETL App for Dynamics NAV Data in Python with CData
Create ETL applications and real-time data pipelines for Dynamics NAV data in Python with petl.
-
Use Dash to Build to Web Apps on IBM Cloud Object Storage Data
Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.
-
How to Use a Microsoft Access Database to Update YouTube Analytics Data in Real Time
Update YouTube Analytics data by creating a linked table in Microsoft Access with the CData YouTube Analytics ODBC Driver.