CData Software - Knowledge Base
Recent Articles
-
Validate Yelp Data with QuerySurge
Access and validate Yelp data in QuerySurge using the CData JDBC Driver.
-
Choosing the Best Method to Connect Google Campaign Manager 360 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Campaign Manager 360 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous FormSite Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FormSite replication to Apache Kafka.
-
Automate Vimeo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Vimeo data replication to Azure Data Lake.
-
Create Informatica Mappings From/To a JDBC Data Source for Customer.io
Create Customer.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Open WebUI with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Twitter Ads data from within the chat interface.
-
Choosing the Best Method to Connect Google Calendar to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Calendar data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Miro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Miro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Miro data.
-
Creating MariaDB-Connected Applications in Unqork
You can use CData Connect AI to feed MariaDB data to Unqork and build custom business apps.
-
Integrate Google's Vertex AI Agent with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAS xpt data within intelligent workflows.
-
Getting Started with the CData Excel Add-In for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua.
-
Connect to Bannerbear Data in JRuby
Create a simple JRuby app with access to live Bannerbear data.
-
Integrating Codex with Tavily 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 HubDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HubDB data replication to OneLake in Microsoft Fabric.
-
Create SAP Concur-Connected Applications in Appsmith
Connect to SAP Concur Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Concur data.
-
Integrate Oracle SCM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle SCM data from Informatica Cloud.
-
Integrate Monday.com Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Monday.com data from Informatica Cloud.
-
Automated Google Translate Data Replication to Teradata
Use CData Sync to Customize and automate Google Translate data replication to Teradata.
-
Create Apps from Paymo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Paymo Data and build apps from live Paymo data in Qlik Sense Cloud.
-
Visualize Live Pinterest Data in the Power BI Service
Use CData Connect AI to connect to live Pinterest data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Neo4J-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Neo4J data.
-
How to Connect to Live Zoho Projects 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 Zoho Projects data through natural language.
-
Integrate Theia IDE with Live MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live MailerLite data from within the development environment.
-
Integrate with TigerGraph Data in JReport Designer
Create charts and reports based on TigerGraph data in JReport Designer.
-
Explore Geographical Relationships in Wrike Data with Power Map
Create data visualizations with Wrike data in Power Map.
-
Replicate Multiple Stack Exchange Accounts via the CData Sync CLI
Replicate multiple Stack Exchange accounts to one or many databases.
-
How to Connect DBeaver to Dynamics 365 via a JDBC Driver
Manage Dynamics 365 data with visual tools in DBeaver like the query browser.
-
Access Live Amazon DynamoDB Data in TIBCO Data Virtualization
Use the Amazon DynamoDB Tibco DV Adapter to create a Amazon DynamoDB data data source in TIBCO Data Virtualization Studio and gain access to live Amazon DynamoDB data from your TDV Server.
-
Connect to Yelp from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Yelp data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Theia IDE with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SAP Ariba Source data from within the development environment.
-
Connect to Paddle Data in RazorSQL
Connect to Paddle from wizards and query Paddle data from the GUI in the RazorSQL database management tool.
-
Publish Databricks-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Databricks data.
-
Create TigerGraph Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time TigerGraph data access from reports, embedded analytics, and more.
-
Automated Continuous Instantly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Instantly replication to Azure SQL Database.
-
Design BIRT Reports on Impala Data
Provide current Impala data to your embedded analytics.
-
Oracle Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle data through CData Connect AI using different applications and tools.
-
Connect to EnterpriseDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for EnterpriseDB in FileMaker Pro to connect to EnterpriseDB and work with EnterpriseDB data in your FileMaker applications.
-
Connect to EnterpriseDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time EnterpriseDB data using standard SQL.
-
Getting Started with the CData SSIS Components for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Elasticsearch.
-
Moving Data from Figshare to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Figshare data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to ZohoInvoice Data from a Connection Pool in Jetty
The ZohoInvoice JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoInvoice data from Web apps in Jetty.
-
How to integrate Short.io with Apache Airflow
Access and process Short.io data in Apache Airflow using the CData JDBC Driver.
-
Analyze Adobe Target Data in Looker
Use CData Connect AI to connect to Adobe Target Data from Looker and build custom apps using live Adobe Target data.
-
Use CData Connect AI to Access Pinterest Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Pinterest data in the Power Pivot business intelligence tool.
-
Build AI/ML Models with Live Greenplum Data using Dataiku
Connect Greenplum Data with Dataiku using the CData JDBC Driver for Greenplum.
-
Use the CData Software JDBC Driver for WordPress in MicroStrategy Web
Connect to WordPress data in MicroStrategy Web using the CData Software JDBC Driver for WordPress.
-
Publish Azure Data Catalog-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Data Catalog data.
-
A PostgreSQL Interface for Zoho CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live CSV Data in Coginiti Pro
Connect to and query live CSV data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connecting Moonlit Workflow with XML 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 XML data in real time.
-
Analyze LightSpeedRetail Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LightSpeedRetail from Power Pivot. You will use the Table Import Wizard to load LightSpeedRetail data. You can visually build the import query or use any SQL supported by the driver.
-
Easily Integrate Browserless Data in Lazarus Pascal IDE
Learn how to easily integrate live Browserless data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Superchat Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Superchat replication to Apache Cassandra.
-
Automate ChartMogul Data Replication to SAP HANA
Use CData Sync to customize and automate ChartMogul data replication to SAP HANA.
-
Automate Insightly Data Replication to Couchbase
Use CData Sync to Customize and automate Insightly data replication to Couchbase.
-
Import Real-Time SageHR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SageHR data in ColdFusion.
-
How to Connect to & Open Dotmailer Data in Microsoft Excel
This article uses the CData ODBC driver for Dotmailer to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Excel Add-In for Azure Table
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Table.
-
Creating CouchDB-Connected Applications in Unqork
You can use CData Connect AI to feed CouchDB data to Unqork and build custom business apps.
-
Getting Started with the CData SSIS Components for Float
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Float.
-
How to integrate Beeminder with Apache Airflow
Access and process Beeminder data in Apache Airflow using the CData JDBC Driver.
-
Create a Data Access Object for ConvertKit Data using JDBI
A brief overview of creating a SQL Object API for ConvertKit data in JDBI.
-
DataBind Controls to Apollo Data in Delphi
DataBind to Apollo data in Delphi with standard data access components and controls.
-
Integrate Dify with Live Tally Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Tally data.
-
Publish Reports with Amazon DynamoDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon DynamoDB data.
-
Connect to Google Spanner Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Spanner Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with AlloyDB Data in ETL Validator JDBC
Connect to AlloyDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Teradata Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Teradata data for you.
-
Connecting GenSpark with Sybase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sybase data without any replication or custom integration required.
-
How to create IBM Informix federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM Informix data in MySQL .
-
Build Yelp-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Yelp Data and create custom apps in Bubble.
-
Work with Epicor Kinetic Data in FoxPro
Load Epicor Kinetic data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Tableau Connector for Box
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Box.
-
Connect to OneNote Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OneNote data in Airbyte.
-
DataBind Controls to Browserless Data in Delphi
DataBind to Browserless data in Delphi with standard data access components and controls.
-
Connect to Databricks Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Databricks data from Filemaker Pro on Mac.
-
Create Postmark Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Postmark from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Claude Code CLI with Clockify 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 ConvertAPI 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 ConvertAPI data.
-
Visualize Live SuiteCRM Data in the Power BI Service
Use CData Connect AI to connect to live SuiteCRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live SAP HANA XS Advanced Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP HANA XS Advanced data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Publish Reports with Oracle Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle data.
-
Back Up Dotmailer data 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 Dotmailer data data.
-
How to connect PolyBase to LinkedIn Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn Ads data.
-
Use Manus AI to Talk to Your Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Amazon S3 data.
-
Query, Visualize, and Share live Zendesk Data in Redash
Use CData Connect AI to connect to live Zendesk data in Redash for querying, visualizing, and sharing.
-
Stream OpenWeatherMap Data into Apache Kafka Topics
Access and stream OpenWeatherMap data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Auth0 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Auth0 data in Python.
-
Query Workable Data in ColdFusion
Write standard ColdFusion data access code to connect to Workable data.
-
Automated Continuous Amazon DynamoDB Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SQLite.
-
Getting Started with the CData JDBC Driver for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoSubscriptions.
-
Import Real-Time Scrapfly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Scrapfly data in ColdFusion.
-
How to Work with Tanda Data in AWS Glue Jobs Using JDBC
Connect to Tanda from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for CouchDB
Create an ODBC connection to CouchDB in Informatica and browse and transfer CouchDB data.
-
How to Easily Query Dynamics 365 Data in OpenOffice Base
Connect to Dynamics 365 data in OpenOffice Base using the CData ODBC Driver for Dynamics 365 and generate reports with live data insights.
-
Edit and Search External Workday Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Workday data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Workday Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData ODBC Driver for Cohere
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cohere.
-
Analyze Facebook Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Facebook data and visualize live Facebook data in Infragistics Reveal.
-
Create Dynamic Phoenix Grids Using the Infragistics XamDataGrid
Learn how you can connect Phoenix to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Aha! Replication to Oracle
Use CData Sync for automated, continuous, customizable Aha! replication to Oracle.