CData Software - Knowledge Base
Recent Articles
-
Connect to Perplexity Data in JRuby
Create a simple JRuby app with access to live Perplexity.
-
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 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 Apache CouchDB, 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 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Databricks Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Databricks and perform CRUD operations on Databricks from Node.js.
-
Migrating data from DocuSign to Databricks using CData SSIS Components.
Easily push DocuSign 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 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Instagram Data in DBVisualizer
Integrate Instagram with visual data analysis tools and data connection wizards in DBVisualizer
-
Working with Box Data in LINQPad
Execute LINQ queries to Box in LINQPad.
-
Access Live Invoiced Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Invoiced into the statistical analysis tools available in SAS JMP. This article shows how to use Invoiced 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 in LINQPad.
-
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.
-
How to Query Live Sage Cloud Accounting Data in Claude Desktop
Connect to and query live Sage Cloud Accounting Data in Claude Desktop using CData MCP Server.
-
Build an OLAP Cube in SSAS from Amplitude Data
Establish a connection to Amplitude 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 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 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.
-
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
-
Visualize Live Keap Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Keap 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 with visual tools in DBeaver like the query browser.
-
Migrating data from Twilio to Snowflake using CData SSIS Components.
Easily push Twilio to Snowflake using the CData SSIS Tasks for Twilio and Snowflake.
-
Access Live Shopify Data in Coginiti Pro
Connect to and query live Shopify 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 Business Cloud Accounting 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 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.
-
Publish Crystal Reports on Mode Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mode.
-
Automated ZohoDesk Data Replication to Teradata
Use CData Sync to Customize and automate ZohoDesk 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.
-
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 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 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 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 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 from PowerShell? This article demonstrates how to utilize the Sendwithus Cmdlets for tasks like connecting to Sendwithus, automating operations, downloading data, and more.
-
Connect to Act-On Data in RazorSQL
Connect to Act-On from wizards and query Act-On 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 in SpagoBI Studio. Host AfterShip reports on SpagoBI Server.
-
Automated Continuous CData Connect AI Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Azure SQL Database.
-
Migrating data from HelloSign to Snowflake using CData SSIS Components.
Easily push HelloSign to Snowflake using the CData SSIS Tasks for HelloSign and Snowflake.
-
How to Query Office 365 Data in MySQL Workbench
Execute MySQL queries against live Microsoft Office 365 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 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 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.
-
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 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 from Web applications running on WebLogic.
-
Import Asana Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Asana. In this article, you will use the OData format to import Asana into Microsoft Power Query.
-
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 to a chart.
-
Working with Wave Financial Data in LINQPad
Execute LINQ queries to Wave Financial 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 for you.
-
Import and Visualize Drip Data in Power View
Create data visualizations based on Drip 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 and integrate live API 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 and visualize live Blackbaud FE NXT in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Tally in MicroStrategy Desktop
Connect to Tally ERP 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 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.
-
Analyze Couchbase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Couchbase 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 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 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Quickbase.
-
How to connect SharePoint with Azure Data Lake Storage Data through external lists
Provide Azure Data Lake Storage 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 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 CLI with Google Tasks 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 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 Google BigQuery from SAS Viya and deploy self-service analytics using live Google BigQuery.
-
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 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 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
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.
-
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.
-
Easily Integrate ActiveCampaign Data in Lazarus Pascal IDE
Learn how to easily integrate live ActiveCampaign 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.
-
Integrating Codex CLI with Salesforce Pardot 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 Microsoft OneNote using the visual workflow in the CloverDX data integration tool.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Lakebase to Power BI dashboards. Simply drag and drop Lakebase into data visuals on the Power BI canvas.
-
Connect to Confluence Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Atlassian Confluence using standard SQL.
-
Access Confluence Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Atlassian Confluence 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 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 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
-
Automated Continuous SpaceX Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SpaceX replication to Apache Cassandra.
-
Automated Continuous Harvest Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Harvest replication to Amazon S3.
-
Query IBM Informix Data in ColdFusion
Write standard ColdFusion data access code to connect to IBM Informix.
-
Provide OData Services of Avro Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Avro by developing a WCF Service Application.
-
Build Google Contacts-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Contacts.
-
DataBind Controls to Webex Data in Delphi
DataBind to Webex in Delphi with standard data access components and controls.
-
Connect to Google Ads Data in DBArtisan
Use wizards in DBArtisan to configure Google Ads as a data source.