CData Software - Knowledge Base
Recent Articles
-
Import and Visualize Microsoft Planner Data in Power View
Create data visualizations based on Microsoft Planner in Excel.
-
Deploy the ADO.NET Provider for Grafana on an SSRS Report Server
Connect to Grafana 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.
-
Connect to Mistral AI Data in HULFT Integrate
Connect to Mistral AI as a JDBC data source in HULFT Integrate
-
Bind Live Azure Analysis Services Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Analysis Services data
-
Connect to SAP ByDesign Data in Ruby
Connect to SAP Business ByDesign in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations Based On Zuora Data in Mode
Use CData Connect AI to connect to Zuora Data from Mode and build visualizations using live
-
Webflow Reporting in OBIEE with the Webflow JDBC Driver
Deploy the Webflow JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Connect AI Python SDK for Sage Intacct
Install the CData Connect AI Python SDK to read and write live Sage Intacct with standard DB-API 2.0 Python code.
-
Automated Continuous Facebook Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Snowflake.
-
Getting Started with the CData Tableau Connector for Freshsales
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous eBay Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable eBay replication to Google BigQuery.
-
Connect to Amazon DynamoDB Data in DBArtisan
Use wizards in DBArtisan to configure Amazon DynamoDB as a data source.
-
Getting Started with the CData Power BI Connector for WordPress
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for WordPress.
-
Visualize Teamwork Data in Tableau
The CData ODBC driver for Teamwork enables you integrate Teamwork into Tableau dashboards.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Xero Accounting using the Model Context Protocol.
-
Visualize CockroachDB Data in Tableau
The CData ODBC driver for CockroachDB enables you integrate CockroachDB into Tableau dashboards.
-
Query Jira Assets Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Jira Assets from Node.js.
-
Create MySQL Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MySQL from PowerBI.com to create Power BI Dataflows with real-time data.
-
Stream Adobe Analytics Data into Apache Kafka Topics
Access and stream Adobe Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Seamlessly Import BambooHR Data into IBM SPSS Modeler
Integrate BambooHR data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Perform Batch Operations with Slack Data in Apache NiFi
Connect to Slack and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build AI Agents with Dynamics 365 Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft Dynamics 365 through CData Connect AI.
-
Connect to SAP SuccessFactors Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP SuccessFactors.
-
Connect to Real-Time Google Ad Manager Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Ad Manager and Dataflow to import and use Google Ad Manager in Power Apps.
-
Connect to Simplesat Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Simplesat in the Denodo Virtual DataPort Administrator.
-
Build Voice Agents in ElevenLabs with access to Live EnterpriseDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live EnterpriseDB.
-
Connecting Moonlit Workflow with CouchDB 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 Apache CouchDB in real time.
-
Connect to Greenplum Data from AWS Glue
Use CData Connect AI to gain access to live Pivotal GreenPlum from your AWS Glue jobs.
-
MarkLogic: SQL-NOCOLUMN: Column Not Found Error
In this entry you will find information relating to MarkLogic's "SQL-NOCOLUMN" error.
-
Validate HubSpot Data with QuerySurge
Access and validate HubSpot in QuerySurge using the CData JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Creator Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Creator.
-
DataBind Controls to MessageBird Data in Delphi
DataBind to MessageBird in Delphi with standard data access components and controls.
-
How to integrate Amazon Athena with Apache Airflow
Access and process Amazon Athena in Apache Airflow using the CData JDBC Driver.
-
LINQ to Procore 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 Procore Data Provider.
-
A PostgreSQL Interface for Cloudant Data using the CData ODBC Driver
Use the SQL Gateway and Cloudant ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Cloudant Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cloudant Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Natively Connect to Rootly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Rootly. Leverage the native support for ODBC in PHP.
-
Replicate Multiple Aircall Accounts
Replicate multiple Aircall accounts to one or many databases.
-
Import and Visualize Unbounce Data in Power View
Create data visualizations based on Unbounce in Excel.
-
Query TigerGraph Data in DataGrip
Create a Data Source for TigerGraph in DataGrip and use SQL to query live TigerGraph.
-
Automated Continuous REST Replication to IBM DB2
Use CData Sync for automated, continuous, customizable REST replication to IBM DB2.
-
Use JayDeBeApi to access Dropbox Data in Python
Use standard Python scripting and the development environment of your choice to access live Dropbox.
-
How to Connect to & Open AgileCRM Data in Microsoft Excel
This article uses the CData ODBC driver for AgileCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Visualize Salesforce Pardot Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Pardot in Python.
-
Import and Visualize Close Data in Power View
Create data visualizations based on Close in Excel.
-
How to create Datadog federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Datadog in MySQL .
-
Publish Reports with Productboard Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Productboard.
-
Use ChatGPT to Talk to Your EnterpriseDB 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 EnterpriseDB for you.
-
How to Create Power BI Visual Reports with Real-Time Unbounce Data
Use CData Power BI Connectors to visualize Unbounce in Power BI.
-
Replicate Unbounce Data from PowerShell
Write a quick PowerShell script to query Unbounce. Use connectivity to the live data to replicate Unbounce to SQL Server.
-
Connect to Sybase in SpagoBI
Create reports featuring live Sybase in SpagoBI Studio. Host Sybase reports on SpagoBI Server.
-
Use Microsoft Copilot Studio to talk to your Tally 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 Tally ERP for you.
-
Prepare, Blend, and Analyze Zoho CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho CRM for self-service data analytics.
-
Connect to Teamgate Data from PowerBuilder via ADO.NET
This article demonstrates how to access Teamgate from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Workable Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Workable facts in real time.
-
Integrating LangGraph with QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on QuickBooks Time within automated workflows.
-
Design BIRT Reports on SFTP Data
Provide current SFTP to your embedded analytics.
-
How to Access Live Google Ad Manager Data in Visual Studio Code via Cline
Run CData MCP Server for Google Ad Manager on Windows Subsytem for Linux (WSL) and connect to live Google Ad Manager from the Cline extension in Visual Studio Code.
-
Working with Deel Data in LINQPad
Execute LINQ queries to Deel in LINQPad.
-
Use Biml to Build SSIS Tasks to Replicate FreshBooks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FreshBooks to SQL Server.
-
Invoiced Reporting in OBIEE with the Invoiced JDBC Driver
Deploy the Invoiced JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate LinkedIn Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate LinkedIn Ads replication to Azure Data Lake.
-
Integrate Theia IDE with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Import Real-Time PayPal Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PayPal in ColdFusion.
-
Automated Microsoft Dataverse Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Dataverse (CDS) replication to Teradata.
-
Connect Azure Table Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Table Storage using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Pipeline CRM Data Replication to Teradata
Use CData Sync to Customize and automate Pipeline CRM replication to Teradata.
-
Connect to VWO Data in RapidMiner
Integrate VWO with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Twilio Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Twilio.
-
Prepare, Blend, and Analyze NetSuite SuiteAnalytics Data in Alteryx Designer (Connect AI)
Build workflows to access live NetSuite SuiteAnalytics for self-service data analytics.
-
Build Dashboards with Missive Data in DBxtra
Create dynamic dashboards and perform analytics based on Missive in DBxtra.
-
How to load ScrapingBee data into Elasticsearch via Logstash
Introducing a simple method to load ScrapingBee data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Grok to Talk to Your Amazon DynamoDB 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 Amazon DynamoDB for you.
-
Rapidly Develop Tavily-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 Tavily.
-
Analyze Live Avalara AvaTax Data in SAS Viya
Use CData Connect AI to connect to Avalara AvaTax from SAS Viya and deploy self-service analytics using live Avalara AvaTax.
-
How to Use a Microsoft Access Database to Update SQL Server Data in Real Time
Update SQL Server data by creating a linked table in Microsoft Access with the CData SQL Server ODBC Driver.
-
Automated Continuous Quickbase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Quickbase replication to PostgreSQL.
-
How to Seamlessly Import Sage Intacct Data into IBM SPSS Modeler
Integrate Sage Intacct data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with Quickbase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Quickbase in SnapLogic.
-
Connect to Jira Assets Data in RapidMiner
Integrate Jira Assets with standard components and data source configuration wizards in RapidMiner Studio.
-
Import and Visualize Scrapfly Data in Power View
Create data visualizations based on Scrapfly in Excel.
-
Integrate with Qualaroo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Qualaroo to a JSON file on disk.
-
Integrating OpenCode Terminal with Oracle Financials Cloud 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.
-
How to import Typeform Data into Apache Solr
Use the CData Software JDBC Driver for Typeform in Data Import Handler and create an automated import of Typeform to Apache Solr Enterprise Search platform.
-
Integrate with Live Redis Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Redis from the MuleSoft Anypoint Platform to integrate live Redis into custom reports and dashboards.
-
How to connect to Pipeline CRM Data from IntelliJ
Integrate connectivity to Pipeline CRM with wizards in IntelliJ.
-
Replicate Zoho CRM Data in Heroku for Use in Salesforce Connect
Replicate Zoho CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from Apollo to Google BigQuery using CData SSIS Components.
Easily push Apollo to Google BigQuery using the CData SSIS Tasks for Apollo and Google BigQuery.
-
Excel Spreadsheet Automation on SAP SuccessFactors Data with the QUERY Formula
Pull data from SAP SuccessFactors, automate spreadsheets, and more with the QUERY formula.
-
Use Grok to Talk to Your Sybase IQ 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 Sybase IQ for you.
-
Use Biml to Build SSIS Tasks to Replicate Gumroad Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Gumroad to SQL Server.
-
Design BIRT Reports on Amazon Athena Data
Provide current Amazon Athena to your embedded analytics.
-
Build a Singer.io Tap for SharePoint Excel Services With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SharePoint Excel Services data using
-
Extract, Transform, and Load Act-On Data in Informatica PowerCenter
Create a simple Workflow for Act-On in Informatica PowerCenter.
-
Publish Cosmos DB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Cosmos DB.
-
Build Smartsheet-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Smartsheet to explore live Smartsheet Data in Gemini Code Assist to assist with building Smartsheet-powered applications.
-
Connect to Snowflake Data in ACL Analytics
Connect to Snowflake via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Snowflake.
-
Getting Started with the CData JDBC Driver for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SurveyMonkey.
-
How to Connect to Live Okta Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Okta for you.
-
Integrating OpenCode Terminal with SAP 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.