CData Software - Knowledge Base
Recent Articles
-
How to connect to Tavily Data from Spring Boot
Connect to Tavily in a Spring Boot Application using the CData API Driver for JDBC
-
Natively Connect to FreshBooks Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to FreshBooks. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Reckon Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Reckon.
-
Integrating Claude Code with Box Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Box within assisted coding and automated development workflows.
-
Excel Spreadsheet Automation on Okta Data with the QUERY Formula
Pull data from Okta, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Microsoft Exchange Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Oracle.
-
How to Connect to Live Microsoft Planner Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Planner without replication.
-
Access Splunk Data from MySQL in Amazon QuickSight
Connect to Splunk and build visualizations of Splunk using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Tableau Connector for Google Tasks
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Data Visualizations in Cognos BI with SFTP Data
Access SFTP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
ETL Codat in Oracle Data Integrator
This article shows how to transfer Codat into a data warehouse using Oracle Data Integrator.
-
Build Apps with Live WordPress Data Using the Low-Code Development Platform of Mendix
Connect WordPress with Mendix to build apps using the CData JDBC Driver for WordPress.
-
View Reports on Real-Time Cosmos DB Data in Power BI Report Server
Use the CData ODBC Driver for Cosmos DB to visualize Azure Cosmos DB in Power BI Desktop and then publish them to Power BI Report Server.
-
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 to SQL Server.
-
Connect to Attio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Attio.
-
Use the CData ODBC Driver for ZohoDesk in Microsoft Power Query
You can use the CData ZohoDesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoDesk into Microsoft Power Query.
-
DataBind Controls to Pingdom Data in Delphi
DataBind to Pingdom in Delphi with standard data access components and controls.
-
Build Data Flows from Mouseflow to SQL Server using SSIS
Easily back up Mouseflow to SQL Server using the SSIS components for Mouseflow.
-
Connect to JobNimbus Data in RapidMiner
Integrate JobNimbus with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Acumatica ERP using the Model Context Protocol.
-
How to connect SharePoint with Salesforce Data 360 Data through external lists
Provide Salesforce Data 360 to SharePoint users as an external list.
-
Import Twilio Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Twilio. In this article, you will use the OData format to import Twilio into Microsoft Power Query.
-
Connect to Workable Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Workable using standard SQL.
-
Analyze Couchbase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Couchbase from Power Pivot. You will use the Table Import Wizard to load Couchbase. You can visually build the import query or use any SQL supported by the driver.
-
Create Microsoft OneDrive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft OneDrive data access from reports, embedded analytics, and more.
-
Automated Continuous Salesforce CRM Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Oracle.
-
Back Up Apache Spark SQL 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 Apache Spark SQL data.
-
Operational Reporting on Office 365 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Office 365.
-
Automate Snowflake Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Snowflake and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData ODBC Driver for Vercel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Vercel to connect to Vercel from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Vercel in Excel.
-
How to Create Power BI Visual Reports with Real-Time Invoiced Data
Use CData Power BI Connectors to visualize Invoiced in Power BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics 365 Business Central
Provide connectivity to Dynamics 365 Business Central through an SAP BusinessObjects universe.
-
Build AI/ML Models with Live Pushbullet Data using Dataiku
Connect Pushbullet Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for Webex
Create Webex data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Postmark 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 Postmark into TIBCO Spotfire.
-
A PostgreSQL Interface for Highrise Data using the CData ODBC Driver
Use the SQL Gateway and Highrise ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live MailerLite Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MailerLite.
-
Build a Simple VCL Application for Hugging Face Data
How to build a simple VCL Application to view Hugging Face in RAD Studio using the CData ODBC Driver for Hugging Face.
-
How to Work with FormSite Data in ETL Validator JDBC
Connect to FormSite from ETL Validator jobs using the CData Software JDBC Driver.
-
ETL Cloudant in Oracle Data Integrator
This article shows how to transfer IBM Cloudant into a data warehouse using Oracle Data Integrator.
-
Publish QuickBooks Online-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Online.
-
Automated Continuous Tickspot Replication to Oracle
Use CData Sync for automated, continuous, customizable Tickspot replication to Oracle.
-
Getting Started with the CData Connect AI Python SDK for Active Directory
Install the CData Connect AI Python SDK to read and write live Active Directory with standard DB-API 2.0 Python code.
-
How to Visualize Oracle Eloqua 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 Oracle Eloqua in Python.
-
Build Semantic Layer Views for EnterpriseDB Data in APOS Live Data Gateway
Use the CData Connector for EnterpriseDB in APOS Live Data Gateway to build Semantic Layer Views for EnterpriseDB.
-
Connect to PayPal Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PayPal to connect to PayPal and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Teamgate in MicroStrategy Web
Connect to Teamgate in MicroStrategy Web using the CData Software ODBC Driver for Teamgate.
-
How to Connect to Live Slack 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 Slack for you.
-
Integrate Mailgun Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mailgun from Informatica Cloud.
-
Bridge Azure DevOps Connectivity with Apache NiFi
Access and process Azure DevOps in Apache NiFi using the CData JDBC Driver.
-
Access Printful Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Printful from your Oracle system.
-
Use the CData Software ODBC Driver for MongoDB in SAS for Real-Time Reporting and Analytics
Connect to real-time MongoDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MongoDB.
-
Analyze Microsoft OneDrive Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft OneDrive Data from Cognos Analytics and analyze live Microsoft OneDrive.
-
Create Reports from Authorize.Net Data in Looker Studio
Use CData Connect AI to gain access to live Authorize.Net and create custom reports in Looker Studio.
-
Enable the Kintone JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Kintone.
-
Automated Continuous Sugar CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Vertica.
-
Connect to Flowlu Data in JRuby
Create a simple JRuby app with access to live Flowlu.
-
Deploy the ADO.NET Provider for Flowlu on an SSRS Report Server
Connect to Flowlu 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.
-
Automated Continuous Epicor Kinetic Replication to Databricks
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Databricks.
-
How to connect to SAP Data in DBVisualizer
Integrate SAP ERP/NetWeaver with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for EnterpriseDB in SAS for Real-Time Reporting and Analytics
Connect to real-time EnterpriseDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for EnterpriseDB.
-
Integrating Claude Code CLI with LDAP Objects 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 Workday-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Workday to explore live Workday Data in Claude Code to assist with building Workday-powered applications.
-
Automated Continuous Access Replication to SQL Server
Use CData Sync for automated, continuous, customizable Access replication to SQL Server.
-
Build Charts with ClickTime Data in Clear Analytics
Create dynamic charts and perform analytics based on ClickTime in Clear Analytics.
-
DataBind Controls to CapsuleCRM Data in Delphi
DataBind to CapsuleCRM in Delphi with standard data access components and controls.
-
Choosing the Best Method to Connect HCL Domino to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HCL Domino from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to import Reply.io Data into Apache Solr
Use the CData Software JDBC Driver for Reply.io in Data Import Handler and create an automated import of Reply.io to Apache Solr Enterprise Search platform.
-
Connect to Sage Intacct Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sage Intacct in FileMaker Pro to connect to Sage Intacct and work with Sage Intacct in your FileMaker applications.
-
How to Access WooCommerce Data Using Entity Framework
This article shows how to access WooCommerce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Excel Spreadsheet Automation on Omnisend Data with the QUERY Formula
Pull data from Omnisend, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous PabblySubscriptions Replication to MongoDB
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to MongoDB.
-
Access Live Quaderno Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Quaderno in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Cursor with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Reckon Accounts Hosted from within the editor.
-
Connect to Avalara AvaTax Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Avalara AvaTax Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Active Directory Data in RapidMiner
Integrate Active Directory with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Amazon S3 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Amazon Redshift.
-
Visualize Printify Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Printify.
-
Work with Live Reckon Accounts Hosted Data in Power Query
Use CData Connect AI to connect to Reckon Accounts Hosted and work with live Reckon Accounts Hosted in Microsoft Power Query.
-
Extract, Transform, and Load Vault CRM Data in Informatica PowerCenter
Create a simple Workflow for Veeva Vault & Vault CRM in Informatica PowerCenter.
-
Create Datasets from FreeAgent in Domo Workbench and Build Visualizations of FreeAgent Data in Domo
Use the CData Software ODBC Driver for FreeAgent to create datasets from FreeAgent in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with Reply.io Data in JReport Designer
Create charts and reports based on Reply.io in JReport Designer.
-
How to create Microsoft Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Ads in MySQL .
-
Automate Pipedrive Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Pipedrive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Todoist Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Extract, Transform, and Load Zoho Inventory Data in Informatica PowerCenter
Create a simple Workflow for Zoho Inventory in Informatica PowerCenter.
-
Visualize Greenplum 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 Pivotal GreenPlum into TIBCO Spotfire.
-
Migrating data from EmailOctopus to Google BigQuery using CData SSIS Components.
Easily push EmailOctopus to Google BigQuery using the CData SSIS Tasks for EmailOctopus and Google BigQuery.
-
Use the CData API Server to Access Oracle Sales Data in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Sales in the Power Pivot business intelligence tool.
-
Query SAP Concur Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Concur from Node.js.
-
Import Real-Time Microsoft Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Ads in ColdFusion.
-
Create HBase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HBase data access from reports, embedded analytics, and more.
-
Natively Connect to Scrapfly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Scrapfly. Leverage the native support for ODBC in PHP.
-
Integrate Live AfterShip Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live AfterShip to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Seamlessly Import SAP Concur Data into IBM SPSS Modeler
Integrate SAP Concur data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
View Reports on Real-Time eBay Analytics Data in Power BI Report Server
Use the CData ODBC Driver for eBay Analytics to visualize eBay Analytics in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Gong-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Gong.
-
Analyze Google Spanner Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Spanner in Microsoft R Open.
-
How to Seamlessly Import Google Tasks Data into IBM SPSS Modeler
Integrate Google Tasks data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live HDFS Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache HDFS in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.