CData Software - Knowledge Base
Recent Articles
-
Persistent Token Storage for Embedded Use Cases with CData Connectors
How CData connectors persist authentication tokens, covering the local file, memory, and S3 token stores, credential file storage, and how to implement the ITokenStore interface for a custom token store.
-
Integrating OpenCode with Clio 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.
-
Connect to Apify Data in Jaspersoft Studio
Execute SQL to remote Apify data in Jaspersoft Studio.
-
Build AI Agents with NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data through CData Connect AI.
-
Build Dashboards with Salesforce Pardot Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce Pardot data in Dundas BI.
-
Build MVC Applications with Connectivity to Factorial Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Factorial from an ASP.NET MVC application.
-
Connect to Typeform Data in RazorSQL
Connect to Typeform from wizards and query Typeform data from the GUI in the RazorSQL database management tool.
-
Integrate Toggl Data in the Pentaho Report Designer
Publish reports based on Toggl data in the Pentaho BI tool.
-
Automated Continuous Keap Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Keap replication to Amazon S3.
-
Connect to Freshservice Data from HeidiSQL
Use CData Connect AI to connect to and query live Freshservice data from HeidiSQL.
-
Replicate MarkLogic Data to Multiple Databases
Replicate MarkLogic data to disparate databases with a point-and-click configuration.
-
Query Live Oracle Eloqua Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Oracle Eloqua data through a conversational interface.
-
Integrate Live Wave Financial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Wave Financial data to Blue Prism using the CData ODBC Driver for Wave Financial to create automated workflows for repetitive business tasks.
-
Visualize MailChimp Data in TIBCO Spotfire through OData
Integrate MailChimp data into dashboards in TIBCO Spotfire.
-
Create NetSuite Dataflows on PowerBI.com
Connect to the CData Power BI Connector for NetSuite from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time Paylocity Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Paylocity data in ColdFusion.
-
How to Visualize SAP Netweaver Gateway Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Netweaver Gateway data in Python.
-
Use the CData Software JDBC Driver for LightSpeedRetail in MicroStrategy
Connect to LightSpeedRetail data in MicroStrategy Developer using the CData Software JDBC Driver for LightSpeedRetail.
-
How to Connect to Live Redis 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 Redis data for you.
-
How to create ZohoMarketingHub federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZohoMarketingHub data in MySQL .
-
Use Databricks Agent Bricks to Talk to Your CapsuleCRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CapsuleCRM data for you.
-
Integrate with Omnisend Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Omnisend data in SnapLogic.
-
Build a PostgreSQL Interface for MailerLite Data using the CData JDBC Driver
Use the Remoting features of the MailerLite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Provide OData Services of SageHR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SageHR data by developing a WCF Service Application.
-
Connect to Acumatica Data from a Connection Pool in JBoss
Integrate Acumatica data into Java servlets: Use the Management Console in JBoss to install the Acumatica JDBC Driver.
-
Extract, Transform, and Load Planio Data in Informatica PowerCenter
Create a simple Workflow for Planio data in Informatica PowerCenter.
-
Working with PDFMonkey Data in LINQPad
Execute LINQ queries to PDFMonkey data in LINQPad.
-
Back Up SAP BusinessObjects BI data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP BusinessObjects BI. In this article, we will employ an SSIS workflow to populate a database with SAP BusinessObjects BI data data.
-
Easily Integrate Short.io Data in Lazarus Pascal IDE
Learn how to easily integrate live Short.io data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Adobe Experience Manager Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Adobe Experience Manager as an External Source in Dremio.
-
Enable the Slack JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Slack data.
-
Build Shopify-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Shopify Data and create custom apps in Bubble.
-
Connect to Paddle Data in Aqua Data Studio
Access Paddle data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Crystal Reports on HelloSign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HelloSign data.
-
How to integrate Metabase with Campaigner Data
Use CData Connect AI to connect to live Campaigner data and create an interactive dashboard in Metabase from Campaigner data.
-
Automated Continuous Salesloft Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesloft data replication to OneLake in Microsoft Fabric.
-
How to update ADP from Excel
This article explains how to transfer data from Excel to ADP using the Excel Add-In for ADP.
-
Access Zoho Inventory Data from MySQL in Amazon QuickSight
Connect to Zoho Inventory and build visualizations of Zoho Inventory data using a MySQL Connection in Amazon QuickSight.
-
Publish Freshservice-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshservice data.
-
Publish Crystal Reports on Nuclia Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Nuclia data.
-
Working with Copper Data in LINQPad
Execute LINQ queries to Copper data in LINQPad.
-
Analyze ActiveCampaign Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ActiveCampaign data and visualize ActiveCampaign data in SAP Analytics Cloud.
-
Connect to Dynamics NAV Data from HeidiSQL
Use CData Connect AI to connect to and query live Dynamics NAV data from HeidiSQL.
-
Getting Started with the CData ADO.NET Provider for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Teams.
-
Connect to Codat Data in Ruby
Connect to Codat data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations in Cognos BI with Teradata Data
Access Teradata data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Explore Geographical Relationships in Flowlu Data with Power Map
Create data visualizations with Flowlu data in Power Map.
-
Build a Singer.io Tap for Placid With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Placid data using the CData Python Connector.
-
Integrate Authorize.Net Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Authorize.Net data from Informatica Cloud.
-
Manage Avalara AvaTax Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avalara AvaTax.
-
Query Planio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Planio data from Node.js.
-
How to Connect to & Open Google Search Results in Microsoft Excel
This article uses the CData ODBC driver for Google Search to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live PayPal 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 PayPal data through natural language.
-
Create Power BI Reports on Real-Time Hive Data
Use the CData ODBC Driver for Hive to visualize Hive data in Power BI Desktop.
-
How to integrate SuiteCRM with Apache Airflow
Access and process SuiteCRM data in Apache Airflow using the CData JDBC Driver.
-
Bind Live Phoenix Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Phoenix data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Planio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Planio as an External Source in Dremio.
-
Connecting GenSpark with Sage 300 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sage 300 data without any replication or custom integration required.
-
Connect to Teradata Data in JRuby
Create a simple JRuby app with access to live Teradata data.
-
How to Connect the Power BI Service to Clari: Complete Guide
Connect to the CData Software Power BI Connector for Clari from PowerBI.com to provide real-time Clari data across the organization.
-
Visualize Brex Data in TIBCO Spotfire through ADO.NET
Integrate Brex data into dashboards in TIBCO Spotfire.
-
Publish PostgreSQL-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PostgreSQL data.
-
How to Build an ETL App for Amazon Athena Data in Python with CData Connect AI
Build ETL pipelines that read and write live Amazon Athena data in Python with petl and the CData Connect AI Python SDK.
-
Stream Simplesat Data into Apache Kafka Topics
Access and stream Simplesat data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to Google Cloud Storage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Cloud Storage data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Mailgun Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mailgun replication to IBM DB2.
-
Access IBM Cloud Object Storage Data from MySQL in PHP
Connect to IBM Cloud Object Storage through the standard MySQL libraries in PHP.
-
Replicate Multiple Sybase Accounts
Replicate multiple Sybase accounts to one or many databases.
-
Configure the CData JDBC Driver for Anaplan in a Connection Pool in Tomcat
Connect to Anaplan data from a connection pool in Tomcat.
-
Model ServiceNow Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ServiceNow, enabling the direct import of real-time ServiceNow data.
-
Integrate Google's Antigravity Agent with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Raisers Edge NXT data using the Model Context Protocol.
-
DataBind Sentry Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Sentry data to a chart.
-
Create Dashboards and Visualize Live OData Services in Geckoboard
Use CData Connect AI to connect to live OData services and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Informatica Mappings From/To an ODBC Data Source for ChartMogul
Create an ODBC connection to ChartMogul in Informatica and browse and transfer ChartMogul data.
-
How to integrate ServiceDesk Plus with Apache Airflow
Access and process ServiceDesk Plus data in Apache Airflow using the CData JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your PostgreSQL Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your PostgreSQL data for you.
-
Build Sybase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sybase data and build visualizations in Tableau.
-
Replicate Multiple Raisers Edge NXT Accounts via the CData Sync CLI
Replicate multiple Raisers Edge NXT accounts to one or many databases.
-
Integrating Codex with SuiteCRM 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.
-
Connecting Pipedream with Zoho Projects Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoho Projects data in real time.
-
Extract, Transform, and Load Google Forms Data in Informatica PowerCenter
Create a simple Workflow for Google Forms data in Informatica PowerCenter.
-
Automated Continuous HDFS Replication to Vertica
Use CData Sync for automated, continuous, customizable HDFS replication to Vertica.
-
Integrating Gumloop with BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BigQuery data within automated workflows.
-
Connect to Raisers Edge NXT Data from HeidiSQL
Use CData Connect AI to connect to and query live Raisers Edge NXT data from HeidiSQL.
-
Automated Continuous LinkedIn Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to IBM DB2.
-
Build AI Agents with Snowflake 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 Snowflake data through CData Connect AI.
-
How to Seamlessly Import SharePoint Data into IBM SPSS Modeler
Integrate SharePoint data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time Aircall Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Aircall data in ColdFusion.
-
Connect to SparkPost Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SparkPost as an External Source in Dremio.
-
Connecting Agentforce with Microsoft Dataverse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Dataverse data for you.
-
Access ZohoSubscriptions Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoSubscriptions data from your Oracle system.
-
Automate Gorgias Data Replication to Azure Synapse
Use CData Sync to customize and automate Gorgias data replication to Azure Synapse.
-
Integrate FHIR with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FHIR with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FHIR data.
-
Access Live Jira Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Jira data from your Excel spreadsheets.
-
Build iContact Visualizations in Tableau Cloud
Use CData Connect AI to connect to live iContact data and build visualizations in Tableau Cloud.
-
Connect to Cloudflare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cloudflare data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Explore Geographical Relationships in Adobe Analytics Data with Power Map
Create data visualizations with Adobe Analytics data in Power Map.
-
Working with GitLab Data in LINQPad
Execute LINQ queries to GitLab data in LINQPad.
-
Connect to and Query Google Drive Data in QlikView over ODBC
Create data visualizations with Google Drive data in QlikView.
-
Integrate Live JSON Services into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to JSON from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live JSON services.