CData Software - Knowledge Base
Recent Articles
-
Shopify Reporting in OBIEE with the Shopify JDBC Driver
Deploy the Shopify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Mailgun Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mailgun replication to SingleStore.
-
How to Visualize Google Tasks Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Tasks data in Python.
-
Using the CData Software ODBC Driver for Clockify in PyCharm
Connect to Clockify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Clockify.
-
Enable the OData JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OData services.
-
Model, Search, and Visualize Live Microsoft Teams Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Teams data for modeling, searching, and visualizing.
-
Connect to MongoDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MongoDB data using standard SQL.
-
Build Azure Table Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Table data and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for Zoho Inventory in MicroStrategy Desktop
Connect to Zoho Inventory data in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Inventory.
-
How to Work with Odoo Data in ETL Validator JDBC
Connect to Odoo from ETL Validator jobs using the CData Software JDBC Driver.
-
Seamlessly Bring Email Data into Retool Using CData Connect AI
Integrate Email data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Salesforce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce replication to SQL Server.
-
Connect to Monday.com Data in RazorSQL
Connect to Monday.com from wizards and query Monday.com data from the GUI in the RazorSQL database management tool.
-
Use Biml to Build SSIS Tasks to Replicate Printify Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Printify data to SQL Server.
-
Work with Aha! Data in FoxPro
Load Aha! data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Freshsales Data in HULFT Integrate
Connect to Freshsales as a JDBC data source in HULFT Integrate
-
How to connect Amazon QuickSight to Impala Data
Create a connection to Impala data in CData Connect AI and insert Impala data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Tableau Connector for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle Financials Cloud.
-
Use Azure AI Foundry to Talk to Your ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ZohoSubscriptions data for you.
-
How to Easily Query Google Analytics Data in OpenOffice Base
Connect to Google Analytics data in OpenOffice Base using the CData ODBC Driver for Google Analytics and generate reports with live data insights.
-
Create Microsoft Exchange-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Exchange Data from OutSystems and build custom enterprise apps using live Microsoft Exchange data.
-
Automated Continuous Mouseflow Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mouseflow replication to Google Cloud SQL.
-
Seamlessly Bring eBay Data into Retool Using CData Connect AI
Integrate eBay data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access ServiceDesk Plus Data from MySQL in PHP
Connect to ServiceDesk Plus through the standard MySQL libraries in PHP.
-
Getting Started with the CData Excel Add-In for Mode
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mode.
-
How to Connect the Power BI Service to PostgreSQL: Complete Guide
Connect to the CData Software Power BI Connector for PostgreSQL from PowerBI.com to provide real-time PostgreSQL data across the organization.
-
Getting Started with the CData JDBC Driver for Teradata
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Teradata.
-
Integrating LangChain with CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on CSV data within automated workflows.
-
Build AI Agents with SAP Ariba Procurement Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Ariba Procurement data through CData Connect AI.
-
Getting Started with the CData JDBC Driver for CircleCI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CircleCI.
-
Integrating Antigravity CLI with Oracle Eloqua Reporting data via CData CLI
Connect Oracle Eloqua Reporting data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apify data.
-
Connect to Sage Cloud Accounting Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage Cloud Accounting to connect to Sage Cloud Accounting data and execute queries in PowerBuilder.
-
Publish SuiteCRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SuiteCRM data.
-
Create MailerSend Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MailerSend data access from reports, embedded analytics, and more.
-
Automated Continuous HBase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HBase replication to Apache Cassandra.
-
Integrating Cursor with Wistia 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 Codat Data from MySQL in PHP
Connect to Codat through the standard MySQL libraries in PHP.
-
Explore Geographical Relationships in CloudConvert Data with Power Map
Create data visualizations with CloudConvert data in Power Map.
-
Configure the CData JDBC Driver for Google Spanner in a Connection Pool in Tomcat
Connect to Google Spanner data from a connection pool in Tomcat.
-
Integrating Cursor with Jodoo 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.
-
Automated Continuous SendInBlue Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendInBlue replication to Amazon Redshift.
-
Connect SurveyMonkey Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SurveyMonkey data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze SAP Hybris C4C Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Hybris C4C from Power Pivot. You will use the Table Import Wizard to load SAP Hybris C4C data. You can visually build the import query or use any SQL supported by the driver.
-
Extract, Transform, and Load Cloudflare Data in Informatica PowerCenter
Create a simple Workflow for Cloudflare data in Informatica PowerCenter.
-
How to Create Power BI Visual Reports with Real-Time Blackbaud FE NXT Data
Use CData Power BI Connectors to visualize Blackbaud FE NXT data in Power BI.
-
Provide OData Services of Apollo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apollo data by developing a WCF Service Application.
-
Explore Geographical Relationships in Calendly Data with Power Map
Create data visualizations with Calendly data in Power Map.
-
How to Connect to & Open Productboard Data in Microsoft Excel
This article uses the CData ODBC driver for Productboard to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Moving Data from Snowflake to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Snowflake data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Bridge Azure Table Connectivity with Apache NiFi
Access and process Azure Table data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live ShipStation 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 ShipStation data for you.
-
Integrate Excel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Excel with External Services.
-
Automated Continuous Google Ad Manager Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQLite.
-
Create SAP Business Warehouse-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Business Warehouse Data from OutSystems and build custom enterprise apps using live SAP Business Warehouse data.
-
How to Connect the Power BI Service to Highrise: Complete Guide
Connect to the CData Software Power BI Connector for Highrise from PowerBI.com to provide real-time Highrise data across the organization.
-
Integrate Postmark with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Postmark with External Services.
-
Analyze Copper Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Copper data with the CData JDBC Driver for Copper.
-
Integrate Cursor with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Confluence data from within the editor.
-
Integrating Claude Code with Dynamics 365 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Dynamics 365 data within assisted coding and automated development workflows.
-
Integrating Codex with AdRoll 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.
-
View Reports on Real-Time Anaplan Data in Power BI Report Server
Use the CData ODBC Driver for Anaplan to visualize Anaplan data in Power BI Desktop and then publish them to Power BI Report Server.
-
Feed Accelo Data into FineReport
How to set Accelo data as a JDBC data source in FineReport.
-
Consume Highrise OData Feeds in PowerBuilder
This article demonstrates how to consume Highrise data as OData feeds from PowerBuilder using the API Server.
-
Connect to Humanity Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Humanity and the SQL Gateway to access Humanity data from Google Apps Script.
-
How to connect to Bitly Data in DBVisualizer
Integrate Bitly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to ZohoExpense Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoExpense data using standard SQL.
-
Integrating GitHub Copilot with Close 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.
-
Getting Started with the CData Python Connector for Reply.io
Learn to install and license the CData Python Connector and configure a connection to live Reply.io data.
-
Visualize QuickBooks Data in Sisense
Create an ElastiCube in Sisense app with access to QuickBooks data.
-
Process & Analyze MariaDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MariaDB Data.
-
Replicate Unbounce Data to Multiple Databases
Replicate Unbounce data to disparate databases with a point-and-click configuration.
-
Connect to and Visualize Live Browserless Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Browserless data.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry data in MicroStrategy Desktop using the CData Software ODBC Driver for Sentry.
-
Build Semantic Layer Views for Eventbrite Data in APOS Live Data Gateway
Use the CData Connector for Eventbrite in APOS Live Data Gateway to build Semantic Layer Views for Eventbrite data.
-
Connect to Vercel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vercel data using standard SQL.
-
Using the CData Software ODBC Driver for Epicor Kinetic in PyCharm
Connect to Epicor Kinetic as an ODBC data source in PyCharm using the CData Software ODBC Driver for Epicor Kinetic.
-
Automated Continuous WooCommerce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable WooCommerce replication to Google BigQuery.
-
Integrating SpaceX Data in Talend Cloud Data Management Platform
Connect SpaceX Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Rapidly Develop SAP Ariba Procurement-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 Ariba Procurement.
-
How to Easily Query SAP Fieldglass Data in OpenOffice Base
Connect to SAP Fieldglass data in OpenOffice Base using the CData ODBC Driver for SAP Fieldglass and generate reports with live data insights.
-
Create Datasets from Mailgun in Domo Workbench and Build Visualizations of Mailgun Data in Domo
Use the CData Software ODBC Driver for Mailgun to create datasets from Mailgun data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Pipeline CRM Data in Coginiti Pro
Connect to and query live Pipeline CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Datasets from VWO in Domo Workbench and Build Visualizations of VWO Data in Domo
Use the CData Software ODBC Driver for VWO to create datasets from VWO data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect SharePoint with Okta Data through external lists
Provide Okta data to SharePoint users as an external list.
-
Work with Snowflake Data in FoxPro
Load Snowflake data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to load Perplexity data into Elasticsearch via Logstash
Introducing a simple method to load Perplexity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect DBeaver to Google Calendar via a JDBC Driver
Manage Google Calendar data with visual tools in DBeaver like the query browser.
-
Build Data Flows from Wave Financial to SQL Server using SSIS
Easily back up Wave Financial data to SQL Server using the SSIS components for Wave Financial.
-
Provide OData Services of Toggl Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Toggl data by developing a WCF Service Application.
-
Build Dashboards with SparkPost Data in DBxtra
Create dynamic dashboards and perform analytics based on SparkPost data in DBxtra.
-
Visualize Retently 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 Retently data into TIBCO Spotfire.
-
Connect to and Query SurveyMonkey Data in QlikView over ODBC
Create data visualizations with SurveyMonkey data in QlikView.
-
Establish a Live Connection with Zuora Data using Tableau Bridge
The CData ODBC Driver for Zuora enables you to integrate live Zuora data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to publish and share Everhour Data dashboards with Tableau Server
The CData ODBC driver for Everhour enables you integrate Everhour data into Tableau dashboards.
-
Integrate ZohoInvoice Data into Power Automate Desktop using CData Connect
CData Connect for ZohoInvoice Data enables you to integrate ZohoInvoice data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Dotmailer Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dotmailer as an External Source in Dremio.
-
How to work with Azure Synapse Data in Apache Spark using SQL
Access and process Azure Synapse Data in Apache Spark using the CData Software JDBC Driver.
-
How to Work with SAP Netweaver Gateway Data in AWS Glue Jobs Using JDBC
Connect to SAP Netweaver Gateway from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SAP Hybris C4C Data in DBArtisan
Use wizards in DBArtisan to configure SAP Hybris C4C data as a data source.