CData Software - Knowledge Base
Recent Articles
-
Automated Continuous LDAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LDAP replication to Amazon S3.
-
Build eBay Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to eBay Analytics and build web apps with connectivity to live eBay Analytics.
-
Automated Continuous Timely Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Timely replication to Amazon Redshift.
-
Connect and Query Live DocuSign Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live DocuSign into Databricks
-
Connect to Nethunt Data from a Connection Pool in Jetty
The Nethunt JDBC Driver supports connection pooling: This article shows how to connect faster to Nethunt from Web apps in Jetty.
-
DataBind Controls to Raisers Edge NXT Data in C++Builder
DataBind to Raisers Edge NXT in C++Builder with standard components and controls.
-
How to connect to CapsuleCRM Data from Spring Boot
Connect to CapsuleCRM in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Kiro CLI with ShipEngine 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.
-
Visualize Live Adobe Commerce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Commerce into custom reports in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for SharePoint
Create SharePoint data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time JobNimbus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JobNimbus in ColdFusion.
-
Integrate Goose with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FTP Servers from within the local AI agent.
-
Build a PostgreSQL Interface for Placid Data using the CData JDBC Driver
Use the Remoting features of the Placid JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for Datadog
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Datadog.
-
Replicate AlloyDB Data from PowerShell
Write a quick PowerShell script to query Google AlloyDB. Use connectivity to the live data to replicate Google AlloyDB to SQL Server.
-
Visualize Stripe Data in TIBCO Spotfire through OData
Integrate Stripe into dashboards in TIBCO Spotfire.
-
How to publish and share SurveyMonkey Data dashboards with Tableau Server
The CData ODBC driver for SurveyMonkey enables you integrate SurveyMonkey into Tableau dashboards.
-
Getting Started with the CData SSIS Components for ClickUp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ClickUp.
-
How to Build an ETL App for Pinecone Data in Python with CData
Create ETL applications and real-time data pipelines for Pinecone in Python with petl.
-
Connect Zoho Books to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Books using the CData Python MCP Server.
-
Integrate Live ActiveCampaign Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CockroachDB
Provide connectivity to CockroachDB through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hacker News
Provide connectivity to Hacker News through an SAP BusinessObjects universe.
-
Automated Continuous BenchmarkEmail Replication to SingleStore
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SingleStore.
-
Integrate CapsuleCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CapsuleCRM with External Services.
-
Stream SAP HANA XS Advanced Data into Apache Kafka Topics
Access and stream SAP HANA XS Advanced in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Auth0 Data in Jaspersoft Studio
Execute SQL to remote Auth0 in Jaspersoft Studio.
-
Connect to Amazon Marketplace Data in Jaspersoft Studio
Execute SQL to remote Amazon Marketplace in Jaspersoft Studio.
-
Import Redis Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Redis. In this article, you will use the OData format to import Redis into Microsoft Power Query.
-
How to connect PolyBase to Slack
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Slack.
-
Connect to AlloyDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google AlloyDB in the Denodo Virtual DataPort Administrator.
-
Visualize WooCommerce 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 WooCommerce into TIBCO Spotfire.
-
Integrating Antigravity CLI with Square via CData CLI
Connect Square to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of MYOB AccountRight Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MYOB AccountRight by developing a WCF Service Application.
-
Integrate Nethunt Data in Pentaho Data Integration
Build ETL pipelines based on Nethunt in the Pentaho Data Integration tool.
-
Integrate Goose with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Lakebase from within the local AI agent.
-
Connect to FHIR Data in ACL Analytics
Connect to FHIR via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FHIR.
-
Import and Visualize Deel Data in Power View
Create data visualizations based on Deel in Excel.
-
A PostgreSQL Interface for Teamwork Data using the CData ODBC Driver
Use the SQL Gateway and Teamwork ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Cosmos DB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cosmos DB Data from Zoho Analytics and import live Azure Cosmos DB.
-
Connect to and Visualize Live MailChimp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MailChimp.
-
3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers
Three ways to connect Claris FileMaker to external data via CData ODBC Drivers: ODBC import, FileMaker scripting, and live ESS through the SQL Gateway.
-
A PostgreSQL Interface for Box Data using the CData ODBC Driver
Use the SQL Gateway and Box ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to AdRoll Data with Squirrel SQL client
Connect to AdRoll and execute queries in the Squirrel SQL Client.
-
Build VWO-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live VWO.
-
How to connect to Scrapfly Data from Spring Boot
Connect to Scrapfly in a Spring Boot Application using the CData API Driver for JDBC
-
Use JayDeBeApi to access ClickUp Data in Python
Use standard Python scripting and the development environment of your choice to access live ClickUp.
-
Natively Connect to Google Forms Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Forms. Leverage the native support for ODBC in PHP.
-
How to Query Live WordPress Data in Perplexity MacOS Desktop
Connect to and query live WordPress Data in Perplexity Desktop using CData MCP Server.
-
Prepare, Blend, and Analyze Authorize.Net Data in Alteryx Designer (ODBC)
Build workflows to access live Authorize.Net for self-service data analytics.
-
Integrate Live SAP SuccessFactors LMS Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP SuccessFactors LMS from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP SuccessFactors LMS.
-
How to Connect to Live Square 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 Square through natural language.
-
Automated Continuous REST Replication to Oracle
Use CData Sync for automated, continuous, customizable REST replication to Oracle.
-
Connect to Notion in SpagoBI
Create reports featuring live Notion in SpagoBI Studio. Host Notion reports on SpagoBI Server.
-
How to create Visio diagrams from SingleStore Data
Automatically update SingleStore with the changes you make to Visio master shapes.
-
How to Connect the Power BI Service to TigerGraph: Complete Guide
Connect to the CData Software Power BI Connector for TigerGraph from PowerBI.com to provide real-time TigerGraph across the organization.
-
View Reports on Real-Time Scrapfly Data in Power BI Report Server
Use the CData ODBC Driver for Scrapfly to visualize Scrapfly in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Google Translate Data in RapidMiner
Integrate Google Translate with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ODBC Driver for Zendesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zendesk.
-
Getting Started with the CData Excel Add-In for Confluence
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Confluence.
-
Use JayDeBeApi to access Customer.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Customer.io.
-
Use Dash to Build to Web Apps on Xero Data
Create Python applications that use pandas and Dash to build Xero-connected web apps.
-
Access Miro Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Miro from your Oracle system.
-
Connect to and Visualize Live Salesforce Data 360 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Data 360.
-
How to Access Live TaxJar Data in Visual Studio Code via Cline
Run CData MCP Server for TaxJar on Windows Subsytem for Linux (WSL) and connect to live TaxJar from the Cline extension in Visual Studio Code.
-
Automated Continuous Todoist Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Todoist replication to Google Cloud SQL.
-
Create Azure Analysis Services-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Analysis Services Data from Klipfolio and build custom visualizations using live Azure Analysis Services.
-
Automated Continuous Zuora Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zuora replication to IBM DB2.
-
Build Freshservice-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Freshservice and build Freshservice-connected web apps with Axios.
-
DataBind Charts to MailerSend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailerSend 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.
-
How to connect to SAS Data Sets Data from IntelliJ
Integrate connectivity to SAS Data Sets with wizards in IntelliJ.
-
Create Simplesat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Simplesat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Kiro CLI with Office 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.
-
Access Live Phoenix Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Phoenix from your Google Sheets.
-
Connect to GetResponse Data in JRuby
Create a simple JRuby app with access to live GetResponse.
-
Use Biml to Build SSIS Tasks to Replicate Eventbrite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Eventbrite to SQL Server.
-
Create API-Connected Dashboards in Grafana
Connect to API Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to API.
-
Create Power BI Reports on Real-Time ADP Data
Use the CData ODBC Driver for ADP to visualize ADP in Power BI Desktop.
-
Automate Salesforce Pardot Data Replication to Couchbase
Use CData Sync to Customize and automate Salesforce Pardot replication to Couchbase.
-
Bidirectional Access to Reply.io Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Reply.io in Filemaker Pro for Mac or Windows.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoPeople
Create an ODBC connection to ZohoPeople in Informatica and browse and transfer ZohoPeople.
-
How to Work with PostgreSQL Data in ETL Validator JDBC
Connect to PostgreSQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Act CRM in SpagoBI
Create reports featuring live Act CRM in SpagoBI Studio. Host Act CRM reports on SpagoBI Server.
-
How to Connect the Power BI Service to Zoho Creator: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Creator from PowerBI.com to provide real-time Zoho Creator across the organization.
-
Integrate TaxJar Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live TaxJar from Informatica Cloud.
-
Connect to Aha! Data in RapidMiner
Integrate Aha! with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Mocean Data in Aqua Data Studio
Access Mocean from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect to Deel Data in DBVisualizer
Integrate Deel with visual data analysis tools and data connection wizards in DBVisualizer
-
Process & Analyze ElevenLabs Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ElevenLabs Data.
-
Access Live Paylocity Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paylocity from your Google Sheets.
-
Create PDFMonkey Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PDFMonkey data access from reports, embedded analytics, and more.
-
Create Oracle Financials Cloud-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Financials Cloud Data from Klipfolio and build custom visualizations using live Oracle Financials Cloud.
-
How to Connect Flowise AI Agents to Live Odoo Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Odoo ERP without replication.
-
Extract, Transform, and Load FreshBooks Data in Informatica PowerCenter
Create a simple Workflow for FreshBooks in Informatica PowerCenter.
-
Add SageHR Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SageHR with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Front Replication to Snowflake
Use CData Sync for automated, continuous, customizable Front replication to Snowflake.
-
Automated Continuous Facebook Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Facebook replication to delimited files (CSV/TSV).
-
Integrating Cursor CLI with FormSite 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 and Visualize Live AgileCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AgileCRM.
-
Access Live Salesforce CRM Analytics Data in AWS Lambda
Connect to live Salesforce CRM Analytics in AWS Lambda using the CData JDBC Driver.