CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor with Microsoft Planner 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 Pipeliner CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pipeliner CRM data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Access Rebilly Data Using Entity Framework
This article shows how to access Rebilly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Work with Live Oracle SCM Data in Power Query
Use CData Connect AI to connect to Oracle SCM data and work with live Oracle SCM data in Microsoft Power Query.
-
Integrate Zoho Inventory Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Inventory Data enables you to integrate Zoho Inventory data into workflows built using Microsoft Power Automate Desktop.
-
Build Visualizations of Oracle Service Cloud Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Service Cloud data in Birst.
-
Create Datasets from Everhour in Domo Workbench and Build Visualizations of Everhour Data in Domo
Use the CData Software ODBC Driver for Everhour to create datasets from Everhour data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate SAP SuccessFactors LMS Data from PowerShell
Write a quick PowerShell script to query SAP SuccessFactors LMS data. Use connectivity to the live data to replicate SAP SuccessFactors LMS data to SQL Server.
-
Design BIRT Reports on ZohoPeople Data
Provide current ZohoPeople data to your embedded analytics.
-
Integrating Codex with Marketo 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.
-
Query Gmail Data as a MySQL Database in Node.js
Execute MySQL queries against Gmail data from Node.js.
-
How to Work with SendInBlue Data in ETL Validator JDBC
Connect to SendInBlue from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Exa Data in MicroStrategy through CData Connect AI
Create a live connection to Exa Data in CData Connect AI and connect to your Exa data from MicroStrategy.
-
Connect to Shortcut Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shortcut data in the Denodo Virtual DataPort Administrator.
-
Access Live ServiceNow Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ServiceNow data through MCP integration.
-
DataBind Charts to Gong Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Gong 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.
-
Design BIRT Reports on Hugging Face Data
Provide current Hugging Face data to your embedded analytics.
-
Enable the Snapchat Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snapchat Ads data.
-
How to load MailerSend data into Elasticsearch via Logstash
Introducing a simple method to load MailerSend data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Manage ActiveCampaign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ActiveCampaign.
-
Build Charts with Trello Data in Clear Analytics
Create dynamic charts and perform analytics based on Trello data in Clear Analytics.
-
Create Data Visualizations in Cognos BI with HBase Data
Access HBase data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Amazon Athena Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Amazon Athena data through MCP integration.
-
How to Connect to Live PingOne 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 PingOne data through natural language.
-
Visualize Live Mailgun Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mailgun data.
-
Analyze ZohoInvoice Data in Looker
Use CData Connect AI to connect to ZohoInvoice Data from Looker and build custom apps using live ZohoInvoice data.
-
Model Jumpseller Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Jumpseller, enabling the direct import of real-time Jumpseller data.
-
Integrating Kiro with WooCommerce 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 Connect to Live Notion 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 Notion data for you.
-
DataBind Charts to Zoom Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoom 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.
-
Connect to NetSuite Data in RapidMiner
Integrate NetSuite data with standard components and data source configuration wizards in RapidMiner Studio.
-
Interact with Live Facebook Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Facebook data.
-
Automate Discourse Data Replication to Azure Synapse
Use CData Sync to customize and automate Discourse data replication to Azure Synapse.
-
Migrating data from Google Campaign Manager 360 to Snowflake using CData SSIS Components.
Easily push Google Campaign Manager 360 data to Snowflake using the CData SSIS Tasks for Google Campaign Manager 360 and Snowflake.
-
Create Datasets from Codat in Domo Workbench and Build Visualizations of Codat Data in Domo
Use the CData Software ODBC Driver for Codat to create datasets from Codat data in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time CouchDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CouchDB data in ColdFusion.
-
Create Elorus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Elorus from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData ODBC Driver for Miro in Microsoft Power Query
You can use the CData Miro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Miro data into Microsoft Power Query.
-
A PostgreSQL Interface for Jira Assets Data using the CData ODBC Driver
Use the SQL Gateway and Jira Assets ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query Avaza Data in OpenOffice Base
Connect to Avaza data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect to Microsoft Entra ID Data from Spring Boot
Connect to Microsoft Entra ID in a Spring Boot Application using the CData JDBC Driver for Microsoft Entra ID
-
Connect to Dynamics 365 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics 365 in FileMaker Pro to connect to Dynamics 365 and work with Dynamics 365 data in your FileMaker applications.
-
Integrating OpenCode with Okta 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.
-
Automated Continuous Demio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Demio replication to Snowflake.
-
Automated Continuous ClickTime Replication to SingleStore
Use CData Sync for automated, continuous, customizable ClickTime replication to SingleStore.
-
Replicate Mixpanel Data to Multiple Databases via the CData Sync CLI
Replicate Mixpanel data to disparate databases with a single configuration.
-
Connect to FHIR Data in Ruby
Connect to FHIR data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated Workflows with Live Google Directory Data in Workato
Use CData Connect AI to connect to live Google Directory data and build automated workflows in Workato.
-
A PostgreSQL Interface for Coinbase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Coinbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Simple VCL Application for Microsoft Entra ID Data
How to build a simple VCL Application to view Microsoft Entra ID data in RAD Studio using the CData ODBC Driver for Microsoft Entra ID.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Drip
Provide connectivity to Drip data through an SAP BusinessObjects universe.
-
Build AI/ML Models with Live Retently Data using Dataiku
Connect Retently Data with Dataiku using the CData API Driver for JDBC.
-
Create a Data Access Object for PayPal Data using JDBI
A brief overview of creating a SQL Object API for PayPal data in JDBI.
-
Creating Vertica-Connected Applications in Unqork
You can use CData Connect AI to feed Vertica data to Unqork and build custom business apps.
-
Migrating data from ShipStation to Snowflake using CData SSIS Components.
Easily push ShipStation data to Snowflake using the CData SSIS Tasks for ShipStation and Snowflake.
-
Prepare, Blend, and Analyze ZohoMarketingHub Data in Alteryx Designer (Connect AI)
Build workflows to access live ZohoMarketingHub data for self-service data analytics.
-
Rapidly Develop Pipedrive-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 Pipedrive.
-
Bannerbear Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bannerbear facts in real time.
-
Integrate Google's Antigravity Agent with Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Wistia data using the Model Context Protocol.
-
Integrating Cursor with Close 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 Trae with Live PayPal Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live PayPal data from within the AI-powered IDE.
-
Automated Continuous Email Replication to SQL Server
Use CData Sync for automated, continuous, customizable Email replication to SQL Server.
-
Connect to SendGrid Data in ACL Analytics
Connect to SendGrid data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SendGrid data.
-
Automated Continuous Sybase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sybase replication to Google BigQuery.
-
How to Connect to Live Bannerbear 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 Bannerbear data for you.
-
Bidirectional Access to Sugar CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sugar CRM data in Filemaker Pro for Mac or Windows.
-
Access Live Opsgenie Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Opsgenie data into the statistical analysis tools available in SAS JMP. This article shows how to use Opsgenie data in the Graph Builder and Query Builder.
-
How to Connect to & Open ShipEngine Data in Microsoft Excel
This article uses the CData ODBC driver for ShipEngine to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Power BI Reports on Real-Time Amazon Marketplace Data
Use the CData ODBC Driver for Amazon Marketplace to visualize Amazon Marketplace data in Power BI Desktop.
-
Back Up LinkedIn data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn. In this article, we will employ an SSIS workflow to populate a database with LinkedIn data data.
-
Model Wistia Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Wistia, enabling the direct import of real-time Wistia data.
-
Build SAP Concur-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Concur Data and create custom apps in Mendix.
-
How to connect to Jodoo Data from Spring Boot
Connect to Jodoo in a Spring Boot Application using the CData API Driver for JDBC
-
How to Connect Sybase Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sybase data in real time using natural language.
-
Integrate Live CircleCI Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CircleCI data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Timely-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Timely data and build web apps with connectivity to live Timely data.
-
Create Reports with ConstantContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConstantContact data.
-
Create Monday.com-Connected Dashboards in Grafana
Connect to Monday.com Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Monday.com data.
-
Integrate Devin with Live Pipedrive Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Pipedrive data.
-
Build Dashboards with Greenplum Data in DBxtra
Create dynamic dashboards and perform analytics based on Greenplum data in DBxtra.
-
Connect to Planio Data in DBeaver
Use the CData ODBC Driver to connect to Planio data in DBeaver.
-
Visualize Live Act CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Act CRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Jumpseller Data from PowerBuilder via JDBC
This article demonstrates how to access Jumpseller data from PowerBuilder using the Jumpseller JDBC Driver.
-
Integrating LangChain with Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Databricks data within automated workflows.
-
Visualize Microsoft Ads Data in Tableau
The CData ODBC driver for Microsoft Ads enables you integrate Microsoft Ads data into Tableau dashboards.
-
Use Dash to Build to Web Apps on Contentful Data
Create Python applications that use pandas and Dash to build Contentful-connected web apps.
-
Natively Connect to Demio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Demio data. Leverage the native support for ODBC in PHP.
-
Access Live Jira Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Jira data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Live Avalara AvaTax 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 Avalara AvaTax data through a conversational interface.
-
Connect to and Query OData Services in QlikView over ODBC
Create data visualizations with OData services in QlikView.
-
Configure the CData JDBC Driver for PolarTeamPro in a Connection Pool in Tomcat
Connect to PolarTeamPro data from a connection pool in Tomcat.
-
Integrate Goose with Live CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live CapsuleCRM data from within the local AI agent.
-
Enable the Adobe Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Adobe Analytics data.
-
Replicate Multiple Reckon Accounts
Replicate multiple Reckon accounts to one or many databases.
-
Connect to Avalara AvaTax Data from a Connection Pool in Jetty
The Avalara AvaTax JDBC Driver supports connection pooling: This article shows how to connect faster to Avalara AvaTax data from Web apps in Jetty.
-
Create Apps from Microsoft Teams Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Teams Data and build apps from live Microsoft Teams data in Qlik Sense Cloud.
-
Integrating LangGraph with LinkedIn Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LinkedIn Ads data within automated workflows.
-
Automated Continuous Clockify Replication to MySQL
Use CData Sync for automated, continuous, customizable Clockify replication to MySQL.
-
How to import Basecamp Data into Apache Solr
Use the CData Software JDBC Driver for Basecamp in Data Import Handler and create an automated import of Basecamp data to Apache Solr Enterprise Search platform.
-
Integrating Codex with Dynamics 365 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.