CData Software - Knowledge Base
Recent Articles
-
Moving Data from Sentry to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sentry data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Natively Connect to IBM Cloud Object Storage Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to IBM Cloud Object Storage. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for IBM Informix
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for IBM Informix.
-
Access Live Google Calendar Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Calendar from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Oracle Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle replication to MySQL.
-
Design BIRT Reports on Sage 300 Data
Provide current Sage 300 to your embedded analytics.
-
Build NetSuite SuiteAnalytics-Connected Apps in Choreo
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Choreo and build custom apps using live NetSuite SuiteAnalytics.
-
How to Connect to Auth0 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Auth0. Leverage the pyodbc module for ODBC in Python.
-
Build MailerLite-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MailerLite.
-
Build a Simple VCL Application for DB2 Data
How to build a simple VCL Application to view IBM DB2 in RAD Studio using the CData ODBC Driver for DB2.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Exchange to Power BI dashboards. Simply drag and drop Microsoft Exchange into data visuals on the Power BI canvas.
-
Visualize ChargeOver Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ChargeOver.
-
Load Dynamics 365 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics 365 to a database.
-
Connect to Certinia Data in ACL Analytics
Connect to Certinia via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Certinia.
-
Create Accelo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Accelo data access from reports, embedded analytics, and more.
-
Choosing the Best Method to Connect Moosend to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Moosend from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to load Spotify data into Elasticsearch via Logstash
Introducing a simple method to load Spotify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to load SQL Analysis Services data into Elasticsearch via Logstash
Introducing a simple method to load SQL Analysis Services data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Automated Workflows with Live Stripe Data in Workato
Use CData Connect AI to connect to live Stripe and build automated workflows in Workato.
-
Automated Continuous SAP Ariba Procurement Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Apache Cassandra.
-
Use the CData Software ODBC Driver for Calendly in MicroStrategy Web
Connect to Calendly in MicroStrategy Web using the CData Software ODBC Driver for Calendly.
-
Manage FreshBooks Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FreshBooks.
-
Access Live Sugar CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sugar CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to MarkLogic Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MarkLogic from Filemaker Pro on Mac.
-
Feed Clockify Data into FineReport
How to set Clockify as a JDBC data source in FineReport.
-
Getting Started with the CData Tableau Connector for Dotmailer
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to WordPress from a Connection Pool in WebLogic
Use the CData JDBC Driver for WordPress to connect to WordPress from Web applications running on WebLogic.
-
Automated Continuous QuickBooks Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks replication to Azure SQL Database.
-
Publish HBase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache HBase.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM through natural language.
-
Connect to Zoho Books Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Books from Filemaker Pro on Mac.
-
Access Optimizely Data from MySQL in PHP
Connect to Optimizely through the standard MySQL libraries in PHP.
-
Getting Started with the CData Python Connector for FreeAgent
Learn to install and license the CData Python Connector
-
Automate Instagram Data Replication to Azure Synapse
Use CData Sync to customize and automate Instagram replication to Azure Synapse.
-
How to Visualize SharePoint 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 Microsoft SharePoint in Python.
-
Build Hive-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Hive to explore live Hive Data in Gemini Code Assist to assist with building Hive-powered applications.
-
How to create CampaignMonitor federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CampaignMonitor in MySQL .
-
Build Marketo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Marketo and build web apps with connectivity to live Marketo.
-
Connect to Oracle Sales Data in JRuby
Create a simple JRuby app with access to live Oracle Sales.
-
Easily Integrate Billsby Data in Lazarus Pascal IDE
Learn how to easily integrate live Billsby in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Salesforce Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce & Force.com through CData Connect AI using different applications and tools.
-
Connect to Postmark Data in JRuby
Create a simple JRuby app with access to live Postmark.
-
Operational Reporting on ChargeOver Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ChargeOver.
-
Use Biml to Build SSIS Tasks to Replicate Procore Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Procore to SQL Server.
-
Automated Continuous Monday.com Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Monday.com replication to delimited files (CSV/TSV).
-
Query Cohere Data as a MySQL Database in Node.js
Execute MySQL queries against Cohere from Node.js.
-
Choosing the Best Method to Connect Mocean to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mocean from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to and Query GetResponse Data in QlikView over ODBC
Create data visualizations with GetResponse in QlikView.
-
Getting Started with the CData Power BI Connector for Mode
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access IBM Informix Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live IBM Informix from HeidiSQL.
-
A PostgreSQL Interface for BigCommerce Data using the CData ODBC Driver
Use the SQL Gateway and BigCommerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to QuickBooks Data from Spring Boot
Connect to QuickBooks in a Spring Boot Application using the CData JDBC Driver for QuickBooks
-
How to Visualize Stripe 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 Stripe in Python.
-
Visualize Live Sybase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sybase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Datasets from Kintone in Domo Workbench and Build Visualizations of Kintone Data in Domo
Use the CData Software ODBC Driver for Kintone to create datasets from Kintone in Domo Workbench and then build visualizations in the Domo service.
-
Work with AfterShip Data in FoxPro
Load AfterShip into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Recurly Data in the Pentaho Report Designer
Publish reports based on Recurly in the Pentaho BI tool.
-
Connect to Bright Data Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bright Data in the Denodo Virtual DataPort Administrator.
-
Build Avro-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Avro.
-
How to connect SharePoint with Freshdesk Data through external lists
Provide Freshdesk to SharePoint users as an external list.
-
Connect to Exact Online Data in Claris FileMaker Pro
Use the CData ODBC Driver for Exact Online in FileMaker Pro to connect to Exact Online and work with Exact Online in your FileMaker applications.
-
Visualize Oracle Service Cloud 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 Oracle Service Cloud into TIBCO Spotfire.
-
Query Jira Assets Data in ColdFusion
Write standard ColdFusion data access code to connect to Jira Assets.
-
Getting Started with the CData Tableau Connector for Bitbucket
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Bitbucket.
-
Connect Azure Table to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Table Storage using the CData Python MCP Server.
-
How to Easily Query Google Spanner Data in OpenOffice Base
Connect to Google Spanner data in OpenOffice Base using the CData ODBC Driver for Google Spanner and generate reports with live data insights.
-
Integrate with Live Xero Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Xero from the MuleSoft Anypoint Platform to integrate live Xero Accounting into custom reports and dashboards.
-
Query Cloudant Data from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Cloudant and perform CRUD operations on Cloudant from Node.js.
-
Use the CData ODBC Driver for Avalara AvaTax in Microsoft Power Query
You can use the CData Avalara AvaTax ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Avalara AvaTax into Microsoft Power Query.
-
How to connect to Vercel Data from Spring Boot
Connect to Vercel in a Spring Boot Application using the CData API Driver for JDBC
-
Publish RSS-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live RSS Feeds.
-
Connect to Spotify Data in DBArtisan
Use wizards in DBArtisan to configure Spotify as a data source.
-
Create SSAS Tabular Models from NetSuite Data
How to build a SQL Server Analysis Service Tabular Model from NetSuite CRM & ERP using CData drivers.
-
Integrate Real-Time Access to SAP Netweaver Gateway in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Netweaver Gateway in real time.
-
How to connect to Google Ad Manager Data with Squirrel SQL client
Connect to Google Ad Manager and execute queries in the Squirrel SQL Client.
-
How to publish and share Factorial Data dashboards with Tableau Server
The CData ODBC driver for Factorial enables you integrate Factorial into Tableau dashboards.
-
How to Create Power BI Visual Reports with Real-Time CircleCI Data
Use CData Power BI Connectors to visualize CircleCI in Power BI.
-
Access Live Avalara AvaTax Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Avalara AvaTax data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Certinia 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 Certinia.
-
Create RabbitMQ Dataflows on PowerBI.com
Connect to the CData Power BI Connector for RabbitMQ from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Azure Table Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Table Storage from your Excel spreadsheets.
-
View Reports on Real-Time Email Data in Power BI Report Server
Use the CData ODBC Driver for Email to visualize Email in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Printify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Printify to connect to Printify from Web applications running on WebLogic.
-
Connect to CouchDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apache CouchDB from Crystal Reports.
-
How to Create Power BI Visual Reports with Real-Time Wave Financial Data
Use CData Power BI Connectors to visualize Wave Financial in Power BI.
-
Use JayDeBeApi to access Klipfolio Data in Python
Use standard Python scripting and the development environment of your choice to access live Klipfolio.
-
Query Adobe Commerce Data in DataGrip
Create a Data Source for Adobe Commerce in DataGrip and use SQL to query live Adobe Commerce.
-
Integrate with Yelp Data in JReport Designer
Create charts and reports based on Yelp in JReport Designer.
-
Access Live SAP BusinessObjects BI Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP BusinessObjects BI from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create SSAS Tabular Models from Telegram Data
How to build a SQL Server Analysis Service Tabular Model from Telegram using CData drivers.
-
Integrate Live Google Spanner Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Spanner and integrate live Google Spanner into apps built in Microsoft Power Apps.
-
Analyze Printful Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Printful with the CData JDBC Driver for Printful.
-
Use Biml to Build SSIS Tasks to Replicate Exact Online Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Exact Online to SQL Server.
-
Extract, Transform, and Load PolarTeamPro Data in Informatica PowerCenter
Create a simple Workflow for PolarTeamPro in Informatica PowerCenter.
-
Integrate with RabbitMQ Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy RabbitMQ to a JSON file on disk.
-
Integrate with Live Azure DevOps Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure DevOps from the MuleSoft Anypoint Platform to integrate live Azure DevOps into custom reports and dashboards.
-
Feed ZarMoney Data into FineReport
How to set ZarMoney as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Salesforce in MicroStrategy Desktop
Connect to Salesforce & Force.com in MicroStrategy Desktop using the CData Software JDBC Driver for Salesforce.
-
Connect to Sage Cloud Accounting Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sage Business Cloud Accounting from Filemaker Pro on Mac.
-
Connect to Azure Data Lake Storage Data from AWS Glue
Use CData Connect AI to gain access to live Azure Data Lake Storage from your AWS Glue jobs.