CData Software - Knowledge Base
Recent Articles
-
Publish Dynamics CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics CRM.
-
Build API-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live API and build API-connected web apps with Axios.
-
Visualize Amazon Marketplace 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 Amazon Marketplace into TIBCO Spotfire.
-
Integrating Gumloop with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zendesk within automated workflows.
-
Connect to Pinterest Data in DBArtisan
Use wizards in DBArtisan to configure Pinterest as a data source.
-
Create Reports from SAS xpt Data in Looker Studio
Use CData Connect AI to gain access to live SAS XPORT and create custom reports in Looker Studio.
-
Connect to GetResponse Data from PowerBuilder via JDBC
This article demonstrates how to access GetResponse from PowerBuilder using the GetResponse JDBC Driver.
-
Connect to QuickBooks Online Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live QuickBooks Online from Filemaker Pro on Mac.
-
How to import Excel Online Data into Apache Solr
Use the CData Software JDBC Driver for Excel Online in Data Import Handler and create an automated import of Microsoft Excel Online to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Power BI Connector for Recurly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Instagram Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Instagram replication to Amazon Redshift.
-
Publish Reports with OneNote Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneNote.
-
Connect to Slack Data from a Connection Pool in Jetty
The Slack JDBC Driver supports connection pooling: This article shows how to connect faster to Slack from Web apps in Jetty.
-
Connect to eBay Analytics Data in DBeaver
Use the CData ODBC Driver to connect to eBay Analytics in DBeaver.
-
Natively Connect to Gong Data in PHP
The CData ODBC driver for Gong enables you to create PHP applications with connectivity to Gong. Leverage the native support for ODBC in PHP.
-
Build Pipelines with Live Google Spanner Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Spanner from Google Cloud Data Fusion, enabling the integration of live Google Spanner into the building and management of effective data pipelines.
-
Migrating data from Azure Data Lake Storage to Snowflake using CData SSIS Components.
Easily push Azure Data Lake Storage to Snowflake using the CData SSIS Tasks for Azure Data Lake Storage and Snowflake.
-
How to Connect to LionDesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LionDesk. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData ODBC Driver for Clari
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Clari.
-
Visualize Live Hacker News Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Hacker News.
-
Build a Simple VCL Application for SAP Netweaver Gateway Data
How to build a simple VCL Application to view SAP Netweaver Gateway in RAD Studio using the CData ODBC Driver for SAP Netweaver Gateway.
-
Create Reports with Copper Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Copper.
-
Automated Continuous Opsgenie Replication to MySQL
Use CData Sync for automated, continuous, customizable Opsgenie replication to MySQL.
-
Use the CData Software ODBC Driver for QuickBooks in MicroStrategy Desktop
Connect to QuickBooks Desktop in MicroStrategy Desktop using the CData Software ODBC Driver for QuickBooks.
-
How to Connect to Quickbase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Quickbase. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze Phoenix Data in Alteryx Designer (Connect AI)
Build workflows to access live Apache Phoenix for self-service data analytics.
-
Access Short.io Data from MySQL in PHP
Connect to Short.io through the standard MySQL libraries in PHP.
-
Create Dashboards and Visualize Live GitLab Data in Geckoboard
Use CData Connect AI to connect to live GitLab and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Amazon Athena-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon Athena.
-
Replicate Aha! Data from PowerShell
Write a quick PowerShell script to query Aha!. Use connectivity to the live data to replicate Aha! to SQL Server.
-
How to Query Live Wistia Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Wistia data in natural language using Python.
-
How to Query Strava Data in MySQL Workbench
Execute MySQL queries against live Strava from MySQL Workbench.
-
Visualize Live Couchbase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Couchbase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Shortcut Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Shortcut to a database.
-
Automate Excel Online Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Excel Online replication to SAP HANA.
-
Visualize Paddle Data in Tableau
The CData ODBC driver for Paddle enables you integrate Paddle into Tableau dashboards.
-
Build Visualizations of Onfleet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Onfleet in Birst.
-
Extend Google Sheets with Azure Data Catalog Data
Make calls to Azure Data Catalog from Google Apps Script via the API Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Twitter Ads
Provide connectivity to Twitter Ads through an SAP BusinessObjects universe.
-
Viewing Greenplum Data in RAD Studio Data Explorer
How to view Pivotal GreenPlum in RAD Studio Data Explorer using the CData ODBC Driver for Greenplum.
-
Visualize Dropbox 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 Dropbox into TIBCO Spotfire.
-
How to Design Jira Assets Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Jira Assets from mobile and tablet Power Apps.
-
Integrating Codex CLI with ZohoExpense 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.
-
Query ZohoDesk Data as a MySQL Database in Node.js
Execute MySQL queries against ZohoDesk from Node.js.
-
How to create Everhour federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Everhour in MySQL .
-
Visualize Zuora 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 Zuora into TIBCO Spotfire.
-
Automate Monday.com Data Replication to Azure Data Lake
Use CData Sync to customize and automate Monday.com replication to Azure Data Lake.
-
Bidirectional Access to Bannerbear Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bannerbear in Filemaker Pro for Mac or Windows.
-
Easily Integrate PivotalTracker Data in Lazarus Pascal IDE
Learn how to easily integrate live PivotalTracker in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query Wave Financial Data in ColdFusion
Write standard ColdFusion data access code to connect to Wave Financial.
-
How to load Clockify data into Elasticsearch via Logstash
Introducing a simple method to load Clockify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to Amazon Marketplace Data in DBVisualizer
Integrate Amazon Marketplace with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live SAP Business Warehouse Data in Coginiti Pro
Connect to and query live SAP Business Warehouse from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for LeadDesk in MicroStrategy
Connect to LeadDesk in MicroStrategy Developer using the CData Software JDBC Driver for LeadDesk.
-
Build Pipelines with Live Zoho Inventory Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Inventory from Google Cloud Data Fusion, enabling the integration of live Zoho Inventory into the building and management of effective data pipelines.
-
Automated GraphQL Data Replication to Teradata
Use CData Sync to Customize and automate GraphQL replication to Teradata.
-
Create Power BI Reports on Real-Time Dynamics 365 Data
Use the CData ODBC Driver for Dynamics 365 to visualize Microsoft Dynamics 365 in Power BI Desktop.
-
Connect to Microsoft Exchange Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Exchange and the SQL Gateway to access Microsoft Exchange from Google Apps Script.
-
How to connect and process Attio from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Attio.
-
Create ShipStation-Connected Nintex Workflows
Use CData Connect AI to connect to ShipStation Data from Nintex Workflow Cloud and build custom workflows using live ShipStation.
-
Replicate Tanda Data from PowerShell
Write a quick PowerShell script to query Tanda. Use connectivity to the live data to replicate Tanda to SQL Server.
-
Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Ariba Procurement.
-
Connect to Suadeo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate with Live SAP Ariba Procurement Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Ariba Procurement from the MuleSoft Anypoint Platform to integrate live SAP Ariba Procurement into custom reports and dashboards.
-
Explore Geographical Relationships in Intercom Data with Power Map
Create data visualizations with Intercom in Power Map.
-
Establish a Live Connection with Basecamp Data using Tableau Bridge
The CData ODBC Driver for Basecamp enables you to integrate live Basecamp into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Grafana in Microsoft Power Query
You can use the CData Grafana ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Grafana into Microsoft Power Query.
-
Build Authorize.Net-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Authorize.Net.
-
Establish a Live Connection with Drip Data using Tableau Bridge
The CData ODBC Driver for Drip enables you to integrate live Drip into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Paylocity Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paylocity from your Excel spreadsheets.
-
Automate BenchmarkEmail Data Replication to Azure Data Lake
Use CData Sync to customize and automate BenchmarkEmail replication to Azure Data Lake.
-
How to Connect to Live Sybase Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sybase without replication.
-
Edit and Search AlloyDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google AlloyDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create AlloyDB objects that you can access from apps and the dashboard.
-
Operational Reporting on SAP Netweaver Gateway Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Netweaver Gateway.
-
How to connect to Deel Data from IntelliJ
Integrate connectivity to Deel with wizards in IntelliJ.
-
Query Zoho Creator Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Creator.
-
Build AI Agents with Zendesk 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 Zendesk through CData Connect AI.
-
Work with Live FHIR Data in Power Query
Use CData Connect AI to connect to FHIR and work with live FHIR in Microsoft Power Query.
-
Create Procore-Connected Dashboards in Grafana
Connect to Procore Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Procore.
-
Automated Continuous Pipeliner CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to OneLake in Microsoft Fabric.
-
Access Google Directory Data from MySQL in PHP
Connect to Google Directory through the standard MySQL libraries in PHP.
-
How to Connect to & Open SAP SuccessFactors Data in Microsoft Excel
This article uses the CData ODBC driver for SAP SuccessFactors to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Facebook Ads-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Facebook Ads to explore live Facebook Ads Data in Gemini Code Assist to assist with building Facebook Ads-powered applications.
-
Connect to Live EnterpriseDB Data in MicroStrategy through CData Connect AI
Create a live connection to EnterpriseDB Data in CData Connect AI and connect to your EnterpriseDB from MicroStrategy.
-
Configure the CData JDBC Driver for Zoom in a Connection Pool in Tomcat
Connect to Zoom from a connection pool in Tomcat.
-
How to create OnePageCrm federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for OnePageCrm in MySQL .
-
Integrating Cursor CLI with Rootly 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.
-
Automate Delighted Data Replication to Couchbase
Use CData Sync to Customize and automate Delighted replication to Couchbase.
-
Create Power BI Reports on Real-Time Helpscout Data
Use the CData ODBC Driver for Helpscout to visualize Helpscout in Power BI Desktop.
-
Query, Visualize, and Share live Active Directory Data in Redash
Use CData Connect AI to connect to live Active Directory in Redash for querying, visualizing, and sharing.
-
Publish Crystal Reports on Salesforce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce & Force.com.
-
Use the CData SSIS Components to Insert New or Update Existing OData Records from SQL Server
Easily push SQL Server data to OData using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into OData or update existing records with data from a SQL Server database.
-
Getting Started with the CData Python Connector for Snapchat Ads
Learn to install and license the CData Python Connector
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Attio
Provide connectivity to Attio through an SAP BusinessObjects universe.
-
Create Google Contacts-Connected Dashboards in Grafana
Connect to Google Contacts Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Contacts.
-
How to Connect to & Open Accelo Data in Microsoft Excel
This article uses the CData ODBC driver for Accelo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Load Apollo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apollo to a database.
-
ETL QuickBooks Online in Oracle Data Integrator
This article shows how to transfer QuickBooks Online into a data warehouse using Oracle Data Integrator.
-
How to Query Live EnterpriseDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live EnterpriseDB data in natural language using Python.
-
Create Data Visualizations in Cognos BI with Missive Data
Access Missive as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.