CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with Excel Online Data through external lists
Provide Excel Online data to SharePoint users as an external list.
-
Work with Live Pipedrive Data in Power Query
Use CData Connect AI to connect to Pipedrive data and work with live Pipedrive data in Microsoft Power Query.
-
Validate Azure Synapse Data with QuerySurge
Access and validate Azure Synapse data in QuerySurge using the CData JDBC Driver.
-
Connect to Rebilly Data from a Connection Pool in JBoss
Integrate Rebilly data into Java servlets: Use the Management Console in JBoss to install the Rebilly JDBC Driver.
-
How to Connect DBeaver to Smartsheet via a JDBC Driver
Manage Smartsheet data with visual tools in DBeaver like the query browser.
-
Model GitLab Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GitLab, enabling the direct import of real-time GitLab data.
-
How to connect and process Paymo data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Paymo data.
-
Visualize Perigon 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 Perigon data into TIBCO Spotfire.
-
Connect to Azure Analysis Services Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Analysis Services as an External Source in Dremio.
-
Bind Live Azure Synapse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Synapse data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Replicate Act-On Data in Heroku for Use in Salesforce Connect
Replicate Act-On data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Visualize RSS Data in Python with pandas
Use pandas and other modules to analyze and visualize live RSS feeds in Python.
-
How to connect to Drip Data from IntelliJ
Integrate connectivity to Drip data with wizards in IntelliJ.
-
Automated Continuous CircleCI Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CircleCI replication to delimited files (CSV/TSV).
-
Explore Geographical Relationships in ZeroBounce Data with Power Map
Create data visualizations with ZeroBounce data in Power Map.
-
Access Live Tanda Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Tanda data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Work with Live Bullhorn CRM Data in Power Query
Use CData Connect AI to connect to Bullhorn CRM data and work with live Bullhorn CRM data in Microsoft Power Query.
-
Automated Continuous Salesloft Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon S3.
-
Integrate OpenCode with Live Procore Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Procore data from within your AI coding agent.
-
Connecting Moonlit Workflow with API 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 API data in real time.
-
How to connect to Salesloft Data with Squirrel SQL client
Connect to Salesloft data and execute queries in the Squirrel SQL Client.
-
Design BIRT Reports on AdRoll Data
Provide current AdRoll data to your embedded analytics.
-
Publish ShipEngine-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ShipEngine data.
-
How to Visualize Beeminder Data in Python with pandas
Use pandas and other modules to analyze and visualize live Beeminder data in Python.
-
Use Microsoft Copilot Studio to talk to your Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Zoho Inventory data for you.
-
Build Email Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Email data and build visualizations in Tableau.
-
Automated Continuous Amazon S3 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amazon S3 replication to SingleStore.
-
Connect to Datadog Data in RapidMiner
Integrate Datadog data with standard components and data source configuration wizards in RapidMiner Studio.
-
Deploy the ADO.NET Provider for SharePoint on an SSRS Report Server
Connect to SharePoint 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.
-
Publish Reports with Oracle Sales Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Sales data.
-
Access Live MYOB AccountRight Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to MYOB AccountRight data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Neo4J Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Neo4J from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Apps with Live Mailgun Data Using the Low-Code Development Platform of Mendix
Connect Mailgun data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Cline with Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesloft data from within your IDE.
-
Integrate xBase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live xBase data from Informatica Cloud.
-
Build an OLAP Cube in SSAS from PhantomBuster Data
Establish a connection to PhantomBuster data data from SQL Server Analysis Services, and use the PhantomBuster Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Google Campaign Manager 360 Data in Coginiti Pro
Connect to and query live Google Campaign Manager 360 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Bugsnag with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bugsnag with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bugsnag data.
-
Migrating data from Marketo to Databricks using CData SSIS Components.
Easily push Marketo data to Databricks using the CData SSIS Tasks for Marketo and Databricks.
-
How to load Sendwithus data into Elasticsearch via Logstash
Introducing a simple method to load Sendwithus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect Flowise AI Agents to Live Sage Intacct 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 Sage Intacct data without replication.
-
Automated Continuous Zoho Projects Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Projects replication to SingleStore.
-
How to Query Auth0 Data in MySQL Workbench
Execute MySQL queries against live Auth0 data from MySQL Workbench.
-
Query ConvertAPI Data in ColdFusion
Write standard ColdFusion data access code to connect to ConvertAPI data.
-
Connect to HDFS Data in Aqua Data Studio
Access HDFS data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Moosend Data in Google Apps Script via Connect AI
Use CData Connect AI to access Moosend data in Google Apps Script.
-
Query eBay Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against eBay Analytics data from Node.js.
-
Automated Continuous Auth0 Replication to Databricks
Use CData Sync for automated, continuous, customizable Auth0 replication to Databricks.
-
Use JayDeBeApi to access Rebilly Data in Python
Use standard Python scripting and the development environment of your choice to access live Rebilly data.
-
Automated Continuous Google Directory Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Directory replication to Vertica.
-
How to Connect to Live SAP Business One 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 SAP Business One data for you.
-
Automated Continuous Google Translate Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Translate replication to Amazon S3.
-
Getting Started with the CData ODBC Driver for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dynamics CRM.
-
Access ZohoDesk Data from MySQL in Amazon QuickSight
Connect to ZohoDesk and build visualizations of ZohoDesk data using a MySQL Connection in Amazon QuickSight.
-
Access Microsoft Ads Data from MySQL in PHP
Connect to Microsoft Ads through the standard MySQL libraries in PHP.
-
How to Connect to & Open QuickBooks Time Data in Microsoft Excel
This article uses the CData ODBC driver for QuickBooks Time to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Elorus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Elorus facts in real time.
-
Automated Continuous Gorgias Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Gorgias replication to Apache Cassandra.
-
Integrating Boomi Agentstudio with Sendwithus Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sendwithus data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Viewing Sentry Data in RAD Studio Data Explorer
How to view Sentry data in RAD Studio Data Explorer using the CData ODBC Driver for Sentry.
-
Access Live Zoho CRM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Zoho CRM data through MCP integration.
-
Replicate Multiple MessageBird Accounts
Replicate multiple MessageBird accounts to one or many databases.
-
Create Data Visualizations in Cognos BI with Clockify Data
Access Clockify data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Certinia Data from AWS Glue
Use CData Connect AI to gain access to live Certinia data from your AWS Glue jobs.
-
Integrate ChargeOver Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ChargeOver data from Informatica Cloud.
-
Use Biml to Build SSIS Tasks to Replicate Discourse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Discourse data to SQL Server.
-
How to Visualize Pinecone Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pinecone data in Python.
-
How to create JSON federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JSON services in MySQL .
-
Automate Google Forms Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Forms data replication to Azure Synapse.
-
How to Connect to Live NetSuite Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live NetSuite data securely in real time.
-
Connect to Google Translate Data in HULFT Integrate
Connect to Google Translate as a JDBC data source in HULFT Integrate
-
Analyze Google Sheets Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Sheets data and visualize Google Sheets data in SAP Analytics Cloud.
-
Connect Beeminder Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Beeminder data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bridge Anaplan Connectivity with Apache NiFi
Access and process Anaplan data in Apache NiFi using the CData JDBC Driver.
-
Consume SQL Server OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SQL Server feeds that reflect any changes in SAP Lumira.
-
Integrate Pingdom Data in Pentaho Data Integration
Build ETL pipelines based on Pingdom data in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy
Connect to Harvest data in MicroStrategy Developer using the CData Software ODBC Driver for Harvest.
-
Connect to Planio Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Planio.
-
Deploy the ADO.NET Provider for Lakebase on an SSRS Report Server
Connect to Lakebase 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.
-
How to Visualize Marketo Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Marketo data in Python.
-
Visualize Sugar CRM Data in TIBCO Spotfire through ADO.NET
Integrate Sugar CRM data into dashboards in TIBCO Spotfire.
-
Explore Geographical Relationships in ZarMoney Data with Power Map
Create data visualizations with ZarMoney data in Power Map.
-
How to load Adobe Experience Manager data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Experience Manager data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Sage Cloud Accounting Data Replication to SAP HANA
Use CData Sync to customize and automate Sage Cloud Accounting data replication to SAP HANA.
-
Establish a Live Connection with BigQuery Data using Tableau Bridge
The CData ODBC Driver for BigQuery enables you to integrate live BigQuery data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live Zoho Projects Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Projects data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating GitHub Copilot with JobNimbus 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.
-
Create Power BI Reports on Real-Time Google Forms Data
Use the CData ODBC Driver for Google Forms to visualize Google Forms data in Power BI Desktop.
-
Connect to Avro Data in DBArtisan
Use wizards in DBArtisan to configure Avro data as a data source.
-
Build Salesforce Data 360-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce Data 360 data.
-
How to update Oracle Sales from Excel
This article explains how to transfer data from Excel to Oracle Sales using the Excel Add-In for Oracle Sales.
-
Use Agno to Talk to Your Sage Intacct 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 Sage Intacct data for you.
-
Operational Reporting on ZeroBounce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZeroBounce data.
-
Connect to and Query ConvertAPI Data in QlikView over ODBC
Create data visualizations with ConvertAPI data in QlikView.
-
Build Discord-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 Discord data without replication.
-
Validate Sendwithus Data with QuerySurge
Access and validate Sendwithus data in QuerySurge using the CData JDBC Driver.
-
Build AI/ML Models with Live Google Tasks Data using Dataiku
Connect Google Tasks Data with Dataiku using the CData API Driver for JDBC.
-
Analyze JotForm Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JotForm data with the CData JDBC Driver for JotForm.
-
Integrate Onfleet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Onfleet with External Services.
-
Connect to Live Oracle Financials Cloud Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Financials Cloud Data in CData Connect AI and connect to your Oracle Financials Cloud data from MicroStrategy.