CData Software - Knowledge Base
Recent Articles
-
Add Humanity Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Humanity with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Klaviyo Data Replication to Azure Synapse
Use CData Sync to customize and automate Klaviyo replication to Azure Synapse.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy Desktop
Connect to Notion in MicroStrategy Desktop using the CData Software ODBC Driver for Notion.
-
Visualize PolarTeamPro Data in TIBCO Spotfire through ADO.NET
Integrate PolarTeamPro into dashboards in TIBCO Spotfire.
-
How to Easily Query Microsoft OneDrive Data in OpenOffice Base
Connect to Microsoft OneDrive data in OpenOffice Base using the CData ODBC Driver for Microsoft OneDrive and generate reports with live data insights.
-
Import GitHub Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access GitHub. In this article, you will use the OData format to import GitHub into Microsoft Power Query.
-
How to connect and process Microsoft OneDrive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft OneDrive.
-
Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Desktop
Connect to Facebook Ads in MicroStrategy Desktop using the CData Software JDBC Driver for Facebook Ads.
-
Integrating Boomi Agentstudio with Neo4J Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Neo4J, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live Oracle HCM Cloud Data in the Power BI Service
Use CData Connect AI to connect to live Oracle HCM Cloud and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze Microsoft Dataverse Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dataverse (CDS) for self-service data analytics.
-
Back Up Tavily 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 Tavily data.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce through natural language.
-
Connect to ConvertAPI in SpagoBI
Create reports featuring live ConvertAPI in SpagoBI Studio. Host ConvertAPI reports on SpagoBI Server.
-
Create Apps from CSV Data in Qlik Sense Cloud
Use CData Connect AI to connect to CSV Data and build apps from live CSV/TSV Files in Qlik Sense Cloud.
-
Getting Started with the CData ADO.NET Provider for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Voice Agents in ElevenLabs with access to Live Google Campaign Manager 360 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Campaign Manager 360.
-
Access Live Oracle Service Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle Service Cloud from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Datasets from Nuclia in Domo Workbench and Build Visualizations of Nuclia Data in Domo
Use the CData Software ODBC Driver for Nuclia to create datasets from Nuclia in Domo Workbench and then build visualizations in the Domo service.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce Marketing Cloud for you.
-
Consume Amazon S3 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon S3 feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple Couchbase Accounts
Replicate multiple Couchbase accounts to one or many databases.
-
Bidirectional Access to Monday.com Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Monday.com in Filemaker Pro for Mac or Windows.
-
Choosing the Best Method to Connect Google Tasks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Tasks from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Claude to Talk to Your Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Gmail for you.
-
Automated Continuous Mode Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mode replication to SQL Server.
-
How to connect SharePoint with HDFS Data through external lists
Provide Apache HDFS to SharePoint users as an external list.
-
How to Query Live Xero Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Xero Accounting data in natural language using Python.
-
Getting Started with the CData JDBC Driver for Stripe
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Stripe.
-
Moving Data from Dynamics NAV to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics NAV data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Amazon Marketplace Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Marketplace in Airbyte.
-
Build Greenplum-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Pivotal GreenPlum.
-
Create Datasets from Reckon in Domo Workbench and Build Visualizations of Reckon Data in Domo
Use the CData Software ODBC Driver for Reckon to create datasets from Reckon in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Okta Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Gumloop with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SendGrid within automated workflows.
-
Connect Testmonitor to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Testmonitor using the CData Python MCP Server.
-
Connect to Salesforce Pardot Data in NetBeans
Connect to Salesforce Pardot in NetBeans with the data source configuration wizard.
-
ETL MailerSend in Oracle Data Integrator
This article shows how to transfer MailerSend into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SAP SuccessFactors Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Google Cloud SQL.
-
Automate Cloudflare Data Replication to Azure Synapse
Use CData Sync to customize and automate Cloudflare replication to Azure Synapse.
-
Prepare, Blend, and Analyze Sybase Data in Alteryx Designer (Connect AI)
Build workflows to access live Sybase for self-service data analytics.
-
Integrate Open WebUI with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Square from within the chat interface.
-
How to Easily Query Sage 300 Data in OpenOffice Base
Connect to Sage 300 data in OpenOffice Base using the CData ODBC Driver for Sage 300 and generate reports with live data insights.
-
DataBind Controls to Bannerbear Data in C++Builder
DataBind to Bannerbear in C++Builder with standard components and controls.
-
Build SAS Data Sets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS Data Sets.
-
How to create SpaceX federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SpaceX in MySQL .
-
Integrating OpenCode Terminal with Hubstaff 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 Reckon Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon replication to SQL Server.
-
Use the CData Software ODBC Driver for ConvertKit in MicroStrategy Desktop
Connect to ConvertKit in MicroStrategy Desktop using the CData Software ODBC Driver for ConvertKit.
-
Bind Live Aweber Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Aweber data
-
Query Slack Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Slack entities in PHP by modeling them as objects.
-
Build Dashboards with Insightly Data in DBxtra
Create dynamic dashboards and perform analytics based on Insightly in DBxtra.
-
Use the CData Software ODBC Driver for Sugar CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Sugar CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sugar CRM.
-
Integrating Claude Code with Databricks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Databricks within assisted coding and automated development workflows.
-
Integrate MongoDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MongoDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MongoDB.
-
Connect to Zoho Books Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Real-Time Samanage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Samanage in ColdFusion.
-
How to Connect DBeaver to BigCommerce via a JDBC Driver
Manage BigCommerce with visual tools in DBeaver like the query browser.
-
Analyze ServiceNow Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ServiceNow and visualize live ServiceNow in Infragistics Reveal.
-
How to Work with Bullhorn CRM Data in ETL Validator JDBC
Connect to Bullhorn CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Billsby in MicroStrategy Desktop
Connect to Billsby in MicroStrategy Desktop using the CData Software ODBC Driver for Billsby.
-
Automated Continuous Shopify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Shopify replication to Amazon Redshift.
-
Build a PostgreSQL Interface for Rootly Data using the CData JDBC Driver
Use the Remoting features of the Rootly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Salesforce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use Agno to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Epicor Kinetic for you.
-
How to connect to SAP Netweaver Gateway Data from IntelliJ
Integrate connectivity to SAP Netweaver Gateway with wizards in IntelliJ.
-
Build Dashboards with Foursquare Data in DBxtra
Create dynamic dashboards and perform analytics based on Foursquare in DBxtra.
-
Connect to Reply.io Data in RapidMiner
Integrate Reply.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Bridge Google Calendar Connectivity with Apache NiFi
Access and process Google Calendar in Apache NiFi using the CData JDBC Driver.
-
How to connect SharePoint with Amazon S3 Data through external lists
Provide Amazon S3 to SharePoint users as an external list.
-
Connect to Telegram Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Telegram in the Denodo Virtual DataPort Administrator.
-
How to Connect DBeaver to Templated via a JDBC Driver
Manage Templated with visual tools in DBeaver like the query browser.
-
Automated Continuous Smartsheet Replication to SQL Server
Use CData Sync for automated, continuous, customizable Smartsheet replication to SQL Server.
-
Visualize Parquet 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 Apache Parquet into TIBCO Spotfire.
-
Integrate Real-Time Access to Google Drive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Drive in real time.
-
Connect to Zoho Books Data from a Connection Pool in JBoss
Integrate Zoho Books into Java servlets: Use the Management Console in JBoss to install the Zoho Books JDBC Driver.
-
Visualize Sentry Data in Sisense
Create an ElastiCube in Sisense app with access to Sentry.
-
Connect Deel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Deel using the CData Python MCP Server.
-
Integrate Real-Time Access to Elasticsearch in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Elasticsearch in real time.
-
Import Okta Data Using Azure Data Factory
Use CData Connect AI to connect to Okta Data from Azure Data Factory and import live Okta.
-
Migrating data from SAP Business One to Snowflake using CData SSIS Components.
Easily push SAP Business One to Snowflake using the CData SSIS Tasks for SAP Business One and Snowflake.
-
Visualize Todoist Data in Tableau
The CData ODBC driver for Todoist enables you integrate Todoist into Tableau dashboards.
-
Use the CData SSIS Components to Insert New or Update Existing MySQL Records from SQL Server
Easily push SQL Server data to MySQL using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MySQL or update existing records with data from a SQL Server database.
-
Automated Continuous HBase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HBase replication to Amazon Redshift.
-
Operational Reporting on SAP Business One Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business One.
-
Automated Continuous QuickBooks Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks replication to Vertica.
-
Integrating Codex CLI with ScrapingBee 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.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web
Connect to Salesforce Pardot in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.
-
Query OpenWeatherMap Data in ColdFusion
Write standard ColdFusion data access code to connect to OpenWeatherMap.
-
Automate Cassandra Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Cassandra replication to Couchbase.
-
How to Connect to Live HBase Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache HBase without replication.
-
Connect to DocuSign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from DocuSign, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Adobe Commerce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Azure SQL Database.
-
Import Real-Time Instagram Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Instagram in ColdFusion.
-
Use Azure AI Foundry to Talk to Your Pipedrive 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 Pipedrive for you.
-
How to Create Power BI Visual Reports with Real-Time Jumpseller Data
Use CData Power BI Connectors to visualize Jumpseller in Power BI.
-
Use Dash to Build to Web Apps on Amazon S3 Data
Create Python applications that use pandas and Dash to build Amazon S3-connected web apps.
-
How to Create Power BI Visual Reports with Real-Time Webex Data
Use CData Power BI Connectors to visualize Webex in Power BI.
-
Migrating data from Smartsheet to Google BigQuery using CData SSIS Components.
Easily push Smartsheet to Google BigQuery using the CData SSIS Tasks for Smartsheet and Google BigQuery.
-
Integrate with Live OneNote Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to OneNote from the MuleSoft Anypoint Platform to integrate live Microsoft OneNote into custom reports and dashboards.