CData Software - Knowledge Base
Recent Articles
-
Access Reply.io Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reply.io data from your Oracle system.
-
Automated Continuous Excel Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable Excel Online replication to SQL Server.
-
Visualize ConstantContact Data in TIBCO Spotfire through ADO.NET
Integrate ConstantContact data into dashboards in TIBCO Spotfire.
-
How to Connect Flowise AI Agents to Live Phoenix Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Phoenix data without replication.
-
Integrating Codex with Cloudflare 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 Oracle SCM Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle SCM data from PowerBuilder using the Oracle SCM JDBC Driver.
-
How to Work with LightSpeedRetail Data in ETL Validator JDBC
Connect to LightSpeedRetail from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Workday Data in DBVisualizer
Integrate Workday data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating GitHub Copilot with Amazon DynamoDB 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.
-
Model Zoho Books Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Books, enabling the direct import of real-time Zoho Books data.
-
Enable the Box JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Box data.
-
Access SAP Tables and SAP Queries using CData SAP Providers
In this article we explain how our SAP products obtain table information and provide a free helper utility to add additional table schemas to our SAP Providers.
-
Connect to Wrike Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Wrike to connect to Wrike data and execute queries in PowerBuilder.
-
How to connect PolyBase to Pipeliner CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pipeliner CRM data.
-
Create Excel Online-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Excel Online Data from OutSystems and build custom enterprise apps using live Excel Online data.
-
Automated Continuous Klaviyo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Klaviyo data replication to OneLake in Microsoft Fabric.
-
Create Reports with SAP Netweaver Gateway Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Netweaver Gateway data.
-
Use the CData Software ODBC Driver for Zoho Recruit in MicroStrategy
Connect to Zoho Recruit data in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Recruit.
-
Provide OData Services of ZohoPeople Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoPeople data by developing a WCF Service Application.
-
Use Biml to Build SSIS Tasks to Replicate PagerDuty Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PagerDuty data to SQL Server.
-
Connect to HubSpot Data in RapidMiner
Integrate HubSpot data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Microsoft Entra ID Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Entra ID Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Printful Data in Jaspersoft Studio
Execute SQL to remote Printful data in Jaspersoft Studio.
-
Back Up Apollo 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 Apollo data data.
-
Create Wistia-Connected Nintex Workflows
Use CData Connect AI to connect to Wistia Data from Nintex Workflow Cloud and build custom workflows using live Wistia data.
-
Analyze Live Phoenix Data in SAS Viya
Use CData Connect AI to connect to Phoenix data from SAS Viya and deploy self-service analytics using live Phoenix data.
-
Connect to LaunchDarkly from a Connection Pool in WebLogic
Use the CData JDBC Driver for LaunchDarkly to connect to LaunchDarkly data from Web applications running on WebLogic.
-
Automated Continuous PabblySubscriptions Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to AlloyDB.
-
Create Data Visualizations in Cognos BI with Spark Data
Access Spark data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Opsgenie Data from MySQL in PHP
Connect to Opsgenie through the standard MySQL libraries in PHP.
-
Connect to LDAP Objects in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LDAP.
-
Back Up BambooHR 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 BambooHR data data.
-
How to create Nethunt federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Nethunt data in MySQL .
-
Getting Started with the CData JDBC Driver for MariaDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MariaDB.
-
How to Work with Splunk Data in ETL Validator JDBC
Connect to Splunk from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to ShipEngine Data from IntelliJ
Integrate connectivity to ShipEngine data with wizards in IntelliJ.
-
Automated Continuous Exact Online Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Exact Online replication to Azure SQL Database.
-
Integrate Shortcut Data in the Pentaho Report Designer
Publish reports based on Shortcut data in the Pentaho BI tool.
-
Build Apps with Live Aweber Data Using the Low-Code Development Platform of Mendix
Connect Aweber data with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Web
Connect to Azure Synapse data in MicroStrategy Web using the CData Software JDBC Driver for Azure Synapse.
-
How to Connect the Power BI Service to Redshift: Complete Guide
Connect to the CData Software Power BI Connector for Redshift from PowerBI.com to provide real-time Redshift data across the organization.
-
Build BigCommerce-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live BigCommerce data and build BigCommerce-connected web apps with Axios.
-
Build Automated Azure Synapse-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Synapse data and build automated workflows in Zapier.
-
Integrating Antigravity CLI with Discourse data via CData CLI
Connect Discourse data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind SuiteCRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SuiteCRM with the DevExpress Windows Forms and Web controls to provide SuiteCRM data to a chart.
-
How to work with Microsoft Teams Data in Apache Spark using SQL
Access and process Microsoft Teams Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating GitHub Copilot with Datadog 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.
-
Build Shopify-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 Shopify data without replication.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse data for you.
-
Visualize Live Zoho Recruit Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho Recruit data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect DBeaver to ZohoMarketingHub via a JDBC Driver
Manage ZohoMarketingHub data with visual tools in DBeaver like the query browser.
-
Automated Databricks Data Replication to Teradata
Use CData Sync to Customize and automate Databricks data replication to Teradata.
-
Replicate Multiple SAP Accounts
Replicate multiple SAP accounts to one or many databases.
-
Build Semantic Layer Views for Freshsales Data in APOS Live Data Gateway
Use the CData Connector for Freshsales in APOS Live Data Gateway to build Semantic Layer Views for Freshsales data.
-
Connect to Twilio from Asprova with CData Software ODBC Driver for Twilio
This article shows how to connect faster to Twilio data from Asprova.
-
Connect to SAP Ariba Procurement Data in ACL Analytics
Connect to SAP Ariba Procurement data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Ariba Procurement data.
-
Automated Continuous Workable Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Workable replication to Amazon Redshift.
-
How to Work with Jira Assets Data in AWS Glue Jobs Using JDBC
Connect to Jira Assets from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software JDBC Driver for AgileCRM in MicroStrategy Web
Connect to AgileCRM data in MicroStrategy Web using the CData Software JDBC Driver for AgileCRM.
-
Integrating GitHub Copilot with Zuora 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.
-
Query Live Bullhorn CRM 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 Bullhorn CRM data directly from the development environment.
-
Use Manus AI to Talk to Your SAP BusinessObjects BI 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 SAP BusinessObjects BI data.
-
Build Agents in Relevance AI with Access to Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ZohoPeople data within intelligent agent workflows.
-
Build Apps with Live Todoist Data Using the Low-Code Development Platform of Mendix
Connect Todoist data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Unbounce Data in Talend Cloud Data Management Platform
Connect Unbounce Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Microsoft Copilot Studio to talk to your Twilio 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 Twilio data for you.
-
Visualize Live Paddle Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Paddle data.
-
DataBind Controls to SparkPost Data in Delphi
DataBind to SparkPost data in Delphi with standard data access components and controls.
-
How to Build an ETL App for Greenplum Data in Python with CData Connect AI
Build ETL pipelines that read and write live Greenplum data in Python with petl and the CData Connect AI Python SDK.
-
Use ChatGPT to Talk to Your Xero 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 Xero data for you.
-
Bidirectional Access to BigCommerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate BigCommerce data in Filemaker Pro for Mac or Windows.
-
Integrating LlamaIndex with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on eBay data in real time.
-
Analyze Exa Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Exa data and visualize Exa data in SAP Analytics Cloud.
-
Getting Started with the CData ODBC Driver for Invoiced
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Invoiced.
-
Use the CData ODBC Driver for Printful from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Printful to connect to Printful data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Printful data in Excel.
-
Model, Search, and Visualize Live Egnyte Data in ThoughtSpot
Use CData Connect AI to connect to live Egnyte data for modeling, searching, and visualizing.
-
Replicate Multiple SAP HANA Accounts via the CData Sync CLI
Replicate multiple SAP HANA accounts to one or many databases.
-
Sage Intacct Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage Intacct data through CData Connect AI using different applications and tools.
-
How to Connect to Live Sage 200 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sage 200 data for you.
-
Connect to Pushbullet Data from a Connection Pool in Jetty
The Pushbullet JDBC Driver supports connection pooling: This article shows how to connect faster to Pushbullet data from Web apps in Jetty.
-
Operational Reporting on Insightly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Insightly data.
-
Connect to SAS xpt Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAS xpt Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Natively Connect to Active Directory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Active Directory data. Leverage the native support for ODBC in PHP.
-
Query Sage 200 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage 200 entities in PHP by modeling them as objects.
-
Automate Retently Data Replication to Couchbase
Use CData Sync to Customize and automate Retently data replication to Couchbase.
-
Create AlloyDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for AlloyDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Consume BigQuery OData Feeds in SAP Lumira
Use the API Server to create data visualizations on BigQuery feeds that reflect any changes in SAP Lumira.
-
Explore Geographical Relationships in HDFS Data with Power Map
Create data visualizations with HDFS data in Power Map.
-
Visualize Live Jira Assets Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Jira Assets data.
-
How to work with Contentful Data in Apache Spark using SQL
Access and process Contentful Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with DB2 Data
Access DB2 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Jodoo Data in CloverDX (formerly CloverETL)
Transfer Jodoo data using the visual workflow in the CloverDX data integration tool.
-
Automate Vimeo Data Replication to Azure Synapse
Use CData Sync to customize and automate Vimeo data replication to Azure Synapse.
-
Edit and Search External Microsoft Dataverse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Dataverse data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Dataverse Data objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for HubSpot Data using the CData ODBC Driver
Use the SQL Gateway and HubSpot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Redis Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Redis data from your Excel spreadsheets.
-
Create Adobe Analytics-Connected Business Apps in AppSheet
Connect to Adobe Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Adobe Analytics data.
-
Access Live ZohoPeople Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ZohoPeople data from your Excel spreadsheets.
-
Access Discourse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Discourse data.
-
Access Live Pinterest Data in Coginiti Pro
Connect to and query live Pinterest data from the GUI in the Coginiti Pro: SQL Analytics Tool.