CData Software - Knowledge Base
Recent Articles
-
Create Apps from Cassandra Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cassandra Data and build apps from live Cassandra data in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for eBay Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time eBay Analytics data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for eBay Analytics.
-
Create Reports with Paymo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paymo data.
-
Connect to Perplexity Data in JRuby
Create a simple JRuby app with access to live Perplexity data.
-
Consume Google Sheets OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Sheets feeds that reflect any changes in SAP Lumira.
-
Connect Datadog to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Datadog data using the CData Python MCP Server.
-
Connect to CouchDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from CouchDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live SAP Hybris C4C Data in Coginiti Pro
Connect to and query live SAP Hybris C4C data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from DocuSign to Databricks using CData SSIS Components.
Easily push DocuSign data to Databricks using the CData SSIS Tasks for DocuSign and Databricks.
-
Getting Started with the CData Excel Add-In for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Elasticsearch.
-
Integrate Sendwithus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sendwithus with External Services.
-
Access Live Guru Data in Coginiti Pro
Connect to and query live Guru data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Instagram Data in DBVisualizer
Integrate Instagram data with visual data analysis tools and data connection wizards in DBVisualizer
-
Working with Box Data in LINQPad
Execute LINQ queries to Box data in LINQPad.
-
Access Live Invoiced Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Invoiced data into the statistical analysis tools available in SAS JMP. This article shows how to use Invoiced data in the Graph Builder and Query Builder.
-
Connect ActiveCampaign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ActiveCampaign with IBM WebSphere for seamless data integration and connectivity.
-
Working with Oracle Service Cloud Data in LINQPad
Execute LINQ queries to Oracle Service Cloud data in LINQPad.
-
Use Dash to Build Web Apps on Salesloft Data via CData Connect AI
Build interactive Dash web apps on live Salesloft data using pandas and the CData Connect AI Python SDK.
-
Connect to Onfleet from Asprova with CData Software ODBC Driver for Onfleet
This article shows how to connect faster to Onfleet data from Asprova.
-
Build a PostgreSQL Interface for Pinecone Data using the CData JDBC Driver
Use the Remoting features of the Pinecone JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build an OLAP Cube in SSAS from Amplitude Data
Establish a connection to Amplitude data data from SQL Server Analysis Services, and use the Amplitude Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to QuickBooks Online Data with Squirrel SQL client
Connect to QuickBooks Online data and execute queries in the Squirrel SQL Client.
-
Load Browserless Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Browserless data to a database.
-
Build Semantic Layer Views for QuickBooks Time Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Time data.
-
Integrating Dataiku with Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Discord data.
-
Integrate Cursor with Live TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live TaxJar data from within the editor.
-
Bind Live SAP Business Warehouse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Business Warehouse data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Visualize Live Keap Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Keap data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect DBeaver to Postmark via a JDBC Driver
Manage Postmark data with visual tools in DBeaver like the query browser.
-
Build Python Apps on Your Business Data with the New CData CLI
Learn how to use the CData CLI and its Python skill to ground AI coding agents in your real data schema and build data-connected Python applications against Salesforce, Gmail, Jira, Snowflake, and hundreds of other sources.
-
Migrating data from Twilio to Snowflake using CData SSIS Components.
Easily push Twilio data to Snowflake using the CData SSIS Tasks for Twilio and Snowflake.
-
Access Live Shopify Data in Coginiti Pro
Connect to and query live Shopify data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Agno to Talk to Your Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Sage Cloud Accounting data for you.
-
Process & Analyze Presto Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Presto Data.
-
Access Couchbase Data from MySQL in Amazon QuickSight
Connect to Couchbase and build visualizations of Couchbase data using a MySQL Connection in Amazon QuickSight.
-
Connect to Oracle HCM Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle HCM Cloud data.
-
Publish Crystal Reports on Mode Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mode data.
-
Automated ZohoDesk Data Replication to Teradata
Use CData Sync to Customize and automate ZohoDesk data replication to Teradata.
-
How to connect PolyBase to Tickspot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Tickspot data.
-
Build LDAP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to LDAP Objects from Zoho Analytics and import live LDAP objects.
-
Visualize Live SAP Hybris C4C Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Hybris C4C data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Establish a Live Connection with SpaceX Data using Tableau Bridge
The CData ODBC Driver for SpaceX enables you to integrate live SpaceX data into Tableau Cloud dashboards using the Tableau Bridge.
-
Trigger Redshift IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Redshift with standard wizards in Logic Apps.
-
How to Connect to Live Sage Intacct 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 Sage Intacct data for you.
-
Use the CData Software ODBC Driver for SAP Business Warehouse in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Business Warehouse data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Business Warehouse.
-
Automate Sendwithus Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sendwithus data from PowerShell? This article demonstrates how to utilize the Sendwithus Cmdlets for tasks like connecting to Sendwithus data, automating operations, downloading data, and more.
-
Connect to Act-On Data in RazorSQL
Connect to Act-On from wizards and query Act-On data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData JDBC Driver for HCL Domino
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HCL Domino.
-
Excel Spreadsheet Automation on SAP SuccessFactors LMS Data with the QUERY Formula
Pull data from SAP SuccessFactors LMS, automate spreadsheets, and more with the QUERY formula.
-
Connect to AfterShip in SpagoBI
Create reports featuring live AfterShip data in SpagoBI Studio. Host AfterShip reports on SpagoBI Server.
-
Migrating data from HelloSign to Snowflake using CData SSIS Components.
Easily push HelloSign data to Snowflake using the CData SSIS Tasks for HelloSign and Snowflake.
-
Seamlessly Bring Google Forms Data into Retool Using CData Connect AI
Integrate Google Forms data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Query Office 365 Data in MySQL Workbench
Execute MySQL queries against live Office 365 data from MySQL Workbench.
-
A PostgreSQL Interface for Humanity Data (MySQL Remoting via JDBC)
Use the Remoting features of the Humanity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LlamaIndex with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Facebook Ads data in real time.
-
Getting Started with the CData Tableau Connector for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Data Catalog.
-
Connect to Clockify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Clockify to connect to Clockify data and execute queries in PowerBuilder.
-
How to use SQLAlchemy ORM to access Google Directory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Directory data.
-
Connect to Procore Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Procore Data and connect to Procore data in Akorbi Digital RunMyProcess.
-
Connect to Google Drive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Drive to connect to Google Drive data from Web applications running on WebLogic.
-
DataBind Placid Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Placid data to a chart.
-
Working with Wave Financial Data in LINQPad
Execute LINQ queries to Wave Financial data in LINQPad.
-
Getting Started with the CData ODBC Driver for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAS Data Sets.
-
Use ChatGPT to Talk to Your GitLab 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 GitLab data for you.
-
Import and Visualize Drip Data in Power View
Create data visualizations based on Drip data in Excel.
-
How to Import Gmail Data into Excel with CData
Learn how to connect and import Gmail data directly into Microsoft Excel using the CData Excel Add-In. Query, analyze, and visualize your email data using standard SQL.
-
Integrate Live API Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to API data and integrate live API data into apps built in Microsoft Power Apps.
-
Analyze Blackbaud FE NXT Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Blackbaud FE NXT data and visualize live Blackbaud FE NXT data in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Tally in MicroStrategy Desktop
Connect to Tally data in MicroStrategy Desktop using the CData Software JDBC Driver for Tally.
-
Deploy the ADO.NET Provider for Gorgias on an SSRS Report Server
Connect to Gorgias data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect and Query Live ZohoExpense Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ZohoExpense data into Databricks and enable direct, live querying and analysis without replication.
-
Analyze Couchbase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Couchbase data with the CData JDBC Driver for Couchbase.
-
Use the CData ODBC Driver for Microsoft Planner in Microsoft Power Query
You can use the CData Microsoft Planner ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Planner data into Microsoft Power Query.
-
How to Easily Query LinkedIn Data in OpenOffice Base
Connect to LinkedIn data in OpenOffice Base using the CData ODBC Driver for LinkedIn and generate reports with live data insights.
-
How to connect and process Quickbase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Quickbase data.
-
How to connect SharePoint with Azure Data Lake Storage Data through external lists
Provide Azure Data Lake Storage data to SharePoint users as an external list.
-
How to Build an ETL App for Zoho Recruit Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Recruit data in Python with petl.
-
Getting Started with the CData SSIS Components for SAS xpt
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAS xpt.
-
Integrating GitHub Copilot with Google Tasks 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 to Hubstaff Data in Ruby
Connect to Hubstaff data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Mailjet Replication to Vertica
Use CData Sync for automated, continuous, customizable Mailjet replication to Vertica.
-
Analyze Live BigQuery Data in SAS Viya
Use CData Connect AI to connect to BigQuery data from SAS Viya and deploy self-service analytics using live BigQuery data.
-
Integrate Cursor with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sage 200 data from within the editor.
-
Getting Started with the CData SSIS Components for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZeroBounce.
-
Access Live JobNimbus Data in AWS Lambda (with IntelliJ IDEA)
Connect to live JobNimbus data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live LDAP Objects 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 LDAP objects for you.
-
How to connect PolyBase to Clio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Clio data.
-
Integrate Salesforce Marketing with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce Marketing with External Services.
-
Use JayDeBeApi to access Egnyte Data in Python
Use standard Python scripting and the development environment of your choice to access live Egnyte data.
-
Easily Integrate ActiveCampaign Data in Lazarus Pascal IDE
Learn how to easily integrate live ActiveCampaign data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Kafka Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Kafka replication to PostgreSQL.
-
Use JayDeBeApi to access Wistia Data in Python
Use standard Python scripting and the development environment of your choice to access live Wistia data.
-
Integrating Codex with Salesforce Pardot 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 to OneNote Data in CloverDX (formerly CloverETL)
Transfer OneNote data using the visual workflow in the CloverDX data integration tool.
-
Integrate ZohoExpense Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ZohoExpense data and integrate live ZohoExpense data into your Power Automate tasks.
-
Connect to Confluence Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Confluence data using standard SQL.
-
Access Confluence Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Confluence data from your Oracle system.
-
Import Avalara AvaTax Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Avalara AvaTax Data and provide access to live Avalara AvaTax data for custom reports in the Power BI Service.
-
Connect to EmailOctopus Data from a Connection Pool in Jetty
The EmailOctopus JDBC Driver supports connection pooling: This article shows how to connect faster to EmailOctopus data from Web apps in Jetty.
-
Bind Live SAP Netweaver Gateway Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Netweaver Gateway data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.