CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Sage Cloud Accounting Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MySQL.
-
Connect to Salesforce Marketing Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce Marketing data using standard SQL.
-
Getting Started with the CData Power BI Connector for Qualaroo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Replicate Outlook Data to Multiple Databases
Replicate Outlook data to disparate databases with a point-and-click configuration.
-
View Reports on Real-Time Rebilly Data in Power BI Report Server
Use the CData ODBC Driver for Rebilly to visualize Rebilly data in Power BI Desktop and then publish them to Power BI Report Server.
-
Building Dynamic Web Pages with DocuSign Data Using AngularJS
Create single-page applications with live connectivity to DocuSign using the CData API Server.
-
Build Helpscout-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Helpscout data and build web apps with connectivity to live Helpscout data.
-
Replicate Multiple Oracle Accounts via the CData Sync CLI
Replicate multiple Oracle accounts to one or many databases.
-
Use the CData Software JDBC Driver for SAP SuccessFactors in MicroStrategy Web
Connect to SAP SuccessFactors data in MicroStrategy Web using the CData Software JDBC Driver for SAP SuccessFactors.
-
How to Connect to Live ServiceNow 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 ServiceNow data through natural language.
-
Automate LeadDesk Data Replication to SAP HANA
Use CData Sync to customize and automate LeadDesk data replication to SAP HANA.
-
Connecting Mastra with Sage 200 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 Sage 200 data, no replication required.
-
Integrate Live Oracle SCM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle SCM data to Blue Prism using the CData ODBC Driver for Oracle SCM to create automated workflows for repetitive business tasks.
-
Access Live Avro Data in TIBCO Data Virtualization
Use the Avro Tibco DV Adapter to create a Avro data data source in TIBCO Data Virtualization Studio and gain access to live Avro data from your TDV Server.
-
How to Connect to Live Twilio Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Twilio data for you.
-
Publish Crystal Reports on Perigon Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Perigon data.
-
Deploy the ADO.NET Provider for Spotify on an SSRS Report Server
Connect to Spotify data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Migrating data from Snowflake to Snowflake using CData SSIS Components.
Easily push Snowflake data to Snowflake using the CData SSIS Tasks for Snowflake and Snowflake.
-
Build SAP Ariba Procurement-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP Ariba Procurement data without replication.
-
How to Connect to Live Lakebase Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Lakebase data for you.
-
Integrate Devin with Live SAP SuccessFactors LMS Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAP SuccessFactors LMS data.
-
Connect to ZohoPeople Data from a Connection Pool in Jetty
The ZohoPeople JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoPeople data from Web apps in Jetty.
-
Automate MessageBird Data Replication to Couchbase
Use CData Sync to Customize and automate MessageBird data replication to Couchbase.
-
Analyze SAP Concur Data in Looker
Use CData Connect AI to connect to SAP Concur Data from Looker and build custom apps using live SAP Concur data.
-
Automated Continuous ClickUp Replication to SingleStore
Use CData Sync for automated, continuous, customizable ClickUp replication to SingleStore.
-
Connect to Twitter Ads Data from a Connection Pool in Jetty
The Twitter Ads JDBC Driver supports connection pooling: This article shows how to connect faster to Twitter Ads data from Web apps in Jetty.
-
How to integrate LDAP with Apache Airflow
Access and process LDAP objects in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for Redshift Data (MySQL Remoting via JDBC)
Use the Remoting features of the Redshift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model, Search, and Visualize Live Redis Data in ThoughtSpot
Use CData Connect AI to connect to live Redis data for modeling, searching, and visualizing.
-
How to connect SharePoint with Salesforce Marketing Data through external lists
Provide Salesforce Marketing data to SharePoint users as an external list.
-
Automated Continuous Cloudant Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cloudant replication to AlloyDB.
-
Integrate Google Search Results in the Pentaho Report Designer
Publish reports based on Google Search results in the Pentaho BI tool.
-
Publish Reports with Stripe Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stripe data.
-
Automated Continuous Azure Data Lake Storage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to AlloyDB.
-
Automated Continuous Google Contacts Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Contacts replication to Amazon S3.
-
Replicate REST Data in Heroku for Use in Salesforce Connect
Replicate REST data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Google's Vertex AI Agent with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Adobe Commerce data within intelligent workflows.
-
Automate Instantly Data Replication to SAP HANA
Use CData Sync to customize and automate Instantly data replication to SAP HANA.
-
How to Work with ZohoMarketingHub Data in ETL Validator JDBC
Connect to ZohoMarketingHub from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Bitbucket Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bitbucket replication to Google BigQuery.
-
Visualize Live Box Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Box data.
-
Integrating Codex with Google Tasks 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 ZohoInvoice Data in RapidMiner
Integrate ZohoInvoice data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Data Flows from SQL Server to Acumatica through SSIS
Easily push SQL Server data to Acumatica using the CData SSIS Tasks for Acumatica.
-
How to Seamlessly Import Azure Analysis Services Data into IBM SPSS Modeler
Integrate Azure Analysis Services data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Acumatica-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Acumatica data.
-
Create Power BI Reports on Real-Time Certinia Data
Use the CData ODBC Driver for Certinia to visualize Certinia data in Power BI Desktop.
-
Connect to ShipEngine Data in HULFT Integrate
Connect to ShipEngine as a JDBC data source in HULFT Integrate
-
Integrate with Intercom Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Intercom data to a JSON file on disk.
-
Access NetSuite Data from MySQL in Amazon QuickSight
Connect to NetSuite and build visualizations of NetSuite data using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData ODBC Driver for Webex
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Webex.
-
Integrate Live Google Contacts Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Contacts data from within the IDE.
-
Moving Data from Quaderno to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Quaderno data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to PolarTeamPro Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PolarTeamPro data. Leverage the pyodbc module for ODBC in Python.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Teams data for you.
-
Natively Connect to Avalara AvaTax Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Avalara AvaTax data. Leverage the native support for ODBC in PHP.
-
Build AI/ML Models with Live Simplesat Data using Dataiku
Connect Simplesat Data with Dataiku using the CData API Driver for JDBC.
-
ETL ConvertAPI in Oracle Data Integrator
This article shows how to transfer ConvertAPI data into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations in Cognos BI with Oracle Eloqua Reporting Data
Access Oracle Eloqua Reporting data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate MongoDB Data to Multiple Databases
Replicate MongoDB data to disparate databases with a point-and-click configuration.
-
Access ServiceDesk Plus Data from MySQL in Amazon QuickSight
Connect to ServiceDesk Plus and build visualizations of ServiceDesk Plus data using a MySQL Connection in Amazon QuickSight.
-
How to Connect DBeaver to Microsoft Exchange via a JDBC Driver
Manage Microsoft Exchange data with visual tools in DBeaver like the query browser.
-
Integrate LibreChat with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Phoenix data from within the chat interface.
-
Build Dynamics CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Dynamics CRM data.
-
Use Dash to Build to Web Apps on SAP Business Warehouse Data
Create Python applications that use pandas and Dash to build SAP Business Warehouse-connected web apps.
-
Visualize Airtable Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Airtable data into TIBCO Spotfire.
-
How to connect to NASA Data from IntelliJ
Integrate connectivity to NASA data with wizards in IntelliJ.
-
Explore Geographical Relationships in Xero Data with Power Map
Create data visualizations with Xero data in Power Map.
-
Integrating GitHub Copilot with HelloSign 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 Cosmos DB in SpagoBI
Create reports featuring live Cosmos DB data in SpagoBI Studio. Host Cosmos DB reports on SpagoBI Server.
-
Build Voice Agents in ElevenLabs with access to Live GraphQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live GraphQL data.
-
Rapidly Develop Sage Cloud Accounting-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 Sage Cloud Accounting.
-
How to Work with Copper Data in AWS Glue Jobs Using JDBC
Connect to Copper from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Raisers Edge NXT Replication to SingleStore
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to SingleStore.
-
Create Reports with Quaderno Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Quaderno data.
-
Import Real-Time Mouseflow Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mouseflow data in ColdFusion.
-
Use Grok to Talk to Your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Zoom data for you.
-
Getting Started with the CData SSIS Components for FTP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for FTP.
-
Automate Exa Data Replication to SAP HANA
Use CData Sync to customize and automate Exa data replication to SAP HANA.
-
Connect to Bullhorn CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Bullhorn CRM data.
-
Trigger Highrise IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Highrise with standard wizards in Logic Apps.
-
Connect Basecamp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Basecamp with IBM WebSphere for seamless data integration and connectivity.
-
How to Access Live Attio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Attio enables you to integrate Attio data into workflows built using Microsoft Power Automate Desktop.
-
Build an OLAP Cube in SSAS from Salesforce Data
Establish a connection to Salesforce data data from SQL Server Analysis Services, and use the Salesforce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Jira Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Jira data and visualize live Jira data in Infragistics Reveal.
-
Integrating Claude Code CLI with Xero 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.
-
Getting Started with the CData Excel Add-In for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Hybris C4C.
-
Connect to Amazon Athena Data from a Connection Pool in Jetty
The Amazon Athena JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon Athena data from Web apps in Jetty.
-
Rapidly Develop Zendesk-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 Zendesk.
-
Validate DB2 Data with QuerySurge
Access and validate DB2 data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData ODBC Driver for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Commerce.
-
Analyze CSV Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of CSV data and visualize live CSV data in Infragistics Reveal.
-
Automated Continuous Reckon Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Reckon data replication to OneLake in Microsoft Fabric.
-
Create Power BI Reports on Real-Time Datadog Data
Use the CData ODBC Driver for Datadog to visualize Datadog data in Power BI Desktop.
-
Query Humanity Data in DataGrip
Create a Data Source for Humanity in DataGrip and use SQL to query live Humanity data.
-
Create Data Visualizations Based On MYOB AccountRight Data in Mode
Use CData Connect AI to connect to MYOB AccountRight Data from Mode and build visualizations using live MYOB AccountRight data.
-
Create Informatica Mappings From/To an ODBC Data Source for AfterShip
Create an ODBC connection to AfterShip in Informatica and browse and transfer AfterShip data.
-
How to Connect to VWO Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to VWO data. Leverage the pyodbc module for ODBC in Python.
-
Automate Oracle Service Cloud Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle Service Cloud data replication to Azure Synapse.
-
Automate SAS xpt Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAS xpt data replication to Azure Data Lake.