CData Software - Knowledge Base
Recent Articles
-
Connect to Copper Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Copper as an External Source in Dremio.
-
Connect to Zoho Books Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Books.
-
How to use SQLAlchemy ORM to access Nethunt Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nethunt.
-
Manage SAP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP.
-
Integrate Cursor with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Cloud Storage from within the editor.
-
Query Oracle Data in DataGrip
Create a Data Source for Oracle in DataGrip and use SQL to query live Oracle Database.
-
Create Reports from SendGrid Data in Looker Studio
Use CData Connect AI to gain access to live SendGrid and create custom reports in Looker Studio.
-
Use Manus AI to Talk to Your Splunk 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 Splunk.
-
Connect to LDAP in SpagoBI
Create reports featuring live LDAP in SpagoBI Studio. Host LDAP reports on SpagoBI Server.
-
Getting Started with the CData Power BI Connector for Active Directory
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Active Directory.
-
Build Bitbucket-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Bitbucket to explore live Bitbucket Data in Cursor to assist with building Bitbucket-powered applications.
-
Perform Batch Operations with Google Contacts Data in Apache NiFi
Connect to Google Contacts and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating LlamaIndex with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAS XPORT in real time.
-
Building Dynamic Web Pages with Aircall Data Using AngularJS
Create single-page applications with live connectivity to Aircall using the CData API Server.
-
Getting Started with the CData Python Connector for Certinia
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for Simplesat in MicroStrategy Web
Connect to Simplesat in MicroStrategy Web using the CData Software ODBC Driver for Simplesat.
-
Replicate Moosend Data from PowerShell
Write a quick PowerShell script to query Moosend. Use connectivity to the live data to replicate Moosend to SQL Server.
-
Publish Gumroad-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gumroad.
-
Bridge Google Analytics Connectivity with Apache NiFi
Access and process Google Analytics in Apache NiFi using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Keap Data
Access Keap as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Freshsales Data to Multiple Databases
Replicate Freshsales to disparate databases with a point-and-click configuration.
-
Connect to Live Avro Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Avro in CData Connect AI and connect to your Apache Avro from PostgreSQL.
-
Build Apps with Live Square Data Using the Low-Code Development Platform of Mendix
Connect Square with Mendix to build apps using the CData JDBC Driver for Square.
-
Connect to Google Cloud Storage Data in Jaspersoft Studio
Execute SQL to remote Google Cloud Storage in Jaspersoft Studio.
-
Use CData Connect AI to Access SAP Concur Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Concur in the Power Pivot business intelligence tool.
-
How to connect to YouTube Analytics Data with Squirrel SQL client
Connect to YouTube Analytics and execute queries in the Squirrel SQL Client.
-
Integrate Productboard Data in Pentaho Data Integration
Build ETL pipelines based on Productboard in the Pentaho Data Integration tool.
-
Connect to JSON Services in Google Apps Script via SQL Gateway
Use the ODBC Driver for JSON and the SQL Gateway to access JSON from Google Apps Script.
-
Visualize Live Google Sheets Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Sheets using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous CData Connect AI Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Azure SQL Database.
-
Connect Exact Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Exact Online using the CData Python MCP Server.
-
Choosing the Best Method to Connect eBay to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect and process Salesloft from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesloft.
-
A PostgreSQL Interface for Zoho Creator Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Creator JDBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Suadeo Data into FineReport
How to set Suadeo as a JDBC data source in FineReport.
-
Integrate Open WebUI with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Hybris C4C from within the chat interface.
-
A PostgreSQL Interface for Azure Analysis Services Data using the CData ODBC Driver
Use the SQL Gateway and Azure Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ActiveCampaign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to PostgreSQL.
-
Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy
Connect to OnePageCrm in MicroStrategy Developer using the CData Software JDBC Driver for OnePageCrm.
-
ETL Webex in Oracle Data Integrator
This article shows how to transfer Webex into a data warehouse using Oracle Data Integrator.
-
How to import Shopify Data into Apache Solr
Use the CData Software JDBC Driver for Shopify in Data Import Handler and create an automated import of Shopify to Apache Solr Enterprise Search platform.
-
Create Azure DevOps-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure DevOps Data from Klipfolio and build custom visualizations using live Azure DevOps.
-
Use Manus AI to Talk to Your FHIR 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 FHIR.
-
Query Gmail Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Gmail and perform CRUD operations on Gmail from Node.js.
-
Getting Started with the CData ADO.NET Provider for Paddle
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Using the CData Software ODBC Driver for Typeform in PyCharm
Connect to Typeform as an ODBC data source in PyCharm using the CData Software ODBC Driver for Typeform.
-
Connect to Tavily from Asprova with CData Software ODBC Driver for Tavily
This article shows how to connect faster to Tavily data from Asprova.
-
How to load SAP Hybris C4C data into Elasticsearch via Logstash
Introducing a simple method to load SAP Hybris C4C data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize MongoDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MongoDB.
-
How to Visualize SAP HANA XS Advanced Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP HANA XS Advanced in Python.
-
LINQ to Azure Table Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Azure Table Data Provider.
-
Connect to Azure Data Catalog Data in HULFT Integrate
Connect to Azure Data Catalog as a JDBC data source in HULFT Integrate
-
Visualize Drift Data in Sisense
Create an ElastiCube in Sisense app with access to Drift.
-
Visualize Scrapfly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Scrapfly.
-
Automated Continuous Zoho Projects Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Snowflake.
-
How to Connect Flowise AI Agents to Live Cloudant 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 IBM Cloudant without replication.
-
Migrating data from FTP to Databricks using CData SSIS Components.
Easily push FTP Servers to Databricks using the CData SSIS Tasks for FTP and Databricks.
-
How to Access Supabase Data Using Entity Framework
This article shows how to access Supabase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Discord Replication to SQL Server
Use CData Sync for automated, continuous, customizable Discord replication to SQL Server.
-
How to publish and share Microsoft OneDrive Data dashboards with Tableau Server
The CData ODBC driver for Microsoft OneDrive enables you integrate Microsoft OneDrive into Tableau dashboards.
-
Natively Connect to Cloudflare Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cloudflare. Leverage the native support for ODBC in PHP.
-
How to connect and process Vercel from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Vercel.
-
Moving Data from Amazon S3 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amazon S3 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Google Forms Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Forms replication to MySQL.
-
How to import Quickbase Data into Apache Solr
Use the CData Software JDBC Driver for Quickbase in Data Import Handler and create an automated import of Quickbase to Apache Solr Enterprise Search platform.
-
Use the CData SSIS Components to Insert New or Update Existing Dynamics CRM Records from SQL Server
Easily push SQL Server data to Dynamics CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Dynamics CRM or update existing records with data from a SQL Server database.
-
How to connect PolyBase to PabblySubscriptions
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PabblySubscriptions.
-
Edit and Search External MySQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MySQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MySQL Data objects that you can access from apps and the dashboard.
-
Integrate Presto Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Presto from Informatica Cloud.
-
Access Live Avro Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Avro data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Real-Time LaunchDarkly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use LaunchDarkly in Power Apps.
-
Extract, Transform, and Load TaxJar Data in Informatica PowerCenter
Create a simple Workflow for TaxJar in Informatica PowerCenter.
-
Create GraphQL-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GraphQL Data from Klipfolio and build custom visualizations using live GraphQL.
-
Access Miro Data from MySQL in Amazon QuickSight
Connect to Miro and build visualizations of Miro using a MySQL Connection in Amazon QuickSight.
-
DataBind Controls to GitHub Data in C++Builder
DataBind to GitHub in C++Builder with standard components and controls.
-
Connect to SAP SuccessFactors Data in Jaspersoft Studio
Execute SQL to remote SAP SuccessFactors in Jaspersoft Studio.
-
Use ChatGPT to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SendGrid for you.
-
Integrating Kiro CLI with Egnyte 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.
-
How to Connect to & Open Procore Data in Microsoft Excel
This article uses the CData ODBC driver for Procore to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Adobe Target Data in CloverDX (formerly CloverETL)
Transfer Adobe Target using the visual workflow in the CloverDX data integration tool.
-
Explore Geographical Relationships in Webflow Data with Power Map
Create data visualizations with Webflow in Power Map.
-
Connect to Amazon Athena Data in ACL Analytics
Connect to Amazon Athena via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Athena.
-
Building Dynamic Web Pages with SurveyMonkey Data Using AngularJS
Create single-page applications with live connectivity to SurveyMonkey using the CData API Server.
-
Work with Live Odoo Data in Power Query
Use CData Connect AI to connect to Odoo ERP and work with live Odoo ERP in Microsoft Power Query.
-
Connect to ConvertAPI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ConvertAPI and the SQL Gateway to access ConvertAPI from Google Apps Script.
-
Build Google Cloud Storage-Connected Apps in Choreo
Use CData Connect AI to connect to Google Cloud Storage Data from Choreo and build custom apps using live Google Cloud Storage.
-
Getting Started with the CData ODBC Driver for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for OpenWeatherMap.
-
Create Power BI Reports on Real-Time Zoho Inventory Data
Use the CData ODBC Driver for Zoho Inventory to visualize Zoho Inventory in Power BI Desktop.
-
How to Easily Query Postmark Data in OpenOffice Base
Connect to Postmark data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to ActiveCampaign Data from Crystal Reports
Use CData Connect AI to connect to and report on live ActiveCampaign from Crystal Reports.
-
Access Live BambooHR Data in AWS Lambda (with IntelliJ IDEA)
Connect to live BambooHR in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Telegram Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Telegram.
-
Analyze HubDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HubDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query Toggl Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Toggl from Node.js.
-
Build YouTube Analytics-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for YouTube Analytics to explore live YouTube Analytics Data in GitHub Copilot to assist with building YouTube Analytics-powered applications.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Procore using the Model Context Protocol.
-
Consume Accelo OData Feeds in PowerBuilder
This article demonstrates how to consume Accelo as OData feeds from PowerBuilder using the API Server.
-
Migrating data from MailerLite to Snowflake using CData SSIS Components.
Easily push MailerLite to Snowflake using the CData SSIS Tasks for MailerLite and Snowflake.
-
Getting Started with the CData JDBC Driver for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics NAV.
-
Rapidly Develop Act-On-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 Act-On.