CData Software - Knowledge Base
Recent Articles
-
Integrate Salesforce Marketing Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce Marketing data and integrate live Salesforce Marketing data into your Power Automate tasks.
-
Automated Continuous Azure Synapse Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Synapse replication to AlloyDB.
-
Automate HDFS Data Replication to Azure Synapse
Use CData Sync to customize and automate HDFS data replication to Azure Synapse.
-
Integrate Real-Time Access to HubDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HubDB data in real time.
-
Build MVC Applications with Connectivity to Dropbox Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dropbox from an ASP.NET MVC application.
-
Integrating OpenCode with Mailjet 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.
-
Work with Klaviyo Data in FoxPro
Load Klaviyo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for Bitly Data using JDBI
A brief overview of creating a SQL Object API for Bitly data in JDBI.
-
Replicate HCL Domino Data from PowerShell
Write a quick PowerShell script to query HCL Domino data. Use connectivity to the live data to replicate HCL Domino data to SQL Server.
-
Automated Continuous FreshBooks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FreshBooks replication to Apache Cassandra.
-
Build Dashboards with Pipeline CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pipeline CRM data in Dundas BI.
-
Create Salesforce Pardot-Connected Business Apps in AppSheet
Connect to Salesforce Pardot Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesforce Pardot data.
-
Replicate Multiple Copper Accounts via the CData Sync CLI
Replicate multiple Copper accounts to one or many databases.
-
How to connect and process Parallel data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Parallel data.
-
Query Live SAP SuccessFactors 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 SAP SuccessFactors data directly from the development environment.
-
Operational Reporting on Keap Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Keap data.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads data without replication.
-
DataBind Controls to Testmonitor Data in C++Builder
DataBind to Testmonitor data in C++Builder with standard components and controls.
-
How to Work with Jumpseller Data in AWS Glue Jobs Using JDBC
Connect to Jumpseller from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Extract, Transform, and Load Browserless Data in Informatica PowerCenter
Create a simple Workflow for Browserless data in Informatica PowerCenter.
-
Migrating data from Figshare to Snowflake using CData SSIS Components.
Easily push Figshare data to Snowflake using the CData SSIS Tasks for Figshare and Snowflake.
-
Integrate Live Short.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Short.io data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize Live Databricks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Databricks data.
-
How to Connect to Live ZohoMarketingHub 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 ZohoMarketingHub data without replication.
-
Use Dash to Build to Web Apps on Okta Data
Create Python applications that use pandas and Dash to build Okta-connected web apps.
-
Build PDFMonkey-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PDFMonkey data and build web apps with connectivity to live PDFMonkey data.
-
Getting Started with the CData Power BI Connector for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics CRM.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Brex
Provide connectivity to Brex data through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy Web
Connect to Scrapfly data in MicroStrategy Web using the CData Software JDBC Driver for Scrapfly.
-
How to Connect to Keap Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Keap data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Snapchat Ads Data in ACL Analytics
Connect to Snapchat Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Snapchat Ads data.
-
Connect to Zendesk 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 Zendesk data.
-
Automate Flowlu Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Flowlu data from PowerShell? This article demonstrates how to utilize the Flowlu Cmdlets for tasks like connecting to Flowlu data, automating operations, downloading data, and more.
-
Analyze Intercom Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Intercom data with the CData JDBC Driver for Intercom.
-
Create Apps from Zoho Creator Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoho Creator Data and build apps from live Zoho Creator data in Qlik Sense Cloud.
-
Bridge SharePoint Excel Services Connectivity with Apache NiFi
Access and process SharePoint Excel Services data in Apache NiFi using the CData JDBC Driver.
-
Visualize Couchbase Data in TIBCO Spotfire through OData
Integrate Couchbase data into dashboards in TIBCO Spotfire.
-
Create Apps from GitLab Data in Qlik Sense Cloud
Use CData Connect AI to connect to GitLab Data and build apps from live GitLab data in Qlik Sense Cloud.
-
How to connect Amazon QuickSight to Xero Data
Create a connection to Xero data in CData Connect AI and insert Xero data into Amazon QuickSight SPICE to build interactive dashboards.
-
Query Confluence Data in ColdFusion
Write standard ColdFusion data access code to connect to Confluence data.
-
Interact with Live Oracle Financials Cloud Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle Financials Cloud data.
-
Prepare, Blend, and Analyze SAP HANA XS Advanced Data in Alteryx Designer (ODBC)
Build workflows to access live SAP HANA XS Advanced data for self-service data analytics.
-
Analyze LinkedIn Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LinkedIn data with the CData JDBC Driver for LinkedIn.
-
Connect to Microsoft Entra ID from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Entra ID to connect to Microsoft Entra ID data from Web applications running on WebLogic.
-
Visualize SuiteCRM 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 SuiteCRM data into TIBCO Spotfire.
-
Integrate with Oracle HCM Cloud Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle HCM Cloud data in SnapLogic.
-
Automate Greenhouse Data Replication to SAP HANA
Use CData Sync to customize and automate Greenhouse data replication to SAP HANA.
-
Build an OLAP Cube in SSAS from CockroachDB Data
Establish a connection to CockroachDB data data from SQL Server Analysis Services, and use the CockroachDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Seamlessly Bring Salesforce CRM Analytics Data into Retool Using CData Connect AI
Integrate Salesforce CRM Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Feed BambooHR Data into FineReport
How to set BambooHR data as a JDBC data source in FineReport.
-
Analyze Jumpseller Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Jumpseller data with the CData JDBC Driver for Jumpseller.
-
Integrating GitHub Copilot with Trello 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 Devin with Live Guru 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 Guru data.
-
Publish Hubstaff-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hubstaff data.
-
Build Agents in Relevance AI with Access to Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Avro data within intelligent agent workflows.
-
A PostgreSQL Interface for PingOne Data (MySQL Remoting via JDBC)
Use the Remoting features of the PingOne JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Campaigner Accounts
Replicate multiple Campaigner accounts to one or many databases.
-
Connect to Google Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Analytics data.
-
Integrating Antigravity CLI with QuickBooks Time data via CData CLI
Connect QuickBooks Time data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to Discord Data in PHP
The CData ODBC driver for Discord enables you to create PHP applications with connectivity to Discord data. Leverage the native support for ODBC in PHP.
-
Create Apps from Mailjet Data in Qlik Sense Cloud
Use CData Connect AI to connect to Mailjet Data and build apps from live Mailjet data in Qlik Sense Cloud.
-
Connect to Real-Time Rootly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Rootly data in Power Apps.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SageHR
Provide connectivity to SageHR data through an SAP BusinessObjects universe.
-
How to Connect DBeaver to Suadeo via a JDBC Driver
Manage Suadeo data with visual tools in DBeaver like the query browser.
-
Build Miro-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Miro data and build web apps with connectivity to live Miro data.
-
Prepare, Blend, and Analyze Clio Data in Alteryx Designer (ODBC)
Build workflows to access live Clio data for self-service data analytics.
-
Automated Continuous SAP HANA XS Advanced Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Oracle.
-
Automated Continuous Sybase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sybase replication to Amazon Redshift.
-
Access Xero Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Xero data from your Oracle system.
-
Integrating Deel Data in Talend Cloud Data Management Platform
Connect Deel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrating Antigravity CLI with Qualaroo data via CData CLI
Connect Qualaroo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Dashboards with Dropbox Data in Dundas BI
Create dynamic dashboards and perform analytics based on Dropbox data in Dundas BI.
-
Connect to and Query Testmonitor Data in QlikView over ODBC
Create data visualizations with Testmonitor data in QlikView.
-
How to Create Power BI Visual Reports with Real-Time SharePoint Data
Use CData Power BI Connectors to visualize SharePoint data in Power BI.
-
Access Live NetSuite SuiteAnalytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live NetSuite SuiteAnalytics data from your Excel spreadsheets.
-
Build Semantic Layer Views for ZohoSubscriptions Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoSubscriptions data.
-
Access Helpscout Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Helpscout data from your Oracle system.
-
Automated Continuous Pingdom Replication to MySQL
Use CData Sync for automated, continuous, customizable Pingdom replication to MySQL.
-
Natively Connect to Odoo Data in PHP
The CData ODBC driver for Odoo enables you to create PHP applications with connectivity to Odoo data. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Quickbase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Quickbase data.
-
Access Live Splunk 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 Splunk data through MCP integration.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Ads
Install the CData Connect AI Python SDK to read and write live Microsoft Ads data with standard DB-API 2.0 Python code.
-
Integrating Claude Code CLI with Klaviyo 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 LinkedIn Ads Data into Power Automate Desktop using CData Connect
CData Connect for LinkedIn Ads Data enables you to integrate LinkedIn Ads data into workflows built using Microsoft Power Automate Desktop.
-
Use Azure AI Foundry to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Jira Assets data for you.
-
How to Easily Query PagerDuty Data in OpenOffice Base
Connect to PagerDuty data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build a Singer.io Tap for Shippo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Shippo data using the CData Python Connector.
-
Replicate Greenhouse Data to Multiple Databases via the CData Sync CLI
Replicate Greenhouse data to disparate databases with a single configuration.
-
Connect to Amazon Marketplace Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon Marketplace Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Authorize.Net Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Authorize.Net data.
-
Automated Continuous ZohoPeople Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoPeople replication to PostgreSQL.
-
Working with eBay Data in LINQPad
Execute LINQ queries to eBay data in LINQPad.
-
Integrate Nethunt Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Nethunt data from Informatica Cloud.
-
Provide OData Services of ADP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ADP data by developing a WCF Service Application.
-
Create Reports from Microsoft Exchange Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Exchange data and create custom reports in Looker Studio.
-
How to Access Live Suadeo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Suadeo enables you to integrate Suadeo data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Moonlit Workflow with SQL Server 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 SQL Server data in real time.
-
Stream Microsoft Dataverse Data into Apache Kafka Topics
Access and stream Microsoft Dataverse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build AI/ML Models with Live Impala Data using Dataiku
Connect Impala Data with Dataiku using the CData JDBC Driver for Impala.
-
Viewing Insightly Data in RAD Studio Data Explorer
How to view Insightly data in RAD Studio Data Explorer using the CData ODBC Driver for Insightly.