CData Software - Knowledge Base
Recent Articles
-
Build Automated Workflows with Live WooCommerce Data in Workato
Use CData Connect AI to connect to live WooCommerce data and build automated workflows in Workato.
-
Connect to Xero Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Xero data.
-
Connect to LeadDesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LeadDesk and the SQL Gateway to access LeadDesk data from Google Apps Script.
-
Connect to Grafana Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Grafana and work with Grafana data in your FileMaker application.
-
Integrate Cloudflare Data in Pentaho Data Integration
Build ETL pipelines based on Cloudflare data in the Pentaho Data Integration tool.
-
Seamlessly Bring RSS Feeds into Retool Using CData Connect AI
Integrate RSS data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Kiro with SAP SuccessFactors LMS 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 MVC Applications with Connectivity to Zoho Books Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Books from an ASP.NET MVC application.
-
Connect to Google Sheets Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Sheets data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Sheets.
-
Import and Visualize Float Data in Power View
Create data visualizations based on Float data in Excel.
-
Object-Relational Mapping (ORM) with Salesforce Data 360 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 Salesforce Data 360 data into a Java-based ORM framework, Hibernate.
-
Build Dashboards with Avalara AvaTax Data in DBxtra
Create dynamic dashboards and perform analytics based on Avalara AvaTax data in DBxtra.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZarMoney
Provide connectivity to ZarMoney data through an SAP BusinessObjects universe.
-
Connect to Instantly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Instantly and work with Instantly data in your FileMaker application.
-
Connect to Front Data in RapidMiner
Integrate Front data with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time Browserless Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Browserless data in ColdFusion.
-
Replicate Multiple Datadog Accounts
Replicate multiple Datadog accounts to one or many databases.
-
Build MVC Applications with Connectivity to ShipEngine Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ShipEngine from an ASP.NET MVC application.
-
Automated Continuous Chargebee Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Chargebee replication to IBM DB2.
-
Create Power BI Reports on Real-Time Gmail Data
Use the CData ODBC Driver for Gmail to visualize Gmail data in Power BI Desktop.
-
Create Reports from HubDB Data in Looker Studio
Use CData Connect AI to gain access to live HubDB data and create custom reports in Looker Studio.
-
Integrate with SingleStore Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SingleStore data to a JSON file on disk.
-
Connect to and Visualize Live Jodoo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jodoo data.
-
Build Salesforce Pardot-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce Pardot Data from Zoho Analytics and import live Salesforce Pardot data.
-
How to Work with Paddle Data in AWS Glue Jobs Using JDBC
Connect to Paddle from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Presto Replication to SQL Server
Use CData Sync for automated, continuous, customizable Presto replication to SQL Server.
-
Build Semantic Layer Views for SharePoint Data in APOS Live Data Gateway
Use the CData Connector for SharePoint in APOS Live Data Gateway to build Semantic Layer Views for SharePoint data.
-
Use Biml to Build SSIS Tasks to Replicate ClickTime Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ClickTime data to SQL Server.
-
Moving Data from Access to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Access data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate SparkPost with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SparkPost with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SparkPost data.
-
Getting Started with the CData ODBC Driver for Sage 300
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sage 300.
-
Bannerbear Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Bannerbear data through CData Connect AI using different applications and tools.
-
Design BIRT Reports on Salesforce Data 360 Data
Provide current Salesforce Data 360 data to your embedded analytics.
-
Automated Certinia Data Replication to Teradata
Use CData Sync to Customize and automate Certinia data replication to Teradata.
-
Use the CData Software ODBC Driver for Timely in SAS for Real-Time Reporting and Analytics
Connect to real-time Timely data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Timely.
-
How to integrate ZohoInvoice with Apache Airflow
Access and process ZohoInvoice data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Pipeline CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Amazon Redshift.
-
Build Apps with Live Sugar CRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sugar CRM data into the Adalo platform and build custom mobile and web applications with real-time Sugar CRM data.
-
Access Live Coda 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 Coda data through MCP integration.
-
How to Connect to Live ZohoMarketingHub Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your ZohoMarketingHub data for you.
-
DataBind Controls to Azure DevOps Data in C++Builder
DataBind to Azure DevOps data in C++Builder with standard components and controls.
-
How to integrate Metabase with LinkedIn Data
Use CData Connect AI to connect to live LinkedIn data and create an interactive dashboard in Metabase from LinkedIn data.
-
Automated Continuous QuickBooks Online Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Apache Cassandra.
-
Build Semantic Layer Views for Scrapfly Data in APOS Live Data Gateway
Use the CData Connector for Scrapfly in APOS Live Data Gateway to build Semantic Layer Views for Scrapfly data.
-
Connect to Dotmailer Data in RapidMiner
Integrate Dotmailer data with standard components and data source configuration wizards in RapidMiner Studio.
-
Add Superchat Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Superchat with the Informatica Enterprise Data Catalog to classify and organize data.
-
Choosing the Best Method to Connect BigCommerce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use BigCommerce data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Migrating data from SendGrid to Snowflake using CData SSIS Components.
Easily push SendGrid data to Snowflake using the CData SSIS Tasks for SendGrid and Snowflake.
-
Use the CData Software JDBC Driver for Bitly in MicroStrategy Web
Connect to Bitly data in MicroStrategy Web using the CData Software JDBC Driver for Bitly.
-
Connect to HubDB Data from a Connection Pool in JBoss
Integrate HubDB data into Java servlets: Use the Management Console in JBoss to install the HubDB JDBC Driver.
-
Sage 200 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage 200 data through CData Connect AI using different applications and tools.
-
Analyze Humanity Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Humanity data with the CData JDBC Driver for Humanity.
-
Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft OneDrive data in real time.
-
Access GitHub Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GitHub data from your Oracle system.
-
Connect to Presto Data from HeidiSQL
Use CData Connect AI to connect to and query live Presto data from HeidiSQL.
-
Connect to Google Search Results in Claris FileMaker Pro
Use the CData ODBC Driver for Google Search in FileMaker Pro to connect to Google Search and work with Google Search results in your FileMaker applications.
-
Automated Continuous Redis Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Redis replication to PostgreSQL.
-
Build Charts with Postmark Data in Clear Analytics
Create dynamic charts and perform analytics based on Postmark data in Clear Analytics.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Web
Connect to MariaDB data in MicroStrategy Web using the CData Software JDBC Driver for MariaDB.
-
A PostgreSQL Interface for Google Campaign Manager 360 Data using the CData ODBC Driver
Use the SQL Gateway and Google Campaign Manager 360 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Redis Data in ColdFusion
Write standard ColdFusion data access code to connect to Redis data.
-
Create Informatica Mappings From/To a JDBC Data Source for Wrike
Create Wrike data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous eBay Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Vertica.
-
View Reports on Real-Time eBay Data in Power BI Report Server
Use the CData ODBC Driver for eBay to visualize eBay data in Power BI Desktop and then publish them to Power BI Report Server.
-
DataBind Controls to Omnisend Data in C++Builder
DataBind to Omnisend data in C++Builder with standard components and controls.
-
Connect to ZendeskSell Data in HULFT Integrate
Connect to ZendeskSell as a JDBC data source in HULFT Integrate
-
How to Connect SageHR 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 SageHR data in real time using natural language.
-
Enable the Facebook Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Facebook Ads data.
-
How to Connect Flowise AI Agents to Live Paymo 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 Paymo data without replication.
-
Automated Continuous Supabase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Supabase replication to Amazon Redshift.
-
Use JayDeBeApi to access PingOne Data in Python
Use standard Python scripting and the development environment of your choice to access live PingOne data.
-
Connecting Moonlit Workflow with Freshdesk 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 Freshdesk data in real time.
-
Connect to Guru Data in HULFT Integrate
Connect to Guru as a JDBC data source in HULFT Integrate
-
Publish Crystal Reports on Zoom Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoom data.
-
Natively Connect to BigCommerce Data in PHP
The CData ODBC driver for BigCommerce enables you to create PHP applications with connectivity to BigCommerce data. Leverage the native support for ODBC in PHP.
-
Pipeline CRM Reporting in OBIEE with the Pipeline CRM JDBC Driver
Deploy the Pipeline CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate MailerLite with Apache Airflow
Access and process MailerLite data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Slack 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 Slack data through natural language.
-
Automated Continuous Raisers Edge NXT Replication to Snowflake
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Snowflake.
-
Access Live Auth0 Data in Coginiti Pro
Connect to and query live Auth0 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connecting Mastra with Redshift Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Redshift data, no replication required.
-
How to create an RPA flow for SAP Fieldglass Data in UiPath Studio
Use the SAP Fieldglass ODBC Driver to create workflows that access real-time SAP Fieldglass data without any coding.
-
How to connect to Workday Data with Squirrel SQL client
Connect to Workday data and execute queries in the Squirrel SQL Client.
-
Connect to OData Services in Google Apps Script via SQL Gateway
Use the ODBC Driver for OData and the SQL Gateway to access OData services from Google Apps Script.
-
Publish Adobe Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Analytics data.
-
Connect to Real-Time Mocean Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mocean data in Power Apps.
-
How to Connect to Live Bright Data 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 Bright Data data for you.
-
Easily Integrate Sage 300 Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage 300 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Sage Intacct Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage Intacct replication to IBM DB2.
-
Automate ConvertKit Data Replication to Azure Data Lake
Use CData Sync to customize and automate ConvertKit data replication to Azure Data Lake.
-
Connect to Google Calendar Data from a Connection Pool in Jetty
The Google Calendar JDBC Driver supports connection pooling: This article shows how to connect faster to Google Calendar data from Web apps in Jetty.
-
Using the CData Software ODBC Driver for Impala in PyCharm
Connect to Impala as an ODBC data source in PyCharm using the CData Software ODBC Driver for Impala.
-
How to load Twilio data into Elasticsearch via Logstash
Introducing a simple method to load Twilio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Rapidly Develop SAP SuccessFactors-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SAP SuccessFactors.
-
How to work with MYOB AccountRight Data in Apache Spark using SQL
Access and process MYOB AccountRight Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Campaigner Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Campaigner data securely in real time.
-
Query FHIR Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume FHIR entities in PHP by modeling them as objects.
-
Integrate Redis Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Redis data and integrate live Redis data into your Power Automate tasks.
-
How to connect to Zoho Inventory Data from IntelliJ
Integrate connectivity to Zoho Inventory data with wizards in IntelliJ.
-
How to Connect to Live Cassandra 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 Cassandra data without replication.