CData Software - Knowledge Base
Recent Articles
-
Model SageHR Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SageHR, enabling the direct import of real-time SageHR data.
-
How to import Stripe Data into Apache Solr
Use the CData Software JDBC Driver for Stripe in Data Import Handler and create an automated import of Stripe data to Apache Solr Enterprise Search platform.
-
Use the CData Software JDBC Driver for Yelp in MicroStrategy Desktop
Connect to Yelp data in MicroStrategy Desktop using the CData Software JDBC Driver for Yelp.
-
Create a Data Access Object for Nethunt Data using JDBI
A brief overview of creating a SQL Object API for Nethunt data in JDBI.
-
Automated Continuous Workday Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Workday replication to Apache Kafka.
-
Integrate Google Calendar with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Calendar with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Calendar data.
-
Getting Started with the CData ADO.NET Provider for ConstantContact
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous SAP BusinessObjects BI Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to delimited files (CSV/TSV).
-
Create Data Visualizations in Cognos BI with Adobe Commerce Data
Access Adobe Commerce data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Boomi Agentstudio with Impala Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Impala data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Query Live Greenplum Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Greenplum data data in natural language using Python.
-
Create PolarTeamPro-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to PolarTeamPro Data from Klipfolio and build custom visualizations using live PolarTeamPro data.
-
Enable the Samanage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Samanage data.
-
How to publish and share Toggl Data dashboards with Tableau Server
The CData ODBC driver for Toggl enables you integrate Toggl data into Tableau dashboards.
-
Use Azure AI Foundry to Talk to Your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Facebook data for you.
-
Validate ChargeOver Data with QuerySurge
Access and validate ChargeOver data in QuerySurge using the CData JDBC Driver.
-
Prepare, Blend, and Analyze AgileCRM Data in Alteryx Designer (Connect AI)
Build workflows to access live AgileCRM data for self-service data analytics.
-
Prepare, Blend, and Analyze HubDB Data in Alteryx Designer (Connect AI)
Build workflows to access live HubDB data for self-service data analytics.
-
Use Microsoft Copilot Studio to talk to your ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Getting Started with the CData Python Connector for SageHR
Learn to install and license the CData Python Connector and configure a connection to live SageHR data.
-
Automated Continuous Snapchat Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Apache Kafka.
-
How to Access Live Jira Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jira enables you to integrate Jira data into workflows built using Microsoft Power Automate Desktop.
-
How to create Freshteam federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshteam data in MySQL .
-
Analyze Live Dynamics CRM Data in SAS Viya
Use CData Connect AI to connect to Dynamics CRM data from SAS Viya and deploy self-service analytics using live Dynamics CRM data.
-
Analyze ShipStation Data in Cognos Analytics
Use CData Connect AI to connect to ShipStation Data from Cognos Analytics and analyze live ShipStation data.
-
Connect to Live NetSuite Data in PostGresSQL Interface through CData Connect AI
Create a live connection to NetSuite in CData Connect AI and connect to your NetSuite data from PostgreSQL.
-
Replicate Multiple SAP Fieldglass Accounts via the CData Sync CLI
Replicate multiple SAP Fieldglass accounts to one or many databases.
-
Migrating data from Active Directory to Google BigQuery using CData SSIS Components.
Easily push Active Directory data to Google BigQuery using the CData SSIS Tasks for Active Directory and Google BigQuery.
-
Automated Continuous Mailgun Replication to Databricks
Use CData Sync for automated, continuous, customizable Mailgun replication to Databricks.
-
Integrating LangGraph with Apify Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apify data within automated workflows.
-
Automated Continuous Raisers Edge NXT Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google Cloud SQL.
-
Use Azure AI Foundry to Talk to Your Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Asana data for you.
-
Build ZohoInvoice-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 ZohoInvoice data without replication.
-
Connect to MessageBird Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MessageBird data using standard SQL.
-
Query ActiveCampaign Data in ColdFusion
Write standard ColdFusion data access code to connect to ActiveCampaign data.
-
Build a Simple VCL Application for Microsoft Teams Data
How to build a simple VCL Application to view Microsoft Teams data in RAD Studio using the CData ODBC Driver for Microsoft Teams.
-
Connect to Redis Data from PowerBuilder via JDBC
This article demonstrates how to access Redis data from PowerBuilder using the Redis JDBC Driver.
-
Automated Continuous EnterpriseDB Replication to MySQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to MySQL.
-
Build Pipelines with Live Google Sheets Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Sheets from Google Cloud Data Fusion, enabling the integration of live Google Sheets data into the building and management of effective data pipelines.
-
Integrate Vimeo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Vimeo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Vimeo data.
-
Access Live Salesforce Data 360 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Data 360 data from your Excel spreadsheets.
-
Integrating OpenCode with Simplesat 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.
-
Build Voice Agents in ElevenLabs with access to Live Amazon DynamoDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon DynamoDB data.
-
Natively Connect to Sage Cloud Accounting Data in PHP
The CData ODBC driver for Sage Cloud Accounting enables you to create PHP applications with connectivity to Sage Cloud Accounting data. Leverage the native support for ODBC in PHP.
-
Access Live Avro Data in Excel 365 Online (Excel for the web)
Connect to Avro data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate OpenCode with Live Salesloft Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Salesloft data from within your AI coding agent.
-
Query Freshservice Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshservice data from Node.js.
-
How to Connect to Live Splunk Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Splunk data for you.
-
DataBind Charts to eBay Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay Analytics data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Aweber Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Aweber data and build visualizations in Tableau.
-
Use the CData Software JDBC Driver for OData in MicroStrategy Web
Connect to OData services in MicroStrategy Web using the CData Software JDBC Driver for OData.
-
Build MVC Applications with Connectivity to Attio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Attio from an ASP.NET MVC application.
-
How to Work with Reckon Data in ETL Validator JDBC
Connect to Reckon from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to SAP HANA Data in CloverDX (formerly CloverETL)
Transfer SAP HANA data using the visual workflow in the CloverDX data integration tool.
-
Build Visualizations of PDFMonkey Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PDFMonkey data in Birst.
-
Build Attio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Attio data.
-
Analyze MessageBird Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MessageBird data with the CData JDBC Driver for MessageBird.
-
Automated Continuous Hugging Face Replication to Oracle
Use CData Sync for automated, continuous, customizable Hugging Face replication to Oracle.
-
Connect to ServiceDesk Plus Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ServiceDesk Plus Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Supabase Replication to Vertica
Use CData Sync for automated, continuous, customizable Supabase replication to Vertica.
-
Access MongoDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MongoDB data from HeidiSQL.
-
Integrate Cursor with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live FTP data from within the editor.
-
Build SparkPost-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SparkPost data and build web apps with connectivity to live SparkPost data.
-
Use the CData Software JDBC Driver for Clockify in MicroStrategy
Connect to Clockify data in MicroStrategy Developer using the CData Software JDBC Driver for Clockify.
-
Connect to Freshservice Data from a Connection Pool in Jetty
The Freshservice JDBC Driver supports connection pooling: This article shows how to connect faster to Freshservice data from Web apps in Jetty.
-
Connect Supabase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Supabase data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process MailerSend data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailerSend data.
-
Integrate with Reckon Accounts Hosted Data in JReport Designer
Create charts and reports based on Reckon Accounts Hosted data in JReport Designer.
-
Build an OLAP Cube in SSAS from Front Data
Establish a connection to Front data data from SQL Server Analysis Services, and use the Front Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Klipfolio Data from HeidiSQL
Use CData Connect AI to connect to and query live Klipfolio data from HeidiSQL.
-
Use Microsoft Copilot Studio to talk to your PingOne 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 PingOne data for you.
-
Publish MessageBird-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MessageBird data.
-
How to Connect DBeaver to SAP via a JDBC Driver
Manage SAP data with visual tools in DBeaver like the query browser.
-
Enable the Email JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Email data.
-
LINQ to EnterpriseDB 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 EnterpriseDB Data Provider.
-
Connect SAP BusinessObjects BI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP BusinessObjects BI with IBM WebSphere for seamless data integration and connectivity.
-
How to Build an ETL App for ZohoInvoice Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoInvoice data in Python with petl.
-
Publish Tickspot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Tickspot data.
-
PolarTeamPro Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PolarTeamPro data through CData Connect AI using different applications and tools.
-
Create Power BI Reports on Real-Time Accelo Data
Use the CData ODBC Driver for Accelo to visualize Accelo data in Power BI Desktop.
-
Load Shippo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Shippo data to a database.
-
Access Live Suadeo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Suadeo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect the Power BI Service to Apollo: Complete Guide
Connect to the CData Software Power BI Connector for Apollo from PowerBI.com to provide real-time Apollo data across the organization.
-
How to Create Power BI Visual Reports with Real-Time Oracle HCM Cloud Data
Use CData Power BI Connectors to visualize Oracle HCM Cloud data in Power BI.
-
Create SSAS Tabular Models from Oracle Eloqua Reporting Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Eloqua Reporting data using CData drivers.
-
Connect to Facebook Data from PowerBuilder via JDBC
This article demonstrates how to access Facebook data from PowerBuilder using the Facebook JDBC Driver.
-
Analyze Cvent Data in Looker
Use CData Connect AI to connect to Cvent Data from Looker and build custom apps using live Cvent data.
-
Visualize Recurly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Recurly data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OneNote
Provide connectivity to OneNote data through an SAP BusinessObjects universe.
-
Configure the CData JDBC Driver for YouTube Analytics in a Connection Pool in Tomcat
Connect to YouTube Analytics data from a connection pool in Tomcat.
-
Automated Continuous Sage Intacct Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google BigQuery.
-
Create JSON-Connected Business Apps in AppSheet
Connect to JSON Services via CData Connect AI in Google AppSheet and create custom business applications with real-time access to JSON services.
-
Build Semantic Layer Views for HDFS Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HDFS data.
-
How to Connect to Live Greenhouse Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Greenhouse data for you.
-
How to Connect to Live DB2 Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your DB2 data for you.
-
Integrate Trae with Live Splunk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Splunk data from within the AI-powered IDE.
-
Connect to Discord Data in HULFT Integrate
Connect to Discord as a JDBC data source in HULFT Integrate
-
Integrate with SAP Ariba Source Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Ariba Source data to a JSON file on disk.
-
Extract, Transform, and Load Jira Data in Informatica PowerCenter
Create a simple Workflow for Jira data in Informatica PowerCenter.
-
Connect to Postmark Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Postmark to connect to Postmark data and execute queries in PowerBuilder.