CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ShipStation
Provide connectivity to ShipStation through an SAP BusinessObjects universe.
-
Access Live Authorize.Net 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 Authorize.Net through MCP integration.
-
How to integrate PagerDuty with Apache Airflow
Access and process PagerDuty in Apache Airflow using the CData JDBC Driver.
-
Connect to and Visualize Live Excel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel.
-
Building Dynamic Web Pages with Outreach.io Data Using AngularJS
Create single-page applications with live connectivity to Outreach.io using the CData API Server.
-
Build Charts with Factorial Data in Clear Analytics
Create dynamic charts and perform analytics based on Factorial in Clear Analytics.
-
Replicate Cohere Data from PowerShell
Write a quick PowerShell script to query Cohere. Use connectivity to the live data to replicate Cohere to SQL Server.
-
Automated Continuous ClickTime Replication to Snowflake
Use CData Sync for automated, continuous, customizable ClickTime replication to Snowflake.
-
Automated Continuous Spark Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Spark SQL replication to OneLake in Microsoft Fabric.
-
Edit and Search Snowflake External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Snowflake to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Snowflake objects that you can access from apps and the dashboard.
-
Getting Started with the CData Power BI Connector for Kintone
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Kintone.
-
Create Datasets from SAS xpt in Domo Workbench and Build Visualizations of SAS xpt Data in Domo
Use the CData Software ODBC Driver for SAS xpt to create datasets from SAS XPORT in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to GitLab Data with Squirrel SQL client
Connect to GitLab and execute queries in the Squirrel SQL Client.
-
How to Query Live Tally Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tally ERP data in natural language using Python.
-
Integrate Live Sugar CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sugar CRM and integrate live Sugar CRM into apps built in Microsoft Power Apps.
-
Choosing the Best Method to Connect SAS Data Sets to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAS Data Sets from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live Workable Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Workable.
-
Consume Marketo OData Feeds in PowerBuilder
This article demonstrates how to consume Marketo as OData feeds from PowerBuilder using the API Server.
-
How to integrate Zendesk with Apache Airflow
Access and process Zendesk in Apache Airflow using the CData JDBC Driver.
-
How to Easily Query Snowflake Data in OpenOffice Base
Connect to Snowflake data in OpenOffice Base using the CData ODBC Driver for Snowflake and generate reports with live data insights.
-
Access Live Freshdesk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshdesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Operational Reporting on QuickBooks Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote QuickBooks Desktop.
-
Process & Analyze Todoist Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Todoist Data.
-
How to Connect DBeaver to ZendeskSell via a JDBC Driver
Manage ZendeskSell with visual tools in DBeaver like the query browser.
-
Build LeadDesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LeadDesk.
-
How to connect PolyBase to CircleCI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CircleCI.
-
Integrating Claude Code CLI with LinkedIn Ads 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.
-
Getting Started with the CData Excel Add-In for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZendeskSell.
-
Integrate SpaceX Data in Pentaho Data Integration
Build ETL pipelines based on SpaceX in the Pentaho Data Integration tool.
-
Natively Connect to Amazon DynamoDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon DynamoDB. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ADO.NET Provider for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Helpscout 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 Helpscout into TIBCO Spotfire.
-
Natively Connect to Oracle Service Cloud Data in PHP
The CData ODBC driver for Oracle Service Cloud enables you to create PHP applications with connectivity to Oracle Service Cloud. Leverage the native support for ODBC in PHP.
-
Integrating GitHub Copilot CLI with Grafana 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.
-
Create a Data Access Object for Gmail Data using JDBI
A brief overview of creating a SQL Object API for Gmail in JDBI.
-
Connect to Real-Time Reckon Accounts Hosted Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Reckon Accounts Hosted and Dataflow to import and use Reckon Accounts Hosted in Power Apps.
-
Create Dynamic Databricks Grids Using the Infragistics XamDataGrid
Learn how you can connect Databricks to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop PolarTeamPro-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PolarTeamPro.
-
Connect to BigQuery Data in RapidMiner
Integrate Google BigQuery with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Customer.io Data in DBArtisan
Use wizards in DBArtisan to configure Customer.io as a data source.
-
Create Dynamic SAS Data Sets Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS Data Sets to Infragistics XamDataGrid to build dynamic grids.
-
A PostgreSQL Interface for Gong Data using the CData ODBC Driver
Use the SQL Gateway and Gong ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Mistral AI Data in Power BI Report Server
Use the CData ODBC Driver for Mistral AI to visualize Mistral AI in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Jumpseller Data from MySQL in PHP
Connect to Jumpseller through the standard MySQL libraries in PHP.
-
Build Semantic Layer Views for Highrise Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Highrise CRM.
-
Integrate Live Insightly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Insightly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Data Flows from Greenplum to SQL Server using SSIS
Easily back up Pivotal GreenPlum to SQL Server using the SSIS components for Greenplum.
-
Create a Data Access Object for Cosmos DB Data using JDBI
A brief overview of creating a SQL Object API for Azure Cosmos DB in JDBI.
-
Create Exact Online-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Exact Online Data from OutSystems and build custom enterprise apps using live Exact Online.
-
How to create Azure Analysis Services federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Analysis Services in MySQL .
-
Prepare, Blend, and Analyze Onfleet Data in Alteryx Designer (ODBC)
Build workflows to access live Onfleet for self-service data analytics.
-
Visualize SAP Business One 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 SAP Business One into TIBCO Spotfire.
-
Query Live SAS Data Sets Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAS Data Sets directly from the development environment.
-
Automated Continuous LaunchDarkly Replication to MySQL
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to MySQL.
-
How to import Mouseflow Data into Apache Solr
Use the CData Software JDBC Driver for Mouseflow in Data Import Handler and create an automated import of Mouseflow to Apache Solr Enterprise Search platform.
-
Automated CapsuleCRM Data Replication to Teradata
Use CData Sync to Customize and automate CapsuleCRM replication to Teradata.
-
Deploy the ADO.NET Provider for Hubstaff on an SSRS Report Server
Connect to Hubstaff 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.
-
Build a Singer.io Tap for Google Forms With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Forms data using
-
Build Dashboards with Hive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Hive in Dundas BI.
-
How to Work with Customer.io Data in AWS Glue Jobs Using JDBC
Connect to Customer.io from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Box Data with Squirrel SQL client
Connect to Box and execute queries in the Squirrel SQL Client.
-
Integrate Cursor with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Vertica from within the editor.
-
Use Biml to Build SSIS Tasks to Replicate Facebook Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Facebook to SQL Server.
-
How to Access Live Quaderno Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Quaderno enables you to integrate Quaderno into workflows built using Microsoft Power Automate Desktop.
-
Viewing Hugging Face Data in RAD Studio Data Explorer
How to view Hugging Face in RAD Studio Data Explorer using the CData ODBC Driver for Hugging Face.
-
How to create Visio diagrams from Gmail Data
Automatically update Gmail with the changes you make to Visio master shapes.
-
How to Visualize IBM Cloud Object Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM Cloud Object Storage in Python.
-
Connect to Google Analytics from Asprova with CData Software ODBC Driver for Google Analytics
This article shows how to connect faster to Google Analytics data from Asprova.
-
Access SAP BusinessObjects BI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP BusinessObjects BI from your Oracle system.
-
How to integrate Mistral AI with Apache Airflow
Access and process Mistral AI in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Kintone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Kintone.
-
Query SingleStore Data in ColdFusion
Write standard ColdFusion data access code to connect to SingleStore.
-
Configure the CData JDBC Driver for REST in a Connection Pool in Tomcat
Connect to REST from a connection pool in Tomcat.
-
How to Connect to Live Google Campaign Manager 360 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Campaign Manager 360 securely in real time.
-
Analyze Salesloft Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesloft and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Creating Vault CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Veeva Vault & Vault CRM to Unqork and build custom business apps.
-
Connect to Live SurveyMonkey Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SurveyMonkey in CData Connect AI and connect to your SurveyMonkey from PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time CampaignMonitor Data
Use CData Power BI Connectors to visualize CampaignMonitor in Power BI.
-
Automate SQL Analysis Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SQL Analysis Services from PowerShell? This article demonstrates how to utilize the SQL Analysis Services Cmdlets for tasks like connecting to SQL Analysis Services, automating operations, downloading data, and more.
-
Build OData-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for OData to explore live OData Services in Cursor to assist with building OData-powered applications.
-
Connect to NetSuite SuiteAnalytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for NetSuite SuiteAnalytics Data and connect to NetSuite SuiteAnalytics in Akorbi Digital RunMyProcess.
-
Connect to Real-Time Access Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Access and Dataflow to import and use Microsoft Access in Power Apps.
-
Build Apps with Live Teradata Data Using the Low-Code Development Platform of Mendix
Connect Teradata with Mendix to build apps using the CData JDBC Driver for Teradata.
-
Integrate LibreChat with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Pivotal GreenPlum from within the chat interface.
-
Connect to Insightly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Insightly to connect to Insightly from Web applications running on WebLogic.
-
Automate Azure Analysis Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Analysis Services from PowerShell? This article demonstrates how to utilize the Azure Analysis Services Cmdlets for tasks like connecting to Azure Analysis Services, automating operations, downloading data, and more.
-
Use Microsoft Copilot Studio to talk to your Oracle 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 Oracle Database for you.
-
How to connect PolyBase to Jumpseller
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jumpseller.
-
Connect to ShipStation Data in DBeaver
Use the CData ODBC Driver to connect to ShipStation in DBeaver.
-
Integrating Antigravity CLI with MailerSend via CData CLI
Connect MailerSend to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Live Kintone Data in SAS Viya
Use CData Connect AI to connect to Kintone from SAS Viya and deploy self-service analytics using live Kintone.
-
How to load SuiteCRM data into Elasticsearch via Logstash
Introducing a simple method to load SuiteCRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to & Open Oracle Eloqua Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Eloqua to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query JotForm Data in DataGrip
Create a Data Source for JotForm in DataGrip and use SQL to query live JotForm.
-
Connect Greenplum to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pivotal GreenPlum using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy Web
Connect to Teradata in MicroStrategy Web using the CData Software ODBC Driver for Teradata.
-
Automated Continuous Shippo Replication to Vertica
Use CData Sync for automated, continuous, customizable Shippo replication to Vertica.
-
Automated Lakebase Data Replication to Teradata
Use CData Sync to Customize and automate Lakebase replication to Teradata.
-
Connect MarkLogic to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MarkLogic with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous SAP Hybris C4C Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Oracle.