CData Software - Knowledge Base
Recent Articles
-
Create SAP HANA-Connected Business Apps in AppSheet
Connect to SAP HANA Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP HANA data.
-
Connect to Odoo Data in RazorSQL
Connect to Odoo from wizards and query Odoo data from the GUI in the RazorSQL database management tool.
-
Automated Continuous SAP Hybris C4C Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Azure SQL Database.
-
Automated Continuous API Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable API replication to Azure SQL Database.
-
Automated Continuous MailChimp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MailChimp replication to Amazon Redshift.
-
Add Microsoft Teams Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Teams with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Semantic Layer Views for Amazon Athena Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon Athena data.
-
A PostgreSQL Interface for SAP Hybris C4C Data using the CData ODBC Driver
Use the SQL Gateway and SAP Hybris C4C ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Oracle HCM Cloud Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Oracle.
-
Build SAP Ariba Source-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Ariba Source data.
-
Automated Splunk Data Replication to Teradata
Use CData Sync to Customize and automate Splunk data replication to Teradata.
-
Getting Started with the CData Tableau Connector for Parallel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for Discord
Create an ODBC connection to Discord in Informatica and browse and transfer Discord data.
-
Integrating Boomi Agentstudio with Marketo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Marketo data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Pipelines with Live Oracle HCM Cloud Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle HCM Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle HCM Cloud data into the building and management of effective data pipelines.
-
Connect to GitHub Data from PowerBuilder via ADO.NET
This article demonstrates how to access GitHub data from Appeon PowerBuilder using the CData ADO.NET Provider for GitHub.
-
Create Reports with Spark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Spark data.
-
Integrate OpenCode with Live SharePoint Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SharePoint data from within your AI coding agent.
-
Getting Started with the CData SSIS Components for Active Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Active Directory.
-
Getting Started with the CData Python Connector for Avalara AvaTax
Learn to install and license the CData Python Connector and configure a connection to live Avalara AvaTax data.
-
How to Connect Sage 300 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sage 300 data in real time using natural language.
-
How to Work with Pipedrive Data in AWS Glue Jobs Using JDBC
Connect to Pipedrive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate Snapchat Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Snapchat Ads data replication to SAP HANA.
-
Create Avro-Connected Applications in Appsmith
Connect to Avro Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Avro data.
-
Connect to Microsoft Entra ID Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Entra ID data from HeidiSQL.
-
Connect to Square Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Square to connect to Square data and execute queries in PowerBuilder.
-
How to Work with Spotify Data in ETL Validator JDBC
Connect to Spotify from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Teamgate Data Replication to Azure Synapse
Use CData Sync to customize and automate Teamgate data replication to Azure Synapse.
-
Import Real-Time Aha! Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aha! data in ColdFusion.
-
Access Oracle HCM Cloud 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 Oracle HCM Cloud data.
-
Oracle Financials Cloud Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Financials Cloud data through CData Connect AI using different applications and tools.
-
Build Klaviyo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Klaviyo data and build web apps with connectivity to live Klaviyo data.
-
Access Aircall Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aircall data from HeidiSQL.
-
Access Live RSS Feeds in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to RSS feeds from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Apps with Live Vercel Data Using the Low-Code Development Platform of Mendix
Connect Vercel data with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Controls to Mixpanel Data in Delphi
DataBind to Mixpanel data in Delphi with standard data access components and controls.
-
Access Live Phoenix Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Phoenix data into the statistical analysis tools available in SAS JMP. This article shows how to use Phoenix data in the Graph Builder and Query Builder.
-
Connect to SharePoint Data from PowerBuilder via ADO.NET
This article demonstrates how to access SharePoint data from Appeon PowerBuilder using the CData ADO.NET Provider for SharePoint.
-
Use the CData Software ODBC Driver for RSS in MicroStrategy
Connect to RSS feeds in MicroStrategy Developer using the CData Software ODBC Driver for RSS.
-
Build Dashboards with EmailOctopus Data in DBxtra
Create dynamic dashboards and perform analytics based on EmailOctopus data in DBxtra.
-
Automated Continuous PabblySubscriptions Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Amazon Redshift.
-
Create ConstantContact Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ConstantContact from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Cloudflare Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Cloudflare data and build visualizations in Tableau Cloud.
-
Automated Continuous Typeform Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Typeform replication to Azure SQL Database.
-
How to connect and process Lakebase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Lakebase data.
-
Getting Started with the CData Excel Add-In for Exa
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Exa.
-
How to create an RPA flow for Spark Data in UiPath Studio
Use the Spark ODBC Driver to create workflows that access real-time Spark data without any coding.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BigQuery
Provide connectivity to BigQuery data through an SAP BusinessObjects universe.
-
Query Live Exact Online 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 Exact Online data directly from the development environment.
-
How to Connect to & Open SparkPost Data in Microsoft Excel
This article uses the CData ODBC driver for SparkPost to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Goose with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live JSON services from within the local AI agent.
-
How to import Azure Synapse Data into Apache Solr
Use the CData Software JDBC Driver for Azure Synapse in Data Import Handler and create an automated import of Azure Synapse data to Apache Solr Enterprise Search platform.
-
Load Insightly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Insightly data to a database.
-
Establish a Live Connection with Sage Intacct Data using Tableau Bridge
The CData ODBC Driver for Sage Intacct enables you to integrate live Sage Intacct data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Grafana from Asprova with CData Software ODBC Driver for Grafana
This article shows how to connect faster to Grafana data from Asprova.
-
Integrate Goose with Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoInvoice data from within the local AI agent.
-
Analyze Pipedrive Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Pipedrive data and visualize Pipedrive data in SAP Analytics Cloud.
-
Use Claude to Talk to Your Figshare 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 Figshare data for you.
-
How to Work with Discord Data in ETL Validator JDBC
Connect to Discord from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Blackbaud FE NXT-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Blackbaud FE NXT data and build web apps with connectivity to live Blackbaud FE NXT data.
-
Integrate Open WebUI with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Eloqua data from within the chat interface.
-
Getting Started with the CData Excel Add-In for Superchat
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Superchat.
-
Create Odoo-Connected Business Apps in AppSheet
Connect to Odoo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Odoo data.
-
How to connect to PayPal Data from IntelliJ
Integrate connectivity to PayPal data with wizards in IntelliJ.
-
Build Charts with Adobe Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Analytics data in Clear Analytics.
-
Create Samanage-Connected Dashboards in Grafana
Connect to Samanage Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Samanage data.
-
Use Agno to Talk to Your Square 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 Square data for you.
-
Visualize Nuclia Data in Sisense
Create an ElastiCube in Sisense app with access to Nuclia data.
-
DataBind Controls to Outreach.io Data in Delphi
DataBind to Outreach.io data in Delphi with standard data access components and controls.
-
Connect to Zoho CRM Data from a Connection Pool in Jetty
The Zoho CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho CRM data from Web apps in Jetty.
-
Access Nethunt Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Nethunt data from HeidiSQL.
-
Access Live Dynamics 365 Business Central Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Dynamics 365 Business Central data from your Excel spreadsheets.
-
Connect to Timely from Asprova with CData Software ODBC Driver for Timely
This article shows how to connect faster to Timely data from Asprova.
-
Automated Continuous Snapchat Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Amazon S3.
-
Build Dashboards with SAP HANA Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP HANA data in DBxtra.
-
Build Semantic Layer Views for Salesforce Pardot Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce Pardot data.
-
How to Connect to Live Phoenix 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 Phoenix data for you.
-
Trigger SAS Data Sets IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAS Data Sets with standard wizards in Logic Apps.
-
Getting Started with the CData JDBC Driver for Excel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Excel.
-
Build Dashboards with Sybase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sybase data in Dundas BI.
-
Query Dynamics 365 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Dynamics 365 data from Node.js.
-
Object-Relational Mapping (ORM) with SparkPost Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SparkPost data into a Java-based ORM framework, Hibernate.
-
Analyze Dynamics NAV Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dynamics NAV data in Microsoft R Open.
-
How to load SQL Analysis Services data into Elasticsearch via Logstash
Introducing a simple method to load SQL Analysis Services data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Deploy the ADO.NET Provider for MarkLogic on an SSRS Report Server
Connect to MarkLogic 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.
-
How to connect to Jira Data from IntelliJ
Integrate connectivity to Jira data with wizards in IntelliJ.
-
Connect to Slack Data in NetBeans
Connect to Slack data in NetBeans with the data source configuration wizard.
-
Integrate Devin with Live SQL Analysis Services 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 SQL Analysis Services data.
-
A PostgreSQL Interface for Ontraport Data using the CData ODBC Driver
Use the SQL Gateway and Ontraport ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate SurveyMonkey Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SurveyMonkey data from Informatica Cloud.
-
Connect to DB2 from a Connection Pool in WebLogic
Use the CData JDBC Driver for DB2 to connect to DB2 data from Web applications running on WebLogic.
-
Enable the SAP ByDesign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP ByDesign data.
-
How to integrate Avro with Apache Airflow
Access and process Avro data in Apache Airflow using the CData JDBC Driver.
-
Integrating Dataiku with Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho CRM data.
-
Using the CData Software ODBC Driver for Spark in PyCharm
Connect to Spark as an ODBC data source in PyCharm using the CData Software ODBC Driver for Spark.
-
How to integrate Metabase with Acumatica Data
Use CData Connect AI to connect to live Acumatica data and create an interactive dashboard in Metabase from Acumatica data.
-
Connect to Pingdom Data in Aqua Data Studio
Access Pingdom data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Cvent Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cvent replication to Amazon S3.
-
Migrating data from Gorgias to Google BigQuery using CData SSIS Components.
Easily push Gorgias data to Google BigQuery using the CData SSIS Tasks for Gorgias and Google BigQuery.
-
Connect to OpenWeatherMap Data in DBeaver
Use the CData ODBC Driver to connect to OpenWeatherMap data in DBeaver.