CData Software - Knowledge Base
Recent Articles
-
Visualize Active Directory 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 Active Directory into TIBCO Spotfire.
-
Build a Salesforce Integration with Java and MCP Server
Accelerate Salesforce-Java integration from days to hours using AI-assisted development with CData drivers and Cursor IDE
-
Build Semantic Layer Views for Google Spanner Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Spanner.
-
Connect to Redis Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Redis from Filemaker Pro on Mac.
-
Create Data Visualizations Based On Klaviyo Data in Mode
Use CData Connect AI to connect to Klaviyo Data from Mode and build visualizations using live
-
Integrate PayPal with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PayPal with External Services.
-
Build a Singer.io Tap for Highrise With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Highrise data using
-
Connect to and Visualize Live Paddle Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paddle.
-
Automated Continuous Shortcut Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shortcut replication to IBM DB2.
-
How to Work with Vault CRM Data in AWS Glue Jobs Using JDBC
Connect to Vault CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build LDAP-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for LDAP to explore live LDAP Objects in Gemini Code Assist to assist with building LDAP-powered applications.
-
Automated Continuous Teamgate Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teamgate replication to IBM DB2.
-
Build an OLAP Cube in SSAS from Short.io Data
Establish a connection to Short.io data from SQL Server Analysis Services, and use the Short.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Cosmos DB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Cosmos DB and visualize live Azure Cosmos DB in Infragistics Reveal.
-
Getting Started with the CData JDBC Driver for Mouseflow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mouseflow.
-
Getting Started with the CData Excel Add-In for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP SuccessFactors LMS.
-
How to Connect Flowise AI Agents to Live Greenhouse 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 Greenhouse without replication.
-
Integrate with Retently Data in JReport Designer
Create charts and reports based on Retently in JReport Designer.
-
Build Salesforce CRM Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce CRM Analytics.
-
Integrating Codex CLI with Google Analytics 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 AlloyDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google AlloyDB in SnapLogic.
-
How to Visualize FreshBooks 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 FreshBooks in Python.
-
Getting Started with the CData Power BI Connector for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Mistral AI Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mistral AI to connect to Mistral AI and execute queries in PowerBuilder.
-
How to create Mocean federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mocean in MySQL .
-
Intercom Reporting in OBIEE with the Intercom JDBC Driver
Deploy the Intercom JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate Google Calendar with Apache Airflow
Access and process Google Calendar in Apache Airflow using the CData JDBC Driver.
-
Connect to Snapchat Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Snapchat Ads in the Denodo Virtual DataPort Administrator.
-
Object-Relational Mapping (ORM) with Google Calendar 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 Google Calendar into a Java-based ORM framework, Hibernate.
-
Automated Continuous Wistia Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wistia replication to SQL Server.
-
How to work with Facebook Ads Data in Apache Spark using SQL
Access and process Facebook Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Google Forms Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Forms replication to Apache Kafka.
-
How to work with Short.io Data in Apache Spark using SQL
Access and process Short.io Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for SAP Fieldglass from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Fieldglass in Excel.
-
Access Auth0 Data from MySQL in PHP
Connect to Auth0 through the standard MySQL libraries in PHP.
-
Connect to Google Cloud Storage Data from a Connection Pool in JBoss
Integrate Google Cloud Storage into Java servlets: Use the Management Console in JBoss to install the Google Cloud Storage JDBC Driver.
-
Bridge Zoom Connectivity with Apache NiFi
Access and process Zoom in Apache NiFi using the CData JDBC Driver.
-
Extract, Transform, and Load Sybase Data in Informatica PowerCenter
Create a simple Workflow for Sybase in Informatica PowerCenter.
-
Connect to Live FTP Data in PostGresSQL Interface through CData Connect AI
Create a live connection to FTP in CData Connect AI and connect to your FTP Servers from PostgreSQL.
-
Seamlessly Bring OneNote Data into Retool Using CData Connect AI
Integrate OneNote data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Kiro CLI with Sybase 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.
-
Choosing the Best Method to Connect Zuora to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zuora from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Accelo Replication to Oracle
Use CData Sync for automated, continuous, customizable Accelo replication to Oracle.
-
Manage CloudConvert Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CloudConvert.
-
Create Reports with Pipedrive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipedrive.
-
Integrate with Live Facebook Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Facebook Ads from the MuleSoft Anypoint Platform to integrate live Facebook Ads into custom reports and dashboards.
-
Build a PostgreSQL Interface for Lakebase Data using the CData JDBC Driver
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect Amazon QuickSight to MYOB AccountRight Data
Create a connection to MYOB AccountRight in CData Connect AI and insert MYOB AccountRight into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Tableau Connector for Zuora
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zuora.
-
Raisers Edge NXT Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Raisers Edge NXT facts in real time.
-
Create Kintone Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Kintone from PowerBI.com to create Power BI Dataflows with real-time data.
-
Working with SAP Hybris C4C Data in LINQPad
Execute LINQ queries to SAP Hybris C4C in LINQPad.
-
Use the CData Software ODBC Driver for Couchbase in MicroStrategy Web
Connect to Couchbase in MicroStrategy Web using the CData Software ODBC Driver for Couchbase.
-
Integrating Claude Code CLI with Jira 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.
-
Integrating LlamaIndex with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Couchbase in real time.
-
Build Visualizations of Act-On Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Act-On in Birst.
-
Enable the Access JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Access.
-
Use the CData ODBC Driver for Splunk in Microsoft Power Query
You can use the CData Splunk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Splunk into Microsoft Power Query.
-
Build Apps with Live SAP Business One Data Using the Low-Code Development Platform of Mendix
Connect SAP Business One with Mendix to build apps using the CData JDBC Driver for SAP Business One.
-
Visualize Live Acumatica Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Acumatica ERP.
-
Automated Continuous Reckon Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Reckon replication to delimited files (CSV/TSV).
-
Connecting Agentforce with Amazon S3 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 Amazon S3 for you.
-
Automated Continuous Amazon S3 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon S3 replication to AlloyDB.
-
Automated Continuous GraphQL Replication to Oracle
Use CData Sync for automated, continuous, customizable GraphQL replication to Oracle.
-
How to Connect DBeaver to Quickbase via a JDBC Driver
Manage Quickbase with visual tools in DBeaver like the query browser.
-
Connect to Salesforce Data in Jaspersoft Studio
Execute SQL to remote Salesforce & Force.com in Jaspersoft Studio.
-
Automated Continuous Todoist Replication to MySQL
Use CData Sync for automated, continuous, customizable Todoist replication to MySQL.
-
Consume SuiteCRM OData Feeds in PowerBuilder
This article demonstrates how to consume SuiteCRM as OData feeds from PowerBuilder using the API Server.
-
Build a Simple VCL Application for Supabase Data
How to build a simple VCL Application to view Supabase in RAD Studio using the CData ODBC Driver for Supabase.
-
Replicate Multiple Insightly Accounts via the CData Sync CLI
Replicate multiple Insightly accounts to one or many databases.
-
Query Hive Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Hive and perform CRUD operations on Hive from Node.js.
-
Import and Visualize Intercom Data in Power View
Create data visualizations based on Intercom in Excel.
-
How to Seamlessly Import Flowlu Data into IBM SPSS Modeler
Integrate Flowlu data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Wistia Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Wistia from PowerShell? This article demonstrates how to utilize the Wistia Cmdlets for tasks like connecting to Wistia, automating operations, downloading data, and more.
-
Query Klipfolio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Klipfolio from Node.js.
-
ZohoMarketingHub Reporting in OBIEE with the ZohoMarketingHub JDBC Driver
Deploy the ZohoMarketingHub JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Bitbucket Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bitbucket replication to Amazon S3.
-
Extract, Transform, and Load Redis Data in Informatica PowerCenter
Create a simple Workflow for Redis in Informatica PowerCenter.
-
How to use SQLAlchemy ORM to access Twilio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twilio.
-
Use the CData ODBC Driver for Helpscout in Microsoft Power Query
You can use the CData Helpscout ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Helpscout into Microsoft Power Query.
-
Integrate with Sage 300 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage 300 to a JSON file on disk.
-
Getting Started with the CData Connect AI Python SDK for LinkedIn Ads
Install the CData Connect AI Python SDK to read and write live LinkedIn Ads with standard DB-API 2.0 Python code.
-
Analyze Reckon Accounts Hosted Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Reckon Accounts Hosted and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query SAP BusinessObjects BI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP BusinessObjects BI from Node.js.
-
Extend Google Sheets with DB2 Data
Make calls to DB2 from Google Apps Script via the API Server.
-
LINQ to Excel 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 Excel Data Provider.
-
Visualize Live OpenWeatherMap Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live OpenWeatherMap.
-
Connect to Google Translate from Asprova with CData Software ODBC Driver for Google Translate
This article shows how to connect faster to Google Translate data from Asprova.
-
Query Live Sage Cloud Accounting Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Sage Business Cloud Accounting directly from the development environment.
-
Analyze Live SAP Business One Data in SAS Viya
Use CData Connect AI to connect to SAP Business One from SAS Viya and deploy self-service analytics using live SAP Business One.
-
Rapidly Develop ConvertAPI-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ConvertAPI.
-
Build Vault CRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in Cursor to assist with building Vault CRM-powered applications.
-
Visualize Live Impala Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apache Impala into custom reports in Power BI.
-
Analyze Landbot Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Landbot in Microsoft R Open.
-
Use the CData ODBC Driver for Google Directory in Microsoft Power Query
You can use the CData Google Directory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Directory into Microsoft Power Query.
-
Getting Started with the CData SSIS Components for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ActiveCampaign.
-
Query Nuclia Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Nuclia from Node.js.
-
Work with Dotmailer Data in FoxPro
Load Dotmailer into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate ChartMogul Data in Pentaho Data Integration
Build ETL pipelines based on ChartMogul in the Pentaho Data Integration tool.
-
Connect to and Visualize Live Foursquare Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Foursquare.