CData Software - Knowledge Base
Recent Articles
-
Viewing Jumpseller Data in RAD Studio Data Explorer
How to view Jumpseller data in RAD Studio Data Explorer using the CData ODBC Driver for Jumpseller.
-
Validate Contentful Data with QuerySurge
Access and validate Contentful data in QuerySurge using the CData JDBC Driver.
-
Operational Reporting on Impala Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Impala data.
-
Connect to Monday.com Data from AWS Glue
Use CData Connect AI to gain access to live Monday.com data from your AWS Glue jobs.
-
Model Apify Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Apify, enabling the direct import of real-time Apify data.
-
How to Connect DBeaver to BambooHR via a JDBC Driver
Manage BambooHR data with visual tools in DBeaver like the query browser.
-
How to connect PolyBase to Amazon DynamoDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon DynamoDB data.
-
Work with VWO Data in FoxPro
Load VWO data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to MailChimp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MailChimp data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Everhour in SpagoBI
Create reports featuring live Everhour data in SpagoBI Studio. Host Everhour reports on SpagoBI Server.
-
Bridge Avaza Connectivity with Apache NiFi
Access and process Avaza data in Apache NiFi using the CData JDBC Driver.
-
How to connect to Spark Data in DBVisualizer
Integrate Spark data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Voice Agents in ElevenLabs with access to Live ZohoInvoice Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ZohoInvoice data.
-
Object-Relational Mapping (ORM) with NetSuite 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 NetSuite data into a Java-based ORM framework, Hibernate.
-
Visualize Unbounce 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 Unbounce data into TIBCO Spotfire.
-
Connect Dynamics NAV Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Dynamics NAV data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for Workday in a Connection Pool in Tomcat
Connect to Workday data from a connection pool in Tomcat.
-
How to Build an ETL App for Supabase Data in Python with CData Connect AI
Extract and transform live Supabase data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Amazon DynamoDB Replication to Databricks
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Databricks.
-
Configure the CData JDBC Driver for Authorize.Net in a Connection Pool in Tomcat
Connect to Authorize.Net data from a connection pool in Tomcat.
-
Create Reports with Paylocity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paylocity data.
-
Model Mailgun Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Mailgun, enabling the direct import of real-time Mailgun data.
-
How to use SQLAlchemy ORM to access ChartMogul Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ChartMogul data.
-
Connect to Zendesk Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zendesk Data and connect to Zendesk data in Akorbi Digital RunMyProcess.
-
Integrate OneNote with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OneNote with External Services.
-
Use Azure AI Foundry to Talk to Your Outreach.io 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 Outreach.io data for you.
-
Choosing the Best Method to Connect Zoho Books to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Books data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Pipedrive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Pipedrive Data from Zoho Analytics and import live Pipedrive data.
-
Analyze Live Paylocity Data in SAS Viya
Use CData Connect AI to connect to Paylocity data from SAS Viya and deploy self-service analytics using live Paylocity data.
-
Provide OData Services of SendGrid Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SendGrid data by developing a WCF Service Application.
-
Visualize Paylocity Data in Tableau
The CData ODBC driver for Paylocity enables you integrate Paylocity data into Tableau dashboards.
-
How to use SQLAlchemy ORM to access Auth0 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Auth0 data.
-
How to Easily Query Hubstaff Data in OpenOffice Base
Connect to Hubstaff data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Pipelines with Live Splunk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Splunk from Google Cloud Data Fusion, enabling the integration of live Splunk data into the building and management of effective data pipelines.
-
Extract, Transform, and Load Wistia Data in Informatica PowerCenter
Create a simple Workflow for Wistia data in Informatica PowerCenter.
-
Build ZohoInvoice-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoInvoice data and build web apps with connectivity to live ZohoInvoice data.
-
Auth0 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Auth0 facts in real time.
-
How to create Google Drive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Drive data in MySQL .
-
Build Dashboards with NetSuite Data in Dundas BI
Create dynamic dashboards and perform analytics based on NetSuite data in Dundas BI.
-
Visualize Microsoft OneDrive 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 Microsoft OneDrive data into TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for Avro
Install the CData Connect AI Python SDK to read live Avro data with standard DB-API 2.0 Python code.
-
Connect to Microsoft Teams Data in Jaspersoft Studio
Execute SQL to remote Microsoft Teams data in Jaspersoft Studio.
-
SAP Business Warehouse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Business Warehouse facts in real time.
-
Integrating LlamaIndex with Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Twilio data in real time.
-
How to connect to Freshteam Data with Squirrel SQL client
Connect to Freshteam data and execute queries in the Squirrel SQL Client.
-
Integrate with Klipfolio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Klipfolio data to a JSON file on disk.
-
How to Connect to Live SAS Data Sets 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 SAS Data Sets data for you.
-
Use the CData Software ODBC Driver for Paddle in MicroStrategy Web
Connect to Paddle data in MicroStrategy Web using the CData Software ODBC Driver for Paddle.
-
Getting Started with the CData Python Connector for SQL Server
Learn to install and license the CData Python Connector and configure a connection to live SQL Server data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Placid
Provide connectivity to Placid data through an SAP BusinessObjects universe.
-
Connect and Visualize Live Trello Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Trello data into the Databricks platform and create visualization dashboards with real-time Trello data.
-
Model, Search, and Visualize Live MYOB AccountRight Data in ThoughtSpot
Use CData Connect AI to connect to live MYOB AccountRight data for modeling, searching, and visualizing.
-
Avro Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Avro facts in real time.
-
Automated Continuous Quaderno Replication to Vertica
Use CData Sync for automated, continuous, customizable Quaderno replication to Vertica.
-
Interact with Live ZohoExpense Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live ZohoExpense data.
-
Google Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Ads data through CData Connect AI using different applications and tools.
-
Connect to Odoo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Odoo data.
-
Automated Continuous Kintone Replication to MySQL
Use CData Sync for automated, continuous, customizable Kintone replication to MySQL.
-
Automate Accelo Data Replication to Couchbase
Use CData Sync to Customize and automate Accelo data replication to Couchbase.
-
Automated Continuous Klaviyo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to Google Cloud SQL.
-
Automated Continuous Acumatica Replication to Vertica
Use CData Sync for automated, continuous, customizable Acumatica replication to Vertica.
-
Connect to Amplitude Data in NetBeans
Connect to Amplitude data in NetBeans with the data source configuration wizard.
-
Use Microsoft Copilot Studio to talk to your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Zoom data for you.
-
Automated Continuous Zoho Projects Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Databricks.
-
Build Bullhorn CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Bullhorn CRM data and build Bullhorn CRM-connected web apps with Axios.
-
How to Visualize Spotify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Spotify data in Python.
-
Integrating OpenCode with PostgreSQL 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.
-
Import Real-Time Freshteam Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshteam data in ColdFusion.
-
How to connect PolyBase to NetSuite
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live NetSuite data.
-
Analyze Zoho Books Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Books data with the CData JDBC Driver for Zoho Books.
-
Build Semantic Layer Views for Pinterest Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Pinterest data.
-
View Reports on Real-Time Planio Data in Power BI Report Server
Use the CData ODBC Driver for Planio to visualize Planio data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live SAP Fieldglass Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Fieldglass data through MCP integration.
-
Connect to Oracle Sales Data in RapidMiner
Integrate Oracle Sales data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Real-Time Access to WooCommerce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to WooCommerce data in real time.
-
Access Dynamics 365 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 Dynamics 365 data.
-
Connect to Freshsales Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Freshsales and work with Freshsales data in your FileMaker applications.
-
Automated Continuous Square Replication to SQLite
Use CData Sync for automated, continuous, customizable Square replication to SQLite.
-
Build Hugging Face-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Hugging Face data.
-
Connect to eBay Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with eBay Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Kafka Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Kafka Data and connect to Kafka data in Akorbi Digital RunMyProcess.
-
Connect to Marketo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Marketo and the SQL Gateway to access Marketo data from Google Apps Script.
-
Integrating Kiro with OData Services 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.
-
Connect to ChartMogul Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ChartMogul.
-
Connect to Amazon Marketplace from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Marketplace data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Automated Workflows with Live Redshift Data in Workato
Use CData Connect AI to connect to live Redshift data and build automated workflows in Workato.
-
Integrating OpenCode with Databricks 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.
-
How to Access LinkedIn Ads Data Using Entity Framework
This article shows how to access LinkedIn Ads data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Square Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Square data in Airbyte.
-
Connect to Live Neo4J Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Neo4J in CData Connect AI and connect to your Neo4J data from PostgreSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shippo
Provide connectivity to Shippo data through an SAP BusinessObjects universe.
-
Automated Continuous JobNimbus Replication to MySQL
Use CData Sync for automated, continuous, customizable JobNimbus replication to MySQL.
-
Manage Google Ad Manager Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Ad Manager.
-
How to Connect to Live BigCommerce Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your BigCommerce data for you.
-
Automated Continuous SendInBlue Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SendInBlue data replication to OneLake in Microsoft Fabric.
-
Trigger Facebook Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Facebook Ads with standard wizards in Logic Apps.
-
Create Box-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Box Data from OutSystems and build custom enterprise apps using live Box data.
-
Build Data Flows from Rootly to SQL Server using SSIS
Easily back up Rootly data to SQL Server using the SSIS components for Rootly.
-
Connect to PagerDuty Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PagerDuty and the SQL Gateway to access PagerDuty data from Google Apps Script.
-
Build AI Agents with Avro Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Avro data through CData Connect AI.