CData Software - Knowledge Base
Recent Articles
-
LINQ to YouTube Analytics 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 YouTube Analytics Data Provider.
-
Connect to Pipedrive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Pipedrive.
-
Analyze SharePoint Data in Cognos Analytics
Use CData Connect AI to connect to SharePoint Data from Cognos Analytics and analyze live Microsoft SharePoint.
-
How to update Zoho Inventory from Excel
This article explains how to transfer data from Excel to Zoho Inventory using the Excel Add-In for Zoho Inventory.
-
How to Create Power BI Visual Reports with Real-Time Zoho CRM Data
Use CData Power BI Connectors to visualize Zoho CRM in Power BI.
-
Build Apps with Live LinkedIn in Adalo using CData Connect AI
Use CData Connect AI to integrate live LinkedIn into the Adalo platform and build custom mobile and web applications with real-time LinkedIn.
-
How to Visualize BigQuery Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google BigQuery in Python.
-
Establish a Live Connection with SAP Netweaver Gateway Data using Tableau Bridge
The CData ODBC Driver for SAP Netweaver Gateway enables you to integrate live SAP Netweaver Gateway into Tableau Cloud dashboards using the Tableau Bridge.
-
Import SAP Hybris C4C Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Hybris C4C Data from Azure Data Factory and import live SAP Hybris C4C.
-
Use the CData Software ODBC Driver for Ontraport in SAS for Real-Time Reporting and Analytics
Connect to real-time Ontraport in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Ontraport.
-
Connect to Discord Data from PowerBuilder via ADO.NET
This article demonstrates how to access Discord from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData ADO.NET Provider for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage Intacct.
-
Configure the CData JDBC Driver for Jira Assets in a Connection Pool in Tomcat
Connect to Jira Assets from a connection pool in Tomcat.
-
How to Connect to NASA Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to NASA. Leverage the pyodbc module for ODBC in Python.
-
How to create Elorus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Elorus in MySQL .
-
Work with SAP Ariba Source Data in FoxPro
Load SAP Ariba Source into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex CLI with ZohoMarketingHub 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.
-
Bidirectional Access to Perplexity Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Perplexity in Filemaker Pro for Mac or Windows.
-
Build Pipelines with Live Zuora Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zuora from Google Cloud Data Fusion, enabling the integration of live Zuora into the building and management of effective data pipelines.
-
Build Apps with Live SAP Business Warehouse Data Using the Low-Code Development Platform of Mendix
Connect SAP Business Warehouse with Mendix to build apps using the CData JDBC Driver for SAP Business Warehouse.
-
Working with Dynamics CRM Data in LINQPad
Execute LINQ queries to Microsoft Dynamics CRM in LINQPad.
-
Use Dash to Build to Web Apps on Grafana Data
Create Python applications that use pandas and Dash to build Grafana-connected web apps.
-
Automated Continuous Testmonitor Replication to SQL Server
Use CData Sync for automated, continuous, customizable Testmonitor replication to SQL Server.
-
Build Vault CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Veeva Vault & Vault CRM.
-
Automated Continuous Greenplum Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Greenplum replication to Google Cloud SQL.
-
Integrate Live Lakebase Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Lakebase from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Lakebase.
-
Automate Sage Intacct Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage Intacct and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Object-Relational Mapping (ORM) with Impala 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 Apache Impala into a Java-based ORM framework, Hibernate.
-
Replicate Todoist Data to Multiple Databases via the CData Sync CLI
Replicate Todoist to disparate databases with a single configuration.
-
Create Dynamic Kintone Grids Using the Infragistics XamDataGrid
Learn how you can connect Kintone to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous SAP Hybris C4C Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to OneLake in Microsoft Fabric.
-
Automated Continuous Keap Replication to MySQL
Use CData Sync for automated, continuous, customizable Keap replication to MySQL.
-
Integrate Cline with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Email from within your IDE.
-
How to Easily Query Pipeliner CRM Data in OpenOffice Base
Connect to Pipeliner CRM data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software JDBC Driver for Asana in MicroStrategy Web
Connect to Asana in MicroStrategy Web using the CData Software JDBC Driver for Asana.
-
Integrating LlamaIndex with NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on NetSuite CRM & ERP in real time.
-
Automated Continuous Everhour Replication to Snowflake
Use CData Sync for automated, continuous, customizable Everhour replication to Snowflake.
-
Create Reports with Tanda Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tanda.
-
Create Dashboards and Visualize Live ShipStation Data in Geckoboard
Use CData Connect AI to connect to live ShipStation and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build a PostgreSQL Interface for Stack Exchange Data using the CData JDBC Driver
Use the Remoting features of the Stack Exchange JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to PhantomBuster Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PhantomBuster. Leverage the native support for ODBC in PHP.
-
Automated Continuous ZohoSubscriptions Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to OneLake in Microsoft Fabric.
-
Build Voice Agents in ElevenLabs with access to Live Amazon Athena Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon Athena.
-
Connect to Hugging Face from Asprova with CData Software ODBC Driver for Hugging Face
This article shows how to connect faster to Hugging Face data from Asprova.
-
Connect to Excel Data in Claris FileMaker Pro
Use the CData ODBC Driver for Excel in FileMaker Pro to connect to Excel and work with Microsoft Excel in your FileMaker applications.
-
Access Live MySQL Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MySQL from your Excel spreadsheets.
-
Replicate Multiple Adobe Target Accounts
Replicate multiple Adobe Target accounts to one or many databases.
-
Build Apps with Live Sage 200 in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage 200 into the Adalo platform and build custom mobile and web applications with real-time Sage 200.
-
View Reports on Real-Time Sage 200 Data in Power BI Report Server
Use the CData ODBC Driver for Sage 200 to visualize Sage 200 in Power BI Desktop and then publish them to Power BI Report Server.
-
Building Dynamic Web Pages with Amazon Marketplace Data Using AngularJS
Create single-page applications with live connectivity to Amazon Marketplace using the CData API Server.
-
Integrating Codex CLI with Coinbase 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 Twitter Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Twitter Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Twitter Ads.
-
Easily Integrate SAP Netweaver Gateway Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Netweaver Gateway in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Vertica Replication to MongoDB
Use CData Sync for automated, continuous, customizable Vertica replication to MongoDB.
-
Connect to Amazon DynamoDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon DynamoDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access SharePoint 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 Microsoft SharePoint.
-
Connect to Qualaroo Data in CloverDX (formerly CloverETL)
Transfer Qualaroo using the visual workflow in the CloverDX data integration tool.
-
Integrating Gumloop with Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Lakebase within automated workflows.
-
How to load BambooHR data into Elasticsearch via Logstash
Introducing a simple method to load BambooHR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dynamics 365-Connected Business Apps in AppSheet
Connect to Dynamics 365 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Dynamics 365.
-
Getting Started with the CData ADO.NET Provider for SAP Concur
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Concur.
-
Automate LeadDesk Data Replication to Azure Synapse
Use CData Sync to customize and automate LeadDesk replication to Azure Synapse.
-
Connect to Gumroad Data in DBArtisan
Use wizards in DBArtisan to configure Gumroad as a data source.
-
Integrate Open WebUI with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Table Storage from within the chat interface.
-
How to Import Data from Wave Financial into Google Sheets
Import Wave Financial into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData JDBC Driver for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ScrapingBee.
-
Visualize Webflow 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 Webflow into TIBCO Spotfire.
-
Analyze PhantomBuster Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PhantomBuster from Power Pivot. You will use the Table Import Wizard to load PhantomBuster. You can visually build the import query or use any SQL supported by the driver.
-
Model Cvent Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cvent, enabling the direct import of real-time Cvent.
-
Publish Reports with CampaignMonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CampaignMonitor.
-
Automated Continuous Tally Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Tally replication to Apache Cassandra.
-
Import and Visualize SingleStore Data in Power View
Create data visualizations based on SingleStore in Excel.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory for you.
-
Bidirectional Access to SharePoint Excel Services Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SharePoint Excel Services in Filemaker Pro for Mac or Windows.
-
Migrating data from QuickBooks to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Desktop to Google BigQuery using the CData SSIS Tasks for QuickBooks and Google BigQuery.
-
Query Productboard Data as a MySQL Database in Node.js
Execute MySQL queries against Productboard from Node.js.
-
Getting Started with the CData ODBC Driver for Gorgias
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Gorgias.
-
Design BIRT Reports on Databricks Data
Provide current Databricks to your embedded analytics.
-
Natively Connect to Paylocity Data in PHP
The CData ODBC driver for Paylocity enables you to create PHP applications with connectivity to Paylocity. Leverage the native support for ODBC in PHP.
-
Automated Continuous Google Calendar Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Calendar replication to SingleStore.
-
Natively Connect to Wave Financial Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Wave Financial. Leverage the native support for ODBC in PHP.
-
Connect to Spark Data from PowerBuilder via JDBC
This article demonstrates how to access Apache Spark SQL from PowerBuilder using the Spark JDBC Driver.
-
Automated Continuous Marketo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Marketo replication to MongoDB.
-
Integrating Claude Code with Sybase IQ Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sybase IQ within assisted coding and automated development workflows.
-
Migrating data from BigQuery to Snowflake using CData SSIS Components.
Easily push Google BigQuery to Snowflake using the CData SSIS Tasks for BigQuery and Snowflake.
-
Automated Continuous MySQL Replication to Vertica
Use CData Sync for automated, continuous, customizable MySQL replication to Vertica.
-
Use Manus AI to Talk to Your Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sybase IQ.
-
Create Data Visualizations in Cognos BI with CapsuleCRM Data
Access CapsuleCRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Autopilot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Autopilot from Node.js.
-
How to Use a Microsoft Access Database to Update SAP SuccessFactors Data in Real Time
Update SAP SuccessFactors data by creating a linked table in Microsoft Access with the CData SAP SuccessFactors ODBC Driver.
-
Use Azure AI Foundry to Talk to Your YouTube Analytics 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 YouTube Analytics for you.
-
Visualize RabbitMQ Data in TIBCO Spotfire through ADO.NET
Integrate RabbitMQ into dashboards in TIBCO Spotfire.
-
How to Access Apify Data Using Entity Framework
This article shows how to access Apify using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Timely Replication to MongoDB
Use CData Sync for automated, continuous, customizable Timely replication to MongoDB.
-
How to Access Live Rootly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Rootly enables you to integrate Rootly into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import Outlook Data into IBM SPSS Modeler
Integrate Outlook data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Oracle Eloqua Data in Claude Desktop
Connect to and query live Oracle Eloqua Data in Claude Desktop using CData MCP Server.
-
Build an OLAP Cube in SSAS from Beeminder Data
Establish a connection to Beeminder data from SQL Server Analysis Services, and use the Beeminder Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Claude Code CLI with Google Search Results 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.
-
A PostgreSQL Interface for WordPress Data (MySQL Remoting via JDBC)
Use the Remoting features of the WordPress JDBC Driver to create a PostgreSQL entry-point for data access.