CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Stripe
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Stripe.
-
Bind Live Azure Analysis Services Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Analysis Services data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect Microsoft OneDrive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft OneDrive data using the CData Python MCP Server.
-
Connect to SAP ByDesign Data in Ruby
Connect to SAP ByDesign data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Foursquare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Foursquare replication to Azure SQL Database.
-
How to Work with Adobe Commerce Data in AWS Glue Jobs Using JDBC
Connect to Adobe Commerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build AI/ML Models with Live Snowflake Data using Dataiku
Connect Snowflake Data with Dataiku using the CData JDBC Driver for Snowflake.
-
Build a PostgreSQL Interface for XML Data using the CData JDBC Driver
Use the Remoting features of the XML JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous MailerLite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MailerLite replication to PostgreSQL.
-
Create SendGrid-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SendGrid Data from Klipfolio and build custom visualizations using live SendGrid data.
-
Getting Started with the CData SSIS Components for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon DynamoDB.
-
Integrate Cursor with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SageHR data from within the editor.
-
Connect to Twilio Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Twilio data.
-
How to create Visio diagrams from Microsoft Exchange Data
Automatically update Microsoft Exchange data with the changes you make to Visio master shapes.
-
Create Dashboards and Visualize Live Optimizely Data in Geckoboard
Use CData Connect AI to connect to live Optimizely data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze ShipEngine Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ShipEngine data and visualize ShipEngine data in SAP Analytics Cloud.
-
Integrate Open WebUI with Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Optimizely data from within the chat interface.
-
Use the CData Software ODBC Driver for Access in MicroStrategy Desktop
Connect to Access data in MicroStrategy Desktop using the CData Software ODBC Driver for Access.
-
Integrate Theia IDE with Live SFTP 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 SFTP data from within the development environment.
-
Integrate Tally Data into Power Automate Desktop using CData Connect
CData Connect for Tally Data enables you to integrate Tally data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Bitbucket Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bitbucket replication to delimited files (CSV/TSV).
-
Analyze QuickBooks Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for QuickBooks Online from Power Pivot. You will use the Table Import Wizard to load QuickBooks Online data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Google Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Ads replication to Amazon S3.
-
Visualize CockroachDB Data in Tableau
The CData ODBC driver for CockroachDB enables you integrate CockroachDB data into Tableau dashboards.
-
Use Agno to Talk to Your Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zoho Creator data for you.
-
Automated Continuous Clari Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Clari data replication to OneLake in Microsoft Fabric.
-
Connect to Square Data in HULFT Integrate
Connect to Square as a JDBC data source in HULFT Integrate
-
Integrating Dataiku with Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Freshteam data.
-
Connect to Microsoft Entra ID Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Entra ID data.
-
Connect Phoenix Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Phoenix data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Monday.com Data in Excel 365 Online (Excel for the web)
Connect to Monday.com data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Apps with Live MailerLite data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MailerLite data into the Adalo platform and build custom mobile and web applications with real-time MailerLite data.
-
DataBind Controls to Adobe Experience Manager Data in Delphi
DataBind to Adobe Experience Manager data in Delphi with standard data access components and controls.
-
Automated Continuous Humanity Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Humanity replication to Google Cloud SQL.
-
Connect to GraphQL Data in HULFT Integrate
Connect to GraphQL as a JDBC data source in HULFT Integrate
-
Query SageHR Data in DataGrip
Create a Data Source for SageHR in DataGrip and use SQL to query live SageHR data.
-
How to Connect to Live xBase 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 xBase data for you.
-
Model Neo4J Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Neo4J, enabling the direct import of real-time Neo4J data.
-
Access Live Adobe Commerce Data in Excel 365 Online (Excel for the web)
Connect to Adobe Commerce data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Azure Data Catalog Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Data Catalog data.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy Desktop
Connect to Neo4J data in MicroStrategy Desktop using the CData Software ODBC Driver for Neo4J.
-
Create Data Visualizations in Cognos BI with HCL Domino Data
Access HCL Domino data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Visualize Live Azure Data Lake Storage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Lake Storage data.
-
How to Work with Azure Data Catalog Data in ETL Validator JDBC
Connect to Azure Data Catalog from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Devin with Live Zoom Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zoom data.
-
Create Reports from Sage 300 Data in Looker Studio
Use CData Connect AI to gain access to live Sage 300 data and create custom reports in Looker Studio.
-
How to Connect to SAP Business Warehouse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business Warehouse data. Leverage the pyodbc module for ODBC in Python.
-
Connect to HCL Domino Data from a Connection Pool in JBoss
Integrate HCL Domino data into Java servlets: Use the Management Console in JBoss to install the HCL Domino JDBC Driver.
-
Connect to Mouseflow Data in RapidMiner
Integrate Mouseflow data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Antigravity CLI with Bullhorn CRM data via CData CLI
Connect Bullhorn CRM data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Back Up Auth0 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Auth0 data data.
-
Connecting Mastra with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Ads data, no replication required.
-
Getting Started with the CData Excel Add-In for Sage 300
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage 300.
-
Connect to Monday.com Data in DBArtisan
Use wizards in DBArtisan to configure Monday.com data as a data source.
-
Use JayDeBeApi to access Dropbox Data in Python
Use standard Python scripting and the development environment of your choice to access live Dropbox data.
-
Automated Continuous OData Replication to Oracle
Use CData Sync for automated, continuous, customizable OData replication to Oracle.
-
How to import Sentry Data into Apache Solr
Use the CData Software JDBC Driver for Sentry in Data Import Handler and create an automated import of Sentry data to Apache Solr Enterprise Search platform.
-
Build AI Agents with MYOB AccountRight Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live MYOB AccountRight data through CData Connect AI.
-
Moving Data from Close to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Close data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Bidirectional Access to Snowflake Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Snowflake data in Filemaker Pro for Mac or Windows.
-
Build Presto-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Presto data and build Presto-connected web apps with Axios.
-
Publish Reports with Productboard Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Productboard data.
-
Integrate Real-Time Access to SuiteCRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SuiteCRM data in real time.
-
Create Reports with RabbitMQ Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date RabbitMQ data.
-
Write a Simple Go Application to work with Invoiced Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Invoiced data.
-
Toggl Reporting in OBIEE with the Toggl JDBC Driver
Deploy the Toggl JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate BenchmarkEmail with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BenchmarkEmail with External Services.
-
Integrating Claude Code CLI with BambooHR 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.
-
Model JSON Services Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and JSON, enabling the direct import of real-time JSON services.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoSubscriptions
Create ZohoSubscriptions data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Live SAP SuccessFactors Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP SuccessFactors from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP SuccessFactors data.
-
Use Grok to Talk to Your OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your OneNote data for you.
-
Automated Continuous Bright Data Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bright Data replication to MongoDB.
-
Create Power BI XMLA-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Power BI XMLA Data from Klipfolio and build custom visualizations using live Power BI XMLA data.
-
Establish a Live Connection with Float Data using Tableau Bridge
The CData ODBC Driver for Float enables you to integrate live Float data into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate SAP HANA XS Advanced Data in Heroku for Use in Salesforce Connect
Replicate SAP HANA XS Advanced data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Google Spanner 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 Google Spanner data for you.
-
Create Data Visualizations in Cognos BI with SAP Hybris C4C Data
Access SAP Hybris C4C data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Interact with Live SageHR Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SageHR data.
-
Connect Shortcut to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Shortcut data using the CData Python MCP Server.
-
Integrating LangGraph with QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on QuickBooks Time data within automated workflows.
-
Integrating Antigravity CLI with Salesloft data via CData CLI
Connect Salesloft data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Live Sage Intacct 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 Intacct data directly from the development environment.
-
How to Access CSV Data Using Entity Framework
This article shows how to access CSV data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to LinkedIn Ads Data in RazorSQL
Connect to LinkedIn Ads from wizards and query LinkedIn Ads data from the GUI in the RazorSQL database management tool.
-
Use Biml to Build SSIS Tasks to Replicate FreshBooks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FreshBooks data to SQL Server.
-
Connect to Dynamics CRM Data in JRuby
Create a simple JRuby app with access to live Dynamics CRM data.
-
Load Anaplan Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Anaplan data to a database.
-
Adobe Target Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Adobe Target facts in real time.
-
Automate LinkedIn Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate LinkedIn Ads data replication to Azure Data Lake.
-
How to create EmailOctopus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for EmailOctopus data in MySQL .
-
Analyze Pipedrive Data in Cognos Analytics
Use CData Connect AI to connect to Pipedrive Data from Cognos Analytics and analyze live Pipedrive data.
-
Connect and Visualize Live Salesforce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce data into the Databricks platform and create visualization dashboards with real-time Salesforce data.
-
Viewing Retently Data in RAD Studio Data Explorer
How to view Retently data in RAD Studio Data Explorer using the CData ODBC Driver for Retently.
-
Connect Azure Table Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Table data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Prepare, Blend, and Analyze Elorus Data in Alteryx Designer (ODBC)
Build workflows to access live Elorus data for self-service data analytics.
-
How to Build an ETL App for VWO Data in Python with CData Connect AI
Extract and transform live VWO data in Python with petl and the CData Connect AI Python SDK.
-
Access Epicor Kinetic Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Epicor Kinetic data from HeidiSQL.
-
Connect to SAP SuccessFactors LMS Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP SuccessFactors LMS data using standard SQL.
-
Integrate Goose with Live Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Shippo data from within the local AI agent.