CData Software - Knowledge Base
Recent Articles
-
Creating Act CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Act CRM data to Unqork and build custom business apps.
-
How to Access ZohoPeople Data Using Entity Framework
This article shows how to access ZohoPeople data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Stream Salesforce Pardot Data into Apache Kafka Topics
Access and stream Salesforce Pardot data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Couchbase Data in the Pentaho Report Designer
Publish reports based on Couchbase data in the Pentaho BI tool.
-
Automated Continuous ZohoPeople Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoPeople replication to AlloyDB.
-
Build an OLAP Cube in SSAS from HCL Domino Data
Establish a connection to HCL Domino data data from SQL Server Analysis Services, and use the HCL Domino Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query LinkedIn Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to LinkedIn Ads data.
-
Use ChatGPT to Talk to Your Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Adobe Target data for you.
-
Visualize Office 365 Data in Tableau
The CData ODBC driver for Office 365 enables you integrate Office 365 data into Tableau dashboards.
-
Build AI Agents with Adobe Analytics 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 Adobe Analytics data through CData Connect AI.
-
How to Connect to Live SingleStore 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 SingleStore data through natural language.
-
Automated Continuous ChargeOver Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ChargeOver replication to Apache Kafka.
-
How to connect to Oracle Eloqua Data in DBVisualizer
Integrate Oracle Eloqua data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to & Open LinkedIn Ads Data in Microsoft Excel
This article uses the CData ODBC driver for LinkedIn Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with ChartMogul Data in Dundas BI
Create dynamic dashboards and perform analytics based on ChartMogul data in Dundas BI.
-
Connect to Google Forms Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Forms data.
-
Automated Continuous Google Ad Manager Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Amazon S3.
-
Getting Started with the CData JDBC Driver for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Blackbaud FE NXT.
-
Connect to Act-On Data in ACL Analytics
Connect to Act-On data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Act-On data.
-
How to Visualize Dynamics 365 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 Dynamics 365 data in Python.
-
How to Work with Demio Data in ETL Validator JDBC
Connect to Demio from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate SQL Analysis Services with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SQL Analysis Services with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SQL Analysis Services data.
-
How to Create Power BI Visual Reports with Real-Time CSV Data
Use CData Power BI Connectors to visualize CSV data in Power BI.
-
Access Live Moosend Data in Coginiti Pro
Connect to and query live Moosend data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Goose with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Square data from within the local AI agent.
-
Design BIRT Reports on Google Directory Data
Provide current Google Directory data to your embedded analytics.
-
Using the CData Software ODBC Driver for Apify in PyCharm
Connect to Apify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Apify.
-
Create Datasets from Cloudant in Domo Workbench and Build Visualizations of Cloudant Data in Domo
Use the CData Software ODBC Driver for Cloudant to create datasets from Cloudant data in Domo Workbench and then build visualizations in the Domo service.
-
MYOB AccountRight Reporting in OBIEE with the MYOB AccountRight JDBC Driver
Deploy the MYOB AccountRight JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating LangChain with Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Quickbase data within automated workflows.
-
Create Shippo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Shippo data access from reports, embedded analytics, and more.
-
How to publish and share WordPress Data dashboards with Tableau Server
The CData ODBC driver for WordPress enables you integrate WordPress data into Tableau dashboards.
-
Connect to Everhour Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Everhour and the SQL Gateway to access Everhour data from Google Apps Script.
-
Automate Spotify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Spotify data replication to Azure Data Lake.
-
Connect to LinkedIn Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LinkedIn data using standard SQL.
-
Integrate Twitter Ads Data into Power Automate Desktop using CData Connect
CData Connect for Twitter Ads Data enables you to integrate Twitter Ads data into workflows built using Microsoft Power Automate Desktop.
-
Link RabbitMQ with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate RabbitMQ data in Filemaker Pro for Mac or Windows.
-
Integrate Freshdesk Data in Pentaho Data Integration
Build ETL pipelines based on Freshdesk data in the Pentaho Data Integration tool.
-
Connect to Active Directory Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Active Directory data in Airbyte.
-
Build Semantic Layer Views for Avaza Data in APOS Live Data Gateway
Use the CData Connector for Avaza in APOS Live Data Gateway to build Semantic Layer Views for Avaza data.
-
Replicate Active Directory Data to Multiple Databases via the CData Sync CLI
Replicate Active Directory data to disparate databases with a single configuration.
-
Automated Continuous Cloudant Replication to Vertica
Use CData Sync for automated, continuous, customizable Cloudant replication to Vertica.
-
Integrating OpenCode with Sendwithus 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.
-
Validate SingleStore Data with QuerySurge
Access and validate SingleStore data in QuerySurge using the CData JDBC Driver.
-
Creating FHIR-Connected Applications in Unqork
You can use CData Connect AI to feed FHIR data to Unqork and build custom business apps.
-
Integrating LangChain with Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Office 365 data within automated workflows.
-
Use Microsoft Copilot Studio to talk to your Greenhouse 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 Greenhouse data for you.
-
Build Outreach.io Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Outreach.io data and build visualizations in Tableau Cloud.
-
Getting Started with the CData JDBC Driver for Superchat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Superchat.
-
Integrate Live Salesforce Marketing Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Marketing data and integrate live Salesforce Marketing data into apps built in Microsoft Power Apps.
-
Connect to SAS Data Sets Data from HeidiSQL
Use CData Connect AI to connect to and query live SAS Data Sets data from HeidiSQL.
-
Integrating GitHub Copilot with ClickTime 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.
-
Configure the CData JDBC Driver for Phoenix in a Connection Pool in Tomcat
Connect to Phoenix data from a connection pool in Tomcat.
-
Access Live Azure DevOps Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure DevOps data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Oracle SCM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle SCM data and integrate live Oracle SCM data into your Power Automate tasks.
-
How to Access Live Certinia Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Certinia enables you to integrate Certinia data into workflows built using Microsoft Power Automate Desktop.
-
Build Microsoft Planner-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 Microsoft Planner data without replication.
-
How to connect SharePoint with Oracle Financials Cloud Data through external lists
Provide Oracle Financials Cloud data to SharePoint users as an external list.
-
Object-Relational Mapping (ORM) with Azure Data Lake Storage 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 Azure Data Lake Storage data into a Java-based ORM framework, Hibernate.
-
Bridge PostgreSQL Connectivity with Apache NiFi
Access and process PostgreSQL data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live IBM Cloud Object Storage Data 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 IBM Cloud Object Storage data for you.
-
Viewing ServiceDesk Plus Data in RAD Studio Data Explorer
How to view ServiceDesk Plus data in RAD Studio Data Explorer using the CData ODBC Driver for ServiceDesk Plus.
-
How to connect SharePoint with Marketo Data through external lists
Provide Marketo data to SharePoint users as an external list.
-
Integrate Dify with Live SAP SuccessFactors LMS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP SuccessFactors LMS data.
-
Add Onfleet Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Onfleet with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to create an RPA flow for SAP Ariba Source Data in UiPath Studio
Use the SAP Ariba Source ODBC Driver to create workflows that access real-time SAP Ariba Source data without any coding.
-
Connecting Mastra with Shopify 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 Shopify data, no replication required.
-
Using the CData Software ODBC Driver for Eventbrite in PyCharm
Connect to Eventbrite as an ODBC data source in PyCharm using the CData Software ODBC Driver for Eventbrite.
-
Create Dynamic Airtable Grids Using the Infragistics XamDataGrid
Learn how you can connect Airtable to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Snapchat Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Snapchat Ads to connect to Snapchat Ads data and execute queries in PowerBuilder.
-
Oracle Reporting in OBIEE with the Oracle JDBC Driver
Deploy the Oracle JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Creating Kafka-Connected Applications in Unqork
You can use CData Connect AI to feed Kafka data to Unqork and build custom business apps.
-
Object-Relational Mapping (ORM) with Amazon S3 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 Amazon S3 data into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code with Pipedrive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Pipedrive data within assisted coding and automated development workflows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Square
Provide connectivity to Square data through an SAP BusinessObjects universe.
-
How to Work with ZohoSubscriptions Data in AWS Glue Jobs Using JDBC
Connect to ZohoSubscriptions from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Dash to Build to Web Apps on Slack Data
Create Python applications that use pandas and Dash to build Slack-connected web apps.
-
Integrate Google's Vertex AI Agent with Live Azure Table 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 Azure Table data within intelligent workflows.
-
Analyze Bitbucket Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Bitbucket data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Charts with BenchmarkEmail Data in Clear Analytics
Create dynamic charts and perform analytics based on BenchmarkEmail data in Clear Analytics.
-
Use the CData ODBC Driver for Azure Data Catalog in Microsoft Power Query
You can use the CData Azure Data Catalog ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Data Catalog data into Microsoft Power Query.
-
Use Dash to Build to Web Apps on Hacker News Data
Create Python applications that use pandas and Dash to build Hacker News-connected web apps.
-
Edit and Search External MYOB AccountRight Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MYOB AccountRight data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MYOB AccountRight Data objects that you can access from apps and the dashboard.
-
Integrate Live Apify 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 Apify data from within the IDE.
-
Use Dash to Build to Web Apps on Vercel Data
Create Python applications that use pandas and Dash to build Vercel-connected web apps.
-
Automated Continuous SAP Netweaver Gateway Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Amazon S3.
-
Connect to Factorial Data in HULFT Integrate
Connect to Factorial as a JDBC data source in HULFT Integrate
-
Write a Simple Go Application to work with Amazon S3 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon S3 data.
-
Connect to and Query AdRoll Data in QlikView over ODBC
Create data visualizations with AdRoll data in QlikView.
-
Integrating GitHub Copilot with SharePoint Excel Services 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.
-
Link HDFS with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HDFS data in Filemaker Pro for Mac or Windows.
-
How to Connect to Live Basecamp 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 Basecamp data for you.
-
Connecting Agentforce with DB2 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 DB2 data for you.
-
Integrating Airtable Data in Talend Cloud Data Management Platform
Connect Airtable Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Airtable.
-
Moving Data from Scrapfly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Scrapfly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Gumloop with Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Service Cloud data within automated workflows.
-
Automated Continuous Authorize.Net Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Authorize.Net data replication to OneLake in Microsoft Fabric.
-
Use the CData ODBC Driver for ChartMogul from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ChartMogul to connect to ChartMogul data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ChartMogul data in Excel.
-
Design BIRT Reports on YouTube Analytics Data
Provide current YouTube Analytics data to your embedded analytics.
-
Build Workday-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workday data and build web apps with connectivity to live Workday data.