CData Software - Knowledge Base

Recent Articles

---

• «
• 1002
• 1003
• 1004
• 1005
• 1006
• 1007
• 1008
• 1009
• 1010
• 1011
• »

• Automated Continuous SQL Server Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SQL Server replication to Amazon S3.

• Connect to Xero Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Xero Accounting from Appeon PowerBuilder using the CData ADO.NET Provider for Xero.

• Query FHIR Data as a SQL Server Database in Node.js

  Execute SQL Server queries against FHIR from Node.js.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed REST to Power BI dashboards. Simply drag and drop REST into data visuals on the Power BI canvas.

• Analyze MYOB AccountRight Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of MYOB AccountRight and visualize MYOB AccountRight in SAP Analytics Cloud.

• Consume Oracle SCM OData Feeds in PowerBuilder

  This article demonstrates how to consume Oracle SCM as OData feeds from PowerBuilder using the API Server.

• Integrating LangChain with Reckon Accounts Hosted Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Reckon Accounts Hosted within automated workflows.

• A PostgreSQL Interface for ShipStation Data (MySQL Remoting via JDBC)

  Use the Remoting features of the ShipStation JDBC Driver to create a PostgreSQL entry-point for data access.

• How to Connect to Live Cloudant Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live IBM Cloudant securely in real time.

• DataBind Controls to Zoho Recruit Data in C++Builder

  DataBind to Zoho Recruit in C++Builder with standard components and controls.

• Query Jira Assets Data in DataGrip

  Create a Data Source for Jira Assets in DataGrip and use SQL to query live Jira Assets.

• Query Hacker News Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Hacker News from Node.js.

• How to Work with MYOB AccountRight Data in AWS Glue Jobs Using JDBC

  Connect to MYOB AccountRight from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Getting Started with the CData Power BI Connector for Avro

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Avro.

• Replicate Multiple Zoho Books Accounts via the CData Sync CLI

  Replicate multiple Zoho Books accounts to one or many databases.

• Connect to Snowflake from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Snowflake to connect to Snowflake from Web applications running on WebLogic.

• How to work with ZohoSubscriptions Data in Apache Spark using SQL

  Access and process ZohoSubscriptions Data in Apache Spark using the CData Software JDBC Driver.

• Connect to Zoho Inventory Data in DBeaver

  Use the CData ODBC Driver to connect to Zoho Inventory in DBeaver.

• How to Connect DBeaver to Adobe Experience Manager via a JDBC Driver

  Manage Adobe Experience Manager with visual tools in DBeaver like the query browser.

• Build Visualizations of REST Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of REST in Birst.

• Build Apps with Live BigCommerce Data Using the Low-Code Development Platform of Mendix

  Connect BigCommerce with Mendix to build apps using the CData JDBC Driver for BigCommerce.

• How to connect and process ShipEngine from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live ShipEngine.

• Analyze Gmail Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Gmail from Power Pivot. You will use the Table Import Wizard to load Gmail. You can visually build the import query or use any SQL supported by the driver.

• How to Connect to & Open Nethunt Data in Microsoft Excel

  This article uses the CData ODBC driver for Nethunt to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Automated Continuous Xero Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Xero replication to Apache Cassandra.

• How to Connect to Live Phoenix Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Apache Phoenix for you.

• Use the CData Software JDBC Driver for AgileCRM in MicroStrategy

  Connect to AgileCRM in MicroStrategy Developer using the CData Software JDBC Driver for AgileCRM.

• Use Claude to Talk to Your SAP SuccessFactors Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP SuccessFactors for you.

• Create Informatica Mappings From/To an ODBC Data Source for ClickTime

  Create an ODBC connection to ClickTime in Informatica and browse and transfer ClickTime.

• Access Live Azure Analysis Services Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Azure Analysis Services from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect to Clari Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Clari from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Connect to MariaDB Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live MariaDB from Filemaker Pro on Mac.

• Build Microsoft Dataverse-Connected Apps in Choreo

  Use CData Connect AI to connect to Microsoft Dataverse Data from Choreo and build custom apps using live Microsoft Dataverse (CDS).

• How to Connect Flowise AI Agents to Live Freshdesk 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 Freshdesk without replication.

• Getting Started with the CData ADO.NET Provider for Procore

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Creating Gong-Connected Applications in Unqork

  You can use CData Connect AI to feed Gong to Unqork and build custom business apps.

• Extend Google Sheets with Monday.com Data

  Make calls to Monday.com from Google Apps Script via the API Server.

• Use the CData ODBC Driver for LinkedIn Ads in Microsoft Power Query

  You can use the CData LinkedIn Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LinkedIn Ads into Microsoft Power Query.

• Connecting Mastra with Smartsheet 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 Smartsheet, no replication required.

• Build Automated Workflows with Live Amazon S3 Data in Workato

  Use CData Connect AI to connect to live Amazon S3 and build automated workflows in Workato.

• Build Voice Agents in ElevenLabs with access to Live Elasticsearch Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Elasticsearch.

• Access Live Cassandra Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Apache Cassandra through MCP integration.

• Access Blackbaud FE NXT Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Blackbaud FE NXT from your Oracle system.

• Use Azure AI Foundry to Talk to Your FreshBooks Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your FreshBooks for you.

• Automate Parquet Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Apache Parquet replication to Azure Data Lake.

• Object-Relational Mapping (ORM) with QuickBooks 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 QuickBooks Desktop into a Java-based ORM framework, Hibernate.

• Use the CData ODBC Driver for Oracle HCM Cloud in Microsoft Power Query

  You can use the CData Oracle HCM Cloud ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle HCM Cloud into Microsoft Power Query.

• Analyze Databricks Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Databricks and visualize live Databricks in Infragistics Reveal.

• LINQ to Avro 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 Avro Data Provider.

• Connect to Parquet Data in CloverDX (formerly CloverETL)

  Transfer Apache Parquet using the visual workflow in the CloverDX data integration tool.

• Connect to Live SAP Business One Data in MicroStrategy through CData Connect AI

  Create a live connection to SAP Business One Data in CData Connect AI and connect to your SAP Business One from MicroStrategy.

• Provide OData Services of Azure Table Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Azure Table Storage by developing a WCF Service Application.

• Use Dash to Build to Web Apps on Beeminder Data

  Create Python applications that use pandas and Dash to build Beeminder-connected web apps.

• xBase Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on xBase facts in real time.

• Automated Continuous Sybase Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Sybase replication to Azure SQL Database.

• Replicate Drip Data from PowerShell

  Write a quick PowerShell script to query Drip. Use connectivity to the live data to replicate Drip to SQL Server.

• Use Azure AI Foundry to Talk to Your Quickbase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Quickbase for you.

• Use the CData Software ODBC Driver for Anaplan in MicroStrategy Desktop

  Connect to Anaplan in MicroStrategy Desktop using the CData Software ODBC Driver for Anaplan.

• Access QuickBooks Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Desktop from HeidiSQL.

• How to update Odoo from Excel

  This article explains how to transfer data from Excel to Odoo using the Excel Add-In for Odoo.

• ETL Greenhouse in Oracle Data Integrator

  This article shows how to transfer Greenhouse into a data warehouse using Oracle Data Integrator.

• Connecting Moonlit Workflow with SAP Netweaver Gateway Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Netweaver Gateway in real time.

• Create Dashboards and Visualize Live GraphQL Data in Geckoboard

  Use CData Connect AI to connect to live GraphQL and create dashboards for real-time monitoring and visualization in Geckoboard.

• Stream OData Services into Apache Kafka Topics

  Access and stream OData in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Freshdesk Data in NetBeans

  Connect to Freshdesk in NetBeans with the data source configuration wizard.

• Build AI/ML Models with Live Reckon Accounts Hosted Data using Dataiku

  Connect Reckon Accounts Hosted Data with Dataiku using the CData JDBC Driver for Reckon Accounts Hosted.

• Establish a Live Connection with Lakebase Data using Tableau Bridge

  The CData ODBC Driver for Lakebase enables you to integrate live Lakebase into Tableau Cloud dashboards using the Tableau Bridge.

• Import Real-Time SAP ByDesign Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use SAP Business ByDesign in ColdFusion.

• Automated Continuous Lakebase Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Lakebase replication to SQL Server.

• Process & Analyze ZohoExpense Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoExpense Data.

• Edit and Search External SAS xpt Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of SAS XPORT to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAS xpt Data objects that you can access from apps and the dashboard.

• Automated Continuous MariaDB Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable MariaDB replication to Google Cloud SQL.

• Build Elasticsearch-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Elasticsearch.

• How to integrate Pipedrive with Apache Airflow

  Access and process Pipedrive in Apache Airflow using the CData JDBC Driver.

• Create Informatica Mappings From/To an ODBC Data Source for Greenhouse

  Create an ODBC connection to Greenhouse in Informatica and browse and transfer Greenhouse.

• Connect to Customer.io Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Customer.io.

• Use the CData Software ODBC Driver for ActiveCampaign in MicroStrategy Web

  Connect to ActiveCampaign in MicroStrategy Web using the CData Software ODBC Driver for ActiveCampaign.

• Automated Continuous BenchmarkEmail Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Amazon S3.

• Connect to and Visualize Live Odoo Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Odoo ERP.

• Integrate Live Dynamics CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Microsoft Dynamics CRM to Blue Prism using the CData ODBC Driver for Dynamics CRM to create automated workflows for repetitive business tasks.

• Create Power BI Reports on Real-Time Sybase Data

  Use the CData ODBC Driver for Sybase to visualize Sybase in Power BI Desktop.

• Integrating OpenCode Terminal with Cloudflare 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.

• Getting Started with the CData ODBC Driver for Zoho CRM

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho CRM.

• Build Dashboards with Google Translate Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Google Translate in Dundas BI.

• Analyze Authorize.Net Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Authorize.Net from Power Pivot. You will use the Table Import Wizard to load Authorize.Net. You can visually build the import query or use any SQL supported by the driver.

• Connect to AdRoll Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time AdRoll using standard SQL.

• Access Live Google Ad Manager Data in TIBCO Data Virtualization

  Use the Google Ad Manager Tibco DV Adapter to create a Google Ad Manager data source in TIBCO Data Virtualization Studio and gain access to live Google Ad Manager from your TDV Server.

• Automated Shopify Data Replication to Teradata

  Use CData Sync to Customize and automate Shopify replication to Teradata.

• Visualize QuickBooks Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to QuickBooks Desktop.

• Visualize Live Microsoft Dataverse Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Dataverse (CDS) into custom reports in Power BI.

• How to Connect to Live SAP Ariba Source 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 SAP Ariba Source for you.

• Connect ClickUp Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your ClickUp using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to create an RPA flow for Access Data in UiPath Studio

  Use the Access ODBC Driver to create workflows that access real-time Microsoft Access without any coding.

• Viewing Sendwithus Data in RAD Studio Data Explorer

  How to view Sendwithus in RAD Studio Data Explorer using the CData ODBC Driver for Sendwithus.

• Validate Oracle Sales Data with QuerySurge

  Access and validate Oracle Sales in QuerySurge using the CData JDBC Driver.

• Integrating SAP SuccessFactors Data in Talend Cloud Data Management Platform

  Connect SAP SuccessFactors Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP SuccessFactors.

• A PostgreSQL Interface for Microsoft Planner Data using the CData ODBC Driver

  Use the SQL Gateway and Microsoft Planner ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to VWO Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for VWO in the Denodo Virtual DataPort Administrator.

• Build AI/ML Models with Live Teamgate Data using Dataiku

  Connect Teamgate Data with Dataiku using the CData API Driver for JDBC.

• Manage JSON Services in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for JSON.

• «
• 1002
• 1003
• 1004
• 1005
• 1006
• 1007
• 1008
• 1009
• 1010
• 1011
• »