CData Software - Knowledge Base
Recent Articles
-
Build Google Directory-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Google Directory data without replication.
-
Integrate Devin with Live Basecamp Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Basecamp data.
-
Build Agents in Relevance AI with Access to Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Perplexity data within intelligent agent workflows.
-
How to Easily Query Spark Data in OpenOffice Base
Connect to Spark data in OpenOffice Base using the CData ODBC Driver for Spark and generate reports with live data insights.
-
Connect to GetResponse Data in HULFT Integrate
Connect to GetResponse as a JDBC data source in HULFT Integrate
-
Access HelloSign Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HelloSign data from HeidiSQL.
-
How to Access Live ZeroBounce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZeroBounce enables you to integrate ZeroBounce data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Azure Analysis Services from Asprova with CData Software ODBC Driver for Azure Analysis Services
This article shows how to connect faster to Azure Analysis Services data from Asprova.
-
Build Automated ShipStation-Connected Workflows in Zapier
Use CData Connect AI to connect to live ShipStation data and build automated workflows in Zapier.
-
Access Nethunt Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Nethunt data from your Oracle system.
-
Connect to and Query ConstantContact Data in QlikView over ODBC
Create data visualizations with ConstantContact data in QlikView.
-
Bidirectional Access to Email Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Email data in Filemaker Pro for Mac or Windows.
-
How to update Databricks from Excel
This article explains how to transfer data from Excel to Databricks using the Excel Add-In for Databricks.
-
Publish Exa-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Exa data.
-
Automated Continuous SingleStore Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SingleStore replication to AlloyDB.
-
Use the CData Software ODBC Driver for Google Directory in MicroStrategy Web
Connect to Google Directory data in MicroStrategy Web using the CData Software ODBC Driver for Google Directory.
-
Connect to Zoom Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zoom data.
-
Connect to WordPress Data in DBArtisan
Use wizards in DBArtisan to configure WordPress data as a data source.
-
Work with Live Google Spanner Data in Power Query
Use CData Connect AI to connect to Google Spanner data and work with live Google Spanner data in Microsoft Power Query.
-
Work with Discourse Data in FoxPro
Load Discourse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Pipelines with Live SAP Fieldglass Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Fieldglass from Google Cloud Data Fusion, enabling the integration of live SAP Fieldglass data into the building and management of effective data pipelines.
-
Connect Go Applications to Web APIs Using net/http and CData API Server
Learn how to connect Go applications to datasource by exposing tables as REST APIs with CData API Server.
-
How to connect to Mocean Data in DBVisualizer
Integrate Mocean data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect WooCommerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect WooCommerce with IBM WebSphere for seamless data integration and connectivity.
-
Edit and Search External LDAP Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of LDAP objects to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create LDAP Objects objects that you can access from apps and the dashboard.
-
Use Claude to Talk to Your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Couchbase data for you.
-
Use the CData Software ODBC Driver for Cassandra in MicroStrategy
Connect to Cassandra data in MicroStrategy Developer using the CData Software ODBC Driver for Cassandra.
-
Access Postmark Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Postmark data from your Oracle system.
-
Automated OData Services Replication to Teradata
Use CData Sync to Customize and automate OData services replication to Teradata.
-
How to Connect to Live Salesloft Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Salesloft data for you.
-
Connect to Google Ad Manager Data in JRuby
Create a simple JRuby app with access to live Google Ad Manager data.
-
Connect to HCL Domino Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HCL Domino data in Airbyte.
-
How to create an RPA flow for Instantly Data in UiPath Studio
Use the Instantly ODBC Driver to create workflows that access real-time Instantly data without any coding.
-
Getting Started with the CData Python Connector for SAP SuccessFactors LMS
Learn to install and license the CData Python Connector and configure a connection to live SAP SuccessFactors LMS data.
-
Integrating Cursor with Microsoft 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.
-
LINQ to Smartsheet 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 Smartsheet Data Provider.
-
Build Data Flows from SQL Server to Sybase IQ through SSIS
Easily push SQL Server data to Sybase IQ using the CData SSIS Tasks for Sybase IQ.
-
Access Live Spark 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 Spark data through MCP integration.
-
Getting Started with the CData SSIS Components for SAP HANA
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP HANA.
-
Automated OnePageCrm Data Replication to Teradata
Use CData Sync to Customize and automate OnePageCrm data replication to Teradata.
-
Establish a Live Connection with Smartsheet Data using Tableau Bridge
The CData ODBC Driver for Smartsheet enables you to integrate live Smartsheet data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build an OLAP Cube in SSAS from Miro Data
Establish a connection to Miro data data from SQL Server Analysis Services, and use the Miro Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with Sybase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sybase data in SnapLogic.
-
Automate JSON Services Replication to Couchbase
Use CData Sync to Customize and automate JSON services replication to Couchbase.
-
Connect to LeadDesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LeadDesk data.
-
Automated Continuous HelloSign Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HelloSign replication to Amazon Redshift.
-
Add PostgreSQL Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PostgreSQL with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to publish and share MessageBird Data dashboards with Tableau Server
The CData ODBC driver for MessageBird enables you integrate MessageBird data into Tableau dashboards.
-
Use the CData Software JDBC Driver for Contentful in MicroStrategy
Connect to Contentful data in MicroStrategy Developer using the CData Software JDBC Driver for Contentful.
-
Query Amazon Marketplace Data in DataGrip
Create a Data Source for Amazon Marketplace in DataGrip and use SQL to query live Amazon Marketplace data.
-
Build Bannerbear Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Bannerbear data and build visualizations in Tableau.
-
Connect to SAS xpt Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAS xpt and the SQL Gateway to access SAS xpt data from Google Apps Script.
-
Create Dashboards and Visualize Live Vertica Data in Geckoboard
Use CData Connect AI to connect to live Vertica data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Wistia Data in RazorSQL
Connect to Wistia from wizards and query Wistia data from the GUI in the RazorSQL database management tool.
-
Integrating GitHub Copilot with Stack Exchange 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.
-
Create Datasets from Epicor Kinetic in Domo Workbench and Build Visualizations of Epicor Kinetic Data in Domo
Use the CData Software ODBC Driver for Epicor Kinetic to create datasets from Epicor Kinetic data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to EnterpriseDB Data from AWS Glue
Use CData Connect AI to gain access to live EnterpriseDB data from your AWS Glue jobs.
-
Analyze Spark Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Spark data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Live Sage 200 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sage 200 data securely in real time.
-
Easily Integrate Pingdom Data in Lazarus Pascal IDE
Learn how to easily integrate live Pingdom data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Raisers Edge NXT Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Raisers Edge NXT data in Airbyte.
-
Analyze GraphQL Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of GraphQL data and visualize GraphQL data in SAP Analytics Cloud.
-
Use Claude to Talk to Your Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho Books data for you.
-
Bidirectional Access to Zendesk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zendesk data in Filemaker Pro for Mac or Windows.
-
Connect to Google Calendar Data in RapidMiner
Integrate Google Calendar data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Jira Data in Looker
Use CData Connect AI to connect to Jira Data from Looker and build custom apps using live Jira data.
-
Publish GitLab-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GitLab data.
-
Connect to Everhour Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Everhour data.
-
Replicate Omnisend Data in Heroku for Use in Salesforce Connect
Replicate Omnisend data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Live Jira Data in the Power BI Service
Use CData Connect AI to connect to live Jira data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create an RPA flow for Lakebase Data in UiPath Studio
Use the Lakebase ODBC Driver to create workflows that access real-time Lakebase data without any coding.
-
Create Data Visualizations Based On MailChimp Data in Mode
Use CData Connect AI to connect to MailChimp Data from Mode and build visualizations using live MailChimp data.
-
Migrating data from Missive to Google BigQuery using CData SSIS Components.
Easily push Missive data to Google BigQuery using the CData SSIS Tasks for Missive and Google BigQuery.
-
Use JayDeBeApi to access Dynamics 365 Data in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics 365 data.
-
Build Automated SAP Hybris C4C-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Hybris C4C data and build automated workflows in Zapier.
-
How to Access Live Email Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Email enables you to integrate Email data into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for JotForm in PyCharm
Connect to JotForm as an ODBC data source in PyCharm using the CData Software ODBC Driver for JotForm.
-
Automated Continuous Azure DevOps Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure DevOps replication to SQLite.
-
Query Azure Data Catalog Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Data Catalog entities in PHP by modeling them as objects.
-
Automated Continuous SAP Ariba Procurement Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to SQL Server.
-
Use the CData Software ODBC Driver for Active Directory in MicroStrategy Desktop
Connect to Active Directory data in MicroStrategy Desktop using the CData Software ODBC Driver for Active Directory.
-
Connect to Outlook Data in RazorSQL
Connect to Outlook from wizards and query Outlook data from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Coda in MicroStrategy Web
Connect to Coda data in MicroStrategy Web using the CData Software ODBC Driver for Coda.
-
Publish Salesforce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce data.
-
Query Amazon S3 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon S3 entities in PHP by modeling them as objects.
-
Create xBase-Connected Applications in Appsmith
Connect to xBase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to xBase data.
-
How to use SQLAlchemy ORM to access Cvent Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Cvent data.
-
Migrating data from Shopify to Snowflake using CData SSIS Components.
Easily push Shopify data to Snowflake using the CData SSIS Tasks for Shopify and Snowflake.
-
Build a Singer.io Tap for HubSpot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HubSpot data using the CData Python Connector.
-
Extract, Transform, and Load Klipfolio Data in Informatica PowerCenter
Create a simple Workflow for Klipfolio data in Informatica PowerCenter.
-
Import Oracle Financials Cloud Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Financials Cloud Data and provide access to live Oracle Financials Cloud data for custom reports in the Power BI Service.
-
How to connect to Epicor Kinetic Data from Spring Boot
Connect to Epicor Kinetic in a Spring Boot Application using the CData JDBC Driver for Epicor Kinetic
-
Build Dashboards with Greenhouse Data in Dundas BI
Create dynamic dashboards and perform analytics based on Greenhouse data in Dundas BI.
-
Automated Continuous EmailOctopus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Azure SQL Database.
-
Create Reckon Accounts Hosted-Connected Business Apps in AppSheet
Connect to Reckon Accounts Hosted Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Reckon Accounts Hosted data.
-
Validate Clio Data with QuerySurge
Access and validate Clio data in QuerySurge using the CData JDBC Driver.
-
Rapidly Develop Insightly-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 Insightly.
-
Connect to Live Google Forms Data in MicroStrategy through CData Connect AI
Create a live connection to Google Forms Data in CData Connect AI and connect to your Google Forms data from MicroStrategy.
-
Viewing WooCommerce Data in RAD Studio Data Explorer
How to view WooCommerce data in RAD Studio Data Explorer using the CData ODBC Driver for WooCommerce.
-
Getting Started with the CData SSIS Components for Unbounce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Unbounce.