CData Software - Knowledge Base
Recent Articles
-
Visualize ElevenLabs 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 ElevenLabs data into TIBCO Spotfire.
-
How to load Mistral AI data into Elasticsearch via Logstash
Introducing a simple method to load Mistral AI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Amplitude Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amplitude data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Monday.com Replication to SingleStore
Use CData Sync for automated, continuous, customizable Monday.com replication to SingleStore.
-
Automated Continuous ZohoExpense Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Azure SQL Database.
-
Enable the xBase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with xBase data.
-
Establish a Live Connection with Zuora Data using Tableau Bridge
The CData ODBC Driver for Zuora enables you to integrate live Zuora data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous CampaignMonitor Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CampaignMonitor data replication to OneLake in Microsoft Fabric.
-
Excel Spreadsheet Automation on Tally Data with the QUERY Formula
Pull data from Tally, automate spreadsheets, and more with the QUERY formula.
-
Create Datasets from Office 365 in Domo Workbench and Build Visualizations of Office 365 Data in Domo
Use the CData Software ODBC Driver for Office 365 to create datasets from Office 365 data in Domo Workbench and then build visualizations in the Domo service.
-
Query Amazon S3 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon S3 data from Node.js.
-
Connect to ZarMoney Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZarMoney data.
-
Connect to PayPal Data in HULFT Integrate
Connect to PayPal as a JDBC data source in HULFT Integrate
-
Build Visualizations of MailerSend Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MailerSend data in Birst.
-
Use the CData SSIS Components to Insert New or Update Existing Office 365 Records from SQL Server
Easily push SQL Server data to Office 365 using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Office 365 or update existing records with data from a SQL Server database.
-
Replicate Multiple Parquet Accounts via the CData Sync CLI
Replicate multiple Parquet accounts to one or many databases.
-
How to publish and share Google Cloud Storage Data dashboards with Tableau Server
The CData ODBC driver for Google Cloud Storage enables you integrate Google Cloud Storage data into Tableau dashboards.
-
Migrating data from SpaceX to Google BigQuery using CData SSIS Components.
Easily push SpaceX data to Google BigQuery using the CData SSIS Tasks for SpaceX and Google BigQuery.
-
Create Informatica Mappings From/To an ODBC Data Source for Outreach.io
Create an ODBC connection to Outreach.io in Informatica and browse and transfer Outreach.io data.
-
Publish Reports with Grafana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Grafana data.
-
Enable the Amplitude JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amplitude data.
-
Access Samanage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Samanage data from your Oracle system.
-
Connect and Query Live Dynamics NAV Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dynamics NAV data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating LangGraph with SingleStore Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SingleStore data within automated workflows.
-
Getting Started with the CData SSIS Components for Redis
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Redis.
-
Choosing the Best Method to Connect Typeform to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Typeform data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Microsoft Exchange Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Exchange in FileMaker Pro to connect to Microsoft Exchange and work with Microsoft Exchange data in your FileMaker applications.
-
Use the CData ODBC Driver for Templated from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Templated to connect to Templated data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Templated data in Excel.
-
Integrate Theia IDE with Live Freshdesk 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 Freshdesk data from within the development environment.
-
Connect to FreeAgent Data from PowerBuilder via ADO.NET
This article demonstrates how to access FreeAgent data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Moving Data from Microsoft OneDrive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft OneDrive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Testmonitor Replication to MySQL
Use CData Sync for automated, continuous, customizable Testmonitor replication to MySQL.
-
How to Build an ETL App for Hugging Face Data in Python with CData
Create ETL applications and real-time data pipelines for Hugging Face data in Python with petl.
-
Getting Started with the CData ODBC Driver for QuickBooks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks.
-
Visualize GraphQL 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 GraphQL data into TIBCO Spotfire.
-
How to create Productboard federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Productboard data in MySQL .
-
Automated Continuous Mistral AI Replication to Databricks
Use CData Sync for automated, continuous, customizable Mistral AI replication to Databricks.
-
Connect to FHIR Data from AWS Glue
Use CData Connect AI to gain access to live FHIR data from your AWS Glue jobs.
-
LINQ to Couchbase 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 Couchbase Data Provider.
-
Build Wave Financial-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Wave Financial Data and create custom apps in Mendix.
-
How to connect to AgileCRM Data from IntelliJ
Integrate connectivity to AgileCRM data with wizards in IntelliJ.
-
Integrate Google's Antigravity Agent with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesforce data using the Model Context Protocol.
-
Access Salesforce Data 360 Data from MySQL in PHP
Connect to Salesforce Data 360 through the standard MySQL libraries in PHP.
-
Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Web
Connect to Google Campaign Manager 360 data in MicroStrategy Web using the CData Software JDBC Driver for Google Campaign Manager 360.
-
Visualize Postmark Data in Tableau
The CData ODBC driver for Postmark enables you integrate Postmark data into Tableau dashboards.
-
Replicate eBay Data to Multiple Databases via the CData Sync CLI
Replicate eBay data to disparate databases with a single configuration.
-
Connect to Placid Data in RazorSQL
Connect to Placid from wizards and query Placid data from the GUI in the RazorSQL database management tool.
-
How to load Paymo data into Elasticsearch via Logstash
Introducing a simple method to load Paymo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Guru Replication to SQL Server
Use CData Sync for automated, continuous, customizable Guru replication to SQL Server.
-
Connect to Parallel Data from PowerBuilder via JDBC
This article demonstrates how to access Parallel data from PowerBuilder using the Parallel JDBC Driver.
-
Use the CData SSIS Components to Insert New or Update Existing Excel Records from SQL Server
Easily push SQL Server data to Excel using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Excel or update existing records with data from a SQL Server database.
-
Integrate with Live Amazon Athena Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Amazon Athena from the MuleSoft Anypoint Platform to integrate live Amazon Athena data into custom reports and dashboards.
-
How to use SQLAlchemy ORM to access Postmark Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Postmark data.
-
How to Connect to Live Apollo Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apollo data without replication.
-
How to Connect to Unbounce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Unbounce data. Leverage the pyodbc module for ODBC in Python.
-
How to create an RPA flow for Elasticsearch Data in UiPath Studio
Use the Elasticsearch ODBC Driver to create workflows that access real-time Elasticsearch data without any coding.
-
Visualize Live GitLab Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GitLab data.
-
Connect to Attio Data in RapidMiner
Integrate Attio data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Google Tasks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Tasks data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Keap Data from a Connection Pool in JBoss
Integrate Keap data into Java servlets: Use the Management Console in JBoss to install the Keap JDBC Driver.
-
How to work with Hacker News Data in Apache Spark using SQL
Access and process Hacker News Data in Apache Spark using the CData Software JDBC Driver.
-
A PostgreSQL Interface for Quaderno Data (MySQL Remoting via JDBC)
Use the Remoting features of the Quaderno JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Webflow Data in Delphi
DataBind to Webflow data in Delphi with standard data access components and controls.
-
Visualize Paymo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paymo data.
-
Query Live Timely 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 Timely data through a conversational interface.
-
Analyze Azure Table Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Table data and visualize live Azure Table data in Infragistics Reveal.
-
Integrate Auth0 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Auth0 data from Informatica Cloud.
-
Use the CData Software ODBC Driver for Workable in MicroStrategy
Connect to Workable data in MicroStrategy Developer using the CData Software ODBC Driver for Workable.
-
Interact with Live Facebook Ads Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Facebook Ads data.
-
Use the CData Software ODBC Driver for SQL Server in MicroStrategy Desktop
Connect to SQL Server data in MicroStrategy Desktop using the CData Software ODBC Driver for SQL Server.
-
Object-Relational Mapping (ORM) with BenchmarkEmail 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 BenchmarkEmail data into a Java-based ORM framework, Hibernate.
-
Visualize Anaplan Data in Tableau
The CData ODBC driver for Anaplan enables you integrate Anaplan data into Tableau dashboards.
-
How to Connect DBeaver to CockroachDB via a JDBC Driver
Manage CockroachDB data with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for EnterpriseDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for EnterpriseDB data.
-
Easily Integrate Codat Data in Lazarus Pascal IDE
Learn how to easily integrate live Codat data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use CData Connect AI to Access Splunk Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Splunk data in the Power Pivot business intelligence tool.
-
Connect to Real-Time Ontraport Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Ontraport data in Power Apps.
-
Build an OLAP Cube in SSAS from Yelp Data
Establish a connection to Yelp data data from SQL Server Analysis Services, and use the Yelp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with SAP Fieldglass Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Fieldglass data to a JSON file on disk.
-
Connect to DocuSign Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with DocuSign Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
ETL GetResponse in Oracle Data Integrator
This article shows how to transfer GetResponse data into a data warehouse using Oracle Data Integrator.
-
How to publish and share HCL Domino Data dashboards with Tableau Server
The CData ODBC driver for HCL Domino enables you integrate HCL Domino data into Tableau dashboards.
-
Build Automated Workflows with Live Google Sheets Data in Workato
Use CData Connect AI to connect to live Google Sheets data and build automated workflows in Workato.
-
Connect to Real-Time PayPal Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PayPal and Dataflow to import and use PayPal data in Power Apps.
-
Object-Relational Mapping (ORM) with Sage Cloud Accounting 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 Sage Cloud Accounting data into a Java-based ORM framework, Hibernate.
-
How to connect PolyBase to SAP HANA
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP HANA data.
-
How to connect to ZohoPeople Data with Squirrel SQL client
Connect to ZohoPeople data and execute queries in the Squirrel SQL Client.
-
Connect to Pushbullet Data in JRuby
Create a simple JRuby app with access to live Pushbullet data.
-
Publish SharePoint-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SharePoint data.
-
Integrating LangGraph with Jumpseller Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Jumpseller data within automated workflows.
-
How to Connect to Live Cvent 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 Cvent data for you.
-
Create Data Visualizations Based On Dynamics 365 Data in Mode
Use CData Connect AI to connect to Dynamics 365 Data from Mode and build visualizations using live Dynamics 365 data.
-
Connect to Oracle Eloqua Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Eloqua data from your AWS Glue jobs.
-
Connect to Odoo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Odoo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Query Klaviyo Data in MySQL Workbench
Execute MySQL queries against live Klaviyo data from MySQL Workbench.
-
Rapidly Develop Discord-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 Discord.
-
Automate Copper Data Replication to Couchbase
Use CData Sync to Customize and automate Copper data replication to Couchbase.
-
Visualize Live Perplexity Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Perplexity data into custom reports in Power BI.
-
Automated Continuous Reckon Accounts Hosted Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Azure SQL Database.
-
Connect to Gmail Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Gmail Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.