CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Instantly in MicroStrategy
Connect to Instantly data in MicroStrategy Developer using the CData Software ODBC Driver for Instantly.
-
Visualize Live CockroachDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CockroachDB data.
-
Integrate Live Salesforce Pardot Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Pardot data and integrate live Salesforce Pardot data into apps built in Microsoft Power Apps.
-
How to Access Live Scrapfly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Scrapfly enables you to integrate Scrapfly data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Klipfolio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Klipfolio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Klipfolio data.
-
Connect to Superchat Data in RazorSQL
Connect to Superchat from wizards and query Superchat data from the GUI in the RazorSQL database management tool.
-
Build Data Flows from SQL Server to MariaDB through SSIS
Easily push SQL Server data to MariaDB using the CData SSIS Tasks for MariaDB.
-
Publish Reports with Planio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Planio data.
-
Query Gumroad Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Gumroad data from Node.js.
-
Operational Reporting on Oracle Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle data.
-
Connect to Google Forms Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Forms data.
-
Connect to eBay Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for eBay and the SQL Gateway to access eBay data from Google Apps Script.
-
Manage xBase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for xBase.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner data through natural language.
-
Replicate Short.io Data in Heroku for Use in Salesforce Connect
Replicate Short.io data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Azure Synapse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Synapse data and build web apps with connectivity to live Azure Synapse data.
-
Build Aha!-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Aha! data and build web apps with connectivity to live Aha! data.
-
Use the CData ODBC Driver for Superchat in Microsoft Power Query
You can use the CData Superchat ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Superchat data into Microsoft Power Query.
-
Integrate with Google Tasks Data in JReport Designer
Create charts and reports based on Google Tasks data in JReport Designer.
-
Integrate Dify with Live Couchbase 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 Couchbase data.
-
Integrating LangGraph with Google Search Results via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Search results within automated workflows.
-
Automate MailChimp Data Replication to Couchbase
Use CData Sync to Customize and automate MailChimp data replication to Couchbase.
-
Integrate Google's Antigravity Agent with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Instagram data using the Model Context Protocol.
-
Integrating Boomi Agentstudio with Egnyte Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Egnyte data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Validate ShipEngine Data with QuerySurge
Access and validate ShipEngine data in QuerySurge using the CData JDBC Driver.
-
Publish ZohoMarketingHub-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoMarketingHub data.
-
Create Dynamics 365 Business Central Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics 365 Business Central from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Adobe Commerce Data in Dundas BI
Create dynamic dashboards and perform analytics based on Adobe Commerce data in Dundas BI.
-
How to Connect to Live Airtable 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 Airtable data for you.
-
Connect to Oracle SCM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle SCM data.
-
Visualize Deel Data in Tableau
The CData ODBC driver for Deel enables you integrate Deel data into Tableau dashboards.
-
Build BambooHR-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live BambooHR data without replication.
-
Link Tavily with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Tavily data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Webex Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Webex replication to Google BigQuery.
-
DataBind Reckon Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Reckon with the DevExpress Windows Forms and Web controls to provide Reckon data to a chart.
-
Integrate Neo4J Data in the Pentaho Report Designer
Publish reports based on Neo4J data in the Pentaho BI tool.
-
Automated Continuous SendInBlue Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SendInBlue replication to Google Cloud SQL.
-
Getting Started with the CData Power BI Connector for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Operational Reporting on HubDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HubDB data.
-
Creating Bright Data-Connected Applications in Unqork
You can use CData Connect AI to feed Bright Data data to Unqork and build custom business apps.
-
Extract, Transform, and Load Amplitude Data in Informatica PowerCenter
Create a simple Workflow for Amplitude data in Informatica PowerCenter.
-
Bulk Import Tasks from Excel to MS Planner: Excel Add-In for MS Planner
Learn how to bulk import and manage Microsoft Planner tasks directly from Excel using the CData Excel Add-In
-
Use the CData Software ODBC Driver for Access in SAS for Real-Time Reporting and Analytics
Connect to real-time Access data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Access.
-
How to Connect to Salesforce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce data. Leverage the pyodbc module for ODBC in Python.
-
Connect and Visualize Live Amazon Marketplace Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon Marketplace data into the Databricks platform and create visualization dashboards with real-time Amazon Marketplace data.
-
Connect and Query Live RSS Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live RSS feeds into Databricks and enable direct, live querying and analysis without replication.
-
View Reports on Real-Time Salesforce Data 360 Data in Power BI Report Server
Use the CData ODBC Driver for Salesforce Data 360 to visualize Salesforce Data 360 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy
Connect to Notion data in MicroStrategy Developer using the CData Software ODBC Driver for Notion.
-
Integrate Wistia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Wistia with External Services.
-
How to load Wrike data into Elasticsearch via Logstash
Introducing a simple method to load Wrike data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Salesforce CRM Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce CRM Analytics data in the Denodo Virtual DataPort Administrator.
-
How to connect to LinkedIn Ads Data in DBVisualizer
Integrate LinkedIn Ads data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Google Ad Manager-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Ad Manager data.
-
Operational Reporting on GraphQL Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GraphQL data.
-
Getting Started with the CData Excel Add-In for Basecamp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Basecamp.
-
How to connect to Microsoft Exchange Data from Spring Boot
Connect to Microsoft Exchange in a Spring Boot Application using the CData JDBC Driver for Microsoft Exchange
-
Build Semantic Layer Views for JSON Services in APOS Live Data Gateway
Use the CData Connector for JSON in APOS Live Data Gateway to build Semantic Layer Views for JSON services.
-
Integrate Cline with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Avro data from within your IDE.
-
Analyze Microsoft Exchange Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Exchange data in Microsoft R Open.
-
How to use SQLAlchemy ORM to access Mixpanel Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mixpanel data.
-
DataBind Controls to Teradata Data in Delphi
DataBind to Teradata data in Delphi with standard data access components and controls.
-
Connect Humanity to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Humanity data using the CData Python MCP Server.
-
Build PayPal-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live PayPal data without replication.
-
Automated Continuous Close Replication to Databricks
Use CData Sync for automated, continuous, customizable Close replication to Databricks.
-
Automated Continuous Salesforce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce replication to Apache Kafka.
-
Getting Started with the CData SSIS Components for Google Drive
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Drive.
-
Migrating data from Mistral AI to Google BigQuery using CData SSIS Components.
Easily push Mistral AI data to Google BigQuery using the CData SSIS Tasks for Mistral AI and Google BigQuery.
-
DataBind Pingdom Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Pingdom data to a chart.
-
Visualize Opsgenie Data in Tableau
The CData ODBC driver for Opsgenie enables you integrate Opsgenie data into Tableau dashboards.
-
How to Work with Salesforce Data in AWS Glue Jobs Using JDBC
Connect to Salesforce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Datadog Replication to SQLite
Use CData Sync for automated, continuous, customizable Datadog replication to SQLite.
-
Integrating Antigravity CLI with Nethunt data via CData CLI
Connect Nethunt data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Goose with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Act-On data from within the local AI agent.
-
Manage SAP Ariba Procurement Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Ariba Procurement.
-
Excel Spreadsheet Automation on Scrapfly Data with the QUERY Formula
Pull data from Scrapfly, automate spreadsheets, and more with the QUERY formula.
-
Integrating LlamaIndex with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Dynamics 365 data in real time.
-
Connect to CouchDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CouchDB data using standard SQL.
-
How to update Microsoft Planner from Excel
This article explains how to transfer data from Excel to Microsoft Planner using the Excel Add-In for Microsoft Planner.
-
Integrate with live Snapchat Ads Data in Jitterbit
Use CData Connect AI to connect to and integrate live Snapchat Ads data in Jitterbit.
-
Connect to HubDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HubDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Using the CData Software ODBC Driver for Parquet in PyCharm
Connect to Parquet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Parquet.
-
Use Manus AI to Talk to Your Sendwithus 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 Sendwithus data.
-
Integrating Gumloop with CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on CSV data within automated workflows.
-
DataBind Controls to WooCommerce Data in Delphi
DataBind to WooCommerce data in Delphi with standard data access components and controls.
-
Excel Spreadsheet Automation on Teamgate Data with the QUERY Formula
Pull data from Teamgate, automate spreadsheets, and more with the QUERY formula.
-
Feed Sugar CRM Data into FineReport
How to set Sugar CRM data as a JDBC data source in FineReport.
-
Use Grok to Talk to Your FTP 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 FTP data for you.
-
Use Biml to Build SSIS Tasks to Replicate Notion Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Notion data to SQL Server.
-
Getting Started with the CData JDBC Driver for GitHub
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GitHub.
-
Use the CData ODBC Driver for XML from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for XML to connect to XML data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring XML data in Excel.
-
Automated Continuous Tally Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tally replication to SingleStore.
-
How to Use a Microsoft Access Database to Update Reckon Accounts Hosted Data in Real Time
Update Reckon Accounts Hosted data by creating a linked table in Microsoft Access with the CData Reckon Accounts Hosted ODBC Driver.
-
Automated Continuous SAP Ariba Procurement Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement data replication to OneLake in Microsoft Fabric.
-
Replicate Figshare Data from PowerShell
Write a quick PowerShell script to query Figshare data. Use connectivity to the live data to replicate Figshare data to SQL Server.
-
Analyze Live Oracle Sales Data in SAS Viya
Use CData Connect AI to connect to Oracle Sales data from SAS Viya and deploy self-service analytics using live Oracle Sales data.
-
Automated Continuous SAP Fieldglass Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to PostgreSQL.
-
Automated Continuous MailerSend Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MailerSend replication to Azure SQL Database.
-
Build Pipelines with Live Omnisend Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Omnisend from Google Cloud Data Fusion, enabling the integration of live Omnisend data into the building and management of effective data pipelines.
-
Integrate Perigon Data in Pentaho Data Integration
Build ETL pipelines based on Perigon data in the Pentaho Data Integration tool.
-
Analyze Live Cassandra Data in SAS Viya
Use CData Connect AI to connect to Cassandra data from SAS Viya and deploy self-service analytics using live Cassandra data.