CData Software - Knowledge Base
Recent Articles
-
Import and Visualize Microsoft Entra ID Data in Power View
Create data visualizations based on Microsoft Entra ID data in Excel.
-
Use the CData ODBC Driver for eBay Analytics in Microsoft Power Query
You can use the CData eBay Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import eBay Analytics data into Microsoft Power Query.
-
Automated Continuous Calendly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Calendly replication to Amazon S3.
-
Rapidly Develop Sage 200-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 Sage 200.
-
Access Hubstaff Data from MySQL in Amazon QuickSight
Connect to Hubstaff and build visualizations of Hubstaff data using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with Hubstaff Data using Tableau Bridge
The CData ODBC Driver for Hubstaff enables you to integrate live Hubstaff data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Microsoft Planner Data from a Connection Pool in Jetty
The Microsoft Planner JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Planner data from Web apps in Jetty.
-
Integrate Live Xero Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Xero data and integrate live Xero data into apps built in Microsoft Power Apps.
-
Automated Continuous CloudConvert Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CloudConvert replication to Azure SQL Database.
-
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 data 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 data in Filemaker Pro for Mac or Windows.
-
Integrate Goose with Live SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP HANA XS Advanced data from within the local AI agent.
-
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 data 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 data 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 data 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 results using pandas and the CData Connect AI Python SDK.
-
Connecting GenSpark with Anaplan Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Anaplan data without any replication or custom integration required.
-
Publish SendPulse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SendPulse data.
-
Connect to Redshift Data in RazorSQL
Connect to Redshift from wizards and query Redshift data 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 data.
-
Natively Connect to HubDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to HubDB data. Leverage the native support for ODBC in PHP.
-
Analyze Teradata Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Teradata data and visualize live Teradata data in Infragistics Reveal.
-
Natively Connect to Clockify Data in PHP
The CData ODBC driver for Clockify enables you to create PHP applications with connectivity to Clockify data. 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 with Aha! 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.
-
Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy
Connect to Salesforce Marketing data 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 data. 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 data 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 data 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 and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
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 Connect to Live PingOne Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your PingOne data for you.
-
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 data.
-
Build Apps with Live DB2 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live DB2 data into the Adalo platform and build custom mobile and web applications with real-time DB2 data.
-
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 data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Perigon-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Perigon data and build web apps with connectivity to live Perigon data.
-
Seamlessly Bring ConstantContact Data into Retool Using CData Connect AI
Integrate ConstantContact data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Miro from a Connection Pool in WebLogic
Use the CData JDBC Driver for Miro to connect to Miro data 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 data 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 data 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 data.
-
Build Apps with Live Facebook data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Facebook data into the Adalo platform and build custom mobile and web applications with real-time Facebook data.
-
Explore Geographical Relationships in Spark Data with Power Map
Create data visualizations with Spark data in Power Map.
-
Integrate Live EnterpriseDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live EnterpriseDB data 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 data 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 data in MicroStrategy Developer using the CData Software JDBC Driver for Accelo.
-
Connect to HBase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for HBase Data and connect to HBase data in Akorbi Digital RunMyProcess.
-
Replicate Apify Data to Multiple Databases
Replicate Apify data to disparate databases with a point-and-click configuration.
-
DataBind Controls to Adobe Analytics Data in Delphi
DataBind to Adobe Analytics data in Delphi with standard data access components and controls.
-
Integrating Dataiku with Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Printify data.
-
Replicate Multiple Brex Accounts via the CData Sync CLI
Replicate multiple Brex accounts to one or many databases.
-
Operational Reporting on FreeAgent Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FreeAgent data.
-
Working with Google Ad Manager Data in LINQPad
Execute LINQ queries to Google Ad Manager data in LINQPad.
-
Integrate Cursor with Live Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Samanage data from within the editor.
-
Back Up Redis data 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 data.
-
Connect to Salesforce Data 360 Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce Data 360 data 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's Cascade agent to securely access and query live Epicor Kinetic data from within the IDE.
-
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 data 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 data 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 data in Excel.
-
Automated Continuous Timely Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Timely replication to Amazon S3.
-
Interact with Live Shopify Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Shopify data.
-
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 Cloudant data.
-
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's built-in AI agents to securely access and query live Google Campaign Manager 360 data from within the development environment.
-
Automate Supabase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Supabase data 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 data to a JSON file on disk.
-
Visualize Facebook Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Facebook data.
-
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 data 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 data.
-
Build Perplexity-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Perplexity Data and create custom apps in Mendix.
-
Build GetResponse-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live GetResponse data without replication.
-
Integrate Live SAP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP data to Blue Prism using the CData ODBC Driver for SAP to create automated workflows for repetitive business tasks.
-
Query Live Typeform Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Typeform data through a conversational interface.
-
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 data 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 data in Power Apps.
-
How to create Visio diagrams from AlloyDB Data
Automatically update AlloyDB data with the changes you make to Visio master shapes.
-
Build Data Flows from Keap to SQL Server using SSIS
Easily back up Keap data to SQL Server using the SSIS components for Keap.
-
How to Visualize Jumpseller 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 Jumpseller data in Python.
-
Work with Live Microsoft Ads Data in Power Query
Use CData Connect AI to connect to Microsoft Ads data and work with live Microsoft Ads data 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 Greenplum data in MicroStrategy Developer using the CData Software ODBC Driver for Greenplum.
-
Build a Simple VCL Application for Recurly Data
How to build a simple VCL Application to view Recurly data 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 data.
-
How to create Quickbase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Quickbase data 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 data in Python with petl and the CData Connect AI Python SDK.
-
Create Data Visualizations in Cognos BI with Coda Data
Access Coda data 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.
-
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.
-
How to Connect to Live Toggl 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 Toggl data through natural language.
-
Integrate Live Okta 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 Okta data from within the IDE.