CData Software - Knowledge Base
Recent Articles
-
Integrate Live Xero Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Xero Accounting and integrate live Xero Accounting into apps built in Microsoft Power Apps.
-
Access Live Oracle HCM Cloud 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 Oracle HCM Cloud through MCP integration.
-
Automated Continuous Google Tasks Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Tasks replication to MongoDB.
-
Bidirectional Access to Acumatica Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Acumatica ERP in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Raisers Edge NXT Data in Power BI Report Server
Use the CData ODBC Driver for Raisers Edge NXT to visualize Raisers Edge NXT in Power BI Desktop and then publish them to Power BI Report Server.
-
Build a PostgreSQL Interface for LaunchDarkly Data using the CData JDBC Driver
Use the Remoting features of the LaunchDarkly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Apollo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Apollo within assisted coding and automated development workflows.
-
Replicate Multiple Billsby Accounts via the CData Sync CLI
Replicate multiple Billsby accounts to one or many databases.
-
Object-Relational Mapping (ORM) with Pipeline CRM 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 Pipeline CRM into a Java-based ORM framework, Hibernate.
-
Use Dash to Build Web Apps on Google Search Results via CData Connect AI
Build interactive Dash web apps on live Google Search using pandas and the CData Connect AI Python SDK.
-
Publish SendPulse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SendPulse.
-
Connect to Redshift Data in RazorSQL
Connect to Redshift from wizards and query Amazon Redshift from the GUI in the RazorSQL database management tool.
-
Publish Reports with SageHR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SageHR.
-
Natively Connect to HubDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HubDB. Leverage the native support for ODBC in PHP.
-
Natively Connect to Clockify Data in PHP
The CData ODBC driver for Clockify enables you to create PHP applications with connectivity to Clockify. Leverage the native support for ODBC in PHP.
-
Automated Continuous Microsoft Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to MongoDB.
-
Integrating Codex CLI with Aha! 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.
-
Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy
Connect to Salesforce Marketing Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Marketing.
-
Analyze Cohere Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cohere from Power Pivot. You will use the Table Import Wizard to load Cohere. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from ZohoDesk to Snowflake using CData SSIS Components.
Easily push ZohoDesk to Snowflake using the CData SSIS Tasks for ZohoDesk and Snowflake.
-
Build Dashboards with Mocean Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mocean in Dundas BI.
-
Bind Live Google Directory Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Directory data
-
How to load SAP Fieldglass data into Elasticsearch via Logstash
Introducing a simple method to load SAP Fieldglass data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to use SQLAlchemy ORM to access SAP Business Warehouse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Business Warehouse.
-
How to Query Live SAP Data in Claude Desktop
Connect to and query live SAP Data in Claude Desktop using CData MCP Server.
-
Build Apps with Live IBM DB2 in Adalo using CData Connect AI
Use CData Connect AI to integrate live IBM DB2 into the Adalo platform and build custom mobile and web applications with real-time IBM DB2.
-
How to connect to Dropbox Data from Spring Boot
Connect to Dropbox in a Spring Boot Application using the CData JDBC Driver for Dropbox
-
How to Easily Query FreshBooks Data in OpenOffice Base
Connect to FreshBooks data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Establish a Live Connection with GraphQL Data using Tableau Bridge
The CData ODBC Driver for GraphQL enables you to integrate live GraphQL into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Perigon-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Perigon and build web apps with connectivity to live Perigon.
-
Connect to Miro from a Connection Pool in WebLogic
Use the CData JDBC Driver for Miro to connect to Miro from Web applications running on WebLogic.
-
Connect to Productboard Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Productboard and the SQL Gateway to access Productboard from Google Apps Script.
-
Choosing the Best Method to Connect Perplexity to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Perplexity from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Dataiku with LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live LinkedIn Ads.
-
Build Apps with Live Facebook in Adalo using CData Connect AI
Use CData Connect AI to integrate live Facebook into the Adalo platform and build custom mobile and web applications with real-time Facebook.
-
Explore Geographical Relationships in Spark Data with Power Map
Create data visualizations with Apache Spark SQL in Power Map.
-
Integrate Live EnterpriseDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live EnterpriseDB to Blue Prism using the CData ODBC Driver for EnterpriseDB to create automated workflows for repetitive business tasks.
-
Create SSAS Tabular Models from XML Data
How to build a SQL Server Analysis Service Tabular Model from XML Files using CData drivers.
-
Trigger SharePoint IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SharePoint with standard wizards in Logic Apps.
-
Use the CData Software JDBC Driver for Accelo in MicroStrategy
Connect to Accelo in MicroStrategy Developer using the CData Software JDBC Driver for Accelo.
-
Query Google Search Results from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Search and perform CRUD operations on Google Search from Node.js.
-
Connect to HBase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for HBase Data and connect to Apache HBase in Akorbi Digital RunMyProcess.
-
Replicate Apify Data to Multiple Databases
Replicate Apify to disparate databases with a point-and-click configuration.
-
DataBind Controls to Adobe Analytics Data in Delphi
DataBind to Adobe Analytics in Delphi with standard data access components and controls.
-
Operational Reporting on FreeAgent Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FreeAgent.
-
Working with Google Ad Manager Data in LINQPad
Execute LINQ queries to Google Ad Manager in LINQPad.
-
Back Up Redis to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Redis. In this article, we will employ an SSIS workflow to populate a database with Redis data.
-
Connect to Salesforce Data 360 Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce Data 360 in DBeaver.
-
Integrate Live Epicor Kinetic Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automated Continuous Oracle Sales Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Snowflake.
-
View Reports on Real-Time Perplexity Data in Power BI Report Server
Use the CData ODBC Driver for Perplexity to visualize Perplexity in Power BI Desktop and then publish them to Power BI Report Server.
-
Easily Integrate Klaviyo Data in Lazarus Pascal IDE
Learn how to easily integrate live Klaviyo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import and Visualize Bright Data Data in Power View
Create data visualizations based on Bright Data in Excel.
-
Automated Continuous Timely Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Timely replication to Amazon S3.
-
How to Use a Microsoft Access Database to Update Klaviyo Data in Real Time
Update Klaviyo data by creating a linked table in Microsoft Access with the CData Klaviyo ODBC Driver.
-
Analyze Cloudant Data in Looker
Use CData Connect AI to connect to Cloudant Data from Looker and build custom apps using live IBM Cloudant.
-
Rapidly Develop Google Calendar-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 Google Calendar.
-
Integrate Theia IDE with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automate Supabase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Supabase replication to Azure Data Lake.
-
Integrate with Raisers Edge NXT Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Raisers Edge NXT to a JSON file on disk.
-
Visualize Facebook Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Facebook.
-
Object-Relational Mapping (ORM) with Tavily 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 Tavily into a Java-based ORM framework, Hibernate.
-
Query Act-On Data in DataGrip
Create a Data Source for Act-On in DataGrip and use SQL to query live Act-On.
-
Integrate Live SAP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP ERP/NetWeaver to Blue Prism using the CData ODBC Driver for SAP to create automated workflows for repetitive business tasks.
-
How to Build an ETL App for MYOB AccountRight Data in Python with CData
Create ETL applications and real-time data pipelines for MYOB AccountRight in Python with petl.
-
Connect to Real-Time Parallel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Parallel in Power Apps.
-
How to create Visio diagrams from AlloyDB Data
Automatically update Google AlloyDB with the changes you make to Visio master shapes.
-
Build Data Flows from Keap to SQL Server using SSIS
Easily back up Keap to SQL Server using the SSIS components for Keap.
-
Work with Live Microsoft Ads Data in Power Query
Use CData Connect AI to connect to Microsoft Ads and work with live Microsoft Ads in Microsoft Power Query.
-
Odoo Reporting in OBIEE with the Odoo JDBC Driver
Deploy the Odoo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy
Connect to Pivotal GreenPlum in MicroStrategy Developer using the CData Software ODBC Driver for Greenplum.
-
Use the CData API Server to Access Microsoft OneDrive Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft OneDrive in the Power Pivot business intelligence tool.
-
Build a Simple VCL Application for Recurly Data
How to build a simple VCL Application to view Recurly in RAD Studio using the CData ODBC Driver for Recurly.
-
Use JayDeBeApi to access SFTP Data in Python
Use standard Python scripting and the development environment of your choice to access live SFTP.
-
How to create Quickbase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Quickbase in MySQL .
-
Replicate Multiple QuickBooks Online Accounts
Replicate multiple QuickBooks Online accounts to one or many databases.
-
How to Build an ETL App for Salesforce Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesforce & Force.com in Python with petl and the CData Connect AI Python SDK.
-
Create Data Visualizations in Cognos BI with Coda Data
Access Coda as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Sugar CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sugar CRM replication to AlloyDB.
-
How to Import Data from Microsoft Planner into Google Sheets
Import Microsoft Planner into a Google spreadsheet that is automatically refreshed.
-
Integrating Claude Code CLI with Webex 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 Live Okta Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to OpenWeatherMap Data in CloverDX (formerly CloverETL)
Transfer OpenWeatherMap using the visual workflow in the CloverDX data integration tool.
-
How to Access Live Adobe Commerce Data in Visual Studio Code via Cline
Run CData MCP Server for Adobe Commerce on Windows Subsytem for Linux (WSL) and connect to live Adobe Commerce from the Cline extension in Visual Studio Code.
-
Add ZohoInvoice Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoInvoice with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Raisers Edge NXT 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 Raisers Edge NXT.
-
Connect to GitHub Data from Crystal Reports
Use CData Connect AI to connect to and report on live GitHub from Crystal Reports.
-
Automated Continuous Zuora Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zuora replication to AlloyDB.
-
Create MYOB AccountRight-Connected Business Apps in AppSheet
Connect to MYOB AccountRight Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MYOB AccountRight.
-
Connect to Dotmailer Data from a Connection Pool in JBoss
Integrate Dotmailer into Java servlets: Use the Management Console in JBoss to install the Dotmailer JDBC Driver.
-
Getting Started with the CData JDBC Driver for Wistia
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Wistia.
-
Connect to Live Oracle Service Cloud Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Service Cloud Data in CData Connect AI and connect to your Oracle Service Cloud from MicroStrategy.
-
Connect to Superchat Data in CloverDX (formerly CloverETL)
Transfer Superchat using the visual workflow in the CloverDX data integration tool.
-
How to create Visio diagrams from Cassandra Data
Automatically update Apache Cassandra with the changes you make to Visio master shapes.
-
Connect to SAP HANA from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP HANA to connect to SAP HANA from Web applications running on WebLogic.
-
Build AI/ML Models with Live LightSpeedRetail Data using Dataiku
Connect LightSpeedRetail Data with Dataiku using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for OneNote in MicroStrategy
Connect to Microsoft OneNote in MicroStrategy Developer using the CData Software JDBC Driver for OneNote.
-
HCL Domino Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to HCL Domino through CData Connect AI using different applications and tools.
-
Query JotForm Data in ColdFusion
Write standard ColdFusion data access code to connect to JotForm.
-
Build Apps with Live Eventbrite Data Using the Low-Code Development Platform of Mendix
Connect Eventbrite with Mendix to build apps using the CData API Driver for JDBC.