CData Software - Knowledge Base
Recent Articles
-
How to Work with ShipStation Data in AWS Glue Jobs Using JDBC
Connect to ShipStation from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Zoho Inventory Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho Inventory from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from LeadDesk to Google BigQuery using CData SSIS Components.
Easily push LeadDesk to Google BigQuery using the CData SSIS Tasks for LeadDesk and Google BigQuery.
-
Getting Started with the CData ODBC Driver for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for EmailOctopus.
-
Use the CData Software ODBC Driver for Clari in MicroStrategy Web
Connect to Clari in MicroStrategy Web using the CData Software ODBC Driver for Clari.
-
How to publish and share Greenhouse Data dashboards with Tableau Server
The CData ODBC driver for Greenhouse enables you integrate Greenhouse into Tableau dashboards.
-
Integrate Google Campaign Manager 360 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Campaign Manager 360 with External Services.
-
DataBind Controls to PayPal Data in C++Builder
DataBind to PayPal in C++Builder with standard components and controls.
-
Design BIRT Reports on Pinterest Data
Provide current Pinterest to your embedded analytics.
-
How to publish and share OneNote Data dashboards with Tableau Server
The CData ODBC driver for OneNote enables you integrate Microsoft OneNote into Tableau dashboards.
-
Easily Integrate Demio Data in Lazarus Pascal IDE
Learn how to easily integrate live Demio in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to SurveyMonkey from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SurveyMonkey, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live Perigon Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Perigon to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Bridge Adobe Experience Manager Connectivity with Apache NiFi
Access and process Adobe Experience Manager in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Airtable Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Airtable replication to Amazon Redshift.
-
Automate Adobe Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Adobe Analytics from PowerShell? This article demonstrates how to utilize the Adobe Analytics Cmdlets for tasks like connecting to Adobe Analytics, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with SingleStore Data
Access SingleStore as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Trello Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Trello in Airbyte.
-
Visualize Cohere Data in TIBCO Spotfire through ADO.NET
Integrate Cohere into dashboards in TIBCO Spotfire.
-
How to update SAP SuccessFactors from Excel
This article explains how to transfer data from Excel to SAP SuccessFactors using the Excel Add-In for SAP SuccessFactors.
-
Integrating Antigravity CLI with CircleCI via CData CLI
Connect CircleCI to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to update Basecamp from Excel
This article explains how to transfer data from Excel to Basecamp using the Excel Add-In for Basecamp.
-
Connect to Missive Data in Jaspersoft Studio
Execute SQL to remote Missive in Jaspersoft Studio.
-
Design BIRT Reports on Google Sheets Data
Provide current Google Sheets to your embedded analytics.
-
Connect to OneNote Data in RazorSQL
Connect to OneNote from wizards and query Microsoft OneNote from the GUI in the RazorSQL database management tool.
-
Integrate with ConvertAPI Data in JReport Designer
Create charts and reports based on ConvertAPI in JReport Designer.
-
Create a Data Access Object for Cassandra Data using JDBI
A brief overview of creating a SQL Object API for Apache Cassandra in JDBI.
-
How to Visualize PostgreSQL Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live PostgreSQL in Python.
-
Analyze Oracle HCM Cloud Data in Cognos Analytics
Use CData Connect AI to connect to Oracle HCM Cloud Data from Cognos Analytics and analyze live Oracle HCM Cloud.
-
Visualize Todoist Data in TIBCO Spotfire through ADO.NET
Integrate Todoist into dashboards in TIBCO Spotfire.
-
Visualize ShipEngine 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 ShipEngine into TIBCO Spotfire.
-
Add Greenhouse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Greenhouse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData API Server to Access Oracle Data in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Database in the Power Pivot business intelligence tool.
-
Connect to Salesforce Marketing Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce Marketing and the SQL Gateway to access Salesforce Marketing Cloud from Google Apps Script.
-
Build Agents in Relevance AI with Access to Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Neo4J within intelligent agent workflows.
-
Model, Search, and Visualize Live Oracle Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Database for modeling, searching, and visualizing.
-
Access Pipeliner CRM Data from MySQL in Amazon QuickSight
Connect to Pipeliner CRM and build visualizations of Pipeliner CRM using a MySQL Connection in Amazon QuickSight.
-
Build Act-On-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Act-On.
-
How to Connect to Live Cvent Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Cvent through natural language.
-
Integrating Cursor CLI with Freshsales 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.
-
Connect and Visualize Live Slack Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Slack into the Databricks platform and create visualization dashboards with real-time Slack.
-
Provide OData Services of Microsoft Entra ID Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Entra ID by developing a WCF Service Application.
-
Connect to ShipEngine Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ShipEngine and work with ShipEngine in your FileMaker applications.
-
How to update Teradata from Excel
This article explains how to transfer data from Excel to Teradata using the Excel Add-In for Teradata.
-
How to Import Data from HubSpot into Google Sheets
Import HubSpot into a Google spreadsheet that is automatically refreshed.
-
Excel Spreadsheet Automation on Google Tasks Data with the QUERY Formula
Pull data from Google Tasks, automate spreadsheets, and more with the QUERY formula.
-
Access Live Aircall Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Aircall in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Real-Time Suadeo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Suadeo in ColdFusion.
-
Enable the Oracle Service Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Service Cloud.
-
WordPress Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on WordPress facts in real time.
-
Automated Continuous Box Replication to SQL Server
Use CData Sync for automated, continuous, customizable Box replication to SQL Server.
-
Connect OData to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live OData using the CData Python MCP Server.
-
Analyze Zoho Inventory Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Inventory with the CData JDBC Driver for Zoho Inventory.
-
Visualize Contentful Data in TIBCO Spotfire through ADO.NET
Integrate Contentful into dashboards in TIBCO Spotfire.
-
Automated Continuous SAP HANA Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP HANA replication to Snowflake.
-
Access Azure Analysis Services 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 Azure Analysis Services.
-
Automated Continuous Microsoft OneLake Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to PostgreSQL.
-
Use ChatGPT to Talk to Your Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle HCM Cloud for you.
-
How to Work with Email Data in AWS Glue Jobs Using JDBC
Connect to Email from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Microsoft Teams Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Teams in FileMaker Pro to connect to Microsoft Teams and work with Microsoft Teams in your FileMaker applications.
-
Use the CData Software ODBC Driver for Gorgias in MicroStrategy
Connect to Gorgias in MicroStrategy Developer using the CData Software ODBC Driver for Gorgias.
-
Manage Mouseflow Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mouseflow.
-
How to Connect to Live HubSpot 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 HubSpot for you.
-
Create Impala Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Impala from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Easily Query ZohoSubscriptions Data in OpenOffice Base
Connect to ZohoSubscriptions data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to load Power BI XMLA data into Elasticsearch via Logstash
Introducing a simple method to load Power BI XMLA data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Codex CLI with QuickBooks Online 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.
-
LINQ to Everhour 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 Everhour Data Provider.
-
Integrate Theia IDE with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Import and Visualize PolarTeamPro Data in Power View
Create data visualizations based on PolarTeamPro in Excel.
-
Viewing Paymo Data in RAD Studio Data Explorer
How to view Paymo in RAD Studio Data Explorer using the CData ODBC Driver for Paymo.
-
View Reports on Real-Time Salesforce Marketing Data in Power BI Report Server
Use the CData ODBC Driver for Salesforce Marketing to visualize Salesforce Marketing Cloud in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAS Data Sets
Provide connectivity to SAS Data Sets through an SAP BusinessObjects universe.
-
Integrate Shippo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Shippo from Informatica Cloud.
-
Publish Instagram-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Instagram.
-
Automated Continuous CSV Replication to MongoDB
Use CData Sync for automated, continuous, customizable CSV replication to MongoDB.
-
Extract, Transform, and Load Pinecone Data in Informatica PowerCenter
Create a simple Workflow for Pinecone in Informatica PowerCenter.
-
Build ADP Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ADP and build visualizations in Tableau.
-
Use JayDeBeApi to access Placid Data in Python
Use standard Python scripting and the development environment of your choice to access live Placid.
-
Analyze Google Spanner Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Spanner and visualize live Google Spanner in Infragistics Reveal.
-
LINQ to SendGrid 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 SendGrid Data Provider.
-
Access Live Adobe Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Adobe Analytics from your Excel spreadsheets.
-
How to Work with Mailjet Data in ETL Validator JDBC
Connect to Mailjet from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live WooCommerce Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live WooCommerce securely in real time.
-
How to connect PolyBase to Airtable
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Airtable.
-
Connect to Elasticsearch Data in CloverDX (formerly CloverETL)
Transfer Elasticsearch using the visual workflow in the CloverDX data integration tool.
-
Integrate Insightly Data in Pentaho Data Integration
Build ETL pipelines based on Insightly in the Pentaho Data Integration tool.
-
Use Dash to Build to Web Apps on SAP Concur Data
Create Python applications that use pandas and Dash to build SAP Concur-connected web apps.
-
How to Connect to Live Kintone Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Kintone through natural language.
-
Connect to Cloudant from Asprova with CData Software ODBC Driver for Cloudant
This article shows how to connect faster to Cloudant data from Asprova.
-
Integrate Live Certinia Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Certinia from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Certinia.
-
How to Connect Flowise AI Agents to Live Splunk Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Splunk without replication.
-
Prepare, Blend, and Analyze ZohoMarketingHub Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoMarketingHub for self-service data analytics.
-
Use Dash to Build to Web Apps on CouchDB Data
Create Python applications that use pandas and Dash to build CouchDB-connected web apps.
-
Connect to Supabase Data in RazorSQL
Connect to Supabase from wizards and query Supabase from the GUI in the RazorSQL database management tool.
-
Connect to SQL Analysis Services Data in Claris FileMaker Pro
Use the CData ODBC Driver for SQL Analysis Services in FileMaker Pro to connect to SQL Analysis Services and work with SQL Analysis Services in your FileMaker applications.
-
Access Live Unbounce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Unbounce in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData SSIS Components for Facebook
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Facebook.
-
Choosing the Best Method to Connect Azure DevOps to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure DevOps from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Clio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Clio to connect to Clio from Web applications running on WebLogic.