CData Software - Knowledge Base
Recent Articles
-
Validate Microsoft Teams Data with QuerySurge
Access and validate Microsoft Teams data in QuerySurge using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Outlook Data
Access Outlook data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Excel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Excel data from Informatica Cloud.
-
Connect to ZohoSubscriptions Data in DBArtisan
Use wizards in DBArtisan to configure ZohoSubscriptions data as a data source.
-
Connect to Real-Time SAP HANA XS Advanced Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP HANA XS Advanced and Dataflow to import and use SAP HANA XS Advanced data in Power Apps.
-
Use JayDeBeApi to access SageHR Data in Python
Use standard Python scripting and the development environment of your choice to access live SageHR data.
-
Replicate Amplitude Data from PowerShell
Write a quick PowerShell script to query Amplitude data. Use connectivity to the live data to replicate Amplitude data to SQL Server.
-
Manage Google Directory Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Directory.
-
Automated Continuous Optimizely Replication to SQLite
Use CData Sync for automated, continuous, customizable Optimizely replication to SQLite.
-
Visualize Live PolarTeamPro Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PolarTeamPro data.
-
How to Work with Sage Intacct Data in ETL Validator JDBC
Connect to Sage Intacct from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Chargebee Data
Use the CData ODBC Driver for Chargebee to visualize Chargebee data in Power BI Desktop.
-
Natively Connect to Microsoft Planner Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Planner data. Leverage the native support for ODBC in PHP.
-
Visualize Gorgias Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Gorgias data into TIBCO Spotfire.
-
Create Azure Table-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Table Data from Klipfolio and build custom visualizations using live Azure Table data.
-
Use Claude to Talk to Your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zendesk data for you.
-
Automated Continuous Lakebase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Lakebase replication to Google Cloud SQL.
-
Visualize Live Teradata Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Teradata data into custom reports in Power BI.
-
Automated Continuous LinkedIn Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LinkedIn replication to Google BigQuery.
-
Access Live Twilio Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Twilio data through MCP integration.
-
Integrate Live Google Sheets Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Sheets data and integrate live Google Sheets data into apps built in Microsoft Power Apps.
-
Automate Oracle HCM Cloud Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle HCM Cloud data replication to SAP HANA.
-
Automate MailChimp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailChimp data from PowerShell? This article demonstrates how to utilize the MailChimp Cmdlets for tasks like connecting to MailChimp data, automating operations, downloading data, and more.
-
Create Power BI Reports on Real-Time Mistral AI Data
Use the CData ODBC Driver for Mistral AI to visualize Mistral AI data in Power BI Desktop.
-
Automated Continuous SAP Netweaver Gateway Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway data replication to OneLake in Microsoft Fabric.
-
Connecting Mastra with Exa 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 Exa data, no replication required.
-
Create Dynamics 365 Business Central-Connected Business Apps in AppSheet
Connect to Dynamics 365 Business Central Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Dynamics 365 Business Central data.
-
Connect to and Visualize Live ClickUp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ClickUp data.
-
Replicate Multiple Monday.com Accounts
Replicate multiple Monday.com accounts to one or many databases.
-
Integrate Cursor with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Vault CRM data from within the editor.
-
Connect Quaderno Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Quaderno data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Datasets from Reply.io in Domo Workbench and Build Visualizations of Reply.io Data in Domo
Use the CData Software ODBC Driver for Reply.io to create datasets from Reply.io data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Microsoft Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Ads data.
-
Connect to SurveyMonkey Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SurveyMonkey data in Airbyte.
-
Getting Started with the CData Connect AI Python SDK for Office 365
Install the CData Connect AI Python SDK to read and write live Office 365 data with standard DB-API 2.0 Python code.
-
Build Freshservice-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Freshservice data and build web apps with connectivity to live Freshservice data.
-
Automated Continuous Codat Replication to SQL Server
Use CData Sync for automated, continuous, customizable Codat replication to SQL Server.
-
Connecting Agentforce with Cloudant 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 Cloudant data for you.
-
Integrating OpenCode with Vercel 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.
-
Bridge Hugging Face Connectivity with Apache NiFi
Access and process Hugging Face data in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for Marketo Data in Python with CData
Create ETL applications and real-time data pipelines for Marketo data in Python with petl.
-
Integrating ShipStation Data in Talend Cloud Data Management Platform
Connect ShipStation Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ShipStation.
-
Connect to Printify Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Printify data.
-
Automated Continuous Databricks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Databricks replication to Amazon Redshift.
-
Integrate with Google Translate Data in JReport Designer
Create charts and reports based on Google Translate data in JReport Designer.
-
Integrate Customer.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Customer.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Customer.io data.
-
LINQ to Dynamics 365 Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Dynamics 365 Data Provider.
-
Integrating Claude Code CLI with Amazon Marketplace 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 Productboard Data in CloverDX (formerly CloverETL)
Transfer Productboard data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous SAP Hybris C4C Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SQLite.
-
Integrating Kiro with SAP HANA XS Advanced 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 SAP BusinessObjects BI 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 SAP BusinessObjects BI data for you.
-
Integrate Live Gmail Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gmail data to Blue Prism using the CData ODBC Driver for Gmail to create automated workflows for repetitive business tasks.
-
Access Customer.io Data from MySQL in PHP
Connect to Customer.io through the standard MySQL libraries in PHP.
-
Facebook Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Facebook Ads facts in real time.
-
Connect to ZohoPeople Data in JRuby
Create a simple JRuby app with access to live ZohoPeople data.
-
Integrate Excel Online Data in Pentaho Data Integration
Build ETL pipelines based on Excel Online data in the Pentaho Data Integration tool.
-
Build AI Agents with PolarTeamPro 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 PolarTeamPro data through CData Connect AI.
-
Connect to Tavily Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Tavily Data and connect to Tavily data in Akorbi Digital RunMyProcess.
-
How to load JSON data into Elasticsearch via Logstash
Introducing a simple method to load JSON data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to HubSpot Data in NetBeans
Connect to HubSpot data in NetBeans with the data source configuration wizard.
-
Automated Continuous Google Search Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Search replication to Vertica.
-
Access Live ConstantContact Data in AWS Lambda
Connect to live ConstantContact data in AWS Lambda using the CData JDBC Driver.
-
Build Visualizations of Paylocity Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Paylocity data in Birst.
-
LDAP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LDAP facts in real time.
-
Replicate API Data in Heroku for Use in Salesforce Connect
Replicate API data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Validate Stack Exchange Data with QuerySurge
Access and validate Stack Exchange data in QuerySurge using the CData JDBC Driver.
-
Build Data Flows from Customer.io to SQL Server using SSIS
Easily back up Customer.io data to SQL Server using the SSIS components for Customer.io.
-
Connect to ADP Data from a Connection Pool in JBoss
Integrate ADP data into Java servlets: Use the Management Console in JBoss to install the ADP JDBC Driver.
-
Access Mistral AI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mistral AI data from HeidiSQL.
-
Build Semantic Layer Views for Testmonitor Data in APOS Live Data Gateway
Use the CData Connector for Testmonitor in APOS Live Data Gateway to build Semantic Layer Views for Testmonitor data.
-
Connect to REST Data from PowerBuilder via ADO.NET
This article demonstrates how to access REST data from Appeon PowerBuilder using the CData ADO.NET Provider for REST.
-
How to Connect to Live Apify 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 Apify data for you.
-
Access SAP Hybris C4C Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Hybris C4C data from your Oracle system.
-
Sybase IQ Reporting in OBIEE with the Sybase IQ JDBC Driver
Deploy the Sybase IQ JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Dashboards with Google Directory Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Directory data in DBxtra.
-
Migrating data from Gumroad to Databricks using CData SSIS Components.
Easily push Gumroad data to Databricks using the CData SSIS Tasks for Gumroad and Databricks.
-
How to Query Live LinkedIn Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn Ads data data in natural language using Python.
-
Connecting Pipedream with Twilio 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 Twilio data in real time.
-
Create Data Visualizations in Cognos BI with SFTP Data
Access SFTP data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a PostgreSQL Interface for SAS Data Sets Data using the CData JDBC Driver
Use the Remoting features of the SAS Data Sets JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Retently Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Retently 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.
-
Create Dynamics 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics 365 data access from reports, embedded analytics, and more.
-
Enable the Couchbase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Couchbase data.
-
Use Biml to Build SSIS Tasks to Replicate Active Directory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Active Directory data to SQL Server.
-
How to Seamlessly Import Perplexity Data into IBM SPSS Modeler
Integrate Perplexity data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Controls to Pingdom Data in Delphi
DataBind to Pingdom data in Delphi with standard data access components and controls.
-
Analyze eBay Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of eBay data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Google's Antigravity Agent with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SQL Server data using the Model Context Protocol.
-
Integrating Kiro with Mode 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 with Missive Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Missive data to a JSON file on disk.
-
Automated Continuous Smartsheet Replication to MySQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to MySQL.
-
How to Connect to Live Salesforce 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 Salesforce data without replication.
-
Back Up Spark data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Spark. In this article, we will employ an SSIS workflow to populate a database with Spark data data.
-
Build Dashboards with Microsoft OneDrive Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft OneDrive data in DBxtra.
-
How to Connect to Live SQL Server 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 SQL Server data without replication.
-
Build Data Flows from Sentry to SQL Server using SSIS
Easily back up Sentry data to SQL Server using the SSIS components for Sentry.
-
Analyze Oracle Sales Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Sales data in Microsoft R Open.
-
Connect to Vercel Data in NetBeans
Connect to Vercel data in NetBeans with the data source configuration wizard.
-
Build Toggl-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Toggl data.