CData Software - Knowledge Base
Recent Articles
-
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.
-
Use the CData API Server to Access ActiveCampaign Data in Microsoft PowerPivot
Use the CData API Server to connect to live ActiveCampaign in the Power Pivot business intelligence tool.
-
Build a Simple VCL Application for Sage Cloud Accounting Data
How to build a simple VCL Application to view Sage Business Cloud Accounting 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 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 into a Java-based ORM framework, Hibernate.
-
Connect to and Query Amazon Marketplace Data in QlikView over ODBC
Create data visualizations with Amazon Marketplace 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
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Cloud Object Storage
Provide connectivity to IBM Cloud Object Storage through an SAP BusinessObjects universe.
-
Bridge Apify Connectivity with Apache NiFi
Access and process Apify 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 Accounting 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 Microsoft OneNote 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 in Python.
-
Integrate Klipfolio Data in Pentaho Data Integration
Build ETL pipelines based on Klipfolio 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 ERP.
-
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 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.
-
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 for modeling, searching, and visualizing.
-
DataBind Charts to Ontraport Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Ontraport 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
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Active Directory 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 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 in MicroStrategy Developer using the CData Software ODBC Driver for Monday.com.
-
Extend Google Sheets with Basecamp Data
Make calls to Basecamp from Google Apps Script via the API Server.
-
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 into Tableau Cloud dashboards using the Tableau Bridge.
-
Bridge Zoho Inventory Connectivity with Apache NiFi
Access and process Zoho Inventory 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 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 Azure Cosmos DB into workflows built using Microsoft Power Automate Desktop.
-
Connect to Spark Data in Jaspersoft Studio
Execute SQL to remote Apache Spark SQL in Jaspersoft Studio.
-
Build Mouseflow-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mouseflow and build web apps with connectivity to live Mouseflow.
-
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 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 for self-service data analytics.
-
Visualize Neo4J Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Neo4J.
-
Use the CData Software ODBC Driver for Azure Data Catalog in MicroStrategy Web
Connect to Azure Data Catalog 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 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 and integrate live ActiveCampaign into apps built in Microsoft Power Apps.
-
Explore Geographical Relationships in Moosend Data with Power Map
Create data visualizations with Moosend 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 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 in JDBI.
-
Connect to Rootly Data in NetBeans
Connect to Rootly 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.
-
Automate Google Forms Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Forms from PowerShell? This article demonstrates how to utilize the Google Forms Cmdlets for tasks like connecting to Google Forms, 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 Query Live JSON Services in Claude Desktop
Connect to and query live JSON Services in Claude Desktop using CData MCP Server.
-
How to Connect to Live Databricks Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Databricks 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 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 for you.
-
Create a Data Access Object for ConvertAPI Data using JDBI
A brief overview of creating a SQL Object API for ConvertAPI 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 in the Pentaho Data Integration tool.
-
Integrate with Clari Data in JReport Designer
Create charts and reports based on Clari in JReport Designer.
-
Integrating Cursor CLI 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.
-
How to connect to Autopilot Data in DBVisualizer
Integrate Autopilot with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Basecamp Data in DBArtisan
Use wizards in DBArtisan to configure Basecamp 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 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.
-
Access Live ADP Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ADP into the statistical analysis tools available in SAS JMP. This article shows how to use ADP 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 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 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 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 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 in Power BI Desktop.
-
DataBind Controls to Optimizely Data in Delphi
DataBind to Optimizely in Delphi with standard data access components and controls.
-
How to Easily Query Presto Data in OpenOffice Base
Connect to Presto data in OpenOffice Base using the CData ODBC Driver for Presto and generate reports with live data insights.
-
Bridge SAS xpt Connectivity with Apache NiFi
Access and process SAS XPORT in Apache NiFi using the CData JDBC Driver.
-
Visualize Amazon DynamoDB Data in TIBCO Spotfire through ADO.NET
Integrate Amazon DynamoDB into dashboards in TIBCO Spotfire.
-
Visualize Google Contacts Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Contacts.
-
Replicate Google Forms Data to Multiple Databases
Replicate Google Forms to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Adobe Target in a Connection Pool in Tomcat
Connect to Adobe Target from a connection pool in Tomcat.
-
Automate Zoho Books Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Books replication to Couchbase.
-
How to Build an ETL App for PayPal Data in Python with CData Connect AI
Build ETL pipelines that read and write live PayPal in Python with petl and the CData Connect AI Python SDK.
-
Easily Integrate Parquet Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Parquet in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use Azure AI Foundry to Talk to Your Cvent 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 Cvent for you.
-
Integrate with PingOne Data in JReport Designer
Create charts and reports based on PingOne in JReport Designer.
-
DataBind Microsoft Teams Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Teams with the DevExpress Windows Forms and Web controls to provide Microsoft Teams to a chart.
-
Getting Started with the CData JDBC Driver for Tavily
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tavily.
-
Getting Started with the CData Python Connector for Exact Online
Learn to install and license the CData Python Connector
-
Connect to CockroachDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live CockroachDB from Filemaker Pro on Mac.
-
How to create CapsuleCRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CapsuleCRM in MySQL .
-
How to Connect to Pipeliner CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipeliner CRM. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations in Cognos BI with Snapchat Ads Data
Access Snapchat Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up Marketo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Marketo. In this article, we will employ an SSIS workflow to populate a database with Marketo data.
-
Build Greenhouse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Greenhouse and build visualizations in Tableau Cloud.