CData Software - Knowledge Base
Recent Articles
-
Integrate Flowlu Data in Pentaho Data Integration
Build ETL pipelines based on Flowlu data in the Pentaho Data Integration tool.
-
Integrate with Certinia Data in JReport Designer
Create charts and reports based on Certinia data in JReport Designer.
-
How to Connect DBeaver to Oracle HCM Cloud via a JDBC Driver
Manage Oracle HCM Cloud data with visual tools in DBeaver like the query browser.
-
Access Live Jira Data in Coginiti Pro
Connect to and query live Jira data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build to Web Apps on Oracle Eloqua Data
Create Python applications that use pandas and Dash to build Oracle Eloqua-connected web apps.
-
Visualize Live AlloyDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live AlloyDB data into custom reports in Power BI.
-
Integrate Google's Vertex AI Agent with Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Salesloft data within intelligent workflows.
-
Load LinkedIn Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LinkedIn Ads data to a database.
-
Publish Crystal Reports on LeadDesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LeadDesk data.
-
Visualize Live MongoDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MongoDB data into custom reports in Power BI.
-
Add Amazon Marketplace Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon Marketplace with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SAP BusinessObjects BI Data from a Connection Pool in Jetty
The SAP BusinessObjects BI JDBC Driver supports connection pooling: This article shows how to connect faster to SAP BusinessObjects BI data from Web apps in Jetty.
-
Connect and Query Live Facebook Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Facebook data into Databricks and enable direct, live querying and analysis without replication.
-
Replicate Reckon Accounts Hosted Data in Heroku for Use in Salesforce Connect
Replicate Reckon Accounts Hosted data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Azure Analysis Services Data from Spring Boot
Connect to Azure Analysis Services in a Spring Boot Application using the CData JDBC Driver for Azure Analysis Services
-
Integrating GitHub Copilot with Pipeline CRM 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.
-
Create Kafka-Connected Applications in Appsmith
Connect to Kafka Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Kafka data.
-
DataBind Charts to Bannerbear Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bannerbear 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.
-
Automate Apify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apify data from PowerShell? This article demonstrates how to utilize the Apify Cmdlets for tasks like connecting to Apify data, automating operations, downloading data, and more.
-
Replicate Multiple Pipedrive Accounts via the CData Sync CLI
Replicate multiple Pipedrive accounts to one or many databases.
-
Analyze GitLab Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GitLab data in Microsoft R Open.
-
Provide OData Services of Simplesat Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Simplesat data by developing a WCF Service Application.
-
Build Data Flows from Aha! to SQL Server using SSIS
Easily back up Aha! data to SQL Server using the SSIS components for Aha!.
-
Back Up Pinterest data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Pinterest. In this article, we will employ an SSIS workflow to populate a database with Pinterest data data.
-
Connect to Bullhorn CRM Data in Jaspersoft Studio
Execute SQL to remote Bullhorn CRM data in Jaspersoft Studio.
-
Automated Continuous ZohoSubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to delimited files (CSV/TSV).
-
Integrating LangChain with AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on AgileCRM data within automated workflows.
-
Getting Started with the CData ADO.NET Provider for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for IBM Cloud Object Storage.
-
Access Live Google Sheets Data in Coginiti Pro
Connect to and query live Google Sheets data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Deel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Deel replication to AlloyDB.
-
Access Google Search Results from MySQL in PHP
Connect to Google Search through the standard MySQL libraries in PHP.
-
Import Real-Time Mistral AI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mistral AI data in ColdFusion.
-
Validate Pinterest Data with QuerySurge
Access and validate Pinterest data in QuerySurge using the CData JDBC Driver.
-
Establish a Live Connection with TaxJar Data using Tableau Bridge
The CData ODBC Driver for TaxJar enables you to integrate live TaxJar data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Microsoft OneDrive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft OneDrive data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect Google Tasks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Tasks data using the CData Python MCP Server.
-
Use the CData ODBC Driver for eBay Analytics in Microsoft Power Query
You can use the CData eBay Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import eBay Analytics data into Microsoft Power Query.
-
Use Dash to Build to Web Apps on Highrise Data
Create Python applications that use pandas and Dash to build Highrise-connected web apps.
-
Query Azure Synapse Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Synapse data from Node.js.
-
Use Agno to Talk to Your Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Jumpseller data for you.
-
Add Shippo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Shippo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Supabase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Supabase data from your Excel spreadsheets.
-
Interact with Live Campaigner Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Campaigner data.
-
Use the CData Software JDBC Driver for MailerSend in MicroStrategy
Connect to MailerSend data in MicroStrategy Developer using the CData Software JDBC Driver for MailerSend.
-
Integrate Goose with Live Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Bannerbear data from within the local AI agent.
-
Build Pipelines with Live ShipStation Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ShipStation from Google Cloud Data Fusion, enabling the integration of live ShipStation data into the building and management of effective data pipelines.
-
Easily Integrate LaunchDarkly Data in Lazarus Pascal IDE
Learn how to easily integrate live LaunchDarkly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting GenSpark with Anaplan Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Anaplan data without any replication or custom integration required.
-
Integrate Theia IDE with Live Jira 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 Jira data from within the development environment.
-
Natively Connect to ElevenLabs Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ElevenLabs data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Freshservice Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshservice replication to SQL Server.
-
Analyze Teradata Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Teradata data and visualize live Teradata data in Infragistics Reveal.
-
Using the CData Software ODBC Driver for Foursquare in PyCharm
Connect to Foursquare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Foursquare.
-
Automated Continuous Microsoft Planner Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to PostgreSQL.
-
Integrate with Live Reckon Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Reckon from the MuleSoft Anypoint Platform to integrate live Reckon data into custom reports and dashboards.
-
Connect to Pipeline CRM from Asprova with CData Software ODBC Driver for Pipeline CRM
This article shows how to connect faster to Pipeline CRM data from Asprova.
-
Stream Reply.io Data into Apache Kafka Topics
Access and stream Reply.io data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Feed FHIR Data into FineReport
How to set FHIR data as a JDBC data source in FineReport.
-
Connect to Confluence from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Confluence data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Establish a Live Connection with GraphQL Data using Tableau Bridge
The CData ODBC Driver for GraphQL enables you to integrate live GraphQL data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Perigon-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Perigon data and build web apps with connectivity to live Perigon data.
-
Visualize Live BigQuery Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live BigQuery data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Google Sheets Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Sheets replication to PostgreSQL.
-
Consume Square OData Feeds in PowerBuilder
This article demonstrates how to consume Square data as OData feeds from PowerBuilder using the API Server.
-
Connect to Live Quickbase Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Quickbase in CData Connect AI and connect to your Quickbase data from PostgreSQL.
-
Use Azure AI Foundry to Talk to Your Snapchat Ads 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 Snapchat Ads data for you.
-
Automated Continuous Oracle SCM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Azure SQL Database.
-
Automated Continuous Float Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Float replication to Amazon Redshift.
-
Automated Continuous Hive Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Hive replication to Apache Kafka.
-
Analyze Slack Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Slack data and visualize live Slack data in Infragistics Reveal.
-
Work with Live Airtable Data in Power Query
Use CData Connect AI to connect to Airtable data and work with live Airtable data in Microsoft Power Query.
-
Explore Geographical Relationships in Spark Data with Power Map
Create data visualizations with Spark data in Power Map.
-
Integrating Codex with Workable 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 Goose with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Adobe Commerce data from within the local AI agent.
-
Query DB2 Data in DataGrip
Create a Data Source for DB2 in DataGrip and use SQL to query live DB2 data.
-
Connect to Greenplum Data in HULFT Integrate
Connect to Greenplum as a JDBC data source in HULFT Integrate
-
Extract, Transform, and Load Smartsheet Data in Informatica PowerCenter
Create a simple Workflow for Smartsheet data in Informatica PowerCenter.
-
Integrate Live Freshdesk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Freshdesk data from within the IDE.
-
Visualize Azure Data Catalog Data in TIBCO Spotfire through ADO.NET
Integrate Azure Data Catalog data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Python Connector for FHIR
Learn to install and license the CData Python Connector and configure a connection to live FHIR data.
-
Integrating Antigravity CLI with Zoho Recruit data via CData CLI
Connect Zoho Recruit data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Claude Code with Confluence Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Confluence data within assisted coding and automated development workflows.
-
How to Connect to Live MariaDB 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 MariaDB data through natural language.
-
Edit and Search External Vertica Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Vertica data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Vertica Data objects that you can access from apps and the dashboard.
-
Build MYOB AccountRight-Connected Apps in Choreo
Use CData Connect AI to connect to MYOB AccountRight Data from Choreo and build custom apps using live MYOB AccountRight data.
-
How to Visualize Cassandra Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Cassandra data in Python.
-
Integrating Gumloop with ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ActiveCampaign data within automated workflows.
-
Build Voice Agents in ElevenLabs with access to Live ADP Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ADP data.
-
Connect Egnyte to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Egnyte data using the CData Python MCP Server.
-
Configure the CData JDBC Driver for FTP in a Connection Pool in Tomcat
Connect to FTP data from a connection pool in Tomcat.
-
Replicate Paylocity Data in Heroku for Use in Salesforce Connect
Replicate Paylocity data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Devin with Live Figshare 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 Figshare data.
-
Easily Integrate Klaviyo Data in Lazarus Pascal IDE
Learn how to easily integrate live Klaviyo data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import and Visualize Bright Data Data in Power View
Create data visualizations based on Bright Data data in Excel.
-
Connect to GraphQL Data in Google Apps Script via Connect AI
Use CData Connect AI to access GraphQL data in Google Apps Script.
-
Getting Started with the CData Power BI Connector for Bitbucket
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Bitbucket.
-
Use Dash to Build Web Apps on Yelp Data via CData Connect AI
Build interactive Dash web apps on live Yelp data using pandas and the CData Connect AI Python SDK.
-
Feed SharePoint Excel Services Data into FineReport
How to set SharePoint Excel Services data as a JDBC data source in FineReport.
-
Use the CData ODBC Driver for SuiteCRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SuiteCRM to connect to SuiteCRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SuiteCRM data in Excel.
-
Interact with Live Shopify Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Shopify data.