CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode with Campaigner 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.
-
Import Real-Time Everhour Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Everhour data in ColdFusion.
-
Import Real-Time ZendeskSell Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZendeskSell data in ColdFusion.
-
Connect to Epicor Kinetic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Epicor Kinetic data.
-
How to Create Power BI Visual Reports with Real-Time Qualaroo Data
Use CData Power BI Connectors to visualize Qualaroo data in Power BI.
-
Automated Continuous OnePageCrm Replication to Vertica
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Vertica.
-
How to Connect to Live Paylocity Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Paylocity data without replication.
-
Establish a Live Connection with Klaviyo Data using Tableau Bridge
The CData ODBC Driver for Klaviyo enables you to integrate live Klaviyo data into Tableau Cloud dashboards using the Tableau Bridge.
-
Work with Live SAP Ariba Source Data in Power Query
Use CData Connect AI to connect to SAP Ariba Source data and work with live SAP Ariba Source data in Microsoft Power Query.
-
Configure the CData JDBC Driver for Google Analytics in a Connection Pool in Tomcat
Connect to Google Analytics data from a connection pool in Tomcat.
-
Access Live PDFMonkey Data in Coginiti Pro
Connect to and query live PDFMonkey data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI/ML Models with Live Excel Data using Dataiku
Connect Excel Data with Dataiku using the CData JDBC Driver for Excel.
-
Visualize Klaviyo Data in TIBCO Spotfire through ADO.NET
Integrate Klaviyo data into dashboards in TIBCO Spotfire.
-
Automated Continuous Excel Online Replication to Databricks
Use CData Sync for automated, continuous, customizable Excel Online replication to Databricks.
-
Build Agents in Relevance AI with Access to Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on eBay data within intelligent agent workflows.
-
Getting Started with the CData Excel Add-In for ShipEngine
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ShipEngine.
-
How to integrate Metabase with DB2 Data
Use CData Connect AI to connect to live DB2 data and create an interactive dashboard in Metabase from DB2 data.
-
Build a PostgreSQL Interface for Wistia Data using the CData JDBC Driver
Use the Remoting features of the Wistia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from JSON Services in Qlik Sense Cloud
Use CData Connect AI to connect to JSON Services and build apps from live JSON services in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for QuickBooks Online in MicroStrategy Web
Connect to QuickBooks Online data in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks Online.
-
Build Data Flows from Raisers Edge NXT to SQL Server using SSIS
Easily back up Raisers Edge NXT data to SQL Server using the SSIS components for Raisers Edge NXT.
-
How to publish and share IBM Informix Data dashboards with Tableau Server
The CData ODBC driver for IBM Informix enables you integrate IBM Informix data into Tableau dashboards.
-
Build Vertica-Connected Apps in Choreo
Use CData Connect AI to connect to Vertica Data from Choreo and build custom apps using live Vertica data.
-
Integrating Bannerbear Data in Talend Cloud Data Management Platform
Connect Bannerbear Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to FreshBooks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FreshBooks to connect to FreshBooks data and execute queries in PowerBuilder.
-
Automated Continuous Tanda Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tanda replication to Snowflake.
-
Build MySQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MySQL data.
-
Query Opsgenie Data in DataGrip
Create a Data Source for Opsgenie in DataGrip and use SQL to query live Opsgenie data.
-
Build MVC Applications with Connectivity to iContact Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access iContact from an ASP.NET MVC application.
-
Connecting Mastra with Redis Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Redis data, no replication required.
-
Query Live MYOB AccountRight 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 MYOB AccountRight data through a conversational interface.
-
Publish Crystal Reports on Recurly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Recurly data.
-
Access Parquet 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 Parquet data.
-
Connect to ActiveCampaign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ActiveCampaign data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData JDBC Driver for Jodoo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jodoo.
-
Connect JDBC-ODBC Bridge to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JDBC-ODBC Bridge with IBM WebSphere for seamless data integration and connectivity.
-
Build Apps with Live ConvertKit Data Using the Low-Code Development Platform of Mendix
Connect ConvertKit data with Mendix to build apps using the CData API Driver for JDBC.
-
Bridge Reckon Accounts Hosted Connectivity with Apache NiFi
Access and process Reckon Accounts Hosted data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Xero Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.
-
Getting Started with the CData SSIS Components for Splunk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Splunk.
-
Build AI Agents with SingleStore 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 SingleStore data through CData Connect AI.
-
Access Telegram Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Telegram data from HeidiSQL.
-
Automate Microsoft OneLake Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft OneLake data replication to Azure Synapse.
-
Create Power BI Reports on Real-Time ZendeskSell Data
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell data in Power BI Desktop.
-
Prepare, Blend, and Analyze Coda Data in Alteryx Designer (Connect AI)
Build workflows to access live Coda data for self-service data analytics.
-
Build a PostgreSQL Interface for Paylocity Data using the CData JDBC Driver
Use the Remoting features of the Paylocity JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for ConstantContact Data (MySQL Remoting via JDBC)
Use the Remoting features of the ConstantContact JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to PhantomBuster Data in RazorSQL
Connect to PhantomBuster from wizards and query PhantomBuster data from the GUI in the RazorSQL database management tool.
-
Provide OData Services of Datadog Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Datadog data by developing a WCF Service Application.
-
Integrating LangChain with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Synapse data within automated workflows.
-
Integrate Hacker News Data in the Pentaho Report Designer
Publish reports based on Hacker News data in the Pentaho BI tool.
-
How to connect to Oracle Financials Cloud Data from Spring Boot
Connect to Oracle Financials Cloud in a Spring Boot Application using the CData JDBC Driver for Oracle Financials Cloud
-
Connect to Wrike Data in JRuby
Create a simple JRuby app with access to live Wrike data.
-
How to integrate Metabase with Oracle Financials Cloud Data
Use CData Connect AI to connect to live Oracle Financials Cloud data and create an interactive dashboard in Metabase from Oracle Financials Cloud data.
-
Connect to Presto Data from a Connection Pool in JBoss
Integrate Presto data into Java servlets: Use the Management Console in JBoss to install the Presto JDBC Driver.
-
Build Semantic Layer Views for Google Calendar Data in APOS Live Data Gateway
Use the CData Connector for Google Calendar in APOS Live Data Gateway to build Semantic Layer Views for Google Calendar data.
-
How to Connect to Live Zoho Projects 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 Zoho Projects data for you.
-
Create Sage 300-Connected Applications in Appsmith
Connect to Sage 300 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage 300 data.
-
Connecting Pipedream with Exa 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 Exa data in real time.
-
Automate Billsby Data Replication to SAP HANA
Use CData Sync to customize and automate Billsby data replication to SAP HANA.
-
How to create an RPA flow for Avro Data in UiPath Studio
Use the Avro ODBC Driver to create workflows that access real-time Avro data without any coding.
-
How to import Suadeo Data into Apache Solr
Use the CData Software JDBC Driver for Suadeo in Data Import Handler and create an automated import of Suadeo data to Apache Solr Enterprise Search platform.
-
Automated Continuous Email Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Email replication to Amazon Redshift.
-
How to Connect to Live RSS Feeds from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your RSS feeds for you.
-
Create Informatica Mappings From/To an ODBC Data Source for PabblySubscriptions
Create an ODBC connection to PabblySubscriptions in Informatica and browse and transfer PabblySubscriptions data.
-
ETL JotForm in Oracle Data Integrator
This article shows how to transfer JotForm data into a data warehouse using Oracle Data Integrator.
-
Create Slack-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Slack Data from OutSystems and build custom enterprise apps using live Slack data.
-
Integrating LangGraph with Reckon Accounts Hosted Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Reckon Accounts Hosted data within automated workflows.
-
Object-Relational Mapping (ORM) with SAP Business One 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 SAP Business One data into a Java-based ORM framework, Hibernate.
-
Search External SAP HANA XS Advanced Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP HANA XS Advanced data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP HANA XS Advanced Data objects that you can access from apps and the dashboard.
-
Automate MailerSend Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailerSend data from PowerShell? This article demonstrates how to utilize the MailerSend Cmdlets for tasks like connecting to MailerSend data, automating operations, downloading data, and more.
-
Automate ZendeskSell Data Replication to SAP HANA
Use CData Sync to customize and automate ZendeskSell data replication to SAP HANA.
-
Connect Zoho Creator to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Creator data using the CData Python MCP Server.
-
Extract, Transform, and Load Twitter Ads Data in Informatica PowerCenter
Create a simple Workflow for Twitter Ads data in Informatica PowerCenter.
-
How to Connect to Wrike Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wrike data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Okta Data in CloverDX (formerly CloverETL)
Transfer Okta data using the visual workflow in the CloverDX data integration tool.
-
Connect to YouTube Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live YouTube Analytics data.
-
Use Dash to Build Web Apps on Amazon Athena Data via CData Connect AI
Build interactive Dash web apps on live Amazon Athena data using pandas and the CData Connect AI Python SDK.
-
Integrate Theia IDE with Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SparkPost data from within the development environment.
-
Visualize Live Stripe Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Stripe data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Guru Data
Establish a connection to Guru data data from SQL Server Analysis Services, and use the Guru Data Provider to build OLAP cubes for use in analytics and reporting.
-
Snapchat Ads Reporting in OBIEE with the Snapchat Ads JDBC Driver
Deploy the Snapchat Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Deploy the ADO.NET Provider for Klipfolio on an SSRS Report Server
Connect to Klipfolio data 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.
-
SAP ERP: Enhanced sys_procedureparameters Metadata for BAPI Procedures
Learn about the enhanced sys_procedureparameters metadata for BAPI procedures in SAP ERP.
-
Automated Continuous PagerDuty Replication to SQL Server
Use CData Sync for automated, continuous, customizable PagerDuty replication to SQL Server.
-
How to Visualize Gmail Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gmail data in Python.
-
Connect to Salesforce Data from a Connection Pool in Jetty
The Salesforce JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce data from Web apps in Jetty.
-
Create Data Visualizations in Cognos BI with Notion Data
Access Notion data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Oracle Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle and the SQL Gateway to access Oracle data from Google Apps Script.
-
Create iContact-Connected Dashboards in Grafana
Connect to iContact Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to iContact data.
-
Getting Started with the CData Python Connector for Freshservice
Learn to install and license the CData Python Connector and configure a connection to live Freshservice data.
-
Automated Continuous Vertica Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vertica replication to Amazon Redshift.
-
Create Power BI Reports on Real-Time Reply.io Data
Use the CData ODBC Driver for Reply.io to visualize Reply.io data in Power BI Desktop.
-
How to Connect Flowise AI Agents to Live WordPress Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live WordPress data without replication.
-
How to use SQLAlchemy ORM to access Kintone Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Kintone data.
-
Prepare, Blend, and Analyze Opsgenie Data in Alteryx Designer (ODBC)
Build workflows to access live Opsgenie data for self-service data analytics.
-
Create QuickBooks-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to QuickBooks Data from OutSystems and build custom enterprise apps using live QuickBooks data.
-
Automated Continuous Rootly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Rootly replication to Snowflake.
-
Integrating GitHub Copilot with Twitter Ads 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 load Cvent data into Elasticsearch via Logstash
Introducing a simple method to load Cvent data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.