CData Software - Knowledge Base
Recent Articles
-
Access Parquet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Parquet data from your Oracle system.
-
Connect to Bannerbear Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bannerbear to connect to Bannerbear data and execute queries in PowerBuilder.
-
Automated Continuous Dynamics 365 Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Databricks.
-
Provide OData Services of Jumpseller Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Jumpseller data by developing a WCF Service Application.
-
Integrate Dify with Live Dynamics 365 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 Dynamics 365 data.
-
Visualize Authorize.Net Data in Tableau
The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net data into Tableau dashboards.
-
How to Connect to Live Odoo 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 Odoo data for you.
-
Automated Continuous ChartMogul Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ChartMogul replication to Amazon Redshift.
-
Create Datasets from Google Cloud Storage in Domo Workbench and Build Visualizations of Google Cloud Storage Data in Domo
Use the CData Software ODBC Driver for Google Cloud Storage to create datasets from Google Cloud Storage data in Domo Workbench and then build visualizations in the Domo service.
-
Import SAP ByDesign Data Using Azure Data Factory
Use CData Connect AI to connect to SAP ByDesign Data from Azure Data Factory and import live SAP ByDesign data.
-
DataBind Controls to SAP ByDesign Data in Delphi
DataBind to SAP ByDesign data in Delphi with standard data access components and controls.
-
Visualize SurveyMonkey Data in Sisense
Create an ElastiCube in Sisense app with access to SurveyMonkey data.
-
Access Live NetSuite Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live NetSuite data through MCP integration.
-
Extract, Transform, and Load Google Contacts Data in Informatica PowerCenter
Create a simple Workflow for Google Contacts data in Informatica PowerCenter.
-
Build Data Flows from SQL Server to Sybase through SSIS
Easily push SQL Server data to Sybase using the CData SSIS Tasks for Sybase.
-
Build API-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to API Data from Zoho Analytics and import live API data.
-
Connect to Live Shippo Data in MicroStrategy through CData Connect AI
Create a live connection to Shippo Data in CData Connect AI and connect to your Shippo data from MicroStrategy.
-
Integrate ScrapingBee with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ScrapingBee with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ScrapingBee data.
-
ETL Teamgate in Oracle Data Integrator
This article shows how to transfer Teamgate data into a data warehouse using Oracle Data Integrator.
-
How to Connect to & Open Oracle HCM Cloud Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle HCM Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for AgileCRM
Provide connectivity to AgileCRM data through an SAP BusinessObjects universe.
-
Integrating Boomi Agentstudio with CouchDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to CouchDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Planio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Planio replication to SQL Server.
-
Build Moosend-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Moosend data.
-
Automated Continuous Contentful Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Contentful replication to AlloyDB.
-
Replicate Multiple Recurly Accounts via the CData Sync CLI
Replicate multiple Recurly accounts to one or many databases.
-
Design BIRT Reports on Yelp Data
Provide current Yelp data to your embedded analytics.
-
Migrating data from ADP to Databricks using CData SSIS Components.
Easily push ADP data to Databricks using the CData SSIS Tasks for ADP and Databricks.
-
Automated Continuous Vault CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Vault CRM replication to AlloyDB.
-
Automated Continuous MongoDB Replication to MySQL
Use CData Sync for automated, continuous, customizable MongoDB replication to MySQL.
-
Connect to Reckon Accounts Hosted 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 Reckon Accounts Hosted data.
-
Use the CData Software ODBC Driver for ElevenLabs in SAS for Real-Time Reporting and Analytics
Connect to real-time ElevenLabs data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ElevenLabs.
-
Automated Continuous Deel Replication to MySQL
Use CData Sync for automated, continuous, customizable Deel replication to MySQL.
-
Connect to SAP Business One Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Business One data from HeidiSQL.
-
Migrating data from ZohoExpense to Databricks using CData SSIS Components.
Easily push ZohoExpense data to Databricks using the CData SSIS Tasks for ZohoExpense and Databricks.
-
Integrating OpenCode with GetResponse 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.
-
Automate Salesforce Marketing Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce Marketing data from PowerShell? This article demonstrates how to utilize the Salesforce Marketing Cmdlets for tasks like connecting to Salesforce Marketing data, automating operations, downloading data, and more.
-
Connecting Agentforce with Optimizely Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Optimizely data for you.
-
Connect to XML Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for XML to connect to XML data and execute queries in PowerBuilder.
-
Use the CData ODBC Driver for Opsgenie in Microsoft Power Query
You can use the CData Opsgenie ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Opsgenie data into Microsoft Power Query.
-
Connect to Optimizely Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Optimizely.
-
Integrating Codat Data in Talend Cloud Data Management Platform
Connect Codat Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous SharePoint Excel Services Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SharePoint Excel Services data replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for Google Contacts in MicroStrategy
Connect to Google Contacts data in MicroStrategy Developer using the CData Software JDBC Driver for Google Contacts.
-
Create Bullhorn CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bullhorn CRM Data from Klipfolio and build custom visualizations using live Bullhorn CRM 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.
-
How to connect to Recurly Data in DBVisualizer
Integrate Recurly data with visual data analysis tools and data connection wizards in DBVisualizer
-
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.
-
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.
-
Integrate with Google Contacts Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Contacts data to a JSON file on disk.
-
Integrate LDAP Objects in Pentaho Data Integration
Build ETL pipelines based on LDAP objects in the Pentaho Data Integration tool.
-
Connect to Browserless Data in HULFT Integrate
Connect to Browserless as a JDBC data source in HULFT Integrate
-
Excel Spreadsheet Automation on ZohoInvoice Data with the QUERY Formula
Pull data from ZohoInvoice, automate spreadsheets, and more with the QUERY formula.
-
Connect to MailChimp Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MailChimp and the Script function in FileMaker Pro to connect to MailChimp and work with MailChimp data in your FileMaker application.
-
Replicate Sentry Data from PowerShell
Write a quick PowerShell script to query Sentry data. Use connectivity to the live data to replicate Sentry data to SQL Server.
-
Use the CData ODBC Driver for PostgreSQL from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PostgreSQL to connect to PostgreSQL data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PostgreSQL data in Excel.
-
Integrating OpenCode with Salesloft 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.
-
Access Spark Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Spark data from HeidiSQL.
-
How to Build an ETL App for Codat Data in Python with CData
Create ETL applications and real-time data pipelines for Codat data in Python with petl.
-
How to Connect to Live SAP HANA Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP HANA data through natural language.
-
Trigger BigQuery IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for BigQuery with standard wizards in Logic Apps.
-
Create Reports with Cloudflare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cloudflare data.
-
Automated Continuous RSS Replication to Snowflake
Use CData Sync for automated, continuous, customizable RSS replication to Snowflake.
-
Create GitHub-Connected Applications in Appsmith
Connect to GitHub Data via CData Connect AI in Appsmith and create custom business applications with real-time access to GitHub data.
-
Build Dashboards with ConvertKit Data in DBxtra
Create dynamic dashboards and perform analytics based on ConvertKit data in DBxtra.
-
Connecting Pipedream with Microsoft Dataverse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Microsoft Dataverse data in real time.
-
How to Build an ETL App for Aweber Data in Python with CData
Create ETL applications and real-time data pipelines for Aweber data in Python with petl.
-
Build YouTube Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live YouTube Analytics data and build YouTube Analytics-connected web apps with Axios.
-
Use JayDeBeApi to access Samanage Data in Python
Use standard Python scripting and the development environment of your choice to access live Samanage data.
-
Using the CData Software ODBC Driver for MySQL in PyCharm
Connect to MySQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for MySQL.
-
Automated Continuous Yelp Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Yelp replication to Google Cloud SQL.
-
Integrate with Egnyte Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Egnyte data in SnapLogic.
-
How to Query Close Data in MySQL Workbench
Execute MySQL queries against live Close data from MySQL Workbench.
-
Building Dynamic Web Pages with Email Data Using AngularJS
Create single-page applications with live connectivity to Email using the CData API Server.
-
Create Google Sheets Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Sheets data access from reports, embedded analytics, and more.
-
Enable the WooCommerce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with WooCommerce data.
-
Connect to CSV Data in HULFT Integrate
Connect to CSV as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for Azure Synapse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Synapse data in Excel.
-
Create Reports from SAP BusinessObjects BI Data in Looker Studio
Use CData Connect AI to gain access to live SAP BusinessObjects BI data and create custom reports in Looker Studio.
-
Automated Continuous Nuclia Replication to Oracle
Use CData Sync for automated, continuous, customizable Nuclia replication to Oracle.
-
Integrate with Coda Data in JReport Designer
Create charts and reports based on Coda data in JReport Designer.
-
Use the CData Software JDBC Driver for Box in MicroStrategy Desktop
Connect to Box data in MicroStrategy Desktop using the CData Software JDBC Driver for Box.
-
Connect to Quickbase Data in DBeaver
Use the CData ODBC Driver to connect to Quickbase data in DBeaver.
-
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 SSIS Components for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Epicor Kinetic.
-
How to Connect DBeaver to FormSite via a JDBC Driver
Manage FormSite data with visual tools in DBeaver like the query browser.
-
Search External SAP Ariba Procurement Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Ariba Procurement data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Ariba Procurement Data objects that you can access from apps and the dashboard.
-
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.
-
Connect to Real-Time Twitter Ads Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Twitter Ads and Dataflow to import and use Twitter Ads data in Power Apps.
-
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.
-
Connect to Real-Time Freshteam Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshteam data in Power Apps.
-
LINQ to ServiceDesk Plus 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 ServiceDesk Plus Data Provider.
-
Access Live Oracle Eloqua Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Eloqua data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect AgileCRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live AgileCRM data using the CData Python MCP Server.
-
Getting Started with the CData JDBC Driver for Brex
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Brex.
-
Import SendGrid Data Using Azure Data Factory
Use CData Connect AI to connect to SendGrid Data from Azure Data Factory and import live SendGrid data.
-
Automated Continuous Flowlu Replication to Databricks
Use CData Sync for automated, continuous, customizable Flowlu replication to Databricks.
-
DataBind Dynamics 365 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dynamics 365 with the DevExpress Windows Forms and Web controls to provide Dynamics 365 data to a chart.
-
DataBind Controls to Mailgun Data in C++Builder
DataBind to Mailgun data in C++Builder with standard components and controls.