CData Software - Knowledge Base
Recent Articles
-
Analyze Parquet Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Parquet and visualize live Apache Parquet in Infragistics Reveal.
-
Automate Exact Online Data Replication to Azure Data Lake
Use CData Sync to customize and automate Exact Online replication to Azure Data Lake.
-
Create a Data Access Object for FTP Data using JDBI
A brief overview of creating a SQL Object API for FTP Servers in JDBI.
-
How to Build an ETL App for Zoho Creator Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Creator in Python with petl.
-
Integrate Slack with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Slack with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Slack.
-
Build Dashboards with Keap Data in Dundas BI
Create dynamic dashboards and perform analytics based on Keap in Dundas BI.
-
How to Query Live Airtable Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Airtable data in natural language using Python.
-
Access Jumpseller Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Jumpseller.
-
Use the CData Software ODBC Driver for FHIR in SAS for Real-Time Reporting and Analytics
Connect to real-time FHIR in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FHIR.
-
Integrate Google Contacts Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Contacts and integrate live Google Contacts into your Power Automate tasks.
-
Provide OData Services of Parquet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Parquet by developing a WCF Service Application.
-
How to load Beeminder data into Elasticsearch via Logstash
Introducing a simple method to load Beeminder data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Microsoft Dataverse Data in Tableau
The CData ODBC driver for Microsoft Dataverse enables you integrate Microsoft Dataverse (CDS) into Tableau dashboards.
-
How to Easily Query Outlook Data in OpenOffice Base
Connect to Outlook data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Data Visualizations in Cognos BI with GetResponse Data
Access GetResponse as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Figshare Data from MySQL in PHP
Connect to Figshare through the standard MySQL libraries in PHP.
-
How to create Google Ad Manager federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Ad Manager in MySQL .
-
Integrate ShipStation Data in Pentaho Data Integration
Build ETL pipelines based on ShipStation in the Pentaho Data Integration tool.
-
How to Build an ETL App for Square Data in Python with CData
Create ETL applications and real-time data pipelines for Square in Python with petl.
-
Access Hacker News Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Hacker News from your Oracle system.
-
Replicate ADP Data to Multiple Databases
Replicate ADP to disparate databases with a point-and-click configuration.
-
Use CData Connect AI to Access Microsoft Dataverse Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) in the Power Pivot business intelligence tool.
-
Automated Continuous BenchmarkEmail Replication to MySQL
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to MySQL.
-
Connect to Klipfolio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Klipfolio to connect to Klipfolio from Web applications running on WebLogic.
-
Integrate Vault CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vault CRM with External Services.
-
Visualize Live Aircall Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Aircall.
-
Build Semantic Layer Views for Telegram Data in APOS Live Data Gateway
Use the CData Connector for Telegram in APOS Live Data Gateway to build Semantic Layer Views for Telegram.
-
Create Datasets from ScrapingBee in Domo Workbench and Build Visualizations of ScrapingBee Data in Domo
Use the CData Software ODBC Driver for ScrapingBee to create datasets from ScrapingBee in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData JDBC Driver for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Ariba Procurement.
-
Back Up LionDesk to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with LionDesk data.
-
Replicate Multiple Microsoft Dataverse Accounts
Replicate multiple Microsoft Dataverse accounts to one or many databases.
-
How to Access Live Microsoft Ads Data in Visual Studio Code via Cline
Run CData MCP Server for Microsoft Ads on Windows Subsytem for Linux (WSL) and connect to live Microsoft Ads from the Cline extension in Visual Studio Code.
-
How to connect to Tavily Data with Squirrel SQL client
Connect to Tavily and execute queries in the Squirrel SQL Client.
-
Object-Relational Mapping (ORM) with Teradata Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Teradata into a Java-based ORM framework, Hibernate.
-
Visualize Live HCL Domino Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HCL Domino.
-
Integrating Claude Code CLI with JobNimbus 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.
-
Connect Epicor Kinetic to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Epicor Kinetic with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to FreshBooks Data with Squirrel SQL client
Connect to FreshBooks and execute queries in the Squirrel SQL Client.
-
Connect to and Visualize Live Opsgenie Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Opsgenie.
-
Excel Spreadsheet Automation on Dynamics NAV Data with the QUERY Formula
Pull data from Dynamics NAV, automate spreadsheets, and more with the QUERY formula.
-
Build MongoDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MongoDB and build visualizations in Tableau.
-
Extract, Transform, and Load Salesloft Data in Informatica PowerCenter
Create a simple Workflow for Salesloft in Informatica PowerCenter.
-
Import Real-Time Foursquare Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Foursquare in ColdFusion.
-
Connect to and Visualize Live Freshsales Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Freshsales.
-
Establish a Live Connection with Amazon Marketplace Data using Tableau Bridge
The CData ODBC Driver for Amazon Marketplace enables you to integrate live Amazon Marketplace into Tableau Cloud dashboards using the Tableau Bridge.
-
Close Reporting in OBIEE with the Close JDBC Driver
Deploy the Close JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build SendGrid-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SendGrid and build web apps with connectivity to live SendGrid.
-
How to Access Monday.com Data Using Entity Framework
This article shows how to access Monday.com using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for Perplexity in MicroStrategy
Connect to Perplexity in MicroStrategy Developer using the CData Software ODBC Driver for Perplexity.
-
DataBind SAP HANA Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP HANA with the DevExpress Windows Forms and Web controls to provide SAP HANA to a chart.
-
Model, Search, and Visualize Live Reckon Accounts Hosted Data in ThoughtSpot
Use CData Connect AI to connect to live Reckon Accounts Hosted for modeling, searching, and visualizing.
-
Prepare, Blend, and Analyze Shortcut Data in Alteryx Designer (ODBC)
Build workflows to access live Shortcut for self-service data analytics.
-
Migrating data from ShipEngine to Snowflake using CData SSIS Components.
Easily push ShipEngine to Snowflake using the CData SSIS Tasks for ShipEngine and Snowflake.
-
Connect to Twilio Data in Aqua Data Studio
Access Twilio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous YouTube Analytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to AlloyDB.
-
Create Oracle Eloqua-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Eloqua Data from OutSystems and build custom enterprise apps using live Oracle Eloqua.
-
Create Data Visualizations in Cognos BI with Reckon Accounts Hosted Data
Access Reckon Accounts Hosted as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze CapsuleCRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CapsuleCRM from Power Pivot. You will use the Table Import Wizard to load CapsuleCRM. You can visually build the import query or use any SQL supported by the driver.
-
Access SAP Fieldglass Data from MySQL in PHP
Connect to SAP Fieldglass through the standard MySQL libraries in PHP.
-
Build Charts with SQL Server Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft SQL Server in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time ZohoDesk Data
Use CData Power BI Connectors to visualize ZohoDesk in Power BI.
-
How to Access Live SAP Data in Visual Studio Code via Cline
Run CData MCP Server for SAP on Windows Subsytem for Linux (WSL) and connect to live SAP ERP/NetWeaver from the Cline extension in Visual Studio Code.
-
Build Twilio Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Twilio and build visualizations in Tableau Cloud.
-
How to Query Live Testmonitor Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Testmonitor data in natural language using Python.
-
Create Reports from Facebook Ads Data in Looker Studio
Use CData Connect AI to gain access to live Facebook Ads and create custom reports in Looker Studio.
-
View Reports on Real-Time RSS Feeds in Power BI Report Server
Use the CData ODBC Driver for RSS to visualize RSS Feeds in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Goose with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ActiveCampaign from within the local AI agent.
-
Build Square-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Square to explore live Square Data in Cursor to assist with building Square-powered applications.
-
ETL BambooHR in Oracle Data Integrator
This article shows how to transfer BambooHR into a data warehouse using Oracle Data Integrator.
-
How to connect PolyBase to ZendeskSell
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZendeskSell.
-
Build Amazon DynamoDB-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon DynamoDB Data from Choreo and build custom apps using live Amazon DynamoDB.
-
Use the CData Software JDBC Driver for LaunchDarkly in MicroStrategy Web
Connect to LaunchDarkly in MicroStrategy Web using the CData Software JDBC Driver for LaunchDarkly.
-
Access Live Oracle HCM Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle HCM Cloud in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Seamlessly Import ScrapingBee Data into IBM SPSS Modeler
Integrate ScrapingBee data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Goose with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live MYOB AccountRight from within the local AI agent.
-
Visualize Live Drift Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Drift.
-
Connect to SAP Ariba Source Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Ariba Source Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build an OLAP Cube in SSAS from Tickspot Data
Establish a connection to Tickspot data from SQL Server Analysis Services, and use the Tickspot Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query, Visualize, and Share live Freshservice Data in Redash
Use CData Connect AI to connect to live Freshservice in Redash for querying, visualizing, and sharing.
-
DataBind Paylocity Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Paylocity with the DevExpress Windows Forms and Web controls to provide Paylocity to a chart.
-
Rapidly Develop Bitbucket-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 Bitbucket.
-
Calendly Reporting in OBIEE with the Calendly JDBC Driver
Deploy the Calendly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous MessageBird Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MessageBird replication to Google Cloud SQL.
-
Visualize Live Exact Online Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Exact Online.
-
Automated Continuous SharePoint Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SharePoint replication to Apache Kafka.
-
Connect to Kintone Data from PowerBuilder via JDBC
This article demonstrates how to access Kintone from PowerBuilder using the Kintone JDBC Driver.
-
Connect to Aweber Data in RazorSQL
Connect to Aweber from wizards and query Aweber from the GUI in the RazorSQL database management tool.
-
Stream Google Analytics Data into Apache Kafka Topics
Access and stream Google Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to work with Azure Data Catalog Data in Apache Spark using SQL
Access and process Azure Data Catalog Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Notion Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Notion. Leverage the pyodbc module for ODBC in Python.
-
Automate Todoist Data Replication to SAP HANA
Use CData Sync to customize and automate Todoist replication to SAP HANA.
-
Integrate with ServiceNow Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ServiceNow to a JSON file on disk.
-
Foursquare Reporting in OBIEE with the Foursquare JDBC Driver
Deploy the Foursquare JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Access Live Float Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Float enables you to integrate Float into workflows built using Microsoft Power Automate Desktop.
-
Create Dropbox Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dropbox data access from reports, embedded analytics, and more.
-
Connect to Exa Data in HULFT Integrate
Connect to Exa as a JDBC data source in HULFT Integrate
-
View Reports on Real-Time Amazon Athena Data in Power BI Report Server
Use the CData ODBC Driver for Amazon Athena to visualize Amazon Athena in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Excel Add-In for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sugar CRM.
-
Integrate with Live Power BI XMLA Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Power BI XMLA from the MuleSoft Anypoint Platform to integrate live Power BI XMLA into custom reports and dashboards.
-
How to Query Live MongoDB Data in Perplexity MacOS Desktop
Connect to and query live MongoDB Data in Perplexity Desktop using CData MCP Server.