CData Software - Knowledge Base
Recent Articles
-
Build Agents in Relevance AI with Access to Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Teams data within intelligent agent workflows.
-
Connect to Snowflake Data in Ruby
Connect to Snowflake data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Microsoft Dataverse Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Dataverse in FileMaker Pro to connect to Microsoft Dataverse and work with Microsoft Dataverse data in your FileMaker applications.
-
Visualize Oracle Eloqua Reporting Data in Tableau
The CData ODBC driver for Oracle Eloqua Reporting enables you integrate Oracle Eloqua Reporting data into Tableau dashboards.
-
Build Semantic Layer Views for Excel Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Excel Online data.
-
Integrating Codex with Brex 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.
-
Integrate SageHR Data in Pentaho Data Integration
Build ETL pipelines based on SageHR data in the Pentaho Data Integration tool.
-
Access Live Google Calendar Data in TIBCO Data Virtualization
Use the Google Calendar Tibco DV Adapter to create a Google Calendar data data source in TIBCO Data Virtualization Studio and gain access to live Google Calendar data from your TDV Server.
-
Model Basecamp Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Basecamp, enabling the direct import of real-time Basecamp data.
-
Create Informatica Mappings From/To an ODBC Data Source for iContact
Create an ODBC connection to iContact in Informatica and browse and transfer iContact data.
-
Automated PostgreSQL Data Replication to Teradata
Use CData Sync to Customize and automate PostgreSQL data replication to Teradata.
-
Create Dashboards and Visualize Live SendPulse Data in Geckoboard
Use CData Connect AI to connect to live SendPulse data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect ScrapingBee to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ScrapingBee data using the CData Python MCP Server.
-
Connect to Demio Data in JRuby
Create a simple JRuby app with access to live Demio data.
-
Getting Started with the CData SSIS Components for Salesloft
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesloft.
-
Create Factorial Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Factorial from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Postmark in MicroStrategy
Connect to Postmark data in MicroStrategy Developer using the CData Software ODBC Driver for Postmark.
-
Create Sage Intacct-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage Intacct Data from OutSystems and build custom enterprise apps using live Sage Intacct data.
-
Create a Data Access Object for Pipeline CRM Data using JDBI
A brief overview of creating a SQL Object API for Pipeline CRM data in JDBI.
-
Analyze Gorgias Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gorgias data in Microsoft R Open.
-
Build Semantic Layer Views for BigQuery Data in APOS Live Data Gateway
Use the CData Connector for BigQuery in APOS Live Data Gateway to build Semantic Layer Views for BigQuery data.
-
Integrate Chargebee Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Chargebee data from Informatica Cloud.
-
Getting Started with the CData Connect AI Python SDK for PostgreSQL
Install the CData Connect AI Python SDK to read and write live PostgreSQL data with standard DB-API 2.0 Python code.
-
Create Phoenix-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Phoenix Data from OutSystems and build custom enterprise apps using live Phoenix data.
-
Access ZeroBounce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZeroBounce data from HeidiSQL.
-
Add Google Spanner Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Spanner with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData JDBC Driver for SharePoint
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SharePoint.
-
Moving Data from Acumatica to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Acumatica data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to use SQLAlchemy ORM to access SAP HANA Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP HANA data.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy Desktop
Connect to Notion data in MicroStrategy Desktop using the CData Software ODBC Driver for Notion.
-
Query Guru Data as a SQL Server Database in Node.js
Execute SQL Server queries against Guru data from Node.js.
-
Connect to Pipedrive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Pipedrive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate with Gorgias Data in JReport Designer
Create charts and reports based on Gorgias data in JReport Designer.
-
Connect to AfterShip Data from HeidiSQL
Use CData Connect AI to connect to and query live AfterShip data from HeidiSQL.
-
Publish Azure Synapse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Synapse data.
-
Replicate GitHub Data to Multiple Databases via the CData Sync CLI
Replicate GitHub data to disparate databases with a single configuration.
-
Integrate LibreChat with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Exact Online data from within the chat interface.
-
How to connect and process Microsoft OneDrive data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft OneDrive data.
-
Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Desktop
Connect to Facebook Ads data in MicroStrategy Desktop using the CData Software JDBC Driver for Facebook Ads.
-
Configure the CData JDBC Driver for Gmail in a Connection Pool in Tomcat
Connect to Gmail data from a connection pool in Tomcat.
-
Getting Started with the CData JDBC Driver for Salesforce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce.
-
Integrating Boomi Agentstudio with Neo4J Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Neo4J data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with HBase Data in ETL Validator JDBC
Connect to HBase from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to ServiceNow Data from IntelliJ
Integrate connectivity to ServiceNow data with wizards in IntelliJ.
-
Add Clio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Prepare, Blend, and Analyze Microsoft Dataverse Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dataverse data for self-service data analytics.
-
Publish Reports with Zendesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zendesk data.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data through natural language.
-
Integrate Quickbase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Quickbase data from Informatica Cloud.
-
A PostgreSQL Interface for Toggl Data using the CData ODBC Driver
Use the SQL Gateway and Toggl ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Webflow Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Webflow data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Miro Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Miro data replication to OneLake in Microsoft Fabric.
-
Connect to Oracle Sales Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Sales data from Crystal Reports.
-
Analyze Oracle Sales Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Sales data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Printful Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Printful data.
-
How to Create Power BI Visual Reports with Real-Time Helpscout Data
Use CData Power BI Connectors to visualize Helpscout data in Power BI.
-
Connect to Sage Intacct Data in DBArtisan
Use wizards in DBArtisan to configure Sage Intacct data as a data source.
-
Automated Continuous Clockify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Clockify replication to SingleStore.
-
Getting Started with the CData ODBC Driver for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Data Lake Storage.
-
Choosing the Best Method to Connect Google Tasks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Tasks data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish FTP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FTP data.
-
Automate Outlook Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Outlook data from PowerShell? This article demonstrates how to utilize the Outlook Cmdlets for tasks like connecting to Outlook data, automating operations, downloading data, and more.
-
Create ConvertAPI Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ConvertAPI from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Simple VCL Application for FormSite Data
How to build a simple VCL Application to view FormSite data in RAD Studio using the CData ODBC Driver for FormSite.
-
Feed SendGrid Data into FineReport
How to set SendGrid data as a JDBC data source in FineReport.
-
Access Live SAP SuccessFactors Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP SuccessFactors data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP SuccessFactors data in the Graph Builder and Query Builder.
-
Automated Continuous GetResponse Replication to SingleStore
Use CData Sync for automated, continuous, customizable GetResponse replication to SingleStore.
-
Use the CData Software ODBC Driver for Bullhorn CRM in MicroStrategy
Connect to Bullhorn CRM data in MicroStrategy Developer using the CData Software ODBC Driver for Bullhorn CRM.
-
How to integrate Figshare with Apache Airflow
Access and process Figshare data in Apache Airflow using the CData JDBC Driver.
-
Visualize Tanda 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 Tanda data into TIBCO Spotfire.
-
Connect to Amazon Marketplace Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Marketplace data in Airbyte.
-
Automated Continuous Coinbase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Coinbase data replication to OneLake in Microsoft Fabric.
-
Automated Continuous PDFMonkey Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Amazon Redshift.
-
Create Datasets from Reckon in Domo Workbench and Build Visualizations of Reckon Data in Domo
Use the CData Software ODBC Driver for Reckon to create datasets from Reckon data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to & Open SAP Data in Microsoft Excel
This article uses the CData ODBC driver for SAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connecting Agentforce with Microsoft Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Ads data for you.
-
Integrate Keap Data in Pentaho Data Integration
Build ETL pipelines based on Keap data in the Pentaho Data Integration tool.
-
Establish a Live Connection with Zoho Projects Data using Tableau Bridge
The CData ODBC Driver for Zoho Projects enables you to integrate live Zoho Projects data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect SharePoint with LDAP Objects through external lists
Provide LDAP objects to SharePoint users as an external list.
-
Connect to Bitbucket from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Bitbucket data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Klipfolio Data in TIBCO Spotfire through ADO.NET
Integrate Klipfolio data into dashboards in TIBCO Spotfire.
-
Process & Analyze SingleStore Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SingleStore Data.
-
Create Dashboards and Visualize Live JSON Services in Geckoboard
Use CData Connect AI to connect to live JSON services and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Azure Data Lake Storage 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 Azure Data Lake Storage data through MCP integration.
-
Integrating Claude Code CLI with YouTube Analytics 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.
-
Establish a Live Connection with LinkedIn Ads Data using Tableau Bridge
The CData ODBC Driver for LinkedIn Ads enables you to integrate live LinkedIn Ads data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Excel Add-In for Mixpanel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mixpanel.
-
How to Connect DBeaver to Klipfolio via a JDBC Driver
Manage Klipfolio data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for ConvertKit in MicroStrategy Desktop
Connect to ConvertKit data in MicroStrategy Desktop using the CData Software ODBC Driver for ConvertKit.
-
Create TaxJar-Connected Applications in Appsmith
Connect to TaxJar Data via CData Connect AI in Appsmith and create custom business applications with real-time access to TaxJar data.
-
Query Slack Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Slack entities in PHP by modeling them as objects.
-
Viewing NASA Data in RAD Studio Data Explorer
How to view NASA data in RAD Studio Data Explorer using the CData ODBC Driver for NASA.
-
Connect to SQL Analysis Services Data in Aqua Data Studio
Access SQL Analysis Services data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Sugar CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Sugar CRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sugar CRM.
-
Interact with Live Printify Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Printify data.
-
Integrating Gumloop with SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAS Data Sets data within automated workflows.
-
Create HubDB-Connected Nintex Workflows
Use CData Connect AI to connect to HubDB Data from Nintex Workflow Cloud and build custom workflows using live HubDB data.
-
Publish Crystal Reports on Azure Data Lake Storage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Data Lake Storage data.
-
Automated Continuous ConvertAPI Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ConvertAPI data replication to OneLake in Microsoft Fabric.
-
Connect to Nethunt Data in JRuby
Create a simple JRuby app with access to live Nethunt data.