CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Presto Data
Create Python applications that use pandas and Dash to build Presto-connected web apps.
-
Connect to Real-Time NetSuite Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for NetSuite and Dataflow to import and use NetSuite data in Power Apps.
-
Access Live Google Contacts Data in TIBCO Data Virtualization
Use the Google Contacts Tibco DV Adapter to create a Google Contacts data data source in TIBCO Data Virtualization Studio and gain access to live Google Contacts data from your TDV Server.
-
Access Live Attio Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Attio data from your Google Sheets.
-
Connect to Bannerbear Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bannerbear and the SQL Gateway to access Bannerbear data from Google Apps Script.
-
DataBind Controls to ActiveCampaign Data in Delphi
DataBind to ActiveCampaign data in Delphi with standard data access components and controls.
-
Publish Paylocity-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Paylocity data.
-
Automated Continuous Cassandra Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cassandra replication to IBM DB2.
-
Connect to SAS xpt Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAS xpt data.
-
Validate Wistia Data with QuerySurge
Access and validate Wistia data in QuerySurge using the CData JDBC Driver.
-
Create Authorize.Net-Connected Nintex Workflows
Use CData Connect AI to connect to Authorize.Net Data from Nintex Workflow Cloud and build custom workflows using live Authorize.Net data.
-
Connect to Instantly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Instantly and the SQL Gateway to access Instantly data from Google Apps Script.
-
Work with Webex Data in FoxPro
Load Webex data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for NetSuite in MicroStrategy
Connect to NetSuite data in MicroStrategy Developer using the CData Software ODBC Driver for NetSuite.
-
Gorgias Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gorgias facts in real time.
-
How to create Shippo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shippo data in MySQL .
-
Replicate CampaignMonitor Data from PowerShell
Write a quick PowerShell script to query CampaignMonitor data. Use connectivity to the live data to replicate CampaignMonitor data to SQL Server.
-
Natively Connect to SuiteCRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SuiteCRM data. Leverage the native support for ODBC in PHP.
-
Integrate Cloudant with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cloudant with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Cloudant data.
-
How to connect and process Coinbase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Coinbase data.
-
Object-Relational Mapping (ORM) with BambooHR 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 BambooHR data into a Java-based ORM framework, Hibernate.
-
Interact with Live SAS xpt Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAS xpt data.
-
Access Live SAP SuccessFactors LMS Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors LMS data from your Excel spreadsheets.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Netweaver Gateway
Create an ODBC connection to SAP Netweaver Gateway in Informatica and browse and transfer SAP Netweaver Gateway data.
-
Integrate Azure Analysis Services Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Analysis Services data and integrate live Azure Analysis Services data into your Power Automate tasks.
-
How to work with HCL Domino Data in Apache Spark using SQL
Access and process HCL Domino Data in Apache Spark using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Dynamics 365 Business Central Data
How to build a SQL Server Analysis Service Tabular Model from Dynamics 365 Business Central data using CData drivers.
-
Connect to PayPal Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with PayPal Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Teamwork Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teamwork replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Timely in MicroStrategy
Connect to Timely data in MicroStrategy Developer using the CData Software JDBC Driver for Timely.
-
Connecting Moonlit Workflow with Google Ad Manager 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 Google Ad Manager data in real time.
-
How to Work with Printify Data in AWS Glue Jobs Using JDBC
Connect to Printify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Act-On Data from AWS Glue
Use CData Connect AI to gain access to live Act-On data from your AWS Glue jobs.
-
Query Mode Data in DataGrip
Create a Data Source for Mode in DataGrip and use SQL to query live Mode data.
-
Connect to Gmail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gmail data using standard SQL.
-
Build Klaviyo-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Klaviyo data without replication.
-
Build SQL Analysis Services Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SQL Analysis Services data and build visualizations in Tableau Cloud.
-
How to Seamlessly Import Greenhouse Data into IBM SPSS Modeler
Integrate Greenhouse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
A PostgreSQL Interface for Auth0 Data using the CData ODBC Driver
Use the SQL Gateway and Auth0 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to FormSite Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FormSite data in the Denodo Virtual DataPort Administrator.
-
Access Live BigQuery Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BigQuery data into the statistical analysis tools available in SAS JMP. This article shows how to use BigQuery data in the Graph Builder and Query Builder.
-
Build a Singer.io Tap for CloudConvert With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CloudConvert data using the CData Python Connector.
-
Connect to ConstantContact Data in CloverDX (formerly CloverETL)
Transfer ConstantContact data using the visual workflow in the CloverDX data integration tool.
-
Build Automated Workflows with Live SharePoint Data in Workato
Use CData Connect AI to connect to live SharePoint data and build automated workflows in Workato.
-
Create SSAS Tabular Models from Rebilly Data
How to build a SQL Server Analysis Service Tabular Model from Rebilly data using CData drivers.
-
Build Pipelines with Live eBay Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to eBay from Google Cloud Data Fusion, enabling the integration of live eBay data into the building and management of effective data pipelines.
-
Object-Relational Mapping (ORM) with Placid 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 Placid data into a Java-based ORM framework, Hibernate.
-
How to Connect DBeaver to Aha! via a JDBC Driver
Manage Aha! data with visual tools in DBeaver like the query browser.
-
Integrate OpenCode with Live ZohoExpense Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ZohoExpense data from within your AI coding agent.
-
Visualize FreeAgent Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FreeAgent data.
-
Integrating Amazon S3 Data in Talend Cloud Data Management Platform
Connect Amazon S3 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon S3.
-
Getting Started with the CData Power BI Connector for MySQL
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MySQL.
-
Build Excel Online-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Excel Online data and build web apps with connectivity to live Excel Online data.
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics data in MicroStrategy Developer using the CData Software JDBC Driver for eBay Analytics.
-
Integrate LibreChat with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho Projects data from within the chat interface.
-
Connecting GenSpark with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Pipedrive data without any replication or custom integration required.
-
How to Access Zoho Creator Data Using Entity Framework
This article shows how to access Zoho Creator data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Bitly Data in Heroku for Use in Salesforce Connect
Replicate Bitly data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Apify 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 Apify data.
-
Consume Adobe Commerce OData Feeds in PowerBuilder
This article demonstrates how to consume Adobe Commerce data as OData feeds from PowerBuilder using the API Server.
-
Connect to Workday Data from PowerBuilder via JDBC
This article demonstrates how to access Workday data from PowerBuilder using the Workday JDBC Driver.
-
Validate Pushbullet Data with QuerySurge
Access and validate Pushbullet data in QuerySurge using the CData JDBC Driver.
-
Connecting Mastra with ADP 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 ADP data, no replication required.
-
Integrating Cursor with Pinecone 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.
-
Build Automated Workflows with Live ServiceDesk Plus Data in Workato
Use CData Connect AI to connect to live ServiceDesk Plus data and build automated workflows in Workato.
-
Automate Close Data Replication to Couchbase
Use CData Sync to Customize and automate Close data replication to Couchbase.
-
How to connect and process Drip data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Drip data.
-
How to Connect to Live DocuSign 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 DocuSign data for you.
-
DataBind Controls to SAP Netweaver Gateway Data in C++Builder
DataBind to SAP Netweaver Gateway data in C++Builder with standard components and controls.
-
Interact with Live Google Sheets Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Sheets data.
-
How to connect to Insightly Data in DBVisualizer
Integrate Insightly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Strava Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Strava facts in real time.
-
Build Visualizations of Scrapfly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Scrapfly data in Birst.
-
Build Apps with Live Zoho Creator data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho Creator data into the Adalo platform and build custom mobile and web applications with real-time Zoho Creator data.
-
Use the CData Software ODBC Driver for Cohere in MicroStrategy Desktop
Connect to Cohere data in MicroStrategy Desktop using the CData Software ODBC Driver for Cohere.
-
Use the CData ODBC Driver for Cosmos DB in Microsoft Power Query
You can use the CData Cosmos DB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cosmos DB data into Microsoft Power Query.
-
Connect and Query Live Google Spanner Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Spanner data into Databricks and enable direct, live querying and analysis without replication.
-
Import and Visualize Airtable Data in Power View
Create data visualizations based on Airtable data in Excel.
-
Build a Singer.io Tap for FormSite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FormSite data using the CData Python Connector.
-
Query Microsoft Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Ads data from Node.js.
-
Connect to DB2 Data in Aqua Data Studio
Access DB2 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Cosmos DB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Cosmos DB as an External Source in Dremio.
-
How to Work with MarkLogic Data in ETL Validator JDBC
Connect to MarkLogic from ETL Validator jobs using the CData Software JDBC Driver.
-
How to import eBay Data into Apache Solr
Use the CData Software JDBC Driver for eBay in Data Import Handler and create an automated import of eBay data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ADO.NET Provider for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Query, Visualize, and Share live Greenplum Data in Redash
Use CData Connect AI to connect to live Greenplum data in Redash for querying, visualizing, and sharing.
-
Automated Continuous EmailOctopus Replication to Oracle
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Oracle.
-
Visualize TaxJar Data in Tableau
The CData ODBC driver for TaxJar enables you integrate TaxJar data into Tableau dashboards.
-
Access Jumpseller Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jumpseller data from your Oracle system.
-
Creating SAP HANA XS Advanced-Connected Applications in Unqork
You can use CData Connect AI to feed SAP HANA XS Advanced data to Unqork and build custom business apps.
-
Access Invoiced Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Invoiced data from HeidiSQL.
-
Access Live Impala Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Impala data from your Google Sheets.
-
Query Gmail Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Gmail entities in PHP by modeling them as objects.
-
Access HBase 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 HBase data.
-
How to connect to Figshare Data in DBVisualizer
Integrate Figshare data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build a Simple VCL Application for Paddle Data
How to build a simple VCL Application to view Paddle data in RAD Studio using the CData ODBC Driver for Paddle.
-
How to Seamlessly Import Microsoft Entra ID Data into IBM SPSS Modeler
Integrate Microsoft Entra ID data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData SSIS Components for Bugsnag
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bugsnag.
-
Operational Reporting on CloudConvert Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CloudConvert data.
-
Connect and Query Live SAP BusinessObjects BI Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP BusinessObjects BI data into Databricks and enable direct, live querying and analysis without replication.