CData Software - Knowledge Base
Recent Articles
-
Integrating Boomi Agentstudio with Workday Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Workday, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create a Data Access Object for Drift Data using JDBI
A brief overview of creating a SQL Object API for Drift in JDBI.
-
Getting Started with the CData SSIS Components for QuickBooks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for QuickBooks.
-
How to create an RPA flow for SAS Data Sets Data in UiPath Studio
Use the SAS Data Sets ODBC Driver to create workflows that access real-time SAS Data Sets without any coding.
-
Connect to JotForm Data in HULFT Integrate
Connect to JotForm as a JDBC data source in HULFT Integrate
-
Build an OLAP Cube in SSAS from Float Data
Establish a connection to Float data from SQL Server Analysis Services, and use the Float Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Rebilly Data in DataGrip
Create a Data Source for Rebilly in DataGrip and use SQL to query live Rebilly.
-
Rapidly Develop GitHub-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 GitHub.
-
How to connect to Deel Data with Squirrel SQL client
Connect to Deel and execute queries in the Squirrel SQL Client.
-
Integrate Live Bullhorn CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bullhorn CRM to Blue Prism using the CData ODBC Driver for Bullhorn CRM to create automated workflows for repetitive business tasks.
-
Connect to Google Contacts Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Contacts.
-
Using the CData Software ODBC Driver for Sage 300 in PyCharm
Connect to Sage 300 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage 300.
-
Access Live Basecamp Data in Coginiti Pro
Connect to and query live Basecamp from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Instagram Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Instagram from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Reckon Accounts Hosted actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Build Lakebase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Lakebase Data and create custom apps in Bubble.
-
Analyze XML Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of XML Files and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with Google Campaign Manager 360 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Campaign Manager 360 in SnapLogic.
-
Build a Simple VCL Application for Stack Exchange Data
How to build a simple VCL Application to view Stack Exchange in RAD Studio using the CData ODBC Driver for Stack Exchange.
-
Integrate with Cassandra Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Cassandra to a JSON file on disk.
-
Connect to Omnisend Data from a Connection Pool in Jetty
The Omnisend JDBC Driver supports connection pooling: This article shows how to connect faster to Omnisend from Web apps in Jetty.
-
Integrating GitHub Copilot CLI with Klipfolio 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.
-
Visualize TigerGraph 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 TigerGraph into TIBCO Spotfire.
-
Connect to Google Forms Data in RazorSQL
Connect to Google Forms from wizards and query Google Forms from the GUI in the RazorSQL database management tool.
-
Use Agno to Talk to Your HubSpot 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 HubSpot for you.
-
Automated Continuous SageHR Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SageHR replication to Google Cloud SQL.
-
Build Data Flows from Samanage to SQL Server using SSIS
Easily back up Samanage to SQL Server using the SSIS components for Samanage.
-
How to Connect to Sage Intacct Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sage Intacct. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Opsgenie Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Opsgenie. Leverage the native support for ODBC in PHP.
-
Integrating Gumloop with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sybase within automated workflows.
-
Getting Started with the CData ODBC Driver for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Creator.
-
How to connect and process Cohere from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cohere.
-
Configure the CData JDBC Driver for Tickspot in a Connection Pool in Tomcat
Connect to Tickspot from a connection pool in Tomcat.
-
How to Access Coda Data Using Entity Framework
This article shows how to access Coda using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Add Apify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Apify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous OneNote Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OneNote replication to IBM DB2.
-
DataBind Controls to Gorgias Data in Delphi
DataBind to Gorgias in Delphi with standard data access components and controls.
-
Connect to Pushbullet Data in NetBeans
Connect to Pushbullet in NetBeans with the data source configuration wizard.
-
Connect to SpaceX Data in NetBeans
Connect to SpaceX in NetBeans with the data source configuration wizard.
-
Import Dropbox Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Dropbox Data and provide access to live Dropbox for custom reports in the Power BI Service.
-
Build MVC Applications with Connectivity to Opsgenie Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Opsgenie from an ASP.NET MVC application.
-
How to Build an ETL App for Yelp Data in Python with CData
Create ETL applications and real-time data pipelines for Yelp in Python with petl.
-
Access Live XML Data in TIBCO Data Virtualization
Use the XML Tibco DV Adapter to create a XML Files data source in TIBCO Data Virtualization Studio and gain access to live XML Files from your TDV Server.
-
Build Visualizations of Google Contacts Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Contacts in Birst.
-
Build QuickBooks Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to QuickBooks Online Data from Zoho Analytics and import live QuickBooks Online.
-
Import eBay Analytics Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access eBay Analytics. In this article, you will use the OData format to import eBay Analytics into Microsoft Power Query.
-
Access Live RabbitMQ Data in AWS Lambda
Connect to live RabbitMQ in AWS Lambda using the CData JDBC Driver.
-
Model Azure DevOps Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure DevOps, enabling the direct import of real-time Azure DevOps.
-
How to integrate Microsoft Ads with Apache Airflow
Access and process Microsoft Ads in Apache Airflow using the CData JDBC Driver.
-
How to Easily Query ConstantContact Data in OpenOffice Base
Connect to ConstantContact data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to load Acumatica data into Elasticsearch via Logstash
Introducing a simple method to load Acumatica data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to work with CircleCI Data in Apache Spark using SQL
Access and process CircleCI Data in Apache Spark using the CData Software JDBC Driver.
-
Model HubSpot Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and HubSpot, enabling the direct import of real-time HubSpot.
-
Visualize Mistral AI Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mistral AI.
-
Build Semantic Layer Views for Azure DevOps Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure DevOps.
-
Build Google Search-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Search to explore live Google Search Results in Cursor to assist with building Google Search-powered applications.
-
Connect SAP Business One to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Business One using the CData Python MCP Server.
-
Connect to and Visualize Live LeadDesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LeadDesk.
-
Replicate Bugsnag Data from PowerShell
Write a quick PowerShell script to query Bugsnag. Use connectivity to the live data to replicate Bugsnag to SQL Server.
-
Connect and Visualize Live Microsoft Teams Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Teams into the Databricks platform and create visualization dashboards with real-time Microsoft Teams.
-
Publish Mocean-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mocean.
-
Seamlessly Bring Act CRM Data into Retool Using CData Connect AI
Integrate Act CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Query Live Google Contacts Data in Claude Desktop
Connect to and query live Google Contacts Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Invoiced Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Invoiced replication to OneLake in Microsoft Fabric.
-
Integrate Cursor with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon Athena from within the editor.
-
Create Datasets from Acumatica in Domo Workbench and Build Visualizations of Acumatica Data in Domo
Use the CData Software ODBC Driver for Acumatica to create datasets from Acumatica ERP in Domo Workbench and then build visualizations in the Domo service.
-
Create Dashboards and Visualize Live Google Ad Manager Data in Geckoboard
Use CData Connect AI to connect to live Google Ad Manager and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Provide OData Services of Clari Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clari by developing a WCF Service Application.
-
Access Live Excel Online 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 Microsoft Excel Online through MCP integration.
-
Query Freshservice Data as a SQL Server Database in Node.js
Execute SQL Server queries against Freshservice from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate Jira Assets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jira Assets to SQL Server.
-
Create Coda Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Coda from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to SQL Analysis Services from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SQL Analysis Services, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gong
Provide connectivity to Gong through an SAP BusinessObjects universe.
-
Import Microsoft Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Ads Data from Azure Data Factory and import live Microsoft Ads.
-
How to connect to Salesforce CRM Analytics Data in DBVisualizer
Integrate Salesforce CRM Analytics with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Epicor Kinetic Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Epicor Kinetic and visualize live Epicor Kinetic in Infragistics Reveal.
-
How to Seamlessly Import Cosmos DB Data into IBM SPSS Modeler
Integrate Cosmos DB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData ODBC Driver for FTP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FTP.
-
Connect to Workday Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Workday from Filemaker Pro on Mac.
-
Visualize Live Amazon Athena Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Athena.
-
Automate SageHR Data Replication to SAP HANA
Use CData Sync to customize and automate SageHR replication to SAP HANA.
-
Use Dash to Build Web Apps on Jira Data via CData Connect AI
Build interactive Dash web apps on live Atlassian Jira using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Typeform Replication to SingleStore
Use CData Sync for automated, continuous, customizable Typeform replication to SingleStore.
-
Connecting GenSpark with Instagram Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Instagram without any replication or custom integration required.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Microsoft Dataverse actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
ActiveCampaign Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ActiveCampaign through CData Connect AI using different applications and tools.
-
Visualize Square Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Square.
-
Natively Connect to Oracle Sales Data in PHP
The CData ODBC driver for Oracle Sales enables you to create PHP applications with connectivity to Oracle Sales. Leverage the native support for ODBC in PHP.
-
Load LightSpeedRetail Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LightSpeedRetail to a database.
-
How to work with WooCommerce Data in Apache Spark using SQL
Access and process WooCommerce Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Gumloop with Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Cosmos DB within automated workflows.
-
Integrate with Oracle SCM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle SCM in SnapLogic.
-
Access Oracle HCM Cloud Data from MySQL in PHP
Connect to Oracle HCM Cloud through the standard MySQL libraries in PHP.
-
Connect to Databricks Data from a Connection Pool in Jetty
The Databricks JDBC Driver supports connection pooling: This article shows how to connect faster to Databricks from Web apps in Jetty.
-
Connect to Coda Data in RapidMiner
Integrate Coda with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Tableau Connector for Recurly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Helpscout Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect DBeaver to MarkLogic via a JDBC Driver
Manage MarkLogic with visual tools in DBeaver like the query browser.
-
Working with Accelo Data in LINQPad
Execute LINQ queries to Accelo in LINQPad.