CData Software - Knowledge Base
Recent Articles
-
Design BIRT Reports on HubDB Data
Provide current HubDB data to your embedded analytics.
-
How to load eBay data into Elasticsearch via Logstash
Introducing a simple method to load eBay data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Kafka Data in TIBCO Data Virtualization
Use the Kafka Tibco DV Adapter to create a Kafka data data source in TIBCO Data Virtualization Studio and gain access to live Kafka data from your TDV Server.
-
Create Power BI Reports on Real-Time Google Cloud Storage Data
Use the CData ODBC Driver for Google Cloud Storage to visualize Google Cloud Storage data in Power BI Desktop.
-
Build Box Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Box data and build visualizations in Tableau.
-
Bidirectional Access to Airtable Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Airtable data in Filemaker Pro for Mac or Windows.
-
Enable the DB2 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with DB2 data.
-
Build Automated Workflows with Live Azure Data Catalog Data in Workato
Use CData Connect AI to connect to live Azure Data Catalog data and build automated workflows in Workato.
-
Query Dynamics CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Dynamics CRM data from Node.js.
-
Build Charts with Rebilly Data in Clear Analytics
Create dynamic charts and perform analytics based on Rebilly data in Clear Analytics.
-
Visualize SAP ByDesign Data in Tableau
The CData ODBC driver for SAP ByDesign enables you integrate SAP ByDesign data into Tableau dashboards.
-
Connect to eBay Analytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access eBay Analytics data in Google Apps Script.
-
Automated Continuous Rebilly Replication to Oracle
Use CData Sync for automated, continuous, customizable Rebilly replication to Oracle.
-
ETL ZohoPeople in Oracle Data Integrator
This article shows how to transfer ZohoPeople data into a data warehouse using Oracle Data Integrator.
-
Build Apps with Live Google Ads Data Using the Low-Code Development Platform of Mendix
Connect Google Ads data with Mendix to build apps using the CData JDBC Driver for Google Ads.
-
Create Reports with Dynamics CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics CRM data.
-
Validate Avro Data with QuerySurge
Access and validate Avro data in QuerySurge using the CData JDBC Driver.
-
Connect to ShipEngine Data from a Connection Pool in JBoss
Integrate ShipEngine data into Java servlets: Use the Management Console in JBoss to install the ShipEngine JDBC Driver.
-
Easily Integrate IBM Cloud Object Storage Data in Lazarus Pascal IDE
Learn how to easily integrate live IBM Cloud Object Storage data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy Desktop
Connect to Greenplum data in MicroStrategy Desktop using the CData Software JDBC Driver for Greenplum.
-
How to Create Power BI Visual Reports with Real-Time MySQL Data
Use CData Power BI Connectors to visualize MySQL data in Power BI.
-
Create a Data Access Object for Wistia Data using JDBI
A brief overview of creating a SQL Object API for Wistia data in JDBI.
-
Use the CData Software ODBC Driver for Facebook Ads in MicroStrategy
Connect to Facebook Ads data in MicroStrategy Developer using the CData Software ODBC Driver for Facebook Ads.
-
Build Wave Financial-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Wave Financial data and build web apps with connectivity to live Wave Financial data.
-
Create Power BI Reports on Real-Time Blackbaud FE NXT Data
Use the CData ODBC Driver for Blackbaud FE NXT to visualize Blackbaud FE NXT data in Power BI Desktop.
-
Integrate Google's Antigravity Agent with Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live PingOne data using the Model Context Protocol.
-
Query Invoiced Data in ColdFusion
Write standard ColdFusion data access code to connect to Invoiced data.
-
Connect to Live MailerLite Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MailerLite in CData Connect AI and connect to your MailerLite data from PostgreSQL.
-
How to Build an ETL App for Okta Data in Python with CData Connect AI
Extract and transform live Okta data in Python with petl and the CData Connect AI Python SDK.
-
Create SSAS Tabular Models from Cosmos DB Data
How to build a SQL Server Analysis Service Tabular Model from Cosmos DB data using CData drivers.
-
How to Connect to Live Bannerbear 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 Bannerbear data for you.
-
Rapidly Develop Miro-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Miro.
-
Create Power BI Reports on Real-Time Amazon Marketplace Data
Use the CData ODBC Driver for Amazon Marketplace to visualize Amazon Marketplace data in Power BI Desktop.
-
Build SAP Concur-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Concur Data and create custom apps in Mendix.
-
Use the CData ODBC Driver for Highrise in Microsoft Power Query
You can use the CData Highrise ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Highrise data into Microsoft Power Query.
-
Access Live SAP SuccessFactors Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors data from your Excel spreadsheets.
-
How to Build an ETL App for Anaplan Data in Python with CData Connect AI
Extract and transform live Anaplan data in Python with petl and the CData Connect AI Python SDK.
-
Enable the Oracle SCM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle SCM data.
-
Automated Continuous ServiceNow Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ServiceNow replication to AlloyDB.
-
Query SurveyMonkey Data in DataGrip
Create a Data Source for SurveyMonkey in DataGrip and use SQL to query live SurveyMonkey data.
-
Manage Jira Assets Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Jira Assets.
-
Use the CData Software ODBC Driver for Hugging Face in SAS for Real-Time Reporting and Analytics
Connect to real-time Hugging Face data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hugging Face.
-
Use Dash to Build to Web Apps on Contentful Data
Create Python applications that use pandas and Dash to build Contentful-connected web apps.
-
Create DB2 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time DB2 data access from reports, embedded analytics, and more.
-
Build Pipelines with Live IBM Informix Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to IBM Informix from Google Cloud Data Fusion, enabling the integration of live IBM Informix data into the building and management of effective data pipelines.
-
Use the CData Software JDBC Driver for Microsoft OneDrive in MicroStrategy Desktop
Connect to Microsoft OneDrive data in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft OneDrive.
-
Visualize Salesloft Data in TIBCO Spotfire through ADO.NET
Integrate Salesloft data into dashboards in TIBCO Spotfire.
-
How to Connect the Power BI Service to Foursquare: Complete Guide
Connect to the CData Software Power BI Connector for Foursquare from PowerBI.com to provide real-time Foursquare data across the organization.
-
Choosing the Best Method to Connect Monday.com to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Monday.com data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access OnePageCrm Data from MySQL in PHP
Connect to OnePageCrm through the standard MySQL libraries in PHP.
-
Query Tanda Data in ColdFusion
Write standard ColdFusion data access code to connect to Tanda data.
-
Search External Jira Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Jira data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Jira Data objects that you can access from apps and the dashboard.
-
Replicate Multiple XML Accounts via the CData Sync CLI
Replicate multiple XML accounts to one or many databases.
-
Consume SAP SuccessFactors LMS OData Feeds in PowerBuilder
This article demonstrates how to consume SAP SuccessFactors LMS data as OData feeds from PowerBuilder using the API Server.
-
Access Live BenchmarkEmail Data in AWS Lambda
Connect to live BenchmarkEmail data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Google Spanner
Install the CData Connect AI Python SDK to read and write live Google Spanner data with standard DB-API 2.0 Python code.
-
Connect to Cvent Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Cvent data in Airbyte.
-
Create PostgreSQL-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to PostgreSQL Data from OutSystems and build custom enterprise apps using live PostgreSQL data.
-
Connect to PayPal Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to PayPal.
-
Automated Continuous Monday.com Replication to Snowflake
Use CData Sync for automated, continuous, customizable Monday.com replication to Snowflake.
-
Integrating LangChain with Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Pinterest data within automated workflows.
-
SharePoint Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SharePoint facts in real time.
-
Deploy the ADO.NET Provider for BenchmarkEmail on an SSRS Report Server
Connect to BenchmarkEmail data 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 Teamgate Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Teamgate replication to AlloyDB.
-
Automated Continuous Amplitude Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amplitude data replication to OneLake in Microsoft Fabric.
-
Integrate Snapchat Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Snapchat Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Snapchat Ads data.
-
Use JayDeBeApi to access Oracle SCM Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle SCM data.
-
Integrate Cursor with Live Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Pinterest data from within the editor.
-
Work with Live Sugar CRM Data in Power Query
Use CData Connect AI to connect to Sugar CRM data and work with live Sugar CRM data in Microsoft Power Query.
-
Getting Started with the CData SSIS Components for Omnisend
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Omnisend.
-
Use JayDeBeApi to access AdRoll Data in Python
Use standard Python scripting and the development environment of your choice to access live AdRoll data.
-
How to Query Elasticsearch Data in MySQL Workbench
Execute MySQL queries against live Elasticsearch data from MySQL Workbench.
-
How to work with Scrapfly Data in Apache Spark using SQL
Access and process Scrapfly Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Sybase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sybase data.
-
Integrate Dify with Live Greenplum Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Greenplum data.
-
Integrating Kiro with IBM Cloud Object Storage 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.
-
How to connect SharePoint with Facebook Ads Data through external lists
Provide Facebook Ads data to SharePoint users as an external list.
-
A PostgreSQL Interface for HelloSign Data using the CData ODBC Driver
Use the SQL Gateway and HelloSign ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Yelp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Yelp data in MySQL .
-
How to create Visio diagrams from Twilio Data
Automatically update Twilio data with the changes you make to Visio master shapes.
-
Automated Continuous ZohoMarketingHub Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to delimited files (CSV/TSV).
-
Integrate Real-Time Access to ServiceNow in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ServiceNow data in real time.
-
Connect to Gumroad Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Gumroad to connect to Gumroad data and execute queries in PowerBuilder.
-
Build Google Drive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Drive data.
-
Build Accelo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Accelo data.
-
Connect to PhantomBuster Data in Jaspersoft Studio
Execute SQL to remote PhantomBuster data in Jaspersoft Studio.
-
Query ConvertAPI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ConvertAPI data from Node.js.
-
Migrating data from Amplitude to Google BigQuery using CData SSIS Components.
Easily push Amplitude data to Google BigQuery using the CData SSIS Tasks for Amplitude and Google BigQuery.
-
Build a Simple VCL Application for Zoom Data
How to build a simple VCL Application to view Zoom data in RAD Studio using the CData ODBC Driver for Zoom.
-
Analyze Paddle Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Paddle from Power Pivot. You will use the Table Import Wizard to load Paddle data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live Blackbaud FE NXT Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Blackbaud FE NXT in CData Connect AI and connect to your Blackbaud FE NXT data from PostgreSQL.
-
Access Live Sybase IQ Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase IQ data from your Excel spreadsheets.
-
Model, Search, and Visualize Live Freshteam Data in ThoughtSpot
Use CData Connect AI to connect to live Freshteam data for modeling, searching, and visualizing.
-
Explore Geographical Relationships in Snapchat Ads Data with Power Map
Create data visualizations with Snapchat Ads data in Power Map.
-
Automated Continuous Google Spanner Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Spanner replication to IBM DB2.
-
Integrate Live QuickBooks Online Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live QuickBooks Online data from within the IDE.
-
Access Live SAP BusinessObjects BI Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP BusinessObjects BI data through MCP integration.
-
Query Dynamics NAV Data as a SQL Server Database in Node.js
Execute SQL Server queries against Dynamics NAV data from Node.js.
-
Use Azure AI Foundry to Talk to Your Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Zoho Projects data for you.
-
Migrating data from WooCommerce to Databricks using CData SSIS Components.
Easily push WooCommerce data to Databricks using the CData SSIS Tasks for WooCommerce and Databricks.