CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Okta Grids Using the Infragistics XamDataGrid
Learn how you can connect Okta to Infragistics XamDataGrid to build dynamic grids.
-
Create Procore-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Procore Data from OutSystems and build custom enterprise apps using live Procore data.
-
Build Adobe Commerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Bubble.
-
Integrating Boomi Agentstudio with XML Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to XML data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Productboard Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Productboard replication to Amazon S3.
-
Prepare, Blend, and Analyze Unbounce Data in Alteryx Designer (ODBC)
Build workflows to access live Unbounce data for self-service data analytics.
-
Migrating data from Sage Intacct to Google BigQuery using CData SSIS Components.
Easily push Sage Intacct data to Google BigQuery using the CData SSIS Tasks for Sage Intacct and Google BigQuery.
-
Automated Continuous Shippo Replication to SQLite
Use CData Sync for automated, continuous, customizable Shippo replication to SQLite.
-
Work with Live Salesloft Data in Power Query
Use CData Connect AI to connect to Salesloft data and work with live Salesloft data in Microsoft Power Query.
-
Integrate Cursor with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Service Cloud data from within the editor.
-
Connect to Zendesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zendesk and the SQL Gateway to access Zendesk data from Google Apps Script.
-
Integrating Boomi Agentstudio with OneNote Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to OneNote data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze Amazon Marketplace Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon Marketplace data in Microsoft R Open.
-
Integrate Live Figshare Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Figshare from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Figshare data.
-
Analyze SAP SuccessFactors LMS Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP SuccessFactors LMS data and visualize SAP SuccessFactors LMS data in SAP Analytics Cloud.
-
Connect to Azure Analysis Services Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure Analysis Services and the SQL Gateway to access Azure Analysis Services data from Google Apps Script.
-
Analyze Google Directory Data in Looker
Use CData Connect AI to connect to Google Directory Data from Looker and build custom apps using live Google Directory data.
-
Connect to Stripe Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Stripe data.
-
How to Connect to Live SAP HANA Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP HANA data for you.
-
Building Dynamic Web Pages with Sage 200 Data Using AngularJS
Create single-page applications with live connectivity to Sage 200 using the CData API Server.
-
Connect and Visualize Live Act-On Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Act-On data into the Databricks platform and create visualization dashboards with real-time Act-On data.
-
Automated Continuous Xero Replication to MongoDB
Use CData Sync for automated, continuous, customizable Xero replication to MongoDB.
-
Analyze Freshsales Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshsales from Power Pivot. You will use the Table Import Wizard to load Freshsales data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Codex with Impala 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.
-
Integrate Landbot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Landbot with External Services.
-
Building Dynamic Web Pages with Paylocity Data Using AngularJS
Create single-page applications with live connectivity to Paylocity using the CData API Server.
-
Build Typeform-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Typeform data.
-
How to Connect to Live Sybase IQ Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Sybase IQ data for you.
-
Create Oracle Eloqua-Connected Dashboards in Grafana
Connect to Oracle Eloqua Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Eloqua data.
-
Feed Superchat Data into FineReport
How to set Superchat data as a JDBC data source in FineReport.
-
Integrate Google's Antigravity Agent with Live Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Supabase data using the Model Context Protocol.
-
Automated Continuous Zoho Projects Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Azure SQL Database.
-
Build a Singer.io Tap for Rootly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Rootly data using the CData Python Connector.
-
Connect to Accelo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Accelo to connect to Accelo data and execute queries in PowerBuilder.
-
Access Live Bitly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bitly data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Visualizations of IBM Informix Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of IBM Informix data in Birst.
-
Write a Simple Go Application to work with Couchbase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Couchbase data.
-
Integrate Slack Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Slack data and integrate live Slack data into your Power Automate tasks.
-
Analyze Microsoft Planner Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Planner data in Microsoft R Open.
-
How to connect and process Mode data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mode data.
-
Integrating LangChain with Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Freshservice data within automated workflows.
-
Connect to Google Directory Data in ACL Analytics
Connect to Google Directory data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Directory data.
-
Integrate LibreChat with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Active Directory data from within the chat interface.
-
Access Live Highrise Data in AWS Lambda
Connect to live Highrise data in AWS Lambda using the CData JDBC Driver.
-
Integrate Certinia Data in the Pentaho Report Designer
Publish reports based on Certinia data in the Pentaho BI tool.
-
A PostgreSQL Interface for SAP SuccessFactors LMS Data using the CData ODBC Driver
Use the SQL Gateway and SAP SuccessFactors LMS ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for Oracle HCM Cloud Data using JDBI
A brief overview of creating a SQL Object API for Oracle HCM Cloud data in JDBI.
-
Use the CData ODBC Driver for Sentry in Microsoft Power Query
You can use the CData Sentry ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sentry data into Microsoft Power Query.
-
Design BIRT Reports on ChartMogul Data
Provide current ChartMogul data to your embedded analytics.
-
How to Access Live Outlook Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Outlook enables you to integrate Outlook data into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Jodoo Data in DBVisualizer
Integrate Jodoo data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to update WordPress from Excel
This article explains how to transfer data from Excel to WordPress using the Excel Add-In for WordPress.
-
Connect to and Visualize Live Avalara AvaTax Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avalara AvaTax data.
-
Connect to Amazon Athena Data in Ruby
Connect to Amazon Athena data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use JayDeBeApi to access xBase Data in Python
Use standard Python scripting and the development environment of your choice to access live xBase data.
-
Build Dropbox-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 Dropbox data without replication.
-
Stream LinkedIn Ads Data into Apache Kafka Topics
Access and stream LinkedIn Ads data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build Web Apps on Apollo Data via CData Connect AI
Build interactive Dash web apps on live Apollo data using pandas and the CData Connect AI Python SDK.
-
Create Reports with Dynamics 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics 365 data.
-
Connecting Moonlit Workflow with OData Services 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 OData services in real time.
-
Create Datasets from Insightly in Domo Workbench and Build Visualizations of Insightly Data in Domo
Use the CData Software ODBC Driver for Insightly to create datasets from Insightly data in Domo Workbench and then build visualizations in the Domo service.
-
Create Dashboards and Visualize Live Salesforce Marketing Data in Geckoboard
Use CData Connect AI to connect to live Salesforce Marketing data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze SingleStore Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SingleStore from Power Pivot. You will use the Table Import Wizard to load SingleStore data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Greenhouse 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 Greenhouse data.
-
Query Live SurveyMonkey Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SurveyMonkey data directly from the development environment.
-
Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through OData
Integrate SAP Netweaver Gateway data into dashboards in TIBCO Spotfire.
-
Integrate with Live Asana Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Asana from the MuleSoft Anypoint Platform to integrate live Asana data into custom reports and dashboards.
-
Build a Singer.io Tap for ActiveCampaign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ActiveCampaign data using the CData Python Connector.
-
Natively Connect to CapsuleCRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CapsuleCRM data. Leverage the native support for ODBC in PHP.
-
Automate HubDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HubDB data from PowerShell? This article demonstrates how to utilize the HubDB Cmdlets for tasks like connecting to HubDB data, automating operations, downloading data, and more.
-
Connect Onfleet Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Onfleet data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Feed Webflow Data into FineReport
How to set Webflow data as a JDBC data source in FineReport.
-
Build Apps with Live Stripe data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Stripe data into the Adalo platform and build custom mobile and web applications with real-time Stripe data.
-
Choosing the Best Method to Connect SAP SuccessFactors to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP SuccessFactors data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Databricks Agent Bricks to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoho Inventory data for you.
-
Connect to OnePageCrm Data in DBeaver
Use the CData ODBC Driver to connect to OnePageCrm data in DBeaver.
-
Build Apps with Live Elasticsearch Data Using the Low-Code Development Platform of Mendix
Connect Elasticsearch data with Mendix to build apps using the CData JDBC Driver for Elasticsearch.
-
Visualize Excel Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Excel Online data.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy Desktop
Connect to Missive data in MicroStrategy Desktop using the CData Software JDBC Driver for Missive.
-
Create Amazon Athena-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon Athena Data from OutSystems and build custom enterprise apps using live Amazon Athena data.
-
Visualize Datadog 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 Datadog data into TIBCO Spotfire.
-
Build Exa-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Exa data and build web apps with connectivity to live Exa data.
-
Connect to SingleStore Data from HeidiSQL
Use CData Connect AI to connect to and query live SingleStore data from HeidiSQL.
-
Integrating Gumloop with FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on FTP data within automated workflows.
-
Automated Continuous Gorgias Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Gorgias replication to Amazon S3.
-
Integrate with SharePoint Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SharePoint data to a JSON file on disk.
-
Visualize FreshBooks Data in Tableau
The CData ODBC driver for FreshBooks enables you integrate FreshBooks data into Tableau dashboards.
-
Write a Simple Go Application to work with SparkPost Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SparkPost data.
-
Create Datasets from Float in Domo Workbench and Build Visualizations of Float Data in Domo
Use the CData Software ODBC Driver for Float to create datasets from Float data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Workable Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Workable replication to Google BigQuery.
-
Connect to Teradata Data in Jaspersoft Studio
Execute SQL to remote Teradata data in Jaspersoft Studio.
-
Visualize SAP Ariba Source Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Ariba Source data.
-
Connect to SendInBlue Data in DBArtisan
Use wizards in DBArtisan to configure SendInBlue data as a data source.
-
How to work with Amazon DynamoDB Data in Apache Spark using SQL
Access and process Amazon DynamoDB Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to BenchmarkEmail 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 BenchmarkEmail data.
-
Migrating data from Shippo to Snowflake using CData SSIS Components.
Easily push Shippo data to Snowflake using the CData SSIS Tasks for Shippo and Snowflake.
-
Visualize Nethunt Data in Sisense
Create an ElastiCube in Sisense app with access to Nethunt data.
-
Replicate Office 365 Data to Multiple Databases via the CData Sync CLI
Replicate Office 365 data to disparate databases with a single configuration.
-
Integrating Gumloop with Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Bannerbear data within automated workflows.
-
Load Trello Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Trello data to a database.