CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for EnterpriseDB Data using the CData JDBC Driver
Use the Remoting features of the EnterpriseDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Unbounce Data in AWS Glue Jobs Using JDBC
Connect to Unbounce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Real-Time Mixpanel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mixpanel in Power Apps.
-
Create Float Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Float from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Toggl with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Toggl with External Services.
-
Query Nuclia Data in ColdFusion
Write standard ColdFusion data access code to connect to Nuclia.
-
Visualize Zoom Data in Sisense
Create an ElastiCube in Sisense app with access to Zoom.
-
Integrating Antigravity CLI with Simplesat via CData CLI
Connect Simplesat to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect the Power BI Service to GitLab: Complete Guide
Connect to the CData Software Power BI Connector for GitLab from PowerBI.com to provide real-time GitLab across the organization.
-
How to Access Google Ads Data Using Entity Framework
This article shows how to access Google Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Visualize ZohoInvoice Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoInvoice in Python.
-
DataBind Charts to SAP BusinessObjects BI Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP BusinessObjects BI 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.
-
Analyze SAS Data Sets Data in Cognos Analytics
Use CData Connect AI to connect to SAS Data Sets Data from Cognos Analytics and analyze live SAS Data Sets.
-
Import Stripe Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Stripe Data and provide access to live Stripe for custom reports in the Power BI Service.
-
Integrate Real-Time Access to LaunchDarkly in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to LaunchDarkly in real time.
-
Load Oracle Eloqua Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Eloqua to a database.
-
Bridge Trello Connectivity with Apache NiFi
Access and process Trello in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Trello Replication to SQL Server
Use CData Sync for automated, continuous, customizable Trello replication to SQL Server.
-
Use the CData Software ODBC Driver for Recurly in MicroStrategy Web
Connect to Recurly in MicroStrategy Web using the CData Software ODBC Driver for Recurly.
-
How to use SQLAlchemy ORM to access Freshservice Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshservice.
-
Integrate Asana with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Asana with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Asana.
-
Connect to PDFMonkey Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PDFMonkey and work with PDFMonkey in your FileMaker applications.
-
Use the CData SSIS Components to Insert New or Update Existing QuickBooks Records from SQL Server
Easily push SQL Server data to QuickBooks using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into QuickBooks or update existing records with data from a SQL Server database.
-
DataBind Controls to Gumroad Data in Delphi
DataBind to Gumroad in Delphi with standard data access components and controls.
-
Replicate Smartsheet Data in Heroku for Use in Salesforce Connect
Replicate Smartsheet to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Real-Time EmailOctopus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use EmailOctopus in ColdFusion.
-
How to import Teamgate Data into Apache Solr
Use the CData Software JDBC Driver for Teamgate in Data Import Handler and create an automated import of Teamgate to Apache Solr Enterprise Search platform.
-
Model, Search, and Visualize Live Asana Data in ThoughtSpot
Use CData Connect AI to connect to live Asana for modeling, searching, and visualizing.
-
How to Easily Query PingOne Data in OpenOffice Base
Connect to PingOne data in OpenOffice Base using the CData ODBC Driver for PingOne and generate reports with live data insights.
-
A PostgreSQL Interface for PolarTeamPro Data (MySQL Remoting via JDBC)
Use the Remoting features of the PolarTeamPro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Perplexity-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Perplexity Data in GitHub Copilot to assist with building Perplexity-powered applications.
-
DataBind Controls to HubSpot Data in C++Builder
DataBind to HubSpot in C++Builder with standard components and controls.
-
Automated Continuous Quaderno Replication to Oracle
Use CData Sync for automated, continuous, customizable Quaderno replication to Oracle.
-
Import and Visualize AfterShip Data in Power View
Create data visualizations based on AfterShip in Excel.
-
Natively Connect to WordPress Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WordPress. Leverage the native support for ODBC in PHP.
-
How to Easily Query Tickspot Data in OpenOffice Base
Connect to Tickspot data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate with Redshift Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon Redshift to a JSON file on disk.
-
Establish a Live Connection with ZohoSubscriptions Data using Tableau Bridge
The CData ODBC Driver for ZohoSubscriptions enables you to integrate live ZohoSubscriptions into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple Google Cloud Storage Accounts via the CData Sync CLI
Replicate multiple Google Cloud Storage accounts to one or many databases.
-
Create Data Visualizations Based On Google Analytics Data in Mode
Use CData Connect AI to connect to Google Analytics Data from Mode and build visualizations using live
-
Automated Continuous MailChimp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MailChimp replication to Amazon S3.
-
Automated Continuous AgileCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable AgileCRM replication to Oracle.
-
Integrating Codex CLI with Klipfolio 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.
-
Working with SAP SuccessFactors Data in LINQPad
Execute LINQ queries to SAP SuccessFactors in LINQPad.
-
How to Connect to & Open Reckon Data in Microsoft Excel
This article uses the CData ODBC driver for Reckon to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for Adobe Commerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Commerce in Excel.
-
Create Google Campaign Manager 360-Connected Applications in Appsmith
Connect to Google Campaign Manager 360 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Campaign Manager 360.
-
DataBind Controls to Epicor Kinetic Data in Delphi
DataBind to Epicor Kinetic in Delphi with standard data access components and controls.
-
How to Connect to Live BigQuery Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google BigQuery securely in real time.
-
How to connect to OpenWeatherMap Data from IntelliJ
Integrate connectivity to OpenWeatherMap with wizards in IntelliJ.
-
Connect to Short.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Short.io and the SQL Gateway to access Short.io from Google Apps Script.
-
How to Access Live Blackbaud FE NXT Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Blackbaud FE NXT enables you to integrate Blackbaud FE NXT into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Cvent in SAS for Real-Time Reporting and Analytics
Connect to real-time Cvent in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cvent.
-
Integrate SAP Ariba Procurement Data in the Pentaho Report Designer
Publish reports based on SAP Ariba Procurement in the Pentaho BI tool.
-
Visualize Live Oracle Sales Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Sales using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Typeform Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Typeform.
-
How to connect to Elasticsearch Data with Squirrel SQL client
Connect to Elasticsearch and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Python Connector for Perigon
Learn to install and license the CData Python Connector
-
Visualize Mode Data in TIBCO Spotfire through OData
Integrate Mode into dashboards in TIBCO Spotfire.
-
How to connect to Grafana Data in DBVisualizer
Integrate Grafana with visual data analysis tools and data connection wizards in DBVisualizer
-
Klaviyo Reporting in OBIEE with the Klaviyo JDBC Driver
Deploy the Klaviyo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Create Power BI Visual Reports with Real-Time Dotmailer Data
Use CData Power BI Connectors to visualize Dotmailer in Power BI.
-
Integrating LangChain with MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MySQL within automated workflows.
-
Use the CData Software JDBC Driver for ShipStation in MicroStrategy Web
Connect to ShipStation in MicroStrategy Web using the CData Software JDBC Driver for ShipStation.
-
How to Connect to Eventbrite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Eventbrite. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations Based On WooCommerce Data in Mode
Use CData Connect AI to connect to WooCommerce Data from Mode and build visualizations using live
-
Integrate with Live Pipedrive Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Pipedrive from the MuleSoft Anypoint Platform to integrate live Pipedrive into custom reports and dashboards.
-
Visualize Simplesat Data in Tableau
The CData ODBC driver for Simplesat enables you integrate Simplesat into Tableau dashboards.
-
How to Query Live Drift Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Drift data in natural language using Python.
-
Visualize Google Cloud Storage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Cloud Storage.
-
Visualize Short.io 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 Short.io into TIBCO Spotfire.
-
How to connect PolyBase to Email
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Email.
-
How to Access Live HubSpot Data in Visual Studio Code via Cline
Run CData MCP Server for HubSpot on Windows Subsytem for Linux (WSL) and connect to live HubSpot from the Cline extension in Visual Studio Code.
-
Integrate LibreChat with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Adobe Analytics from within the chat interface.
-
Use Agno to Talk to Your Jira 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 Atlassian Jira for you.
-
Create Data Visualizations in Cognos BI with Wrike Data
Access Wrike as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Mastra with Certinia Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Certinia, no replication required.
-
Analyze SAS Data Sets Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAS Data Sets in Microsoft R Open.
-
Connect Neo4J Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Neo4J using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Clockify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Clockify from HeidiSQL.
-
Integrate Theia IDE with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Process & Analyze Excel Online Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Excel Online Data.
-
Connect to Amazon Athena Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon Athena Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Voice Agents in ElevenLabs with access to Live AlloyDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google AlloyDB.
-
How to Connect to Live FTP Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your FTP Servers for you.
-
Analyze Live Twitter Ads Data in SAS Viya
Use CData Connect AI to connect to Twitter Ads from SAS Viya and deploy self-service analytics using live Twitter Ads.
-
Connect to Perplexity in SpagoBI
Create reports featuring live Perplexity in SpagoBI Studio. Host Perplexity reports on SpagoBI Server.
-
Integrating LangChain with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SurveyMonkey within automated workflows.
-
Build a Singer.io Tap for Cloudflare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudflare data using
-
Analyze Data in MicroStrategy Using the CData ODBC Driver for Dynamics CRM
In this article we show the use of CData ODBC Drivers with the MicroStrategy BI platform.
-
Import Shopify Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Shopify. In this article, you will use the OData format to import Shopify into Microsoft Power Query.
-
Automated Continuous Blackbaud FE NXT Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to IBM DB2.
-
Integrating ZarMoney Data in Talend Cloud Data Management Platform
Connect ZarMoney Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Sybase IQ Data in Coginiti Pro
Connect to and query live Sybase IQ from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize ActiveCampaign Data in TIBCO Spotfire through ADO.NET
Integrate ActiveCampaign into dashboards in TIBCO Spotfire.
-
Automate Mailgun Data Replication to Couchbase
Use CData Sync to Customize and automate Mailgun replication to Couchbase.
-
Access Live MarkLogic Data in AWS Lambda
Connect to live MarkLogic in AWS Lambda using the CData JDBC Driver.
-
Replicate Multiple MarkLogic Accounts via the CData Sync CLI
Replicate multiple MarkLogic accounts to one or many databases.
-
Build Vault CRM-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in Claude Code to assist with building Vault CRM-powered applications.
-
Build a Simple VCL Application for Dynamics 365 Data
How to build a simple VCL Application to view Microsoft Dynamics 365 in RAD Studio using the CData ODBC Driver for Dynamics 365.