CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Simplesat Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Simplesat data replication to OneLake in Microsoft Fabric.
-
Query SendPulse Data as a MySQL Database in Node.js
Execute MySQL queries against SendPulse data from Node.js.
-
Link Bannerbear with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bannerbear data in Filemaker Pro for Mac or Windows.
-
How to connect to Mouseflow Data from IntelliJ
Integrate connectivity to Mouseflow data with wizards in IntelliJ.
-
Model, Search, and Visualize Live Shippo Data in ThoughtSpot
Use CData Connect AI to connect to live Shippo data for modeling, searching, and visualizing.
-
Connecting Mastra with Salesforce Marketing Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Salesforce Marketing data, no replication required.
-
Explore Geographical Relationships in Apollo Data with Power Map
Create data visualizations with Apollo data in Power Map.
-
How to Easily Query Apollo Data in OpenOffice Base
Connect to Apollo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Configure the CData JDBC Driver for Klipfolio in a Connection Pool in Tomcat
Connect to Klipfolio data from a connection pool in Tomcat.
-
Access Live SAP Business Warehouse Data in Coginiti Pro
Connect to and query live SAP Business Warehouse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Google Drive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Drive data from your Excel spreadsheets.
-
Visualize Live Apollo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apollo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Devin with Live Freshteam Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Freshteam data.
-
Natively Connect to Amazon Marketplace Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon Marketplace data. Leverage the native support for ODBC in PHP.
-
Build an OLAP Cube in SSAS from Rootly Data
Establish a connection to Rootly data data from SQL Server Analysis Services, and use the Rootly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Easily Integrate Sybase Data in Lazarus Pascal IDE
Learn how to easily integrate live Sybase data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Active Directory Data in DBeaver
Use the CData ODBC Driver to connect to Active Directory data in DBeaver.
-
Use Dash to Build to Web Apps on JotForm Data
Create Python applications that use pandas and Dash to build JotForm-connected web apps.
-
Integrate Flowlu with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Flowlu with External Services.
-
Working with Active Directory Data in LINQPad
Execute LINQ queries to Active Directory data in LINQPad.
-
Automate BenchmarkEmail Data Replication to Azure Data Lake
Use CData Sync to customize and automate BenchmarkEmail data replication to Azure Data Lake.
-
Build Dashboards with Hacker News Data in Dundas BI
Create dynamic dashboards and perform analytics based on Hacker News data in Dundas BI.
-
Connect to SendGrid Data from Crystal Reports
Use CData Connect AI to connect to and report on live SendGrid data from Crystal Reports.
-
Create Reports with SAP Business One Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business One data.
-
Replicate Autopilot Data from PowerShell
Write a quick PowerShell script to query Autopilot data. Use connectivity to the live data to replicate Autopilot data to SQL Server.
-
Replicate Multiple Helpscout Accounts
Replicate multiple Helpscout accounts to one or many databases.
-
Query Bright Data Data as a SQL Server Database in Node.js
Execute SQL Server queries against Bright Data data from Node.js.
-
Build a Singer.io Tap for HubDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HubDB data using the CData Python Connector.
-
Connect to and Query Oracle SCM Data in QlikView over ODBC
Create data visualizations with Oracle SCM data in QlikView.
-
Automated Continuous Google Calendar Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Calendar replication to Google BigQuery.
-
Integrating Claude Code CLI with PDFMonkey 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.
-
Publish Crystal Reports on Salesforce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce data.
-
Publish Hive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hive data.
-
Build AI/ML Models with Live AdRoll Data using Dataiku
Connect AdRoll Data with Dataiku using the CData API Driver for JDBC.
-
Integrate with live ZohoPeople Data in Jitterbit
Use CData Connect AI to connect to and integrate live ZohoPeople data in Jitterbit.
-
Access Live Perigon Data in Coginiti Pro
Connect to and query live Perigon data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Brex Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Brex replication to Google BigQuery.
-
Connect to SendPulse Data in DBArtisan
Use wizards in DBArtisan to configure SendPulse data as a data source.
-
Connect BambooHR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live BambooHR data using the CData Python MCP Server.
-
Connect to Smartsheet Data from a Connection Pool in JBoss
Integrate Smartsheet data into Java servlets: Use the Management Console in JBoss to install the Smartsheet JDBC Driver.
-
How to Connect to Live Jira Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Jira data for you.
-
A PostgreSQL Interface for SAP SuccessFactors Data using the CData ODBC Driver
Use the SQL Gateway and SAP SuccessFactors ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live EnterpriseDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live EnterpriseDB data data in natural language using Python.
-
Connect to Oracle from Asprova with CData Software ODBC Driver for Oracle
This article shows how to connect faster to Oracle data from Asprova.
-
Use Azure AI Foundry to Talk to Your Microsoft Planner 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 Microsoft Planner data for you.
-
Integrate Live Salesforce Pardot Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Pardot from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Pardot data.
-
Query Live Vertica 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 Vertica data directly from the development environment.
-
How to connect to MailChimp Data in DBVisualizer
Integrate MailChimp data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Sage 200 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage 200 data.
-
Use Grok to Talk to Your ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your ZohoExpense data for you.
-
Connect to Guru Data in JRuby
Create a simple JRuby app with access to live Guru data.
-
Publish Vimeo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Vimeo data.
-
How to Access Live Instantly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Instantly enables you to integrate Instantly data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Recurly Data from a Connection Pool in Jetty
The Recurly JDBC Driver supports connection pooling: This article shows how to connect faster to Recurly data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for GitHub in SAS for Real-Time Reporting and Analytics
Connect to real-time GitHub data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for GitHub.
-
How to integrate Amazon S3 with Apache Airflow
Access and process Amazon S3 data in Apache Airflow using the CData JDBC Driver.
-
Publish Reports with Mode Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mode data.
-
Integrate Google Forms Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Forms data from Informatica Cloud.
-
Integrate Parquet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Parquet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Parquet data.
-
Design BIRT Reports on CockroachDB Data
Provide current CockroachDB data to your embedded analytics.
-
Integrate Live Guru Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Guru data from within the IDE.
-
Automated Continuous Impala Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Impala replication to IBM DB2.
-
Import and Visualize JobNimbus Data in Power View
Create data visualizations based on JobNimbus data in Excel.
-
How to Query Salesloft Data in MySQL Workbench
Execute MySQL queries against live Salesloft data from MySQL Workbench.
-
DataBind Controls to Onfleet Data in C++Builder
DataBind to Onfleet data in C++Builder with standard components and controls.
-
Connect to Google Cloud Storage Data from a Connection Pool in Jetty
The Google Cloud Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Google Cloud Storage data from Web apps in Jetty.
-
Use the CData SSIS Components to Insert New or Update Existing Stripe Records from SQL Server
Easily push SQL Server data to Stripe using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Stripe or update existing records with data from a SQL Server database.
-
Deploy the ADO.NET Provider for Hacker News on an SSRS Report Server
Connect to Hacker News data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Create Cvent-Connected Nintex Workflows
Use CData Connect AI to connect to Cvent Data from Nintex Workflow Cloud and build custom workflows using live Cvent data.
-
Toggl Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Toggl data through CData Connect AI using different applications and tools.
-
LINQ to Instagram 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 Instagram Data Provider.
-
Replicate Close Data to Multiple Databases via the CData Sync CLI
Replicate Close data to disparate databases with a single configuration.
-
Getting Started with the CData SSIS Components for Pinecone
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Pinecone.
-
Use Manus AI to Talk to Your Cloudant 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 Cloudant data.
-
Connecting Mastra with Google Spanner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Spanner data, no replication required.
-
Visualize Suadeo Data in Tableau
The CData ODBC driver for Suadeo enables you integrate Suadeo data into Tableau dashboards.
-
How to work with Google Sheets Data in Apache Spark using SQL
Access and process Google Sheets Data in Apache Spark using the CData Software JDBC Driver.
-
Access DB2 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live DB2 data from HeidiSQL.
-
Build Pipelines with Live FHIR Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to FHIR from Google Cloud Data Fusion, enabling the integration of live FHIR data into the building and management of effective data pipelines.
-
Deploy CData API Server to Azure App Service with SQL Server
Deploy CData API Server to Azure App Service (Linux) and store its configuration in SQL Server, so your REST APIs survive restarts and are ready to scale.
-
Visualize Zendesk 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 Zendesk data into TIBCO Spotfire.
-
Connect to eBay Data in RapidMiner
Integrate eBay data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Cline with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Netweaver Gateway data from within your IDE.
-
Automated Continuous MySQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MySQL replication to Amazon S3.
-
Query Aha! Data in DataGrip
Create a Data Source for Aha! in DataGrip and use SQL to query live Aha! data.
-
Connect to SageHR Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SageHR and the SQL Gateway to access SageHR data from Google Apps Script.
-
Build a Simple VCL Application for Zoho CRM Data
How to build a simple VCL Application to view Zoho CRM data in RAD Studio using the CData ODBC Driver for Zoho CRM.
-
Analyze Live Blackbaud FE NXT Data in SAS Viya
Use CData Connect AI to connect to Blackbaud FE NXT data from SAS Viya and deploy self-service analytics using live Blackbaud FE NXT data.
-
How to Connect to Live Odoo Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Odoo data for you.
-
Replicate SparkPost Data to Multiple Databases
Replicate SparkPost data to disparate databases with a point-and-click configuration.
-
Access Live Mode Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Mode data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Operational Reporting on Sentry Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sentry data.
-
Integrate LibreChat with Live xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live xBase data from within the chat interface.
-
A PostgreSQL Interface for SAP Ariba Procurement Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Ariba Procurement JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy Web
Connect to Microsoft Teams data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Teams.
-
Connect to Calendly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Calendly data using standard SQL.
-
Automated Continuous OneNote Replication to Snowflake
Use CData Sync for automated, continuous, customizable OneNote replication to Snowflake.
-
Use JayDeBeApi to access Omnisend Data in Python
Use standard Python scripting and the development environment of your choice to access live Omnisend data.
-
How to connect and process Active Directory data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Active Directory data.
-
Access Live ActiveCampaign Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ActiveCampaign data from your Excel spreadsheets.