CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time Salesforce Data
Use CData Power BI Connectors to visualize Salesforce & Force.com in Power BI.
-
Visualize Live Sybase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sybase into custom reports in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for MailerSend
Create MailerSend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Azure Data Catalog Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Amazon Redshift.
-
Create Google Cloud Storage-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Cloud Storage Data from Klipfolio and build custom visualizations using live Google Cloud Storage.
-
Create Delighted Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Delighted data access from reports, embedded analytics, and more.
-
Analyze NetSuite Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of NetSuite CRM & ERP and visualize live NetSuite CRM & ERP in Infragistics Reveal.
-
How to Query Live ElevenLabs Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ElevenLabs data in natural language using Python.
-
Working with Nethunt Data in LINQPad
Execute LINQ queries to Nethunt in LINQPad.
-
Build Microsoft Dataverse-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Dataverse Data and create custom apps in Bubble.
-
Visualize Supabase Data in TIBCO Spotfire through OData
Integrate Supabase into dashboards in TIBCO Spotfire.
-
Connect to Snapchat Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Snapchat Ads.
-
Access Live Azure Table Data in TIBCO Data Virtualization
Use the Azure Tibco DV Adapter to create a Azure Table Storage data source in TIBCO Data Virtualization Studio and gain access to live Azure Table Storage from your TDV Server.
-
Use the CData API Server to Access Copper Data in Microsoft PowerPivot
Use the CData API Server to connect to live Copper in the Power Pivot business intelligence tool.
-
Query FreeAgent Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FreeAgent from Node.js.
-
Integrate Freshteam with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Freshteam with External Services.
-
Automated Continuous Datadog Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Datadog replication to Amazon S3.
-
Automated Continuous Printful Replication to Vertica
Use CData Sync for automated, continuous, customizable Printful replication to Vertica.
-
ETL Google Translate in Oracle Data Integrator
This article shows how to transfer Google Translate into a data warehouse using Oracle Data Integrator.
-
Connect to Microsoft Teams Data in JRuby
Create a simple JRuby app with access to live Microsoft Teams.
-
Integrating Pingdom Data in Talend Cloud Data Management Platform
Connect Pingdom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access IBM Informix Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Informix.
-
Build Mode-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mode Data in Gemini Code Assist to assist with building Mode-powered applications.
-
Access Salesforce Marketing Data from MySQL in Amazon QuickSight
Connect to Salesforce Marketing and build visualizations of Salesforce Marketing Cloud using a MySQL Connection in Amazon QuickSight.
-
Connect to Browserless in SpagoBI
Create reports featuring live Browserless in SpagoBI Studio. Host Browserless reports on SpagoBI Server.
-
Analyze Aha! Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aha! in Microsoft R Open.
-
Connect to Brex Data from PowerBuilder via JDBC
This article demonstrates how to access Brex from PowerBuilder using the Brex JDBC Driver.
-
Extend Google Sheets with SAP Concur Data
Make calls to SAP Concur from Google Apps Script via the API Server.
-
How to Connect to Jira Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Atlassian Jira. Leverage the pyodbc module for ODBC in Python.
-
Connect to Mocean Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mocean and the SQL Gateway to access Mocean from Google Apps Script.
-
Getting Started with the CData SSIS Components for Zoom
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoom.
-
Automated Continuous Airtable Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Airtable replication to Amazon S3.
-
How to create Customer.io federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Customer.io in MySQL .
-
Work with Live Redis Data in Power Query
Use CData Connect AI to connect to Redis and work with live Redis in Microsoft Power Query.
-
Connect Power BI XMLA Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Power BI XMLA using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to SparkPost Data from Spring Boot
Connect to SparkPost in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from SAP SuccessFactors LMS to Snowflake using CData SSIS Components.
Easily push SAP SuccessFactors LMS to Snowflake using the CData SSIS Tasks for SAP SuccessFactors LMS and Snowflake.
-
Connect to Paylocity Data in JRuby
Create a simple JRuby app with access to live Paylocity.
-
Automate FreshBooks Data Replication to SAP HANA
Use CData Sync to customize and automate FreshBooks replication to SAP HANA.
-
Using the CData Software ODBC Driver for GraphQL in PyCharm
Connect to GraphQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for GraphQL.
-
Query SpaceX Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SpaceX from Node.js.
-
Integrate with GetResponse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy GetResponse to a JSON file on disk.
-
How to Query Live ZohoDesk Data in Perplexity MacOS Desktop
Connect to and query live ZohoDesk Data in Perplexity Desktop using CData MCP Server.
-
Create ClickUp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ClickUp from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Import Data from ClickTime into Google Sheets
Import ClickTime into a Google spreadsheet that is automatically refreshed.
-
Access Live Hubstaff Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Hubstaff into the statistical analysis tools available in SAS JMP. This article shows how to use Hubstaff in the Graph Builder and Query Builder.
-
Automated Continuous Billsby Replication to Databricks
Use CData Sync for automated, continuous, customizable Billsby replication to Databricks.
-
Moving Data from Cassandra to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cassandra data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Azure Data Catalog Data Replication to Teradata
Use CData Sync to Customize and automate Azure Data Catalog replication to Teradata.
-
Explore Geographical Relationships in Tickspot Data with Power Map
Create data visualizations with Tickspot in Power Map.
-
Replicate SharePoint Excel Services Data to Multiple Databases via the CData Sync CLI
Replicate SharePoint Excel Services to disparate databases with a single configuration.
-
Connect to AlloyDB Data in JRuby
Create a simple JRuby app with access to live Google AlloyDB.
-
Query Teamgate Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Teamgate entities in PHP by modeling them as objects.
-
Use the CData Software JDBC Driver for SAP SuccessFactors in MicroStrategy
Connect to SAP SuccessFactors in MicroStrategy Developer using the CData Software JDBC Driver for SAP SuccessFactors.
-
Connect to Airtable Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Airtable and the Script function in FileMaker Pro to connect to Airtable and work with Airtable in your FileMaker application.
-
Build Zoho Projects-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zoho Projects to explore live Zoho Projects Data in Claude Code to assist with building Zoho Projects-powered applications.
-
Validate Optimizely Data with QuerySurge
Access and validate Optimizely in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for PingOne
Learn to install and license the CData Python Connector
-
Validate SAS xpt Data with QuerySurge
Access and validate SAS XPORT in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to Anaplan Data in C++Builder
DataBind to Anaplan in C++Builder with standard components and controls.
-
Connect to SAP Netweaver Gateway Data in ACL Analytics
Connect to SAP Netweaver Gateway via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Netweaver Gateway.
-
Query ZendeskSell Data as a MySQL Database in Node.js
Execute MySQL queries against ZendeskSell from Node.js.
-
Build a Singer.io Tap for SAP ByDesign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP ByDesign data using
-
Publish Reports with Rebilly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rebilly.
-
Getting Started with the CData Python Connector for SpaceX
Learn to install and license the CData Python Connector
-
Automate PagerDuty Data Replication to SAP HANA
Use CData Sync to customize and automate PagerDuty replication to SAP HANA.
-
Create Data Visualizations in Cognos BI with Google Campaign Manager 360 Data
Access Google Campaign Manager 360 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create API-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to API Data from Klipfolio and build custom visualizations using live API.
-
Getting Started with the CData ODBC Driver for Toggl
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Toggl.
-
Integrating Sage 300 Data in Talend Cloud Data Management Platform
Connect Sage 300 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage 300.
-
Bridge ActiveCampaign Connectivity with Apache NiFi
Access and process ActiveCampaign in Apache NiFi using the CData JDBC Driver.
-
Visualize Wave Financial Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Wave Financial.
-
Design BIRT Reports on Coda Data
Provide current Coda to your embedded analytics.
-
Configure the CData JDBC Driver for Mocean in a Connection Pool in Tomcat
Connect to Mocean from a connection pool in Tomcat.
-
Import and Visualize Quaderno Data in Power View
Create data visualizations based on Quaderno in Excel.
-
Create Apps from SendGrid Data in Qlik Sense Cloud
Use CData Connect AI to connect to SendGrid Data and build apps from live SendGrid in Qlik Sense Cloud.
-
Access Shortcut Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shortcut from HeidiSQL.
-
Getting Started with the CData ADO.NET Provider for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sybase IQ.
-
Automate Bullhorn CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Bullhorn CRM replication to Couchbase.
-
Integrating Claude Code with MongoDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MongoDB within assisted coding and automated development workflows.
-
Build Semantic Layer Views for SpaceX Data in APOS Live Data Gateway
Use the CData Connector for SpaceX in APOS Live Data Gateway to build Semantic Layer Views for SpaceX.
-
Automated Continuous EnterpriseDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Snowflake.
-
View Reports on Real-Time Reckon Accounts Hosted Data in Power BI Report Server
Use the CData ODBC Driver for Reckon Accounts Hosted to visualize Reckon Accounts Hosted in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Reports with Placid Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Placid.
-
Use the CData Software JDBC Driver for Deel in MicroStrategy Desktop
Connect to Deel in MicroStrategy Desktop using the CData Software JDBC Driver for Deel.
-
Create a Data Access Object for Pingdom Data using JDBI
A brief overview of creating a SQL Object API for Pingdom in JDBI.
-
Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Ariba Procurement.
-
Integrate Amazon Athena Data into Power Automate Desktop using CData Connect
CData Connect for Amazon Athena Data enables you to integrate Amazon Athena into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Oracle Financials Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Financials Cloud in Python with petl.
-
Consume GetResponse OData Feeds in PowerBuilder
This article demonstrates how to consume GetResponse as OData feeds from PowerBuilder using the API Server.
-
Integrate Live Trello Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Query SendInBlue Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SendInBlue from Node.js.
-
Integrate with live Gmail Data in Jitterbit
Use CData Connect AI to connect to and integrate live Gmail in Jitterbit.
-
Connect to Datadog Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Datadog as an External Source in Dremio.
-
Integrate with live LinkedIn Data in Jitterbit
Use CData Connect AI to connect to and integrate live LinkedIn in Jitterbit.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Data 360 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Data 360.
-
Integrating OpenCode Terminal with Grafana 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.
-
Build Instagram-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Instagram.
-
Provide OData Services of Microsoft OneDrive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft OneDrive by developing a WCF Service Application.
-
Create Informatica Mappings From/To a JDBC Data Source for Codat
Create Codat data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.