CData Software - Knowledge Base
Recent Articles
-
How to update NetSuite from Excel
This article explains how to transfer data from Excel to NetSuite using the Excel Add-In for NetSuite.
-
Rapidly Develop Rootly-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 Rootly.
-
Automated Continuous JobNimbus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable JobNimbus replication to Azure SQL Database.
-
Excel Spreadsheet Automation on Google Sheets Data with the QUERY Formula
Pull data from Google Sheets, automate spreadsheets, and more with the QUERY formula.
-
Rapidly Develop Zoho Inventory-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 Zoho Inventory.
-
Working with Gorgias Data in LINQPad
Execute LINQ queries to Gorgias data in LINQPad.
-
Publish Reports with GitLab Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitLab data.
-
Integrating OpenCode with Shortcut 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.
-
Getting Started with the CData Tableau Connector for Okta
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Okta.
-
Automated Instagram Data Replication to Teradata
Use CData Sync to Customize and automate Instagram data replication to Teradata.
-
Create Data Visualizations Based On Slack Data in Mode
Use CData Connect AI to connect to Slack Data from Mode and build visualizations using live Slack data.
-
How to Build an ETL App for Zoom Data in Python with CData Connect AI
Extract and transform live Zoom data in Python with petl and the CData Connect AI Python SDK.
-
Integrate CloudConvert Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CloudConvert data from Informatica Cloud.
-
Automated Continuous IBM Informix Replication to Amazon S3
Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon S3.
-
Validate TigerGraph Data with QuerySurge
Access and validate TigerGraph data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Zoho Creator Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Creator replication to PostgreSQL.
-
Access Live Data in AWS Batch Using CData JDBC Drivers
Learn how to build a containerized Java batch job that queries live Salesforce data using the CData JDBC Driver, push it to Amazon ECR, and schedule it with AWS Batch.
-
Use Dash to Build to Web Apps on Zoom Data
Create Python applications that use pandas and Dash to build Zoom-connected web apps.
-
Connect to SAP Business One Data from AWS Glue
Use CData Connect AI to gain access to live SAP Business One data from your AWS Glue jobs.
-
Build Apps with Live Google Contacts Data Using the Low-Code Development Platform of Mendix
Connect Google Contacts data with Mendix to build apps using the CData JDBC Driver for Google Contacts.
-
Build Klipfolio-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 Klipfolio data without replication.
-
Access Live TaxJar Data in AWS Lambda
Connect to live TaxJar data in AWS Lambda using the CData JDBC Driver.
-
Feed BigQuery Data into FineReport
How to set BigQuery data as a JDBC data source in FineReport.
-
Replicate Multiple AgileCRM Accounts
Replicate multiple AgileCRM accounts to one or many databases.
-
How to Seamlessly Import Ontraport Data into IBM SPSS Modeler
Integrate Ontraport data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Productboard Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Productboard replication to Google Cloud SQL.
-
Use the CData ODBC Driver for Microsoft Teams from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Teams to connect to Microsoft Teams data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Teams data in Excel.
-
Operational Reporting on DB2 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote DB2 data.
-
Access Datadog Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Datadog data from your Oracle system.
-
Visualize SAP Ariba Source Data in Tableau
The CData ODBC driver for SAP Ariba Source enables you integrate SAP Ariba Source data into Tableau dashboards.
-
Migrating data from Calendly to Snowflake using CData SSIS Components.
Easily push Calendly data to Snowflake using the CData SSIS Tasks for Calendly and Snowflake.
-
Feed Simplesat Data into FineReport
How to set Simplesat data as a JDBC data source in FineReport.
-
Connect to VWO Data in JRuby
Create a simple JRuby app with access to live VWO data.
-
Create SSAS Tabular Models from PolarTeamPro Data
How to build a SQL Server Analysis Service Tabular Model from PolarTeamPro data using CData drivers.
-
Integrate Google's Antigravity Agent with Live Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Grafana data using the Model Context Protocol.
-
How to connect Amazon QuickSight to Twitter Ads Data
Create a connection to Twitter Ads data in CData Connect AI and insert Twitter Ads data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Agents in Relevance AI with Access to Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zuora data within intelligent agent workflows.
-
Build a PostgreSQL Interface for SQL Server Data using the CData JDBC Driver
Use the Remoting features of the SQL Server JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Greenhouse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Greenhouse data using standard SQL.
-
Getting Started with the CData Python Connector for Twitter Ads
Learn to install and license the CData Python Connector and configure a connection to live Twitter Ads data.
-
Use the CData Software ODBC Driver for PhantomBuster in MicroStrategy Web
Connect to PhantomBuster data in MicroStrategy Web using the CData Software ODBC Driver for PhantomBuster.
-
Connect to Salesforce Marketing Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce Marketing data.
-
Integrate Cline with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live OneNote data from within your IDE.
-
Connecting Moonlit Workflow with Wave Financial 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 Wave Financial data in real time.
-
Query Keap Data as a MySQL Database in Node.js
Execute MySQL queries against Keap data from Node.js.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy Web
Connect to ZohoSubscriptions data in MicroStrategy Web using the CData Software JDBC Driver for ZohoSubscriptions.
-
Feed Greenplum Data into FineReport
How to set Greenplum data as a JDBC data source in FineReport.
-
Automated Continuous Teradata Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teradata replication to Google Cloud SQL.
-
Integrating Codex with Quickbase 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.
-
Load Asana Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Asana data to a database.
-
Integrate Aircall Data in Pentaho Data Integration
Build ETL pipelines based on Aircall data in the Pentaho Data Integration tool.
-
Connect to Microsoft Teams Data in Aqua Data Studio
Access Microsoft Teams data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to integrate Webex with Apache Airflow
Access and process Webex data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CapsuleCRM.
-
How to Create Power BI Visual Reports with Real-Time Billsby Data
Use CData Power BI Connectors to visualize Billsby data in Power BI.
-
Integrating Antigravity CLI with RabbitMQ data via CData CLI
Connect RabbitMQ data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Back Up Supabase data 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 Supabase data data.
-
Analyze Quickbase Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Quickbase data and visualize Quickbase data in SAP Analytics Cloud.
-
Access Live Square Data in AWS Lambda
Connect to live Square data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Accelo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Accelo replication to SQL Server.
-
A PostgreSQL Interface for Sybase Data using the CData ODBC Driver
Use the SQL Gateway and Sybase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate Mocean Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mocean data to SQL Server.
-
Visualize SharePoint Excel Services Data in Tableau
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services data into Tableau dashboards.
-
Natively Connect to Mixpanel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mixpanel data. Leverage the native support for ODBC in PHP.
-
Use JayDeBeApi to access Close Data in Python
Use standard Python scripting and the development environment of your choice to access live Close data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amazon Athena
Provide connectivity to Amazon Athena data through an SAP BusinessObjects universe.
-
How to Work with SQL Analysis Services Data in ETL Validator JDBC
Connect to SQL Analysis Services from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous SharePoint Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SharePoint replication to delimited files (CSV/TSV).
-
Extract, Transform, and Load Beeminder Data in Informatica PowerCenter
Create a simple Workflow for Beeminder data in Informatica PowerCenter.
-
How to Access Live SparkPost Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SparkPost enables you to integrate SparkPost data into workflows built using Microsoft Power Automate Desktop.
-
How to connect to JotForm Data with Squirrel SQL client
Connect to JotForm data and execute queries in the Squirrel SQL Client.
-
DataBind Controls to SageHR Data in Delphi
DataBind to SageHR data in Delphi with standard data access components and controls.
-
How to create Oracle HCM Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle HCM Cloud data in MySQL .
-
Process & Analyze EmailOctopus Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live EmailOctopus Data.
-
Use ChatGPT to Talk to Your Zoho CRM 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 Zoho CRM data for you.
-
Connect to Apify Data from HeidiSQL
Use CData Connect AI to connect to and query live Apify data from HeidiSQL.
-
How to Work with Planio Data in AWS Glue Jobs Using JDBC
Connect to Planio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to and Query Sage 200 Data in QlikView over ODBC
Create data visualizations with Sage 200 data in QlikView.
-
Create Dynamic Twilio Grids Using the Infragistics XamDataGrid
Learn how you can connect Twilio to Infragistics XamDataGrid to build dynamic grids.
-
Create PingOne-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to PingOne Data from Klipfolio and build custom visualizations using live PingOne data.
-
Access Live ZohoMarketingHub Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ZohoMarketingHub data through MCP integration.
-
Automated Continuous ScrapingBee Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Azure SQL Database.
-
Prepare, Blend, and Analyze Productboard Data in Alteryx Designer (ODBC)
Build workflows to access live Productboard data for self-service data analytics.
-
Automate Basecamp Data Replication to Couchbase
Use CData Sync to Customize and automate Basecamp data replication to Couchbase.
-
How to Connect Flowise AI Agents to Live XML 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 XML data without replication.
-
Connect Paylocity to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Paylocity data using the CData Python MCP Server.
-
Getting Started with the CData ADO.NET Provider for Mouseflow
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Publish Reports with ZohoSubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoSubscriptions data.
-
Connect to Dropbox Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dropbox Data and connect to Dropbox data in Akorbi Digital RunMyProcess.
-
Connect to and Visualize Live Sage Cloud Accounting Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage Cloud Accounting data.
-
Build Data Flows from SQL Server to Dynamics CRM through SSIS
Easily push SQL Server data to Dynamics CRM using the CData SSIS Tasks for Dynamics CRM.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Datadog
Provide connectivity to Datadog data through an SAP BusinessObjects universe.
-
Getting Started with the CData Python Connector for Dynamics CRM
Learn to install and license the CData Python Connector and configure a connection to live Dynamics CRM data.
-
Create Data Visualizations Based On Aweber Data in Mode
Use CData Connect AI to connect to Aweber Data from Mode and build visualizations using live Aweber data.
-
Build AI/ML Models with Live AlloyDB Data using Dataiku
Connect AlloyDB Data with Dataiku using the CData JDBC Driver for AlloyDB.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy Desktop
Connect to Jira data in MicroStrategy Desktop using the CData Software ODBC Driver for Jira.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Quaderno
Provide connectivity to Quaderno data through an SAP BusinessObjects universe.
-
Integrate Deel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Deel with External Services.
-
Integrate Devin with Live Google Search 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 Google Search results.
-
Visualize Placid Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Placid data.