CData Software - Knowledge Base
Recent Articles
-
Integrate with SAP SuccessFactors Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors to a JSON file on disk.
-
How to Query SAP ByDesign Data in MySQL Workbench
Execute MySQL queries against live SAP Business ByDesign from MySQL Workbench.
-
Build Semantic Layer Views for LaunchDarkly Data in APOS Live Data Gateway
Use the CData Connector for LaunchDarkly in APOS Live Data Gateway to build Semantic Layer Views for LaunchDarkly.
-
Integrate Real-Time Access to Snowflake in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Snowflake in real time.
-
Consume Excel OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Excel as OData feeds from PowerBuilder using the API Server.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Inventory Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Inventory.
-
How to Work with MySQL Data in ETL Validator JDBC
Connect to MySQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Stripe Data in APOS Live Data Gateway
Use the CData Connector for Stripe in APOS Live Data Gateway to build Semantic Layer Views for Stripe.
-
Create HubDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HubDB data access from reports, embedded analytics, and more.
-
Use Agno to Talk to Your OData Services 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 OData for you.
-
Extract, Transform, and Load MYOB AccountRight Data in Informatica PowerCenter
Create a simple Workflow for MYOB AccountRight in Informatica PowerCenter.
-
Build Airtable Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Airtable and build visualizations in Tableau Cloud.
-
Build Oracle Service Cloud-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Service Cloud and build Oracle Service Cloud-connected web apps with Axios.
-
How to publish and share RSS Feeds dashboards with Tableau Server
The CData ODBC driver for RSS enables you integrate RSS Feeds into Tableau dashboards.
-
DataBind Databricks Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Databricks with the DevExpress Windows Forms and Web controls to provide Databricks to a chart.
-
View Reports on Real-Time Strava Data in Power BI Report Server
Use the CData ODBC Driver for Strava to visualize Strava in Power BI Desktop and then publish them to Power BI Report Server.
-
Import Microsoft Ads Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Ads. In this article, you will use the OData format to import Microsoft Ads into Microsoft Power Query.
-
Integrate OData with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OData with External Services.
-
Automated Continuous Xero Replication to Snowflake
Use CData Sync for automated, continuous, customizable Xero replication to Snowflake.
-
Build Automated Workflows with Live Redis Data in Workato
Use CData Connect AI to connect to live Redis and build automated workflows in Workato.
-
Create Apps from Google Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Ads Data and build apps from live Google Ads in Qlik Sense Cloud.
-
Migrating data from Instagram to Databricks using CData SSIS Components.
Easily push Instagram to Databricks using the CData SSIS Tasks for Instagram and Databricks.
-
How to Connect DBeaver to LinkedIn Ads via a JDBC Driver
Manage LinkedIn Ads with visual tools in DBeaver like the query browser.
-
Analyze Chargebee Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Chargebee in Microsoft R Open.
-
Connect to SAP Hybris C4C Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Hybris C4C in Google Apps Script.
-
Configure the CData JDBC Driver for Splunk in a Connection Pool in Tomcat
Connect to Splunk from a connection pool in Tomcat.
-
ETL SAP SuccessFactors in Oracle Data Integrator
This article shows how to transfer SAP SuccessFactors into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live WooCommerce 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 WooCommerce through natural language.
-
Query MYOB AccountRight Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MYOB AccountRight entities in PHP by modeling them as objects.
-
How to Visualize Slack Data in Python with pandas
Use pandas and other modules to analyze and visualize live Slack in Python.
-
How to Connect to Live SAP Business One Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business One securely in real time.
-
Automated Continuous Front Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Front replication to AlloyDB.
-
Query ShipEngine Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ShipEngine from Node.js.
-
Build a Simple VCL Application for Amazon Athena Data
How to build a simple VCL Application to view Amazon Athena in RAD Studio using the CData ODBC Driver for Amazon Athena.
-
Integrate Postmark Data in Pentaho Data Integration
Build ETL pipelines based on Postmark in the Pentaho Data Integration tool.
-
Build Semantic Layer Views for Vault CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Veeva Vault & Vault CRM.
-
Visualize Instagram Data in TIBCO Spotfire through OData
Integrate Instagram into dashboards in TIBCO Spotfire.
-
A PostgreSQL Interface for Pinterest Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pinterest JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Workable Data from IntelliJ
Integrate connectivity to Workable with wizards in IntelliJ.
-
Connect to Redis Data from a Connection Pool in Jetty
The Redis JDBC Driver supports connection pooling: This article shows how to connect faster to Redis from Web apps in Jetty.
-
Automated Continuous Smartsheet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to Google Cloud SQL.
-
Connect and Query Live Authorize.Net Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Authorize.Net into Databricks
-
How to connect to Sugar CRM Data with Squirrel SQL client
Connect to Sugar CRM and execute queries in the Squirrel SQL Client.
-
Build a Simple VCL Application for Pingdom Data
How to build a simple VCL Application to view Pingdom in RAD Studio using the CData ODBC Driver for Pingdom.
-
Automate Reckon Accounts Hosted Data Replication to Couchbase
Use CData Sync to Customize and automate Reckon Accounts Hosted replication to Couchbase.
-
How to connect to IBM Informix Data in DBVisualizer
Integrate IBM Informix with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to and Query Klipfolio Data in QlikView over ODBC
Create data visualizations with Klipfolio in QlikView.
-
Query SAP Fieldglass Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Fieldglass from Node.js.
-
Work with Live Amazon Athena Data in Power Query
Use CData Connect AI to connect to Amazon Athena and work with live Amazon Athena in Microsoft Power Query.
-
Automate Phoenix Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache Phoenix replication to Azure Synapse.
-
Automated Continuous Jira Replication to SQLite
Use CData Sync for automated, continuous, customizable Jira replication to SQLite.
-
Visualize Bitbucket 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 Bitbucket into TIBCO Spotfire.
-
Connect and Query Live Cloudant Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live IBM Cloudant into Databricks
-
Access Flowlu Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Flowlu from your Oracle system.
-
How to Visualize PivotalTracker Data in Python with pandas
Use pandas and other modules to analyze and visualize live PivotalTracker in Python.
-
Replicate Multiple Outreach.io Accounts
Replicate multiple Outreach.io accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Webex
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Webex.
-
ETL Azure Synapse in Oracle Data Integrator
This article shows how to transfer Azure Synapse into a data warehouse using Oracle Data Integrator.
-
Build MVC Applications with Connectivity to Greenplum Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Greenplum from an ASP.NET MVC application.
-
Extend Google Sheets with Smartsheet Data
Make calls to Smartsheet from Google Apps Script via the API Server.
-
Build Automated BigQuery-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google BigQuery and build automated workflows in Zapier.
-
Access Live Lakebase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Lakebase from your Google Sheets.
-
Automated Continuous SageHR Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SageHR replication to OneLake in Microsoft Fabric.
-
Create SSAS Tabular Models from Quaderno Data
How to build a SQL Server Analysis Service Tabular Model from Quaderno using CData drivers.
-
Write a Simple Go Application to work with Outlook Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Outlook.
-
How to Connect DBeaver to xBase via a JDBC Driver
Manage xBase with visual tools in DBeaver like the query browser.
-
Build Apps with Live Veeva Vault & Vault CRM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Veeva Vault & Vault CRM into the Adalo platform and build custom mobile and web applications with real-time Veeva Vault & Vault CRM.
-
Import Real-Time Nethunt Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Nethunt in ColdFusion.
-
Automated Continuous SAP HANA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP HANA replication to Google BigQuery.
-
How to Query Live Helpscout Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Helpscout data in natural language using Python.
-
Integrate MongoDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MongoDB from Informatica Cloud.
-
Bidirectional Access to Wistia Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Wistia in Filemaker Pro for Mac or Windows.
-
Integrating TaxJar Data in Talend Cloud Data Management Platform
Connect TaxJar Data with Talend Cloud Data Management Platform using the CData JDBC Driver for TaxJar.
-
Getting Started with the CData ODBC Driver for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for IBM Cloud Object Storage.
-
Back Up Cohere 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 Cohere data.
-
Build Oracle Service Cloud-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Service Cloud Data and create custom apps in Mendix.
-
Manage DocuSign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for DocuSign.
-
Integrate with Avro Data in JReport Designer
Create charts and reports based on Apache Avro in JReport Designer.
-
Write a Simple Go Application to work with Mode Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mode.
-
Connect to CloudConvert Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CloudConvert.
-
Create Datasets from Twitter Ads in Domo Workbench and Build Visualizations of Twitter Ads Data in Domo
Use the CData Software ODBC Driver for Twitter Ads to create datasets from Twitter Ads in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous LightSpeedRetail Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Apache Cassandra.
-
Integrating Claude Code CLI with Supabase 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.
-
How to Access Okta Data Using Entity Framework
This article shows how to access Okta using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Create SQL Pass-Through Queries in MS Access Using CData
Learn how to create SQL pass-through queries in MS Access using CData to optimize database performance and execute SQL directly on external data sources.
-
Access Live FTP Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FTP Servers from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous TaxJar Replication to Vertica
Use CData Sync for automated, continuous, customizable TaxJar replication to Vertica.
-
Connect to Microsoft Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Ads.
-
Migrating data from QuickBooks Time to Snowflake using CData SSIS Components.
Easily push QuickBooks Time to Snowflake using the CData SSIS Tasks for QuickBooks Time and Snowflake.
-
Connect to SendPulse Data in Jaspersoft Studio
Execute SQL to remote SendPulse in Jaspersoft Studio.
-
Connecting GenSpark with SQL Server Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft SQL Server without any replication or custom integration required.
-
Import Real-Time Opsgenie Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Opsgenie in ColdFusion.
-
Connect to Google Calendar Data in ACL Analytics
Connect to Google Calendar via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Calendar.
-
Publish Reports with Drip Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drip.
-
Migrating data from Contentful to Snowflake using CData SSIS Components.
Easily push Contentful to Snowflake using the CData SSIS Tasks for Contentful and Snowflake.
-
Analyze OpenWeatherMap Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze OpenWeatherMap in Microsoft R Open.
-
Object-Relational Mapping (ORM) with Toggl 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 Toggl into a Java-based ORM framework, Hibernate.
-
How to connect Amazon QuickSight to IBM Informix Data
Create a connection to IBM Informix in CData Connect AI and insert IBM Informix into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Calendly Data from PowerShell
Write a quick PowerShell script to query Calendly. Use connectivity to the live data to replicate Calendly to SQL Server.
-
How to create an RPA flow for Bright Data Data in UiPath Studio
Use the Bright Data ODBC Driver to create workflows that access real-time Bright Data without any coding.