CData Software - Knowledge Base
Recent Articles
-
Load Webex Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Webex to a database.
-
Connect to ZohoDesk from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoDesk to connect to ZohoDesk from Web applications running on WebLogic.
-
Integrating Gumloop with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on NetSuite SuiteAnalytics within automated workflows.
-
Visualize Live Float Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Float using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Elasticsearch Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Elasticsearch. In this article, you will use the OData format to import Elasticsearch into Microsoft Power Query.
-
How to load Webex data into Elasticsearch via Logstash
Introducing a simple method to load Webex data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Sendwithus in MicroStrategy Desktop
Connect to Sendwithus in MicroStrategy Desktop using the CData Software ODBC Driver for Sendwithus.
-
How to Connect to Live Google Sheets 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 Google Sheets through natural language.
-
How to Easily Query Aweber Data in OpenOffice Base
Connect to Aweber data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Salesforce CRM Analytics-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Salesforce CRM Analytics to explore live Salesforce CRM Analytics Data in GitHub Copilot to assist with building Salesforce CRM Analytics-powered applications.
-
Create a Data Access Object for Keap Data using JDBI
A brief overview of creating a SQL Object API for Keap in JDBI.
-
Connect to Browserless Data from a Connection Pool in Jetty
The Browserless JDBC Driver supports connection pooling: This article shows how to connect faster to Browserless from Web apps in Jetty.
-
Viewing BigQuery Data in RAD Studio Data Explorer
How to view Google BigQuery in RAD Studio Data Explorer using the CData ODBC Driver for BigQuery.
-
Viewing ZohoPeople Data in RAD Studio Data Explorer
How to view ZohoPeople in RAD Studio Data Explorer using the CData ODBC Driver for ZohoPeople.
-
Visualize WooCommerce Data in TIBCO Spotfire through OData
Integrate WooCommerce into dashboards in TIBCO Spotfire.
-
Moving Data from eBay to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live eBay data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Amazon DynamoDB Data using the CData ODBC Driver
Use the SQL Gateway and Amazon DynamoDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Amazon DynamoDB Data into IBM SPSS Modeler
Integrate Amazon DynamoDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query Mailjet Data in QlikView over ODBC
Create data visualizations with Mailjet in QlikView.
-
Integrate with Freshservice Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Freshservice in SnapLogic.
-
Build Zoho Projects-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zoho Projects to explore live Zoho Projects Data in GitHub Copilot to assist with building Zoho Projects-powered applications.
-
Build MVC Applications with Connectivity to Pipedrive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipedrive from an ASP.NET MVC application.
-
Query Vault CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Vault CRM entities in PHP by modeling them as objects.
-
Automated Continuous ShipStation Replication to SQLite
Use CData Sync for automated, continuous, customizable ShipStation replication to SQLite.
-
Import and Visualize Flowlu Data in Power View
Create data visualizations based on Flowlu in Excel.
-
Integrate with Strava Data in JReport Designer
Create charts and reports based on Strava in JReport Designer.
-
Use the CData ODBC Driver for SAP SuccessFactors in Microsoft Power Query
You can use the CData SAP SuccessFactors ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP SuccessFactors into Microsoft Power Query.
-
Import Real-Time Highrise Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Highrise CRM in ColdFusion.
-
Getting Started with the CData Excel Add-In for Google Drive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Drive.
-
Connect to Facebook from Asprova with CData Software ODBC Driver for Facebook
This article shows how to connect faster to Facebook data from Asprova.
-
Build Splunk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Splunk and build visualizations in Tableau.
-
Use JayDeBeApi to access Delighted Data in Python
Use standard Python scripting and the development environment of your choice to access live Delighted.
-
Create Power BI Reports on Real-Time SAP SuccessFactors LMS Data
Use the CData ODBC Driver for SAP SuccessFactors LMS to visualize SAP SuccessFactors LMS in Power BI Desktop.
-
How to Work with Instagram Data in AWS Glue Jobs Using JDBC
Connect to Instagram from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live OnePageCrm Data in AWS Lambda (with IntelliJ IDEA)
Connect to live OnePageCrm in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Zoho Books Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho Books from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho Books.
-
Build Data Flows from MailChimp to SQL Server using SSIS
Easily back up MailChimp to SQL Server using the SSIS components for MailChimp.
-
Access Postmark Data from MySQL in Amazon QuickSight
Connect to Postmark and build visualizations of Postmark using a MySQL Connection in Amazon QuickSight.
-
Import Splunk Data Using Azure Data Factory
Use CData Connect AI to connect to Splunk Data from Azure Data Factory and import live Splunk.
-
How to Visualize PagerDuty Data in Python with pandas
Use pandas and other modules to analyze and visualize live PagerDuty in Python.
-
Analyze Pushbullet Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pushbullet from Power Pivot. You will use the Table Import Wizard to load Pushbullet. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Recurly Data in AWS Lambda
Connect to live Recurly in AWS Lambda using the CData JDBC Driver.
-
Build Pipelines with Live Google Analytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Analytics from Google Cloud Data Fusion, enabling the integration of live Google Analytics into the building and management of effective data pipelines.
-
Connect to Avaza Data from a Connection Pool in Jetty
The Avaza JDBC Driver supports connection pooling: This article shows how to connect faster to Avaza from Web apps in Jetty.
-
Automated Continuous RSS Replication to SQL Server
Use CData Sync for automated, continuous, customizable RSS replication to SQL Server.
-
Access Pipedrive 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 Pipedrive.
-
Working with Oracle Financials Cloud Data in LINQPad
Execute LINQ queries to Oracle Financials Cloud in LINQPad.
-
How to import Oracle Service Cloud Data into Apache Solr
Use the CData Software JDBC Driver for Oracle Service Cloud in Data Import Handler and create an automated import of Oracle Service Cloud to Apache Solr Enterprise Search platform.
-
Automate Couchbase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Couchbase from PowerShell? This article demonstrates how to utilize the Couchbase Cmdlets for tasks like connecting to Couchbase, automating operations, downloading data, and more.
-
Publish Teamgate-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Teamgate.
-
Migrating data from HBase to Databricks using CData SSIS Components.
Easily push Apache HBase to Databricks using the CData SSIS Tasks for HBase and Databricks.
-
How to Build an ETL App for Microsoft OneDrive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft OneDrive in Python with petl and the CData Connect AI Python SDK.
-
Connect to Foursquare Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Foursquare and the SQL Gateway to access Foursquare from Google Apps Script.
-
Connect to Keap Data in CloverDX (formerly CloverETL)
Transfer Keap using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ODBC Driver for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP SuccessFactors LMS.
-
Trigger SAP Business One IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Business One with standard wizards in Logic Apps.
-
View Reports on Real-Time Google Analytics Data in Power BI Report Server
Use the CData ODBC Driver for Google Analytics to visualize Google Analytics in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous WordPress Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable WordPress replication to Google Cloud SQL.
-
Publish Instantly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Instantly.
-
Build Active Directory Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Active Directory and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy Desktop
Connect to Invoiced in MicroStrategy Desktop using the CData Software ODBC Driver for Invoiced.
-
Automated Continuous NetSuite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable NetSuite replication to Amazon S3.
-
Natively Connect to Beeminder Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Beeminder. Leverage the native support for ODBC in PHP.
-
How to Visualize Redis Data in Python with pandas
Use pandas and other modules to analyze and visualize live Redis in Python.
-
Tally Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Tally ERP through CData Connect AI using different applications and tools.
-
Create a Data Access Object for Pinterest Data using JDBI
A brief overview of creating a SQL Object API for Pinterest in JDBI.
-
Build Semantic Layer Views for PagerDuty Data in APOS Live Data Gateway
Use the CData Connector for PagerDuty in APOS Live Data Gateway to build Semantic Layer Views for PagerDuty.
-
Rapidly Develop ActiveCampaign-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 ActiveCampaign.
-
Connect to Blackbaud FE NXT Data in JRuby
Create a simple JRuby app with access to live Blackbaud FE NXT.
-
Build Apps with Live NetSuite SuiteAnalytics in Adalo using CData Connect AI
Use CData Connect AI to integrate live NetSuite SuiteAnalytics into the Adalo platform and build custom mobile and web applications with real-time NetSuite SuiteAnalytics.
-
Connect to Gumroad from a Connection Pool in WebLogic
Use the CData JDBC Driver for Gumroad to connect to Gumroad from Web applications running on WebLogic.
-
Build Microsoft Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Ads.
-
Import Real-Time Certinia Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Certinia in ColdFusion.
-
Build Sage Cloud Accounting-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sage Business Cloud Accounting and build Sage Cloud Accounting-connected web apps with Axios.
-
Build MVC Applications with Connectivity to Grafana Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Grafana from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with Brex 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 Brex into a Java-based ORM framework, Hibernate.
-
Excel Spreadsheet Automation on Mistral AI Data with the QUERY Formula
Pull data from Mistral AI, automate spreadsheets, and more with the QUERY formula.
-
Integrating Cursor CLI with Hugging Face 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.
-
Excel Spreadsheet Automation on ZohoSubscriptions Data with the QUERY Formula
Pull data from ZohoSubscriptions, automate spreadsheets, and more with the QUERY formula.
-
Query Live FTP 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 FTP Servers directly from the development environment.
-
How to Work with Bitbucket Data in ETL Validator JDBC
Connect to Bitbucket from ETL Validator jobs using the CData Software JDBC Driver.
-
Build AI/ML Models with Live Greenhouse Data using Dataiku
Connect Greenhouse Data with Dataiku using the CData JDBC Driver for Greenhouse.
-
Build Visualizations of Bright Data Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bright Data in Birst.
-
Import Real-Time Oracle Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Database in ColdFusion.
-
Build Data Flows from ElevenLabs to SQL Server using SSIS
Easily back up ElevenLabs to SQL Server using the SSIS components for ElevenLabs.
-
Build Apps with Live Superchat Data Using the Low-Code Development Platform of Mendix
Connect Superchat with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live Gong Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Gong using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect Flowise AI Agents to Live CockroachDB 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 CockroachDB without replication.
-
Connect to Azure Table Data from a Connection Pool in JBoss
Integrate Azure Table Storage into Java servlets: Use the Management Console in JBoss to install the Azure Table JDBC Driver.
-
Automated Continuous Freshsales Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshsales replication to SQL Server.
-
Working with Snapchat Ads Data in LINQPad
Execute LINQ queries to Snapchat Ads in LINQPad.
-
Integrate PivotalTracker Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PivotalTracker from Informatica Cloud.
-
Automate Facebook Data Replication to SAP HANA
Use CData Sync to customize and automate Facebook replication to SAP HANA.
-
Connect to Cassandra from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cassandra to connect to Apache Cassandra from Web applications running on WebLogic.
-
Connect to Smartsheet Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Smartsheet Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect the Power BI Service to Odoo: Complete Guide
Connect to the CData Software Power BI Connector for Odoo from PowerBI.com to provide real-time Odoo ERP across the organization.
-
DataBind Controls to Elasticsearch Data in Delphi
DataBind to Elasticsearch in Delphi with standard data access components and controls.
-
Build AI/ML Models with Live iContact Data using Dataiku
Connect iContact Data with Dataiku using the CData API Driver for JDBC.
-
Connect to ClickUp Data in CloverDX (formerly CloverETL)
Transfer ClickUp using the visual workflow in the CloverDX data integration tool.
-
Connect and Query Live FHIR Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live FHIR into Databricks