CData Software - Knowledge Base
Recent Articles
-
Consume Xero OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Xero feeds that reflect any changes in SAP Lumira.
-
Connect to SAP HANA XS Advanced Data in RazorSQL
Connect to SAP HANA XS Advanced from wizards and query SAP HANA XS Advanced data from the GUI in the RazorSQL database management tool.
-
Perform Batch Operations with Highrise Data in Apache NiFi
Connect to Highrise data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Azure Synapse Data in AWS Lambda
Connect to live Azure Synapse data in AWS Lambda using the CData JDBC Driver.
-
How to connect and process MariaDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MariaDB data.
-
Automated Continuous GitLab Replication to SQL Server
Use CData Sync for automated, continuous, customizable GitLab replication to SQL Server.
-
Replicate Redis Data in Heroku for Use in Salesforce Connect
Replicate Redis data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to CircleCI Data from IntelliJ
Integrate connectivity to CircleCI data with wizards in IntelliJ.
-
Use Dash to Build to Web Apps on Square Data
Create Python applications that use pandas and Dash to build Square-connected web apps.
-
Build Strava-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Strava data.
-
How to Query Webex Data in MySQL Workbench
Execute MySQL queries against live Webex data from MySQL Workbench.
-
Use the CData Software ODBC Driver for Toggl in SAS for Real-Time Reporting and Analytics
Connect to real-time Toggl data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Toggl.
-
Automated Continuous Google Calendar Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to PostgreSQL.
-
Build Apps with Live TigerGraph Data Using the Low-Code Development Platform of Mendix
Connect TigerGraph data with Mendix to build apps using the CData JDBC Driver for TigerGraph.
-
Build Semantic Layer Views for Impala Data in APOS Live Data Gateway
Use the CData Connector for Impala in APOS Live Data Gateway to build Semantic Layer Views for Impala data.
-
How to connect to SQL Analysis Services Data from Spring Boot
Connect to SQL Analysis Services in a Spring Boot Application using the CData JDBC Driver for SQL Analysis Services
-
Automated Continuous Lakebase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Lakebase replication to MongoDB.
-
Operational Reporting on SAP Hybris C4C Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Hybris C4C data.
-
Build a Simple VCL Application for Sage Cloud Accounting Data
How to build a simple VCL Application to view Sage Cloud Accounting data in RAD Studio using the CData ODBC Driver for Sage Cloud Accounting.
-
Connect BambooHR to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BambooHR with IBM WebSphere for seamless data integration and connectivity.
-
Use Biml to Build SSIS Tasks to Replicate SuiteCRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SuiteCRM data to SQL Server.
-
Object-Relational Mapping (ORM) with PhantomBuster 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 PhantomBuster data into a Java-based ORM framework, Hibernate.
-
Connect to and Query Amazon Marketplace Data in QlikView over ODBC
Create data visualizations with Amazon Marketplace data in QlikView.
-
Bind Live eBay Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live eBay data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Cloud Object Storage
Provide connectivity to IBM Cloud Object Storage data through an SAP BusinessObjects universe.
-
Bridge Apify Connectivity with Apache NiFi
Access and process Apify data in Apache NiFi using the CData JDBC Driver.
-
Integrate with Xero Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Xero data in SnapLogic.
-
Integrate Goose with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live OneNote data from within the local AI agent.
-
How to Visualize Microsoft Exchange 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 Exchange data in Python.
-
Create Timely-Connected Business Apps in AppSheet
Connect to Timely Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Timely data.
-
Integrate Klipfolio Data in Pentaho Data Integration
Build ETL pipelines based on Klipfolio data in the Pentaho Data Integration tool.
-
Publish Odoo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Odoo data.
-
Create Dynamic Sentry Grids Using the Infragistics XamDataGrid
Learn how you can connect Sentry to Infragistics XamDataGrid to build dynamic grids.
-
Excel Spreadsheet Automation on Amazon Athena Data with the QUERY Formula
Pull data from Amazon Athena, automate spreadsheets, and more with the QUERY formula.
-
How to Use a Microsoft Access Database to Update GitHub Data in Real Time
Update GitHub data by creating a linked table in Microsoft Access with the CData GitHub ODBC Driver.
-
Visualize eBay Data in TIBCO Spotfire through OData
Integrate eBay data into dashboards in TIBCO Spotfire.
-
Build Sybase IQ-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sybase IQ data.
-
Add RabbitMQ Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for RabbitMQ with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model, Search, and Visualize Live Google Directory Data in ThoughtSpot
Use CData Connect AI to connect to live Google Directory data for modeling, searching, and visualizing.
-
DataBind Charts to Ontraport Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Ontraport 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.
-
Integrate Google's Antigravity Agent with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Active Directory data using the Model Context Protocol.
-
Integrating Google Search Results in Talend Cloud Data Management Platform
Connect Google Search Results with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Search.
-
Use the CData Software ODBC Driver for Bitbucket in MicroStrategy
Connect to Bitbucket data in MicroStrategy Developer using the CData Software ODBC Driver for Bitbucket.
-
Use the CData Software ODBC Driver for Monday.com in MicroStrategy
Connect to Monday.com data in MicroStrategy Developer using the CData Software ODBC Driver for Monday.com.
-
Establish a Live Connection with IBM Cloud Object Storage Data using Tableau Bridge
The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate live IBM Cloud Object Storage data into Tableau Cloud dashboards using the Tableau Bridge.
-
Bridge Zoho Inventory Connectivity with Apache NiFi
Access and process Zoho Inventory data in Apache NiFi using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Salesloft Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesloft data to SQL Server.
-
How to load ZohoDesk data into Elasticsearch via Logstash
Introducing a simple method to load ZohoDesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build AI/ML Models with Live Slack Data using Dataiku
Connect Slack Data with Dataiku using the CData JDBC Driver for Slack.
-
How to Access Live Cosmos DB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cosmos DB enables you to integrate Cosmos DB data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Spark Data in Jaspersoft Studio
Execute SQL to remote Spark data in Jaspersoft Studio.
-
Build Mouseflow-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mouseflow data and build web apps with connectivity to live Mouseflow data.
-
How to connect to Cloudflare Data from Spring Boot
Connect to Cloudflare in a Spring Boot Application using the CData API Driver for JDBC
-
Consume WooCommerce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on WooCommerce feeds that reflect any changes in SAP Lumira.
-
Integrating Claude Code with Basecamp Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Basecamp data within assisted coding and automated development workflows.
-
Prepare, Blend, and Analyze SAP Concur Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Concur data for self-service data analytics.
-
Visualize Neo4J Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Neo4J data.
-
Use the CData Software ODBC Driver for Azure Data Catalog in MicroStrategy Web
Connect to Azure Data Catalog data in MicroStrategy Web using the CData Software ODBC Driver for Azure Data Catalog.
-
Seamlessly Bring HBase Data into Retool Using CData Connect AI
Integrate HBase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Stream Zuora Data into Apache Kafka Topics
Access and stream Zuora data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous IBM Informix Replication to MongoDB
Use CData Sync for automated, continuous, customizable IBM Informix replication to MongoDB.
-
Integrate Live ActiveCampaign Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ActiveCampaign data and integrate live ActiveCampaign data into apps built in Microsoft Power Apps.
-
Explore Geographical Relationships in Moosend Data with Power Map
Create data visualizations with Moosend data in Power Map.
-
Automated Continuous Drip Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Drip replication to Amazon S3.
-
Feed Qualaroo Data into FineReport
How to set Qualaroo data as a JDBC data source in FineReport.
-
Create a Data Access Object for Tickspot Data using JDBI
A brief overview of creating a SQL Object API for Tickspot data in JDBI.
-
Connect to Rootly Data in NetBeans
Connect to Rootly data in NetBeans with the data source configuration wizard.
-
Publish Reports with ScrapingBee Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ScrapingBee data.
-
Integrate OpenCode with Live Apify Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Apify data from within your AI coding agent.
-
Automate Google Forms Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Forms data from PowerShell? This article demonstrates how to utilize the Google Forms Cmdlets for tasks like connecting to Google Forms data, automating operations, downloading data, and more.
-
How to work with Adobe Analytics Data in Apache Spark using SQL
Access and process Adobe Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Databricks Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Databricks data without replication.
-
Connect to Real-Time FreeAgent Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use FreeAgent data in Power Apps.
-
Excel Spreadsheet Automation on SAP HANA XS Advanced Data with the QUERY Formula
Pull data from SAP HANA XS Advanced, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live Redis Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Redis data for you.
-
Connect to Pinterest Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Pinterest Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create a Data Access Object for ConvertAPI Data using JDBI
A brief overview of creating a SQL Object API for ConvertAPI data in JDBI.
-
How to Work with Pinterest Data in AWS Glue Jobs Using JDBC
Connect to Pinterest from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Browserless Data in Pentaho Data Integration
Build ETL pipelines based on Browserless data in the Pentaho Data Integration tool.
-
Build SQL Server-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SQL Server data without replication.
-
Integrate with Clari Data in JReport Designer
Create charts and reports based on Clari data in JReport Designer.
-
Integrating Cursor with SageHR 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.
-
Access Google Ads Data from MySQL in PHP
Connect to Google Ads through the standard MySQL libraries in PHP.
-
Visualize Live Reckon Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Reckon data into custom reports in Power BI.
-
How to connect to Autopilot Data in DBVisualizer
Integrate Autopilot data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Sendwithus Data from AWS Glue
Use CData Connect AI to gain access to live Sendwithus data from your AWS Glue jobs.
-
Connect to Basecamp Data in DBArtisan
Use wizards in DBArtisan to configure Basecamp data as a data source.
-
Connect to Avro Data in HULFT Integrate
Connect to Avro as a JDBC data source in HULFT Integrate
-
Use Microsoft Copilot Studio to talk to your Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Amazon Marketplace data for you.
-
Publish Reports with Freshsales Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshsales data.
-
Access Live ADP Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ADP data into the statistical analysis tools available in SAS JMP. This article shows how to use ADP data in the Graph Builder and Query Builder.
-
LINQ to Oracle Service Cloud Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Oracle Service Cloud Data Provider.
-
Stream PingOne Data into Apache Kafka Topics
Access and stream PingOne data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for PabblySubscriptions in MicroStrategy Desktop
Connect to PabblySubscriptions data in MicroStrategy Desktop using the CData Software JDBC Driver for PabblySubscriptions.
-
Automated Continuous Impala Replication to Oracle
Use CData Sync for automated, continuous, customizable Impala replication to Oracle.
-
Automated Continuous Close Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Close replication to Google Cloud SQL.
-
Automated Continuous Front Replication to Databricks
Use CData Sync for automated, continuous, customizable Front replication to Databricks.
-
Import and Visualize Workable Data in Power View
Create data visualizations based on Workable data in Excel.
-
Create Informatica Mappings From/To a JDBC Data Source for Coda
Create Coda data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Power BI Reports on Real-Time Microsoft Teams Data
Use the CData ODBC Driver for Microsoft Teams to visualize Microsoft Teams data in Power BI Desktop.