CData Software - Knowledge Base
Recent Articles
-
Work with Adobe Target Data in FoxPro
Load Adobe Target into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Paddle Data in Pentaho Data Integration
Build ETL pipelines based on Paddle in the Pentaho Data Integration tool.
-
Establish a Live Connection with Google Ad Manager Data using Tableau Bridge
The CData ODBC Driver for Google Ad Manager enables you to integrate live Google Ad Manager into Tableau Cloud dashboards using the Tableau Bridge.
-
Operational Reporting on LinkedIn Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LinkedIn.
-
Build Data Flows from SQL Server to OneNote through SSIS
Easily push SQL Server data to OneNote using the CData SSIS Tasks for OneNote.
-
Write a Simple Go Application to work with Tickspot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Tickspot.
-
Integrate Live Oracle Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software ODBC Driver for Paymo in MicroStrategy
Connect to Paymo in MicroStrategy Developer using the CData Software ODBC Driver for Paymo.
-
Build Dashboards with OneNote Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft OneNote in Dundas BI.
-
Publish Reports with Attio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Attio.
-
Create Oracle Sales Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Sales data access from reports, embedded analytics, and more.
-
Connect to Google Search Results in DBeaver
Use the CData ODBC Driver to connect to Google Search in DBeaver.
-
Integrate Sage 200 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sage 200 from Informatica Cloud.
-
Access Printify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Printify from your Oracle system.
-
Connect to Oracle Service Cloud Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Service Cloud from HeidiSQL.
-
Analyze Pipeline CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pipeline CRM in Microsoft R Open.
-
Working with ChartMogul Data in LINQPad
Execute LINQ queries to ChartMogul in LINQPad.
-
Automated Continuous CSV Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CSV replication to AlloyDB.
-
How to integrate Typeform with Apache Airflow
Access and process Typeform in Apache Airflow using the CData JDBC Driver.
-
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 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.
-
Model, Search, and Visualize Live Microsoft Teams Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Teams 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 using standard SQL.
-
Build Azure Table Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Table Storage and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for Zoho Inventory in MicroStrategy Desktop
Connect to Zoho Inventory 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 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 to SQL Server.
-
Work with Aha! Data in FoxPro
Load Aha! 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 Apache Impala in CData Connect AI and insert Apache Impala 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.
-
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.
-
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 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/TSV Files 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 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 via CData CLI
Connect Oracle Eloqua Reporting 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.
-
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 Business Cloud Accounting 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.
-
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 CLI 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 in Power Map.
-
Configure the CData JDBC Driver for Google Spanner in a Connection Pool in Tomcat
Connect to Google Spanner from a connection pool in Tomcat.
-
Integrating Cursor CLI 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 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. 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 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 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 by developing a WCF Service Application.
-
Explore Geographical Relationships in Calendly Data with Power Map
Create data visualizations with Calendly 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 Storage 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 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.
-
How to import LionDesk Data into Apache Solr
Use the CData Software JDBC Driver for LionDesk in Data Import Handler and create an automated import of LionDesk to Apache Solr Enterprise Search platform.
-
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 CRM 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 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 Atlassian Confluence 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 Microsoft Dynamics 365 within assisted coding and automated development workflows.
-
Integrating Codex CLI with AdRoll 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 CData Connect AI Data Replication to Teradata
Use CData Sync to Customize and automate CData Connect AI replication to Teradata.
-
Edit and Search Pinterest External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Pinterest to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Pinterest objects that you can access from apps and the dashboard.
-
View Reports on Real-Time Anaplan Data in Power BI Report Server
Use the CData ODBC Driver for Anaplan to visualize Anaplan in Power BI Desktop and then publish them to Power BI Report Server.
-
Feed Accelo Data into FineReport
How to set Accelo as a JDBC data source in FineReport.
-
Consume Highrise OData Feeds in PowerBuilder
This article demonstrates how to consume Highrise CRM 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 from Google Apps Script.
-
How to connect to Bitly Data in DBVisualizer
Integrate Bitly 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 using standard SQL.
-
Integrating GitHub Copilot CLI with Close 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
-
Visualize QuickBooks Data in Sisense
Create an ElastiCube in Sisense app with access to QuickBooks Desktop.
-
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 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.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry 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.
-
Connect to Vercel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vercel 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.