CData Software - Knowledge Base
Recent Articles
-
Build Google Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Analytics and build visualizations in Tableau.
-
How to Connect to Live Splunk Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Splunk for you.
-
A PostgreSQL Interface for Oracle Service Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Service Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Superchat Data with Squirrel SQL client
Connect to Superchat and execute queries in the Squirrel SQL Client.
-
Connect to CSV Data in Aqua Data Studio
Access CSV/TSV Files from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Google Sheets Data from MySQL in Amazon QuickSight
Connect to Google Sheets and build visualizations of Google Sheets using a MySQL Connection in Amazon QuickSight.
-
Integrate with WooCommerce Data in SnapLogic
Use CData Connect AI to connect to and integrate with live WooCommerce in SnapLogic.
-
Visualize Live Trello Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Trello using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live WooCommerce Data in Excel 365 Online (Excel for the web)
Connect to WooCommerce from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Migrating data from Discord to Snowflake using CData SSIS Components.
Easily push Discord to Snowflake using the CData SSIS Tasks for Discord and Snowflake.
-
Write a Simple Go Application to work with Simplesat Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Simplesat.
-
DataBind Controls to Zoho Books Data in Delphi
DataBind to Zoho Books in Delphi with standard data access components and controls.
-
Write a Simple Go Application to work with Twilio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Twilio.
-
Visualize Live Lakebase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Lakebase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to integrate Google Cloud Storage with Apache Airflow
Access and process Google Cloud Storage in Apache Airflow using the CData JDBC Driver.
-
Connect to Google Analytics Data in Ruby
Connect to Google Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Stripe Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Stripe from HeidiSQL.
-
Use the CData ODBC Driver for SAP Concur from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Concur to connect to SAP Concur from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Concur in Excel.
-
Integrate Live Apollo Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build AI Agents with Microsoft Teams Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft Teams through CData Connect AI.
-
Access Teamgate Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teamgate from your Oracle system.
-
Use the CData Software ODBC Driver for Amplitude in MicroStrategy Desktop
Connect to Amplitude in MicroStrategy Desktop using the CData Software ODBC Driver for Amplitude.
-
Visualize Templated 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 Templated into TIBCO Spotfire.
-
How to Work with Onfleet Data in AWS Glue Jobs Using JDBC
Connect to Onfleet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ADO.NET Provider for Webflow
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Accelo Data in Aqua Data Studio
Access Accelo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy Web
Connect to Sugar CRM in MicroStrategy Web using the CData Software JDBC Driver for Sugar CRM.
-
Build Automated Google Search-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Search and build automated workflows in Zapier.
-
Analyze Postmark Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Postmark in Microsoft R Open.
-
Connect to Paddle Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze ScrapingBee Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ScrapingBee in Microsoft R Open.
-
How to create Visio diagrams from SAS Data Sets Data
Automatically update SAS Data Sets with the changes you make to Visio master shapes.
-
Access Live Planio Data in Coginiti Pro
Connect to and query live Planio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Webex in MicroStrategy Web
Connect to Webex in MicroStrategy Web using the CData Software ODBC Driver for Webex.
-
Integrate with MarkLogic Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MarkLogic to a JSON file on disk.
-
How to connect and process Webflow from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Webflow.
-
Use the CData SSIS Components to Insert New or Update Existing Paylocity Records from SQL Server
Easily push SQL Server data to Paylocity using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Paylocity or update existing records with data from a SQL Server database.
-
Bridge Klaviyo Connectivity with Apache NiFi
Access and process Klaviyo in Apache NiFi using the CData JDBC Driver.
-
Access Adobe Commerce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Adobe Commerce from HeidiSQL.
-
Migrating data from Salesforce CRM Analytics to Snowflake using CData SSIS Components.
Easily push Salesforce CRM Analytics to Snowflake using the CData SSIS Tasks for Salesforce CRM Analytics and Snowflake.
-
Connect to Placid Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Placid and work with Placid in your FileMaker application.
-
Getting Started with the CData ODBC Driver for Dotmailer
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dotmailer.
-
Working with EmailOctopus Data in LINQPad
Execute LINQ queries to EmailOctopus in LINQPad.
-
Analyze Stripe Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Stripe in Microsoft R Open.
-
Query EnterpriseDB Data in ColdFusion
Write standard ColdFusion data access code to connect to EnterpriseDB.
-
Integrating GitHub Copilot CLI with Suadeo 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.
-
Migrating data from Sybase to Databricks using CData SSIS Components.
Easily push Sybase to Databricks using the CData SSIS Tasks for Sybase and Databricks.
-
Establish a Live Connection with QuickBooks Time Data using Tableau Bridge
The CData ODBC Driver for QuickBooks Time enables you to integrate live QuickBooks Time into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Impala Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Impala from Power Pivot. You will use the Table Import Wizard to load Apache Impala. You can visually build the import query or use any SQL supported by the driver.
-
Easily Integrate SAP HANA XS Advanced Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP HANA XS Advanced in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating LaunchDarkly Data in Talend Cloud Data Management Platform
Connect LaunchDarkly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query MySQL Data in ColdFusion
Write standard ColdFusion data access code to connect to MySQL.
-
Use Grok to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Azure Analysis Services for you.
-
Analyze Outreach.io Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Outreach.io from Power Pivot. You will use the Table Import Wizard to load Outreach.io. You can visually build the import query or use any SQL supported by the driver.
-
How to Create Power BI Visual Reports with Real-Time Harvest Data
Use CData Power BI Connectors to visualize Harvest in Power BI.
-
Query Zoho Projects Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Projects from Node.js.
-
How to import Miro Data into Apache Solr
Use the CData Software JDBC Driver for Miro in Data Import Handler and create an automated import of Miro to Apache Solr Enterprise Search platform.
-
Create a Data Access Object for Jodoo Data using JDBI
A brief overview of creating a SQL Object API for Jodoo in JDBI.
-
Visualize Salesloft Data in Tableau
The CData ODBC driver for Salesloft enables you integrate Salesloft into Tableau dashboards.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Data Lake Storage to Power BI dashboards. Simply drag and drop Azure Data Lake Storage into data visuals on the Power BI canvas.
-
How to create Codat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Codat in MySQL .
-
Visualize BigCommerce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to BigCommerce.
-
How to connect and process Google Calendar from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Calendar.
-
ZohoSubscriptions Reporting in OBIEE with the ZohoSubscriptions JDBC Driver
Deploy the ZohoSubscriptions JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Productboard Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Productboard data access from reports, embedded analytics, and more.
-
Deploy the ADO.NET Provider for Drift on an SSRS Report Server
Connect to Drift 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.
-
Automated Continuous SAP HANA XS Advanced Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Snowflake.
-
Build an OLAP Cube in SSAS from Cosmos DB Data
Establish a connection to Azure Cosmos DB data from SQL Server Analysis Services, and use the Cosmos DB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Jira Assets Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Jira Assets from Informatica Cloud.
-
How to Import Data from SAP Ariba Source into Google Sheets
Import SAP Ariba Source into a Google spreadsheet that is automatically refreshed.
-
Connect to RabbitMQ Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to load SpaceX data into Elasticsearch via Logstash
Introducing a simple method to load SpaceX data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Facebook Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Facebook Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Aha! Replication to Databricks
Use CData Sync for automated, continuous, customizable Aha! replication to Databricks.
-
Build a Simple VCL Application for Microsoft Exchange Data
How to build a simple VCL Application to view Microsoft Exchange in RAD Studio using the CData ODBC Driver for Microsoft Exchange.
-
Access Live ADP Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ADP from your Excel spreadsheets.
-
How to connect to Recurly Data from Spring Boot
Connect to Recurly in a Spring Boot Application using the CData API Driver for JDBC
-
Model, Search, and Visualize Live NetSuite SuiteAnalytics Data in ThoughtSpot
Use CData Connect AI to connect to live NetSuite SuiteAnalytics for modeling, searching, and visualizing.
-
Amazon Athena Reporting in OBIEE with the Amazon Athena JDBC Driver
Deploy the Amazon Athena JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to Yelp Data in DBVisualizer
Integrate Yelp with visual data analysis tools and data connection wizards in DBVisualizer
-
How to use SQLAlchemy ORM to access Dynamics NAV Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics NAV.
-
Connect to ServiceDesk Plus Data in Ruby
Connect to ServiceDesk Plus in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Adobe Target Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Adobe Target replication to Apache Kafka.
-
Use the CData API Server to Access Sage 300 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage 300 in the Power Pivot business intelligence tool.
-
Replicate Multiple CData Connect AI Accounts via the CData Sync CLI
Replicate multiple CData Connect AI accounts to one or many databases.
-
Connect to and Query Toggl Data in QlikView over ODBC
Create data visualizations with Toggl in QlikView.
-
Access Live Sybase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sybase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Trello-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Trello Data from OutSystems and build custom enterprise apps using live Trello.
-
Build Dashboards with Mocean Data in DBxtra
Create dynamic dashboards and perform analytics based on Mocean in DBxtra.
-
Design BIRT Reports on Wistia Data
Provide current Wistia to your embedded analytics.
-
Bridge Clari Connectivity with Apache NiFi
Access and process Clari in Apache NiFi using the CData JDBC Driver.
-
Migrating data from Scrapfly to Snowflake using CData SSIS Components.
Easily push Scrapfly to Snowflake using the CData SSIS Tasks for Scrapfly and Snowflake.
-
Connect to and Query Chargebee Data in QlikView over ODBC
Create data visualizations with Chargebee in QlikView.
-
Seamlessly Bring SAP BusinessObjects BI Data into Retool Using CData Connect AI
Integrate SAP BusinessObjects BI data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Power BI XMLA in SpagoBI
Create reports featuring live Power BI XMLA in SpagoBI Studio. Host Power BI XMLA reports on SpagoBI Server.
-
Connect to Twilio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Twilio to connect to Twilio from Web applications running on WebLogic.
-
Integrate Cursor with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce & Force.com from within the editor.
-
Analyze Adobe Commerce Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Adobe Commerce and visualize live Adobe Commerce in Infragistics Reveal.
-
Automate Telegram Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Telegram from PowerShell? This article demonstrates how to utilize the Telegram Cmdlets for tasks like connecting to Telegram, automating operations, downloading data, and more.
-
How to Connect Flowise AI Agents to Live PostgreSQL Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live PostgreSQL without replication.