CData Software - Knowledge Base
Recent Articles
-
Access Live Elasticsearch Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Elasticsearch data from your Excel spreadsheets.
-
Analyze SAS Data Sets Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAS Data Sets data and visualize SAS Data Sets data in SAP Analytics Cloud.
-
Edit and Search External Jira Assets Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Jira Assets data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Jira Assets Data objects that you can access from apps and the dashboard.
-
Connecting to MongoDB Atlas with MongoDB Drivers
Connect to a MongoDB Atlas instance using any CData Software Driver for MongoDB.
-
Connect to Suadeo Data in Ruby
Connect to Suadeo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Slack-Connected Apps in Choreo
Use CData Connect AI to connect to Slack Data from Choreo and build custom apps using live Slack data.
-
Use the CData Software JDBC Driver for OpenWeatherMap in MicroStrategy Desktop
Connect to OpenWeatherMap data in MicroStrategy Desktop using the CData Software JDBC Driver for OpenWeatherMap.
-
Connect to Zendesk Data from PowerBuilder via JDBC
This article demonstrates how to access Zendesk data from PowerBuilder using the Zendesk JDBC Driver.
-
How to Easily Query Bugsnag Data in OpenOffice Base
Connect to Bugsnag data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect the Power BI Service to Strava: Complete Guide
Connect to the CData Software Power BI Connector for Strava from PowerBI.com to provide real-time Strava data across the organization.
-
Load SAP Ariba Procurement Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Ariba Procurement data to a database.
-
Provide OData Services of SAP SuccessFactors LMS Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP SuccessFactors LMS data by developing a WCF Service Application.
-
Rapidly Develop PostgreSQL-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 PostgreSQL.
-
Replicate Gong Data from PowerShell
Write a quick PowerShell script to query Gong data. Use connectivity to the live data to replicate Gong data to SQL Server.
-
Getting Started with the CData ODBC Driver for ShipStation
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ShipStation.
-
Connect to HubSpot Data in HULFT Integrate
Connect to HubSpot as a JDBC data source in HULFT Integrate
-
Integrating Claude Code with Egnyte Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Egnyte data within assisted coding and automated development workflows.
-
How to Visualize ServiceDesk Plus Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live ServiceDesk Plus data in Python.
-
Bridge QuickBooks Connectivity with Apache NiFi
Access and process QuickBooks data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for Printify
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Printify.
-
Connect Clari Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Clari data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Microsoft Dataverse Data to Multiple Databases
Replicate Microsoft Dataverse data to disparate databases with a point-and-click configuration.
-
Create Dynamic Gumroad Grids Using the Infragistics XamDataGrid
Learn how you can connect Gumroad to Infragistics XamDataGrid to build dynamic grids.
-
Connect to SAP Hybris C4C Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C data and execute queries in PowerBuilder.
-
How to Connect to Live MYOB AccountRight 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 MYOB AccountRight data through natural language.
-
Connect to Coda Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Coda as an External Source in Dremio.
-
Integrating Gumloop with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Marketing data within automated workflows.
-
Getting Started with the CData ODBC Driver for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZohoPeople.
-
Create Data Visualizations in Cognos BI with Datadog Data
Access Datadog data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze QuickBooks Time Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Time data with the CData JDBC Driver for QuickBooks Time.
-
SAS xpt Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAS xpt data through CData Connect AI using different applications and tools.
-
Connect to Instantly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instantly to connect to Instantly data and execute queries in PowerBuilder.
-
Access Live SendInBlue Data in Coginiti Pro
Connect to and query live SendInBlue data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Microsoft Copilot Studio to talk to your Google Search Results 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 Google Search results for you.
-
Integrating Kiro with Amplitude 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 with Optimizely Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Optimizely data to a JSON file on disk.
-
How to connect to Jodoo Data from IntelliJ
Integrate connectivity to Jodoo data with wizards in IntelliJ.
-
Connect to Shortcut 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 Shortcut data.
-
Integrate OpenCode with Live Neo4J Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Neo4J data from within your AI coding agent.
-
Getting Started with the CData Excel Add-In for Asana
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Asana.
-
Analyze ZohoPeople Data in Looker
Use CData Connect AI to connect to ZohoPeople Data from Looker and build custom apps using live ZohoPeople data.
-
Connect to Egnyte Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Egnyte data from Filemaker Pro on Mac.
-
Deploy the ADO.NET Provider for SAP HANA on an SSRS Report Server
Connect to SAP HANA 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.
-
Publish Crystal Reports on Amazon S3 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon S3 data.
-
Connect to Act-On Data from a Connection Pool in Jetty
The Act-On JDBC Driver supports connection pooling: This article shows how to connect faster to Act-On data from Web apps in Jetty.
-
Getting Started with the CData Power BI Connector for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Egnyte Replication to Oracle
Use CData Sync for automated, continuous, customizable Egnyte replication to Oracle.
-
Use the CData ODBC Driver for Microsoft Ads in Microsoft Power Query
You can use the CData Microsoft Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Ads data into Microsoft Power Query.
-
Connect to Cvent from Asprova with CData Software ODBC Driver for Cvent
This article shows how to connect faster to Cvent data from Asprova.
-
Access Hive Data from MySQL in Amazon QuickSight
Connect to Hive and build visualizations of Hive data using a MySQL Connection in Amazon QuickSight.
-
Connect and Query Live Klipfolio Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Klipfolio data into Databricks and enable direct, live querying and analysis without replication.
-
Analyze Office 365 Data in Looker
Use CData Connect AI to connect to Office 365 Data from Looker and build custom apps using live Office 365 data.
-
Extract, Transform, and Load Insightly Data in Informatica PowerCenter
Create a simple Workflow for Insightly data in Informatica PowerCenter.
-
Connect to Live Shippo Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Shippo in CData Connect AI and connect to your Shippo data from PostgreSQL.
-
How to create Browserless federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Browserless data in MySQL .
-
How to Connect to Live SAS Data Sets 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 SAS Data Sets data through natural language.
-
Connect to Stripe Data from PowerBuilder via JDBC
This article demonstrates how to access Stripe data from PowerBuilder using the Stripe JDBC Driver.
-
How to Connect DBeaver to ServiceNow via a JDBC Driver
Manage ServiceNow data with visual tools in DBeaver like the query browser.
-
How to Easily Query Insightly Data in OpenOffice Base
Connect to Insightly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Analyze Google Spanner Data in Cognos Analytics
Use CData Connect AI to connect to Google Spanner Data from Cognos Analytics and analyze live Google Spanner data.
-
Build a PostgreSQL Interface for Sage Cloud Accounting Data using the CData JDBC Driver
Use the Remoting features of the Sage Cloud Accounting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for SageHR in MicroStrategy Web
Connect to SageHR data in MicroStrategy Web using the CData Software JDBC Driver for SageHR.
-
Integrate Act CRM Data in Pentaho Data Integration
Build ETL pipelines based on Act CRM data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Helpscout Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Helpscout data.
-
Analyze Opsgenie Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Opsgenie data with the CData JDBC Driver for Opsgenie.
-
How to Create Power BI Visual Reports with Real-Time Box Data
Use CData Power BI Connectors to visualize Box data in Power BI.
-
Getting Started with the CData JDBC Driver for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Twitter Ads.
-
Connect to Dynamics 365 Data in Aqua Data Studio
Access Dynamics 365 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Recurly Data from MySQL in Amazon QuickSight
Connect to Recurly and build visualizations of Recurly data using a MySQL Connection in Amazon QuickSight.
-
How to Connect to Typeform Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Typeform data. Leverage the pyodbc module for ODBC in Python.
-
Build Semantic Layer Views for Mailgun Data in APOS Live Data Gateway
Use the CData Connector for Mailgun in APOS Live Data Gateway to build Semantic Layer Views for Mailgun data.
-
Automate IBM Informix Data Replication to SAP HANA
Use CData Sync to customize and automate IBM Informix data replication to SAP HANA.
-
Use Claude to Talk to Your Pinterest 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 Pinterest data for you.
-
Build QuickBooks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for QuickBooks Data and create custom apps in Bubble.
-
Access Shortcut Data from MySQL in Amazon QuickSight
Connect to Shortcut and build visualizations of Shortcut data using a MySQL Connection in Amazon QuickSight.
-
Build a PostgreSQL Interface for JobNimbus Data using the CData JDBC Driver
Use the Remoting features of the JobNimbus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Dynamics NAV in SAS for Real-Time Reporting and Analytics
Connect to real-time Dynamics NAV data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics NAV.
-
Establish a Live Connection with Excel Online Data using Tableau Bridge
The CData ODBC Driver for Excel Online enables you to integrate live Excel Online data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy
Connect to Hive data in MicroStrategy Developer using the CData Software JDBC Driver for Hive.
-
Integrate Salesforce Data 360 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce Data 360 data and integrate live Salesforce Data 360 data into your Power Automate tasks.
-
Using Mail Merge with Salesforce, SharePoint, or Google Contacts
The CData ODBC Drivers can be used from tools like Mail Merge in Microsoft Word to access live data from various sources (QuickBooks, Salesforce, SharePoint etc.). This article uses the CData ODBC Driver for Salesforce with Mail Merge, but this procedure can be follwoed for other CData ODBC drivers.
-
Automated Continuous Superchat Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Superchat replication to IBM DB2.
-
Analyze Redshift Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Redshift data and visualize Redshift data in SAP Analytics Cloud.
-
Analyze Invoiced Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Invoiced data with the CData JDBC Driver for Invoiced.
-
Connect to RSS Feeds in Google Apps Script via SQL Gateway
Use the ODBC Driver for RSS and the SQL Gateway to access RSS feeds from Google Apps Script.
-
Build Visualizations of Recurly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Recurly data in Birst.
-
Automated Continuous Mixpanel Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mixpanel replication to Snowflake.
-
Using the CData Software ODBC Driver for Elorus in PyCharm
Connect to Elorus as an ODBC data source in PyCharm using the CData Software ODBC Driver for Elorus.
-
DataBind Charts to SFTP Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SFTP data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Kafka Replication to Vertica
Use CData Sync for automated, continuous, customizable Kafka replication to Vertica.
-
Use the CData Software ODBC Driver for EmailOctopus in MicroStrategy
Connect to EmailOctopus data in MicroStrategy Developer using the CData Software ODBC Driver for EmailOctopus.
-
Use CData Connect AI to Access Exa Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Exa data in the Power Pivot business intelligence tool.
-
How to Seamlessly Import FTP Data into IBM SPSS Modeler
Integrate FTP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Shopify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shopify replication to MongoDB.
-
Automated Continuous Reckon Accounts Hosted Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQL Server.
-
Connect to GetResponse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GetResponse data.
-
Access Recurly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Recurly data from your Oracle system.
-
Integrating Antigravity CLI with OData services via CData CLI
Connect OData services to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Microsoft Planner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Planner data from Informatica Cloud.
-
How to create an RPA flow for SQL Server Data in UiPath Studio
Use the SQL Server ODBC Driver to create workflows that access real-time SQL Server data without any coding.