CData Software - Knowledge Base
Recent Articles
-
Connect to Insightly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Insightly in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Trello Replication to SingleStore
Use CData Sync for automated, continuous, customizable Trello replication to SingleStore.
-
Getting Started with the CData ODBC Driver for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for eBay Analytics.
-
Automate SAP BusinessObjects BI Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP BusinessObjects BI and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate Guru Data in the Pentaho Report Designer
Publish reports based on Guru in the Pentaho BI tool.
-
Visualize Adobe Experience Manager 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 Adobe Experience Manager into TIBCO Spotfire.
-
How to create Aweber federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aweber in MySQL .
-
Deploy the ADO.NET Provider for Apify on an SSRS Report Server
Connect to Apify 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.
-
Integrating Gumloop with Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon DynamoDB within automated workflows.
-
Integrate with Dynamics CRM Data in JReport Designer
Create charts and reports based on Microsoft Dynamics CRM in JReport Designer.
-
Editing API Driver API Profiles
Edit existing API Profiles to enable more SQL access to APIs.
-
Excel Spreadsheet Automation on Adobe Target Data with the QUERY Formula
Pull data from Adobe Target, automate spreadsheets, and more with the QUERY formula.
-
Visualize Email Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Email.
-
Query SAP BusinessObjects BI Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP BusinessObjects BI from Node.js.
-
How to Query Exact Online Data in MySQL Workbench
Execute MySQL queries against live Exact Online from MySQL Workbench.
-
Access Sugar CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sugar CRM from HeidiSQL.
-
A PostgreSQL Interface for PivotalTracker Data (MySQL Remoting via JDBC)
Use the Remoting features of the PivotalTracker JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Redis Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Redis from Informatica Cloud.
-
Trigger Google Directory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Directory with standard wizards in Logic Apps.
-
Feed Attio Data into FineReport
How to set Attio as a JDBC data source in FineReport.
-
Connect to Zoho Projects Data from a Connection Pool in JBoss
Integrate Zoho Projects into Java servlets: Use the Management Console in JBoss to install the Zoho Projects JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Rootly
Create an ODBC connection to Rootly in Informatica and browse and transfer Rootly.
-
How to Connect to & Open LDAP Objects in Microsoft Excel
This article uses the CData ODBC driver for LDAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import and Visualize MailerSend Data in Power View
Create data visualizations based on MailerSend in Excel.
-
Build Charts with BigCommerce Data in Clear Analytics
Create dynamic charts and perform analytics based on BigCommerce in Clear Analytics.
-
Automate Acumatica Data Replication to Azure Data Lake
Use CData Sync to customize and automate Acumatica ERP replication to Azure Data Lake.
-
Import and Visualize Calendly Data in Power View
Create data visualizations based on Calendly in Excel.
-
Getting Started with the CData Excel Add-In for Vimeo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vimeo.
-
Integrate Live Cosmos DB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Cosmos DB to Blue Prism using the CData ODBC Driver for Cosmos DB to create automated workflows for repetitive business tasks.
-
Connect to Quickbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Operational Reporting on Vercel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vercel.
-
Connect to Jira Assets Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Jira Assets.
-
Access Live Telegram Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Telegram in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Viewing Autopilot Data in RAD Studio Data Explorer
How to view Autopilot in RAD Studio Data Explorer using the CData ODBC Driver for Autopilot.
-
Connect to Cloudflare from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cloudflare to connect to Cloudflare from Web applications running on WebLogic.
-
How to integrate CircleCI with Apache Airflow
Access and process CircleCI in Apache Airflow using the CData JDBC Driver.
-
Extend Google Sheets with MarkLogic Data
Make calls to MarkLogic from Google Apps Script via the API Server.
-
Query QuickBooks Online Data from Node.js
Use the OData endpoint of the CData API Server to connect to your QuickBooks Online and perform CRUD operations on QuickBooks Online from Node.js.
-
How to Connect to Live Azure Synapse 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 Azure Synapse through natural language.
-
Visualize Greenplum Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pivotal GreenPlum.
-
How to use SQLAlchemy ORM to access Excel Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Excel Online.
-
Build a Singer.io Tap for HDFS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HDFS data using
-
Build AI/ML Models with Live Elasticsearch Data using Dataiku
Connect Elasticsearch Data with Dataiku using the CData JDBC Driver for Elasticsearch.
-
Integrating Claude Code with Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Spanner within assisted coding and automated development workflows.
-
Connect to Omnisend Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Omnisend to connect to Omnisend and execute queries in PowerBuilder.
-
Connect to Stripe Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Stripe using standard SQL.
-
Design BIRT Reports on SAP ByDesign Data
Provide current SAP Business ByDesign to your embedded analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Short.io
Provide connectivity to Short.io through an SAP BusinessObjects universe.
-
How to Import Data from SAP Business Warehouse into Google Sheets
Import SAP Business Warehouse into a Google spreadsheet that is automatically refreshed.
-
Integrate REST Data in the Pentaho Report Designer
Publish reports based on REST in the Pentaho BI tool.
-
Access Live CouchDB 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 Apache CouchDB through MCP integration.
-
Building Dynamic Web Pages with Oracle Eloqua Data Using AngularJS
Create single-page applications with live connectivity to Oracle Eloqua using the CData API Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Landbot to Power BI dashboards. Simply drag and drop Landbot into data visuals on the Power BI canvas.
-
Visualize Coinbase Data in Sisense
Create an ElastiCube in Sisense app with access to Coinbase.
-
Getting Started with the CData Excel Add-In for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CapsuleCRM.
-
How to Connect DBeaver to Microsoft Dataverse via a JDBC Driver
Manage Microsoft Dataverse (CDS) with visual tools in DBeaver like the query browser.
-
How to Connect to Facebook Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook Ads. Leverage the pyodbc module for ODBC in Python.
-
Build Cosmos DB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Cosmos DB and build Cosmos DB-connected web apps with Axios.
-
Integrating Boomi Agentstudio with Microsoft Exchange Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Exchange, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Add PhantomBuster Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PhantomBuster with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query, Visualize, and Share live Snowflake Data in Redash
Use CData Connect AI to connect to live Snowflake in Redash for querying, visualizing, and sharing.
-
How to create an RPA flow for Email Data in UiPath Studio
Use the Email ODBC Driver to create workflows that access real-time Email without any coding.
-
DataBind ClickTime Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ClickTime to a chart.
-
Publish Factorial-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Factorial.
-
Build Workable-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workable and build web apps with connectivity to live Workable.
-
Replicate Vimeo Data from PowerShell
Write a quick PowerShell script to query Vimeo. Use connectivity to the live data to replicate Vimeo to SQL Server.
-
DataBind Controls to DocuSign Data in C++Builder
DataBind to DocuSign in C++Builder with standard components and controls.
-
Connect to SAP Ariba Source Data from AWS Glue
Use CData Connect AI to gain access to live SAP Ariba Source from your AWS Glue jobs.
-
Object-Relational Mapping (ORM) with Spark Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apache Spark SQL into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for BenchmarkEmail Data (MySQL Remoting via JDBC)
Use the Remoting features of the BenchmarkEmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Quaderno Data dashboards with Tableau Server
The CData ODBC driver for Quaderno enables you integrate Quaderno into Tableau dashboards.
-
Connect to Moosend Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Moosend and work with Moosend in your FileMaker applications.
-
How to Connect to & Open SendGrid Data in Microsoft Excel
This article uses the CData ODBC driver for SendGrid to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Outreach.io 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 Outreach.io through MCP integration.
-
Automate LightSpeedRetail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LightSpeedRetail from PowerShell? This article demonstrates how to utilize the LightSpeedRetail Cmdlets for tasks like connecting to LightSpeedRetail, automating operations, downloading data, and more.
-
Connect to Xero Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Xero Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Create Power BI Visual Reports with Real-Time ZohoExpense Data
Use CData Power BI Connectors to visualize ZohoExpense in Power BI.
-
Presto Reporting in OBIEE with the Presto JDBC Driver
Deploy the Presto JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Adobe Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Choosing the Best Method to Connect Tickspot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tickspot from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous WordPress Replication to IBM DB2
Use CData Sync for automated, continuous, customizable WordPress replication to IBM DB2.
-
Integrating Cursor CLI with Intercom 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 Connect to Live Google Ad Manager 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 Google Ad Manager for you.
-
How to import Raisers Edge NXT Data into Apache Solr
Use the CData Software JDBC Driver for Raisers Edge NXT in Data Import Handler and create an automated import of Raisers Edge NXT to Apache Solr Enterprise Search platform.
-
How to connect to SendGrid Data in DBVisualizer
Integrate SendGrid with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Unbounce in SAS for Real-Time Reporting and Analytics
Connect to real-time Unbounce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Unbounce.
-
Connect to Freshdesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshdesk from Appeon PowerBuilder using the CData ADO.NET Provider for Freshdesk.
-
Build Apps with Live MailerSend Data Using the Low-Code Development Platform of Mendix
Connect MailerSend with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous FormSite Replication to Oracle
Use CData Sync for automated, continuous, customizable FormSite replication to Oracle.
-
Use Dash to Build to Web Apps on Tally Data
Create Python applications that use pandas and Dash to build Tally-connected web apps.
-
Integrate PagerDuty Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PagerDuty from Informatica Cloud.
-
Work with Live QuickBooks Online Data in Power Query
Use CData Connect AI to connect to QuickBooks Online and work with live QuickBooks Online in Microsoft Power Query.
-
Analyze Hubstaff Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hubstaff from Power Pivot. You will use the Table Import Wizard to load Hubstaff. You can visually build the import query or use any SQL supported by the driver.
-
Publish Reports with Unbounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce.
-
Integrate LibreChat with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Acumatica ERP from within the chat interface.
-
Automated Continuous CData Connect AI Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Amazon S3.
-
Access Testmonitor 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 Testmonitor.
-
Create Zoho CRM-Connected Business Apps in AppSheet
Connect to Zoho CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho CRM.
-
Connect ActiveCampaign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ActiveCampaign using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Klipfolio from Asprova with CData Software ODBC Driver for Klipfolio
This article shows how to connect faster to Klipfolio data from Asprova.