CData Software - Knowledge Base
Recent Articles
-
Connect to Clio Data in Aqua Data Studio
Access Clio data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP
Provide connectivity to SAP data through an SAP BusinessObjects universe.
-
Use Agno to Talk to Your Google 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 Google Analytics data for you.
-
How to connect Amazon QuickSight to Jumpseller Data
Create a connection to Jumpseller data in CData Connect AI and insert Jumpseller data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Spark Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Spark data from your Oracle system.
-
Link CapsuleCRM with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate CapsuleCRM data in Filemaker Pro for Mac or Windows.
-
Migrating data from Quaderno to Databricks using CData SSIS Components.
Easily push Quaderno data to Databricks using the CData SSIS Tasks for Quaderno and Databricks.
-
Visualize Live Snapchat Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Snapchat Ads data into custom reports in Power BI.
-
Connect to Klaviyo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Klaviyo data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Live Avro 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 Avro data for you.
-
Query Zoho CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho CRM entities in PHP by modeling them as objects.
-
Integrate Live Zoom Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoom from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoom data.
-
Build AI Agents with Oracle HCM Cloud 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 Oracle HCM Cloud data through CData Connect AI.
-
Automated Continuous Twitter Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Snowflake.
-
Connect to Everhour Data from PowerBuilder via ADO.NET
This article demonstrates how to access Everhour data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Seamlessly Import Pinterest Data into IBM SPSS Modeler
Integrate Pinterest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Reports with Redshift Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redshift data.
-
Build Voice Agents in ElevenLabs with access to Live Salesloft Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesloft data.
-
Connect to Facebook Ads Data in Aqua Data Studio
Access Facebook Ads data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Work with Live SAP ByDesign Data in Power Query
Use CData Connect AI to connect to SAP ByDesign data and work with live SAP ByDesign data in Microsoft Power Query.
-
Use the CData Software JDBC Driver for Keap in MicroStrategy Web
Connect to Keap data in MicroStrategy Web using the CData Software JDBC Driver for Keap.
-
Easily Integrate Strava Data in Lazarus Pascal IDE
Learn how to easily integrate live Strava data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to integrate GetResponse with Apache Airflow
Access and process GetResponse data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous SAP ByDesign Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP ByDesign data replication to OneLake in Microsoft Fabric.
-
How to Connect to Live SFTP Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SFTP data securely in real time.
-
Integrate Theia IDE with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Freshservice data from within the development environment.
-
Configure the CData JDBC Driver for HCL Domino in a Connection Pool in Tomcat
Connect to HCL Domino data from a connection pool in Tomcat.
-
Query PolarTeamPro Data in DataGrip
Create a Data Source for PolarTeamPro in DataGrip and use SQL to query live PolarTeamPro data.
-
Use the CData Software JDBC Driver for Exa in MicroStrategy Desktop
Connect to Exa data in MicroStrategy Desktop using the CData Software JDBC Driver for Exa.
-
Create a Data Access Object for ShipStation Data using JDBI
A brief overview of creating a SQL Object API for ShipStation data in JDBI.
-
Use Microsoft Copilot Studio to talk to your Google Spanner 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 Google Spanner data for you.
-
How to create an RPA flow for IBM Informix Data in UiPath Studio
Use the IBM Informix ODBC Driver to create workflows that access real-time IBM Informix data without any coding.
-
Interact with Live SAP Fieldglass Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP Fieldglass data.
-
Connect to Testmonitor 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 Testmonitor data.
-
Visualize Mocean Data in Tableau
The CData ODBC driver for Mocean enables you integrate Mocean data into Tableau dashboards.
-
Migrating data from Telegram to Snowflake using CData SSIS Components.
Easily push Telegram data to Snowflake using the CData SSIS Tasks for Telegram and Snowflake.
-
Connect to Dynamics NAV Data in Ruby
Connect to Dynamics NAV data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate ActiveCampaign Data from PowerShell
Write a quick PowerShell script to query ActiveCampaign data. Use connectivity to the live data to replicate ActiveCampaign data to SQL Server.
-
Connect to Snowflake Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Snowflake as an External Source in Dremio.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Cloud Accounting data in MicroStrategy Developer using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Integrate Dify with Live Salesforce CRM Analytics 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 CRM Analytics data.
-
Integrate Google's Vertex AI Agent with Live Typeform 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 Typeform data within intelligent workflows.
-
Build Data Flows from OneNote to SQL Server using SSIS
Easily back up OneNote data to SQL Server using the SSIS components for OneNote.
-
A PostgreSQL Interface for Azure Table Data using the CData ODBC Driver
Use the SQL Gateway and Azure Table ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Eventbrite Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Eventbrite.
-
Viewing Elorus Data in RAD Studio Data Explorer
How to view Elorus data in RAD Studio Data Explorer using the CData ODBC Driver for Elorus.
-
Build Data Flows from Float to SQL Server using SSIS
Easily back up Float data to SQL Server using the SSIS components for Float.
-
How to connect to FreshBooks Data in DBVisualizer
Integrate FreshBooks data with visual data analysis tools and data connection wizards in DBVisualizer
-
Choosing the Best Method to Connect PolarTeamPro to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PolarTeamPro data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to and Query Guru Data in QlikView over ODBC
Create data visualizations with Guru data in QlikView.
-
Build Facebook Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Facebook Ads Data from Zoho Analytics and import live Facebook Ads data.
-
Manage Typeform Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Typeform.
-
ETL SAP Ariba Source in Oracle Data Integrator
This article shows how to transfer SAP Ariba Source data into a data warehouse using Oracle Data Integrator.
-
Access Live Apify Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apify data into the statistical analysis tools available in SAS JMP. This article shows how to use Apify data in the Graph Builder and Query Builder.
-
Connect to SAP Ariba Source Data in RapidMiner
Integrate SAP Ariba Source data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Real-Time JotForm Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use JotForm data in Power Apps.
-
Visualize Retently Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Retently data.
-
Connect to Tavily Data from Crystal Reports
Use CData Connect AI to connect to and report on live Tavily data from Crystal Reports.
-
Create Data Visualizations in Cognos BI with SAP Ariba Procurement Data
Access SAP Ariba Procurement data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Zoho Recruit from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Recruit to connect to Zoho Recruit data from Web applications running on WebLogic.
-
Access Live SingleStore 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 SingleStore data through MCP integration.
-
Enable the Quaderno JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Quaderno data.
-
Integrate Trae with Live Active Directory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Active Directory data from within the AI-powered IDE.
-
Manage Pipeliner CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pipeliner CRM.
-
Getting Started with the CData JDBC Driver for eBay
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for eBay.
-
Use the CData Software ODBC Driver for Shortcut in MicroStrategy
Connect to Shortcut data in MicroStrategy Developer using the CData Software ODBC Driver for Shortcut.
-
Build Adobe Target-Connected Apps in Choreo
Use CData Connect AI to connect to Adobe Target Data from Choreo and build custom apps using live Adobe Target data.
-
Build a PostgreSQL Interface for Salesforce Marketing Data using the CData JDBC Driver
Use the Remoting features of the Salesforce Marketing JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Grok to Talk to Your Google Calendar 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 Google Calendar data for you.
-
Automate Figshare Data Replication to SAP HANA
Use CData Sync to customize and automate Figshare data replication to SAP HANA.
-
Automate Kafka Data Replication to Azure Synapse
Use CData Sync to customize and automate Kafka data replication to Azure Synapse.
-
Connect Beeminder to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Beeminder data using the CData Python MCP Server.
-
How to Connect to Live ConstantContact Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ConstantContact data without replication.
-
Access SAP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP data from your Oracle system.
-
How to create REST federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for REST data in MySQL .
-
Automated Continuous Wistia Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Wistia replication to AlloyDB.
-
Back Up Gumroad 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 Gumroad data data.
-
Publish Printify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Printify data.
-
Integrate Live Zendesk 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 Zendesk data from within the IDE.
-
How to work with Customer.io Data in Apache Spark using SQL
Access and process Customer.io Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Salesforce CRM Analytics from Asprova with CData Software ODBC Driver for Salesforce CRM Analytics
This article shows how to connect faster to Salesforce CRM Analytics data from Asprova.
-
Publish Reports with ChargeOver Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChargeOver data.
-
Build Data Flows from SAP ByDesign to SQL Server using SSIS
Easily back up SAP ByDesign data to SQL Server using the SSIS components for SAP ByDesign.
-
Connect to Sage Cloud Accounting Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage Cloud Accounting and the Script function in FileMaker Pro to connect to Sage Cloud Accounting and work with Sage Cloud Accounting data in your FileMaker application.
-
Create SSAS Tabular Models from Suadeo Data
How to build a SQL Server Analysis Service Tabular Model from Suadeo data using CData drivers.
-
Design BIRT Reports on Sage Intacct Data
Provide current Sage Intacct data to your embedded analytics.
-
Use the CData Software ODBC Driver for Oracle in MicroStrategy
Connect to Oracle data in MicroStrategy Developer using the CData Software ODBC Driver for Oracle.
-
Visualize Rebilly Data in Sisense
Create an ElastiCube in Sisense app with access to Rebilly data.
-
Connect to Pipeline CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipeline CRM data.
-
Automated Continuous Omnisend Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Omnisend replication to delimited files (CSV/TSV).
-
Connect to DB2 Data in Jaspersoft Studio
Execute SQL to remote DB2 data in Jaspersoft Studio.
-
Analyze Workday Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Workday data in Microsoft R Open.
-
Use Dash to Build to Web Apps on PostgreSQL Data
Create Python applications that use pandas and Dash to build PostgreSQL-connected web apps.
-
Automated Continuous CockroachDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CockroachDB replication to Amazon S3.
-
Getting Started with the CData Excel Add-In for Klipfolio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Klipfolio.
-
Integrate Aha! with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Aha! with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Aha! data.
-
How to Create Power BI Visual Reports with Real-Time Perigon Data
Use CData Power BI Connectors to visualize Perigon data in Power BI.
-
How to update SAP HANA from Excel
This article explains how to transfer data from Excel to SAP HANA using the Excel Add-In for SAP HANA.
-
Integrate Grafana Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Grafana data and integrate live Grafana data into your Power Automate tasks.
-
Build Apps with Live Kafka data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Kafka data into the Adalo platform and build custom mobile and web applications with real-time Kafka data.