CData Software - Knowledge Base
Recent Articles
-
Connect to Everhour Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Everhour in the Denodo Virtual DataPort Administrator.
-
Use CData Connect AI to Access Azure Analysis Services Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure Analysis Services in the Power Pivot business intelligence tool.
-
Analyze Live Acumatica Data in SAS Viya
Use CData Connect AI to connect to Acumatica ERP from SAS Viya and deploy self-service analytics using live Acumatica ERP.
-
Connect to Splunk Data from Crystal Reports
Use CData Connect AI to connect to and report on live Splunk from Crystal Reports.
-
Integrate with Egnyte Data in JReport Designer
Create charts and reports based on Egnyte in JReport Designer.
-
Integrate Live Stripe Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Stripe and integrate live Stripe into apps built in Microsoft Power Apps.
-
How to create Spark federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Spark SQL in MySQL .
-
Easily Integrate Reckon Accounts Hosted Data in Lazarus Pascal IDE
Learn how to easily integrate live Reckon Accounts Hosted in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Semantic Layer Views for SAP Concur Data in APOS Live Data Gateway
Use the CData Connector for SAP Concur in APOS Live Data Gateway to build Semantic Layer Views for SAP Concur.
-
Validate Eventbrite Data with QuerySurge
Access and validate Eventbrite in QuerySurge using the CData JDBC Driver.
-
Automate BigCommerce Data Replication to SAP HANA
Use CData Sync to customize and automate BigCommerce replication to SAP HANA.
-
Access Live Amazon Marketplace 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 Amazon Marketplace through MCP integration.
-
Use Biml to Build SSIS Tasks to Replicate Avaza Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Avaza to SQL Server.
-
Access Live JSON Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate JSON into the statistical analysis tools available in SAS JMP. This article shows how to use JSON in the Graph Builder and Query Builder.
-
Automated Continuous CSV Replication to SQLite
Use CData Sync for automated, continuous, customizable CSV replication to SQLite.
-
How to Query Live Oracle HCM Cloud Data in Perplexity MacOS Desktop
Connect to and query live Oracle HCM Cloud Data in Perplexity Desktop using CData MCP Server.
-
Build Moosend-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Moosend.
-
Access Google Forms Data from MySQL in PHP
Connect to Google Forms through the standard MySQL libraries in PHP.
-
A PostgreSQL Interface for Splunk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Splunk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Gong Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Gong Data and provide access to live Gong for custom reports in the Power BI Service.
-
Automated Continuous Perplexity Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Perplexity replication to IBM DB2.
-
Migrating data from SAP BusinessObjects BI to Databricks using CData SSIS Components.
Easily push SAP BusinessObjects BI to Databricks using the CData SSIS Tasks for SAP BusinessObjects BI and Databricks.
-
Query Browserless Data in DataGrip
Create a Data Source for Browserless in DataGrip and use SQL to query live Browserless.
-
Integrate with SAS Data Sets Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAS Data Sets to a JSON file on disk.
-
A PostgreSQL Interface for Exact Online Data using the CData ODBC Driver
Use the SQL Gateway and Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Paymo Data in CloverDX (formerly CloverETL)
Transfer Paymo using the visual workflow in the CloverDX data integration tool.
-
Connect to Amazon Marketplace Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon Marketplace from PowerBuilder using the Amazon Marketplace JDBC Driver.
-
Getting Started with the CData Tableau Connector for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData ADO.NET Provider for Parquet
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Parquet.
-
How to Connect to Live YouTube Analytics 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 YouTube Analytics through natural language.
-
How to connect to Amazon S3 Data from IntelliJ
Integrate connectivity to Amazon S3 with wizards in IntelliJ.
-
Integrate Cursor with Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sage Intacct from within the editor.
-
Replicate SendPulse Data to Multiple Databases via the CData Sync CLI
Replicate SendPulse to disparate databases with a single configuration.
-
Connect and Query Live Oracle HCM Cloud Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle HCM Cloud into Databricks
-
Build Lakebase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Lakebase and build web apps with connectivity to live Lakebase.
-
Visualize Shopify Data in Tableau
The CData ODBC driver for Shopify enables you integrate Shopify into Tableau dashboards.
-
Prepare, Blend, and Analyze Bullhorn CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Bullhorn CRM for self-service data analytics.
-
How to Query SAP Hybris C4C Data in MySQL Workbench
Execute MySQL queries against live SAP Hybris C4C from MySQL Workbench.
-
Stream Cloudant Data into Apache Kafka Topics
Access and stream IBM Cloudant in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Microsoft Dataverse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Dataverse (CDS) in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to integrate Act CRM with Apache Airflow
Access and process Act CRM in Apache Airflow using the CData JDBC Driver.
-
Automate Hive Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Hive replication to SAP HANA.
-
Configure the CData JDBC Driver for Simplesat in a Connection Pool in Tomcat
Connect to Simplesat from a connection pool in Tomcat.
-
Automated Continuous Insightly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Insightly replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Python Connector for QuickBooks Online
Learn to install and license the CData Python Connector
-
Working with Datadog Data in LINQPad
Execute LINQ queries to Datadog in LINQPad.
-
Easily Integrate Jumpseller Data in Lazarus Pascal IDE
Learn how to easily integrate live Jumpseller in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Sentry Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sentry from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SharePoint Excel Services
Provide connectivity to SharePoint Excel Services through an SAP BusinessObjects universe.
-
How to integrate Metabase with Exact Online Data
Use CData Connect AI to connect to live Exact Online and create an interactive dashboard in Metabase from Exact Online.
-
How to Access Live ZohoInvoice Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoInvoice enables you to integrate ZohoInvoice into workflows built using Microsoft Power Automate Desktop.
-
View Reports on Real-Time Azure Analysis Services Data in Power BI Report Server
Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Eloqua.
-
Create Google Sheets-Connected Business Apps in AppSheet
Connect to Google Sheets Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Sheets.
-
Connect to SAP SuccessFactors LMS in SpagoBI
Create reports featuring live SAP SuccessFactors LMS in SpagoBI Studio. Host SAP SuccessFactors LMS reports on SpagoBI Server.
-
Build an OLAP Cube in SSAS from Xero Data
Establish a connection to Xero Accounting data from SQL Server Analysis Services, and use the Xero Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with live Cassandra Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apache Cassandra in Jitterbit.
-
How to connect to Perigon Data from IntelliJ
Integrate connectivity to Perigon with wizards in IntelliJ.
-
Stream Oracle Eloqua Data into Apache Kafka Topics
Access and stream Oracle Eloqua in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Microsoft Copilot Studio to talk to your Twitter Ads Data 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 Twitter Ads for you.
-
Connect to Google Ads Data in Aqua Data Studio
Access Google Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Cassandra 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 Apache Cassandra.
-
Connect to Reckon Accounts Hosted Data from PowerBuilder via JDBC
This article demonstrates how to access Reckon Accounts Hosted from PowerBuilder using the Reckon Accounts Hosted JDBC Driver.
-
How to Access Live Clockify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Clockify enables you to integrate Clockify into workflows built using Microsoft Power Automate Desktop.
-
Build Lakebase-Connected Apps in Choreo
Use CData Connect AI to connect to Lakebase Data from Choreo and build custom apps using live Lakebase.
-
Connect to Sage 300 Data from a Connection Pool in Jetty
The Sage 300 JDBC Driver supports connection pooling: This article shows how to connect faster to Sage 300 from Web apps in Jetty.
-
Connect to Pushbullet from Asprova with CData Software ODBC Driver for Pushbullet
This article shows how to connect faster to Pushbullet data from Asprova.
-
Integrate Cursor with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live GitHub from within the editor.
-
How to Visualize Miro Data in Python with pandas
Use pandas and other modules to analyze and visualize live Miro in Python.
-
Automated Continuous LinkedIn Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LinkedIn replication to IBM DB2.
-
Automated Continuous Elorus Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Elorus replication to Apache Kafka.
-
How to Query Live Google Cloud Storage Data in Perplexity MacOS Desktop
Connect to and query live Google Cloud Storage Data in Perplexity Desktop using CData MCP Server.
-
Visualize IBM Cloud Object Storage Data in TIBCO Spotfire through OData
Integrate IBM Cloud Object Storage into dashboards in TIBCO Spotfire.
-
Analyze Mistral AI Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mistral AI from Power Pivot. You will use the Table Import Wizard to load Mistral AI. You can visually build the import query or use any SQL supported by the driver.
-
How to Build an ETL App for Blackbaud FE NXT Data in Python with CData
Create ETL applications and real-time data pipelines for Blackbaud FE NXT in Python with petl.
-
Integrate with AdRoll Data in JReport Designer
Create charts and reports based on AdRoll in JReport Designer.
-
How to connect to Bugsnag Data with Squirrel SQL client
Connect to Bugsnag and execute queries in the Squirrel SQL Client.
-
Replicate Quaderno Data from PowerShell
Write a quick PowerShell script to query Quaderno. Use connectivity to the live data to replicate Quaderno to SQL Server.
-
Automated Continuous JotForm Replication to MySQL
Use CData Sync for automated, continuous, customizable JotForm replication to MySQL.
-
Create Data Visualizations in Cognos BI with Tickspot Data
Access Tickspot as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build MVC Applications with Connectivity to Zendesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zendesk from an ASP.NET MVC application.
-
Connect to Google Search Results in DBArtisan
Use wizards in DBArtisan to configure Google Search as a data source.
-
How to Work with Presto Data in AWS Glue Jobs Using JDBC
Connect to Presto from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize PabblySubscriptions 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 PabblySubscriptions into TIBCO Spotfire.
-
Build a PostgreSQL Interface for GitHub Data using the CData JDBC Driver
Use the Remoting features of the GitHub JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for SAS xpt Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAS xpt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Shippo Data in DBeaver
Use the CData ODBC Driver to connect to Shippo in DBeaver.
-
Connect to Real-Time EnterpriseDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for EnterpriseDB and Dataflow to import and use EnterpriseDB in Power Apps.
-
Connect to Exa Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Exa in the Denodo Virtual DataPort Administrator.
-
Create Adobe Commerce-Connected Business Apps in AppSheet
Connect to Adobe Commerce Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Adobe Commerce.
-
Access Live Elasticsearch 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 Elasticsearch through MCP integration.
-
Create Power BI Reports on Real-Time xBase Data
Use the CData ODBC Driver for xBase to visualize xBase in Power BI Desktop.
-
How to Connect to Live Greenplum 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 Pivotal GreenPlum without replication.
-
Build AI Agents with Salesforce Marketing 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 Salesforce Marketing Cloud through CData Connect AI.
-
How to Connect to Avro Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Avro. Leverage the pyodbc module for ODBC in Python.
-
Access Freshsales Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshsales from HeidiSQL.
-
How to Connect to Live Jira Assets 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 Jira Assets for you.
-
Automated Continuous Avaza Replication to SQLite
Use CData Sync for automated, continuous, customizable Avaza replication to SQLite.
-
Provide OData Services of CircleCI Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CircleCI by developing a WCF Service Application.
-
Analyze QuickBooks Time Data in Looker
Use CData Connect AI to connect to QuickBooks Time Data from Looker and build custom apps using live QuickBooks Time.