CData Software - Knowledge Base
Recent Articles
-
Visualize Cloudant Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cloudant data.
-
Integrating Codex with Google Calendar 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 Databricks Agent Bricks to Talk to Your Outreach.io Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Outreach.io data for you.
-
Connect to Trello in SpagoBI
Create reports featuring live Trello data in SpagoBI Studio. Host Trello reports on SpagoBI Server.
-
Connect and Query Live Bright Data Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Bright Data data into Databricks and enable direct, live querying and analysis without replication.
-
Build Visualizations of HubDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HubDB data in Birst.
-
Build Charts with SingleStore Data in Clear Analytics
Create dynamic charts and perform analytics based on SingleStore data in Clear Analytics.
-
Build Impala Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Impala data and build visualizations in Tableau Cloud.
-
Replicate SAP Ariba Procurement Data to Multiple Databases via the CData Sync CLI
Replicate SAP Ariba Procurement data to disparate databases with a single configuration.
-
Build Visualizations of MariaDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MariaDB data in Birst.
-
How to Easily Query SparkPost Data in OpenOffice Base
Connect to SparkPost data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to SingleStore Data from AWS Glue
Use CData Connect AI to gain access to live SingleStore data from your AWS Glue jobs.
-
LINQ to Shopify 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 Shopify Data Provider.
-
Query HDFS Data as a SQL Server Database in Node.js
Execute SQL Server queries against HDFS data from Node.js.
-
Replicate Multiple Azure Data Catalog Accounts via the CData Sync CLI
Replicate multiple Azure Data Catalog accounts to one or many databases.
-
Integrate XML with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate XML with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to XML data.
-
Automated Continuous Keap Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Keap replication to Apache Kafka.
-
Access SageHR Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SageHR data from your Oracle system.
-
Access SageHR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SageHR data from HeidiSQL.
-
How to Query Redis Data in MySQL Workbench
Execute MySQL queries against live Redis data from MySQL Workbench.
-
Build an OLAP Cube in SSAS from Demio Data
Establish a connection to Demio data data from SQL Server Analysis Services, and use the Demio Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with live SAP Concur Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Concur data in Jitterbit.
-
Access Microsoft Planner Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Planner data from your Oracle system.
-
Automated Continuous ChartMogul Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ChartMogul replication to IBM DB2.
-
Access Procore Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Procore data from your Oracle system.
-
Build Semantic Layer Views for Active Directory Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Active Directory data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Hive
Provide connectivity to Hive data through an SAP BusinessObjects universe.
-
Integrate with IBM Cloud Object Storage Data in JReport Designer
Create charts and reports based on IBM Cloud Object Storage data in JReport Designer.
-
DataBind Controls to Paddle Data in Delphi
DataBind to Paddle data in Delphi with standard data access components and controls.
-
Object-Relational Mapping (ORM) with Workable 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 Workable data into a Java-based ORM framework, Hibernate.
-
Automate Salesforce Marketing Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce Marketing data replication to Azure Synapse.
-
Process & Analyze BigQuery Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live BigQuery Data.
-
Integrate with Splunk Data in JReport Designer
Create charts and reports based on Splunk data in JReport Designer.
-
Build a PostgreSQL Interface for ZohoSubscriptions Data using the CData JDBC Driver
Use the Remoting features of the ZohoSubscriptions JDBC Driver to create a PostgreSQL entry-point for data access.
-
Consume Zoho CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho CRM data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous NetSuite Replication to SingleStore
Use CData Sync for automated, continuous, customizable NetSuite replication to SingleStore.
-
Integrate Wave Financial Data in the Pentaho Report Designer
Publish reports based on Wave Financial data in the Pentaho BI tool.
-
Build ClickTime-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ClickTime data and build web apps with connectivity to live ClickTime data.
-
How to connect and process Google Directory data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Directory data.
-
Create Power BI Reports on Real-Time Google Translate Data
Use the CData ODBC Driver for Google Translate to visualize Google Translate data in Power BI Desktop.
-
Integrating LangGraph with Timely Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Timely data within automated workflows.
-
Object-Relational Mapping (ORM) with Power BI XMLA 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 Power BI XMLA data into a Java-based ORM framework, Hibernate.
-
Create a Data Access Object for Splunk Data using JDBI
A brief overview of creating a SQL Object API for Splunk data in JDBI.
-
Connect to ZohoSubscriptions Data from HeidiSQL
Use CData Connect AI to connect to and query live ZohoSubscriptions data from HeidiSQL.
-
Create Data Visualizations in Cognos BI with FHIR Data
Access FHIR data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect and process SurveyMonkey data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SurveyMonkey data.
-
Feed EnterpriseDB Data into FineReport
How to set EnterpriseDB data as a JDBC data source in FineReport.
-
How to connect to Google Ads Data from Spring Boot
Connect to Google Ads in a Spring Boot Application using the CData JDBC Driver for Google Ads
-
Connect to Shippo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Shippo and the SQL Gateway to access Shippo data from Google Apps Script.
-
Connect to Gmail Data from AWS Glue
Use CData Connect AI to gain access to live Gmail data from your AWS Glue jobs.
-
Integrate with Jira Data in JReport Designer
Create charts and reports based on Jira data in JReport Designer.
-
Connect to CSV Data in ACL Analytics
Connect to CSV data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to CSV data.
-
How to Connect QuickBooks Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live QuickBooks data in real time using natural language.
-
Connect Aircall to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Aircall data using the CData Python MCP Server.
-
Connect to Wistia Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Wistia and work with Wistia data in your FileMaker application.
-
How to Query Greenhouse Data in MySQL Workbench
Execute MySQL queries against live Greenhouse data from MySQL Workbench.
-
Build Dashboards with Amazon Marketplace Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Marketplace data in DBxtra.
-
Analyze Twitter Ads Data in Cognos Analytics
Use CData Connect AI to connect to Twitter Ads Data from Cognos Analytics and analyze live Twitter Ads data.
-
Analyze Live Microsoft Ads Data in SAS Viya
Use CData Connect AI to connect to Microsoft Ads data from SAS Viya and deploy self-service analytics using live Microsoft Ads data.
-
Getting Started with the CData ADO.NET Provider for AdRoll
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Real-Time VWO Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use VWO data in Power Apps.
-
Moving Data from PagerDuty to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PagerDuty data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Apps with Live CouchDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live CouchDB data into the Adalo platform and build custom mobile and web applications with real-time CouchDB data.
-
How to Connect to Live Reckon Accounts Hosted Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Reckon Accounts Hosted data securely in real time.
-
Connect to ChartMogul Data in RazorSQL
Connect to ChartMogul from wizards and query ChartMogul data from the GUI in the RazorSQL database management tool.
-
How to connect SharePoint with SendGrid Data through external lists
Provide SendGrid data to SharePoint users as an external list.
-
Create Dynamic FreshBooks Grids Using the Infragistics XamDataGrid
Learn how you can connect FreshBooks to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Google's Vertex AI Agent with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live WooCommerce data within intelligent workflows.
-
How to Build an ETL App for Mailjet Data in Python with CData
Create ETL applications and real-time data pipelines for Mailjet data in Python with petl.
-
Connect Salesforce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Real-Time Blackbaud FE NXT Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Blackbaud FE NXT and Dataflow to import and use Blackbaud FE NXT data in Power Apps.
-
How to Create Power BI Visual Reports with Real-Time NASA Data
Use CData Power BI Connectors to visualize NASA data in Power BI.
-
How to Access Asana Data Using Entity Framework
This article shows how to access Asana data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
A PostgreSQL Interface for Tickspot Data using the CData ODBC Driver
Use the SQL Gateway and Tickspot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Zoho Recruit Data in FoxPro
Load Zoho Recruit data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Brex Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Brex data using standard SQL.
-
Build Voice Agents in ElevenLabs with access to Live DB2 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live DB2 data.
-
Bind Live Reckon Accounts Hosted Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Reckon Accounts Hosted data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Apps with Live Teamgate Data Using the Low-Code Development Platform of Mendix
Connect Teamgate data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Reports from Google Cloud Storage Data in Looker Studio
Use CData Connect AI to gain access to live Google Cloud Storage data and create custom reports in Looker Studio.
-
Build Charts with SAP Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP data in Clear Analytics.
-
Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy
Connect to Pipeliner CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Pipeliner CRM.
-
Integrate with Cohere Data in JReport Designer
Create charts and reports based on Cohere data in JReport Designer.
-
Use the CData Software ODBC Driver for Confluence in SAS for Real-Time Reporting and Analytics
Connect to real-time Confluence data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Confluence.
-
Integrate Devin with Live ShipEngine 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 ShipEngine data.
-
Connect to WordPress Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time WordPress data using standard SQL.
-
Connect to FormSite Data in Jaspersoft Studio
Execute SQL to remote FormSite data in Jaspersoft Studio.
-
How to Connect to & Open SQL Analysis Services Data in Microsoft Excel
This article uses the CData ODBC driver for SQL Analysis Services to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Oracle SCM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle SCM data and visualize Oracle SCM data in SAP Analytics Cloud.
-
DataBind Charts to Flowlu Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Flowlu data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Back Up Ontraport 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 Ontraport data data.
-
Build Data Flows from SQL Server to Microsoft Teams through SSIS
Easily push SQL Server data to Microsoft Teams using the CData SSIS Tasks for Microsoft Teams.
-
Analyze ChartMogul Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ChartMogul data in Microsoft R Open.
-
Getting Started with the CData Python Connector for ConstantContact
Learn to install and license the CData Python Connector and configure a connection to live ConstantContact data.
-
Automated Continuous RabbitMQ Replication to SQLite
Use CData Sync for automated, continuous, customizable RabbitMQ replication to SQLite.
-
Automate Mailgun Data Replication to Azure Data Lake
Use CData Sync to customize and automate Mailgun data replication to Azure Data Lake.
-
Create a Data Access Object for Smartsheet Data using JDBI
A brief overview of creating a SQL Object API for Smartsheet data in JDBI.
-
Use JayDeBeApi to access Planio Data in Python
Use standard Python scripting and the development environment of your choice to access live Planio data.
-
How to create BigCommerce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for BigCommerce data in MySQL .
-
Import and Visualize Sage Cloud Accounting Data in Power View
Create data visualizations based on Sage Cloud Accounting data in Excel.