CData Software - Knowledge Base
Recent Articles
-
How to connect to Yelp Data from Spring Boot
Connect to Yelp in a Spring Boot Application using the CData API Driver for JDBC
-
Query Live Square 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 Square data through a conversational interface.
-
Excel Spreadsheet Automation on AfterShip Data with the QUERY Formula
Pull data from AfterShip, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Exa Replication to SQL Server
Use CData Sync for automated, continuous, customizable Exa replication to SQL Server.
-
Connect to Basecamp Data in Aqua Data Studio
Access Basecamp data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Using the CData Software ODBC Driver for YouTube Analytics in PyCharm
Connect to YouTube Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for YouTube Analytics.
-
Connect to Reckon Accounts Hosted Data in ACL Analytics
Connect to Reckon Accounts Hosted data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Reckon Accounts Hosted data.
-
Natively Connect to Azure Synapse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Synapse data. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Testmonitor via a JDBC Driver
Manage Testmonitor data with visual tools in DBeaver like the query browser.
-
Integrate Live TaxJar Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to TaxJar data and integrate live TaxJar data into apps built in Microsoft Power Apps.
-
How to Connect to Pipeline CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipeline CRM data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Aircall with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Aircall with External Services.
-
Connect to Retently Data in DBeaver
Use the CData ODBC Driver to connect to Retently data in DBeaver.
-
Access Live MongoDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MongoDB data from your Excel spreadsheets.
-
Automated Continuous Google Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ads replication to SQLite.
-
Moving Data from Impala to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Impala data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Bidirectional Access to Kintone Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Kintone data in Filemaker Pro for Mac or Windows.
-
Work with Live VWO Data in Power Query
Use CData Connect AI to connect to VWO data and work with live VWO data in Microsoft Power Query.
-
Integrate Cline with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live iContact data from within your IDE.
-
Connect to Greenplum Data in Claris FileMaker Pro
Use the CData ODBC Driver for Greenplum in FileMaker Pro to connect to Greenplum and work with Greenplum data in your FileMaker applications.
-
Connect to SingleStore Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SingleStore as an External Source in Dremio.
-
Publish Campaigner-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Campaigner data.
-
Connect to Landbot Data from a Connection Pool in JBoss
Integrate Landbot data into Java servlets: Use the Management Console in JBoss to install the Landbot JDBC Driver.
-
Connecting GenSpark with QuickBooks Time Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to QuickBooks Time data without any replication or custom integration required.
-
Automated Continuous GraphQL Replication to MySQL
Use CData Sync for automated, continuous, customizable GraphQL replication to MySQL.
-
How to create an RPA flow for Twilio Data in UiPath Studio
Use the Twilio ODBC Driver to create workflows that access real-time Twilio data without any coding.
-
How to connect Amazon QuickSight to Google Spanner Data
Create a connection to Google Spanner data in CData Connect AI and insert Google Spanner data into Amazon QuickSight SPICE to build interactive dashboards.
-
ETL Superchat in Oracle Data Integrator
This article shows how to transfer Superchat data into a data warehouse using Oracle Data Integrator.
-
Access PostgreSQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PostgreSQL data from your Oracle system.
-
Connect to Live Google Search Results in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Search in CData Connect AI and connect to your Google Search results from PostgreSQL.
-
Validate Facebook Ads Data with QuerySurge
Access and validate Facebook Ads data in QuerySurge using the CData JDBC Driver.
-
Connect to Dynamics 365 Data in NetBeans
Connect to Dynamics 365 data in NetBeans with the data source configuration wizard.
-
Create Google Forms Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Forms data access from reports, embedded analytics, and more.
-
Build AgileCRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for AgileCRM Data and create custom apps in Mendix.
-
Migrating data from Cloudflare to Databricks using CData SSIS Components.
Easily push Cloudflare data to Databricks using the CData SSIS Tasks for Cloudflare and Databricks.
-
Connect to Access from Asprova with CData Software ODBC Driver for Access
This article shows how to connect faster to Access data from Asprova.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy Desktop
Connect to Zoho Projects data in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Projects.
-
Access WordPress Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access WordPress data from your Oracle system.
-
LINQ to ActiveCampaign Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ActiveCampaign Data Provider.
-
Connect to Authorize.Net from a Connection Pool in WebLogic
Use the CData JDBC Driver for Authorize.Net to connect to Authorize.Net data from Web applications running on WebLogic.
-
How to import CampaignMonitor Data into Apache Solr
Use the CData Software JDBC Driver for CampaignMonitor in Data Import Handler and create an automated import of CampaignMonitor data to Apache Solr Enterprise Search platform.
-
Replicate Multiple ZohoPeople Accounts
Replicate multiple ZohoPeople accounts to one or many databases.
-
Back Up Oracle Eloqua Reporting data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua Reporting. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua Reporting data data.
-
Create BambooHR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BambooHR Data from OutSystems and build custom enterprise apps using live BambooHR data.
-
Model, Search, and Visualize Live SFTP Data in ThoughtSpot
Use CData Connect AI to connect to live SFTP data for modeling, searching, and visualizing.
-
Analyze QuickBooks Time Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of QuickBooks Time data and visualize QuickBooks Time data in SAP Analytics Cloud.
-
Access Live SAP SuccessFactors LMS Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP SuccessFactors LMS data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP SuccessFactors LMS data in the Graph Builder and Query Builder.
-
Connect to QuickBooks Time Data in HULFT Integrate
Connect to QuickBooks Time as a JDBC data source in HULFT Integrate
-
Connect to Teamwork Data from PowerBuilder via ADO.NET
This article demonstrates how to access Teamwork data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Microsoft Copilot Studio to talk to your Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Bullhorn CRM data for you.
-
ETL HubDB in Oracle Data Integrator
This article shows how to transfer HubDB data into a data warehouse using Oracle Data Integrator.
-
Connect to Bannerbear Data in Ruby
Connect to Bannerbear data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Landbot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Landbot data.
-
Access Live Office 365 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Office 365 data from your Excel spreadsheets.
-
Build Data Flows from Nethunt to SQL Server using SSIS
Easily back up Nethunt data to SQL Server using the SSIS components for Nethunt.
-
Automated Continuous Pinterest Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pinterest replication to Apache Cassandra.
-
Use the CData ODBC Driver for Spark from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Spark to connect to Spark data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Spark data in Excel.
-
Connect to HubSpot Data from AWS Glue
Use CData Connect AI to gain access to live HubSpot data from your AWS Glue jobs.
-
Integrate Live Yelp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Yelp data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Enable the Bitbucket JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bitbucket data.
-
Migrating data from ConstantContact to Databricks using CData SSIS Components.
Easily push ConstantContact data to Databricks using the CData SSIS Tasks for ConstantContact and Databricks.
-
Create Jira Assets Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Jira Assets from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Cursor with Mistral AI 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 Real-Time Access to SAP ByDesign in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP ByDesign data in real time.
-
Connect to Office 365 Data from a Connection Pool in JBoss
Integrate Office 365 data into Java servlets: Use the Management Console in JBoss to install the Office 365 JDBC Driver.
-
Connect to Supabase Data from a Connection Pool in JBoss
Integrate Supabase data into Java servlets: Use the Management Console in JBoss to install the Supabase JDBC Driver.
-
Build AI Agents with CockroachDB 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 CockroachDB data through CData Connect AI.
-
Build a Simple VCL Application for Freshsales Data
How to build a simple VCL Application to view Freshsales data in RAD Studio using the CData ODBC Driver for Freshsales.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy Web
Connect to CloudConvert data in MicroStrategy Web using the CData Software ODBC Driver for CloudConvert.
-
Build Semantic Layer Views for Sybase IQ Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sybase IQ data.
-
Reply.io Reporting in OBIEE with the Reply.io JDBC Driver
Deploy the Reply.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Vertica Replication to Snowflake
Use CData Sync for automated, continuous, customizable Vertica replication to Snowflake.
-
Analyze Optimizely Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Optimizely data and visualize live Optimizely data in Infragistics Reveal.
-
Create Dashboards and Visualize Live YouTube Analytics Data in Geckoboard
Use CData Connect AI to connect to live YouTube Analytics data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Rapidly Develop Google Cloud Storage-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 Google Cloud Storage.
-
Integrating Boomi Agentstudio with SendPulse Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SendPulse data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Building Dynamic Web Pages with Sybase Data Using AngularJS
Create single-page applications with live connectivity to Sybase using the CData API Server.
-
Use Databricks Agent Bricks to Talk to Your HBase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HBase data for you.
-
Use CData Connect AI to Access Oracle Sales Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Sales data in the Power Pivot business intelligence tool.
-
Use Claude to Talk to Your YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your YouTube Analytics data for you.
-
Integrate Dify with Live Salesforce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Salesforce data.
-
Automated Continuous Cohere Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cohere replication to SingleStore.
-
Automate Exact Online Data Replication to Azure Data Lake
Use CData Sync to customize and automate Exact Online data replication to Azure Data Lake.
-
How to Connect to Live Cloudant 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 Cloudant data for you.
-
Build Dashboards with Keap Data in Dundas BI
Create dynamic dashboards and perform analytics based on Keap data in Dundas BI.
-
How to publish and share Asana Data dashboards with Tableau Server
The CData ODBC driver for Asana enables you integrate Asana data into Tableau dashboards.
-
Integrate Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data from within the IDE.
-
Write a Simple Go Application to work with HelloSign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to HelloSign data.
-
Automated Continuous FHIR Replication to Databricks
Use CData Sync for automated, continuous, customizable FHIR replication to Databricks.
-
Use the CData Software ODBC Driver for FHIR in SAS for Real-Time Reporting and Analytics
Connect to real-time FHIR data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FHIR.
-
Create Dynamic Couchbase Grids Using the Infragistics XamDataGrid
Learn how you can connect Couchbase to Infragistics XamDataGrid to build dynamic grids.
-
How to connect and process Dynamics CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Dynamics CRM data.
-
Integrating QuickBooks Online Data in Talend Cloud Data Management Platform
Connect QuickBooks Online Data with Talend Cloud Data Management Platform using the CData JDBC Driver for QuickBooks Online.
-
Using the CData Software ODBC Driver for Short.io in PyCharm
Connect to Short.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Short.io.
-
DataBind Controls to Accelo Data in C++Builder
DataBind to Accelo data in C++Builder with standard components and controls.
-
Build Sybase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sybase data and build visualizations in Tableau Cloud.
-
Build Dynamics CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Dynamics CRM Data from Choreo and build custom apps using live Dynamics CRM data.
-
How to Build an ETL App for Twitter Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Twitter Ads data in Python with petl.
-
Query Live Tally 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 Tally data directly from the development environment.
-
How to connect SharePoint with Snowflake Data through external lists
Provide Snowflake data to SharePoint users as an external list.