CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Asana 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 Asana data for you.
-
Visualize Authorize.Net Data in Tableau
The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net data into Tableau dashboards.
-
Build EnterpriseDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live EnterpriseDB data.
-
Automated Continuous Clio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Clio data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Teradata Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teradata replication to Amazon Redshift.
-
Establish a Live Connection with HubSpot Data using Tableau Bridge
The CData ODBC Driver for HubSpot enables you to integrate live HubSpot data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to and Visualize Live Redshift Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Redshift data.
-
Import SAP ByDesign Data Using Azure Data Factory
Use CData Connect AI to connect to SAP ByDesign Data from Azure Data Factory and import live SAP ByDesign data.
-
Codat Reporting in OBIEE with the Codat JDBC Driver
Deploy the Codat JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate with HubDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live HubDB data in SnapLogic.
-
How to load ServiceDesk Plus data into Elasticsearch via Logstash
Introducing a simple method to load ServiceDesk Plus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Feed Power BI XMLA Data into FineReport
How to set Power BI XMLA data as a JDBC data source in FineReport.
-
Zendesk Reporting in OBIEE with the Zendesk JDBC Driver
Deploy the Zendesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Figshare in MicroStrategy Desktop
Connect to Figshare data in MicroStrategy Desktop using the CData Software ODBC Driver for Figshare.
-
Access Miro 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 Miro data.
-
Validate MailChimp Data with QuerySurge
Access and validate MailChimp data in QuerySurge using the CData JDBC Driver.
-
Connect to Nethunt Data in RapidMiner
Integrate Nethunt data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Planio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Planio replication to SQL Server.
-
Connect Teamgate Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Teamgate data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Multiple Google Cloud Storage Accounts
Replicate multiple Google Cloud Storage accounts to one or many databases.
-
Extract, Transform, and Load Shortcut Data in Informatica PowerCenter
Create a simple Workflow for Shortcut data in Informatica PowerCenter.
-
Connect to Excel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Excel as an External Source in Dremio.
-
Deploy the ADO.NET Provider for Email on an SSRS Report Server
Connect to Email 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.
-
Build FTP-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live FTP data.
-
Replicate JSON Services to Multiple Databases via the CData Sync CLI
Replicate JSON services to disparate databases with a single configuration.
-
Automated Continuous Vault CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Vault CRM replication to AlloyDB.
-
How to connect to Pipeline CRM Data with Squirrel SQL client
Connect to Pipeline CRM data and execute queries in the Squirrel SQL Client.
-
Connect to Reckon Accounts Hosted 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 Reckon Accounts Hosted data.
-
Integrating Kiro with SFTP 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.
-
Build AI/ML Models with Live Adobe Commerce Data using Dataiku
Connect Adobe Commerce Data with Dataiku using the CData JDBC Driver for Adobe Commerce.
-
Link Freshsales with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshsales data in Filemaker Pro for Mac or Windows.
-
Connecting Agentforce with Redis 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 Redis data for you.
-
Query Power BI XMLA Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Power BI XMLA data from Node.js.
-
Connecting Agentforce with Optimizely 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 Optimizely data for you.
-
How to connect PolyBase to SAP Business One
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Business One data.
-
Query, Visualize, and Share live Moosend Data in Redash
Use CData Connect AI to connect to live Moosend data in Redash for querying, visualizing, and sharing.
-
Connect to XML Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for XML to connect to XML data and execute queries in PowerBuilder.
-
Build Phoenix-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Phoenix Data and create custom apps in Mendix.
-
How to Connect to Live Marketo 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 Marketo data for you.
-
Build Apps with Live Oracle Financials Cloud Data Using the Low-Code Development Platform of Mendix
Connect Oracle Financials Cloud data with Mendix to build apps using the CData JDBC Driver for Oracle Financials Cloud.
-
Automated Continuous SharePoint Excel Services Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SharePoint Excel Services data replication to OneLake in Microsoft Fabric.
-
Visualize Live Access Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Access data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Campaigner Data in ETL Validator JDBC
Connect to Campaigner from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate SendGrid Data Replication to Couchbase
Use CData Sync to Customize and automate SendGrid data replication to Couchbase.
-
Work with Supabase Data in FoxPro
Load Supabase data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Work with NASA Data in AWS Glue Jobs Using JDBC
Connect to NASA from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Work with FTP Data in AWS Glue Jobs Using JDBC
Connect to FTP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Codex with MarkLogic 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 Power BI Reports on Real-Time Eventbrite Data
Use the CData ODBC Driver for Eventbrite to visualize Eventbrite data in Power BI Desktop.
-
Integrate LDAP Objects in Pentaho Data Integration
Build ETL pipelines based on LDAP objects in the Pentaho Data Integration tool.
-
Integrate ConstantContact Data into Power Automate Desktop using CData Connect
CData Connect for ConstantContact Data enables you to integrate ConstantContact data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Kiro with Google 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.
-
Integrate Sybase IQ Data in Pentaho Data Integration
Build ETL pipelines based on Sybase IQ data in the Pentaho Data Integration tool.
-
Publish Crystal Reports on Supabase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Supabase data.
-
Integrate Cline with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ServiceNow data from within your IDE.
-
Integrating BenchmarkEmail Data in Talend Cloud Data Management Platform
Connect BenchmarkEmail Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Greenhouse Replication to Oracle
Use CData Sync for automated, continuous, customizable Greenhouse replication to Oracle.
-
Build a Simple VCL Application for iContact Data
How to build a simple VCL Application to view iContact data in RAD Studio using the CData ODBC Driver for iContact.
-
How to Connect to Live SAP HANA 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 SAP HANA data through natural language.
-
Analyze Teamwork Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Teamwork data in Microsoft R Open.
-
Natively Connect to Gumroad Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Gumroad data. Leverage the native support for ODBC in PHP.
-
Connecting Pipedream with Microsoft Dataverse 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 Microsoft Dataverse data in real time.
-
How to Build an ETL App for Aweber Data in Python with CData
Create ETL applications and real-time data pipelines for Aweber data in Python with petl.
-
How to publish and share ZarMoney Data dashboards with Tableau Server
The CData ODBC driver for ZarMoney enables you integrate ZarMoney data into Tableau dashboards.
-
Analyze Odoo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Odoo from Power Pivot. You will use the Table Import Wizard to load Odoo data. You can visually build the import query or use any SQL supported by the driver.
-
Create Highrise Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Highrise from PowerBI.com to create Power BI Dataflows with real-time data.
-
Validate Facebook Data with QuerySurge
Access and validate Facebook data in QuerySurge using the CData JDBC Driver.
-
Create a Data Access Object for Kafka Data using JDBI
A brief overview of creating a SQL Object API for Kafka data in JDBI.
-
Work with CircleCI Data in FoxPro
Load CircleCI data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Live OneNote 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 OneNote data from within the IDE.
-
SAP Hybris C4C Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Hybris C4C data through CData Connect AI using different applications and tools.
-
Connecting Agentforce with SAP Netweaver Gateway 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 SAP Netweaver Gateway data for you.
-
Integrating Codex with Customer.io 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.
-
Connecting Agentforce with CockroachDB 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 CockroachDB data for you.
-
Automate ZohoMarketingHub Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoMarketingHub data from PowerShell? This article demonstrates how to utilize the ZohoMarketingHub Cmdlets for tasks like connecting to ZohoMarketingHub data, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Recruit
Create an ODBC connection to Zoho Recruit in Informatica and browse and transfer Zoho Recruit data.
-
Access Live eBay Analytics Data in Excel 365 Online (Excel for the web)
Connect to eBay Analytics data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Visualize EnterpriseDB Data in Tableau
The CData ODBC driver for EnterpriseDB enables you integrate EnterpriseDB data into Tableau dashboards.
-
Build a PostgreSQL Interface for Humanity Data using the CData JDBC Driver
Use the Remoting features of the Humanity JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to Perplexity via a JDBC Driver
Manage Perplexity data with visual tools in DBeaver like the query browser.
-
Access Live Sage 300 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage 300 data from your Excel spreadsheets.
-
Automated Continuous Confluence Replication to Snowflake
Use CData Sync for automated, continuous, customizable Confluence replication to Snowflake.
-
Connect to Sage Cloud Accounting Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage Cloud Accounting data from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Cloud Accounting.
-
Import and Visualize Active Directory Data in Power View
Create data visualizations based on Active Directory data in Excel.
-
Use CData Connect AI to Access QuickBooks Time Data in Microsoft Power Pivot
Use CData Connect AI to connect to live QuickBooks Time data in the Power Pivot business intelligence tool.
-
Create Datasets from Google Drive in Domo Workbench and Build Visualizations of Google Drive Data in Domo
Use the CData Software ODBC Driver for Google Drive to create datasets from Google Drive data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Cursor with Microsoft OneDrive 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.
-
A PostgreSQL Interface for Splunk Data using the CData ODBC Driver
Use the SQL Gateway and Splunk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Live Salesforce Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesforce in CData Connect AI and connect to your Salesforce data from PostgreSQL.
-
Connect to Real-Time Vault CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Vault CRM and Dataflow to import and use Vault CRM data in Power Apps.
-
Connect to SparkPost Data from a Connection Pool in Jetty
The SparkPost JDBC Driver supports connection pooling: This article shows how to connect faster to SparkPost data from Web apps in Jetty.
-
Integrate OpenCode with Live Mode Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Mode data from within your AI coding agent.
-
Viewing Power BI XMLA Data in RAD Studio Data Explorer
How to view Power BI XMLA data in RAD Studio Data Explorer using the CData ODBC Driver for Power BI XMLA.
-
Integrate with Wave Financial Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Wave Financial data in SnapLogic.
-
Analyze HubSpot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HubSpot data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Spotify Replication to SQLite
Use CData Sync for automated, continuous, customizable Spotify replication to SQLite.
-
Replicate Multiple Testmonitor Accounts
Replicate multiple Testmonitor accounts to one or many databases.
-
Automate Chargebee Data Replication to SAP HANA
Use CData Sync to customize and automate Chargebee data replication to SAP HANA.
-
Viewing Tavily Data in RAD Studio Data Explorer
How to view Tavily data in RAD Studio Data Explorer using the CData ODBC Driver for Tavily.
-
Automated Continuous Chargebee Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Chargebee replication to delimited files (CSV/TSV).