CData Software - Knowledge Base
Recent Articles
-
How to work with Google Search Results in Apache Spark using SQL
Access and process Google Search Results in Apache Spark using the CData Software JDBC Driver.
-
Integrate Impala Data into Power Automate Desktop using CData Connect
CData Connect for Impala Data enables you to integrate Impala data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple Unbounce Accounts
Replicate multiple Unbounce accounts to one or many databases.
-
Automated Continuous Freshservice Replication to Oracle
Use CData Sync for automated, continuous, customizable Freshservice replication to Oracle.
-
How to Visualize Shippo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Shippo data in Python.
-
Integrate with ZohoSubscriptions Data in JReport Designer
Create charts and reports based on ZohoSubscriptions data in JReport Designer.
-
Build Dashboards with Wistia Data in Dundas BI
Create dynamic dashboards and perform analytics based on Wistia data in Dundas BI.
-
How to publish and share Nuclia Data dashboards with Tableau Server
The CData ODBC driver for Nuclia enables you integrate Nuclia data into Tableau dashboards.
-
Object-Relational Mapping (ORM) with Aha! 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 Aha! data into a Java-based ORM framework, Hibernate.
-
Access SAS xpt Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAS xpt data from your Oracle system.
-
Migrating data from Google Cloud Storage to Databricks using CData SSIS Components.
Easily push Google Cloud Storage data to Databricks using the CData SSIS Tasks for Google Cloud Storage and Databricks.
-
Connect to Microsoft Teams Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Teams data from your AWS Glue jobs.
-
Connect to Epicor Kinetic in SpagoBI
Create reports featuring live Epicor Kinetic data in SpagoBI Studio. Host Epicor Kinetic reports on SpagoBI Server.
-
Create Testmonitor Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Testmonitor from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to integrate PagerDuty with Apache Airflow
Access and process PagerDuty data in Apache Airflow using the CData JDBC Driver.
-
Query Exa Data as a MySQL Database in Node.js
Execute MySQL queries against Exa data from Node.js.
-
Getting Started with the CData Power BI Connector for Instantly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Google's Antigravity Agent with Live Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Mode data using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Demio in MicroStrategy Web
Connect to Demio data in MicroStrategy Web using the CData Software ODBC Driver for Demio.
-
Access Live SAP Business One Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business One data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Amazon Marketplace from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon Marketplace to connect to Amazon Marketplace data from Web applications running on WebLogic.
-
Connect to Mixpanel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mixpanel data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Prepare, Blend, and Analyze Sage Intacct Data in Alteryx Designer (Connect AI)
Build workflows to access live Sage Intacct data for self-service data analytics.
-
Analyze Cvent Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cvent data in Microsoft R Open.
-
How to Query Live Tally Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tally data data in natural language using Python.
-
Import Real-Time Box Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Box data in ColdFusion.
-
Connect to Dynamics 365 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Dynamics 365 data from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365.
-
Natively Connect to Amazon DynamoDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon DynamoDB data. Leverage the native support for ODBC in PHP.
-
Query Landbot Data in DataGrip
Create a Data Source for Landbot in DataGrip and use SQL to query live Landbot data.
-
Visualize Helpscout 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 Helpscout data into TIBCO Spotfire.
-
Automate Microsoft Exchange Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Exchange data replication to SAP HANA.
-
Create Data Visualizations in Cognos BI with CampaignMonitor Data
Access CampaignMonitor data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access MailChimp Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MailChimp data from your Oracle system.
-
Natively Connect to Humanity Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Humanity data. Leverage the native support for ODBC in PHP.
-
How to Work with Oracle Financials Cloud Data in AWS Glue Jobs Using JDBC
Connect to Oracle Financials Cloud from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Goose with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Twitter Ads data from within the local AI agent.
-
Integrate iContact Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live iContact data from Informatica Cloud.
-
Create Dynamic Databricks Grids Using the Infragistics XamDataGrid
Learn how you can connect Databricks to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Charts to Oracle HCM Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle HCM Cloud data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to integrate Klaviyo with Apache Airflow
Access and process Klaviyo data in Apache Airflow using the CData JDBC Driver.
-
Easily Integrate Wistia Data in Lazarus Pascal IDE
Learn how to easily integrate live Wistia data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to ElevenLabs Data in Delphi
DataBind to ElevenLabs data in Delphi with standard data access components and controls.
-
Integrate Live Gumroad Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gumroad data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Chargebee in SAS for Real-Time Reporting and Analytics
Connect to real-time Chargebee data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Chargebee.
-
Working with Keap Data in LINQPad
Execute LINQ queries to Keap data in LINQPad.
-
Integrating ConvertAPI Data in Talend Cloud Data Management Platform
Connect ConvertAPI Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Creating Mode-Connected Applications in Unqork
You can use CData Connect AI to feed Mode data to Unqork and build custom business apps.
-
Publish Crystal Reports on Splunk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Splunk data.
-
Visualize Live AgileCRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AgileCRM data.
-
Easily Integrate Elorus Data in Lazarus Pascal IDE
Learn how to easily integrate live Elorus data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query Dynamics NAV Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics NAV entities in PHP by modeling them as objects.
-
How to integrate Metabase with ServiceDesk Plus Data
Use CData Connect AI to connect to live ServiceDesk Plus data and create an interactive dashboard in Metabase from ServiceDesk Plus data.
-
How to Connect DBeaver to LDAP via a JDBC Driver
Manage LDAP objects with visual tools in DBeaver like the query browser.
-
Build Apps with Live Spotify Data Using the Low-Code Development Platform of Mendix
Connect Spotify data with Mendix to build apps using the CData API Driver for JDBC.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for eBay Analytics
Provide connectivity to eBay Analytics data through an SAP BusinessObjects universe.
-
Connect to Google Search Results in RazorSQL
Connect to Google Search from wizards and query Google Search results from the GUI in the RazorSQL database management tool.
-
Easily Integrate Google Contacts Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Contacts data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Live Google Directory Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Directory from the MuleSoft Anypoint Platform to integrate live Google Directory data into custom reports and dashboards.
-
How to Connect Zoho Projects Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Zoho Projects data in real time using natural language.
-
Extract, Transform, and Load BambooHR Data in Informatica PowerCenter
Create a simple Workflow for BambooHR data in Informatica PowerCenter.
-
Visualize Live LightSpeedRetail Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LightSpeedRetail data.
-
DataBind Google Forms Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Google Forms data to a chart.
-
Integrate Live Cvent 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 Cvent data from within the IDE.
-
Connect to Outreach.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Outreach.io as an External Source in Dremio.
-
Connect to Google Tasks Data in CloverDX (formerly CloverETL)
Transfer Google Tasks data using the visual workflow in the CloverDX data integration tool.
-
Integrate PDFMonkey Data in Pentaho Data Integration
Build ETL pipelines based on PDFMonkey data in the Pentaho Data Integration tool.
-
Analyze Suadeo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Suadeo from Power Pivot. You will use the Table Import Wizard to load Suadeo data. You can visually build the import query or use any SQL supported by the driver.
-
Microsoft Exchange Reporting in OBIEE with the Microsoft Exchange JDBC Driver
Deploy the Microsoft Exchange JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Cvent Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Cvent and the Script function in FileMaker Pro to connect to Cvent and work with Cvent data in your FileMaker application.
-
Use the CData Software JDBC Driver for CapsuleCRM in MicroStrategy Desktop
Connect to CapsuleCRM data in MicroStrategy Desktop using the CData Software JDBC Driver for CapsuleCRM.
-
Prepare, Blend, and Analyze Apify Data in Alteryx Designer (Connect AI)
Build workflows to access live Apify data for self-service data analytics.
-
Import Real-Time Aircall Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aircall data in ColdFusion.
-
Interact with Live IBM Informix Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live IBM Informix data.
-
Connecting Pipedream with Paylocity Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Paylocity data in real time.
-
Bridge Google Forms Connectivity with Apache NiFi
Access and process Google Forms data in Apache NiFi using the CData JDBC Driver.
-
Automate Aircall Data Replication to Couchbase
Use CData Sync to Customize and automate Aircall data replication to Couchbase.
-
Create Dynamic Scrapfly Grids Using the Infragistics XamDataGrid
Learn how you can connect Scrapfly to Infragistics XamDataGrid to build dynamic grids.
-
Create a Data Access Object for Notion Data using JDBI
A brief overview of creating a SQL Object API for Notion data in JDBI.
-
Access Perigon 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 Perigon data.
-
Publish Drip-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Drip data.
-
Integrating GitHub Copilot with Autopilot 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.
-
Automated Continuous SpaceX Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SpaceX replication to Amazon Redshift.
-
Visualize Live Pinecone Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinecone data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Antigravity CLI with Google Ads data via CData CLI
Connect Google Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Tableau Connector for Zendesk
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zendesk.
-
Feed HDFS Data into FineReport
How to set HDFS data as a JDBC data source in FineReport.
-
Connect to Mouseflow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mouseflow and the SQL Gateway to access Mouseflow data from Google Apps Script.
-
How to load IBM Informix data into Elasticsearch via Logstash
Introducing a simple method to load IBM Informix data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous JotForm Replication to SQL Server
Use CData Sync for automated, continuous, customizable JotForm replication to SQL Server.
-
Replicate Tickspot Data from PowerShell
Write a quick PowerShell script to query Tickspot data. Use connectivity to the live data to replicate Tickspot data to SQL Server.
-
Using the CData Software ODBC Driver for Basecamp in PyCharm
Connect to Basecamp as an ODBC data source in PyCharm using the CData Software ODBC Driver for Basecamp.
-
Query FreshBooks Data in DataGrip
Create a Data Source for FreshBooks in DataGrip and use SQL to query live FreshBooks data.
-
Connect to Live SurveyMonkey Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SurveyMonkey in CData Connect AI and connect to your SurveyMonkey data from PostgreSQL.
-
Use the CData Software ODBC Driver for Salesforce Marketing in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Marketing data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Marketing.
-
Publish eBay-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live eBay data.
-
How to Connect Flowise AI Agents to Live Lakebase Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Lakebase data without replication.
-
Automated Continuous RSS Replication to SQLite
Use CData Sync for automated, continuous, customizable RSS replication to SQLite.
-
Feed Databricks Data into FineReport
How to set Databricks data as a JDBC data source in FineReport.
-
Automate SQL Analysis Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SQL Analysis Services data from PowerShell? This article demonstrates how to utilize the SQL Analysis Services Cmdlets for tasks like connecting to SQL Analysis Services data, automating operations, downloading data, and more.
-
Automated Continuous Cloudant Replication to Databricks
Use CData Sync for automated, continuous, customizable Cloudant replication to Databricks.