CData Software - Knowledge Base
Recent Articles
-
How to import Microsoft Ads Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Ads in Data Import Handler and create an automated import of Microsoft Ads data to Apache Solr Enterprise Search platform.
-
Make API Requests with a Custom Shopify Admin API Token Using the CData Shopify Driver
Make secure API requests to Shopify using a custom Admin API access token with the CData Shopify JDBC Driver for seamless integration.
-
Build Voice Agents in ElevenLabs with access to Live IBM Cloud Object Storage Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live IBM Cloud Object Storage data.
-
Publish Flowlu-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Flowlu data.
-
Build Data Flows from Missive to SQL Server using SSIS
Easily back up Missive data to SQL Server using the SSIS components for Missive.
-
Validate Sage 200 Data with QuerySurge
Access and validate Sage 200 data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Mocean Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Mocean replication to delimited files (CSV/TSV).
-
Add Avaza Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Avaza with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to load Timely data into Elasticsearch via Logstash
Introducing a simple method to load Timely data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous SuiteCRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Apache Kafka.
-
Access Sugar CRM Data from MySQL in Amazon QuickSight
Connect to Sugar CRM and build visualizations of Sugar CRM data using a MySQL Connection in Amazon QuickSight.
-
Publish Deel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Deel data.
-
Manage SFTP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SFTP.
-
Build Optimizely Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Optimizely data and build visualizations in Tableau.
-
Connect to Neo4J Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Neo4J data in Airbyte.
-
Analyze Vimeo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Vimeo data with the CData JDBC Driver for Vimeo.
-
Prepare, Blend, and Analyze Sugar CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Sugar CRM data for self-service data analytics.
-
Connect to Pingdom Data from a Connection Pool in JBoss
Integrate Pingdom data into Java servlets: Use the Management Console in JBoss to install the Pingdom JDBC Driver.
-
A PostgreSQL Interface for Nuclia Data (MySQL Remoting via JDBC)
Use the Remoting features of the Nuclia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Creating Office 365-Connected Applications in Unqork
You can use CData Connect AI to feed Office 365 data to Unqork and build custom business apps.
-
Analyze Live Azure Synapse Data in SAS Viya
Use CData Connect AI to connect to Azure Synapse data from SAS Viya and deploy self-service analytics using live Azure Synapse data.
-
Integrating Sentry Data in Talend Cloud Data Management Platform
Connect Sentry Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access REST Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access REST data from your Oracle system.
-
Analyze HCL Domino Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HCL Domino data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Codat from Asprova with CData Software ODBC Driver for Codat
This article shows how to connect faster to Codat data from Asprova.
-
Paddle Reporting in OBIEE with the Paddle JDBC Driver
Deploy the Paddle JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create SSAS Tabular Models from SAP Data
How to build a SQL Server Analysis Service Tabular Model from SAP data using CData drivers.
-
Create Xero-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Xero Data from OutSystems and build custom enterprise apps using live Xero data.
-
Create a Data Access Object for Azure Analysis Services Data using JDBI
A brief overview of creating a SQL Object API for Azure Analysis Services data in JDBI.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy Desktop
Connect to Kafka data in MicroStrategy Desktop using the CData Software JDBC Driver for Kafka.
-
Create Reports from Jumpseller Data in Looker Studio
Use CData Connect AI to gain access to live Jumpseller data and create custom reports in Looker Studio.
-
Use the CData Software JDBC Driver for OData in MicroStrategy Desktop
Connect to OData services in MicroStrategy Desktop using the CData Software JDBC Driver for OData.
-
Connect to Everhour Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Everhour to connect to Everhour data and execute queries in PowerBuilder.
-
DataBind XML Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for XML with the DevExpress Windows Forms and Web controls to provide XML data to a chart.
-
Build SuiteCRM-Connected Apps in Choreo
Use CData Connect AI to connect to SuiteCRM Data from Choreo and build custom apps using live SuiteCRM data.
-
A PostgreSQL Interface for Klipfolio Data using the CData ODBC Driver
Use the SQL Gateway and Klipfolio ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Twitter Ads Data into Apache Solr
Use the CData Software JDBC Driver for Twitter Ads in Data Import Handler and create an automated import of Twitter Ads data to Apache Solr Enterprise Search platform.
-
Access Snowflake Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Snowflake data from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Paddle
Provide connectivity to Paddle data through an SAP BusinessObjects universe.
-
Connect to Helpscout Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Helpscout data using standard SQL.
-
Prepare, Blend, and Analyze CSV Data in Alteryx Designer (ODBC)
Build workflows to access live CSV data for self-service data analytics.
-
How to Build an ETL App for DB2 Data in Python with CData
Create ETL applications and real-time data pipelines for DB2 data in Python with petl.
-
Connect to Campaigner Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Campaigner and work with Campaigner data in your FileMaker applications.
-
Access Live Sage 200 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage 200 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live Google Forms Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Forms from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Forms data.
-
Automated Continuous SAP Business One Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Business One data replication to OneLake in Microsoft Fabric.
-
How to Connect to Live QuickBooks Time Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your QuickBooks Time data for you.
-
Prepare, Blend, and Analyze SAP Business One Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Business One data for self-service data analytics.
-
Visualize Live Pingdom Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pingdom data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Viewing Impala Data in RAD Studio Data Explorer
How to view Impala data in RAD Studio Data Explorer using the CData ODBC Driver for Impala.
-
Connect to Azure Table Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Azure Table data.
-
How to Access Live Tickspot Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tickspot enables you to integrate Tickspot data into workflows built using Microsoft Power Automate Desktop.
-
Reckon Reporting in OBIEE with the Reckon JDBC Driver
Deploy the Reckon JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Tableau Connector for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Analytics.
-
How to connect to PagerDuty Data with Squirrel SQL client
Connect to PagerDuty data and execute queries in the Squirrel SQL Client.
-
Object-Relational Mapping (ORM) with Sage Intacct 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 Sage Intacct data into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for CampaignMonitor in MicroStrategy Web
Connect to CampaignMonitor data in MicroStrategy Web using the CData Software ODBC Driver for CampaignMonitor.
-
Visualize MailerSend Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailerSend data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for NetSuite
Provide connectivity to NetSuite data through an SAP BusinessObjects universe.
-
Access Live FHIR Data in Coginiti Pro
Connect to and query live FHIR data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to import XML Data into Apache Solr
Use the CData Software JDBC Driver for XML in Data Import Handler and create an automated import of XML data to Apache Solr Enterprise Search platform.
-
Load Google Contacts Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Contacts data to a database.
-
Automated Continuous Discourse Replication to SQLite
Use CData Sync for automated, continuous, customizable Discourse replication to SQLite.
-
Build Shortcut Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Shortcut data and build visualizations in Tableau.
-
Connect to ZeroBounce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZeroBounce data in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Freshteam Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Freshteam data through natural language.
-
How to Connect to Live SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
Build Dashboards with CSV Data in DBxtra
Create dynamic dashboards and perform analytics based on CSV data in DBxtra.
-
Integrating GitHub Copilot with Postmark 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.
-
DataBind Bullhorn CRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Bullhorn CRM with the DevExpress Windows Forms and Web controls to provide Bullhorn CRM data to a chart.
-
Query, Visualize, and Share live Bullhorn CRM Data in Redash
Use CData Connect AI to connect to live Bullhorn CRM data in Redash for querying, visualizing, and sharing.
-
Feed ZohoDesk Data into FineReport
How to set ZohoDesk data as a JDBC data source in FineReport.
-
Connect to ZohoPeople Data from Crystal Reports
Use CData Connect AI to connect to and report on live ZohoPeople data from Crystal Reports.
-
How to Connect the Power BI Service to Bright Data: Complete Guide
Connect to the CData Software Power BI Connector for Bright Data from PowerBI.com to provide real-time Bright Data data across the organization.
-
Build MVC Applications with Connectivity to Azure Data Catalog Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Data Catalog from an ASP.NET MVC application.
-
Integrate Dify with Live ClickUp 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 ClickUp data.
-
Connect Missive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Missive data using the CData Python MCP Server.
-
Link Bright Data with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bright Data data in Filemaker Pro for Mac or Windows.
-
Add Google Campaign Manager 360 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Campaign Manager 360 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Sybase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sybase replication to Apache Kafka.
-
Create a Data Access Object for Dynamics CRM Data using JDBI
A brief overview of creating a SQL Object API for Dynamics CRM data in JDBI.
-
Create Data Visualizations in Cognos BI with Rootly Data
Access Rootly data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use ChatGPT to Talk to Your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Shopify data for you.
-
Choosing the Best Method to Connect Cassandra to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Cassandra data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze xBase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of xBase data and visualize live xBase data in Infragistics Reveal.
-
View Reports on Real-Time Freshsales Data in Power BI Report Server
Use the CData ODBC Driver for Freshsales to visualize Freshsales data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Yelp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Yelp data and build web apps with connectivity to live Yelp data.
-
Automated Continuous Mocean Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mocean replication to AlloyDB.
-
Process & Analyze FreeAgent Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FreeAgent Data.
-
Automated Continuous ZohoInvoice Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to IBM DB2.
-
Integrate Dropbox Data in Pentaho Data Integration
Build ETL pipelines based on Dropbox data in the Pentaho Data Integration tool.
-
Design BIRT Reports on BambooHR Data
Provide current BambooHR data to your embedded analytics.
-
Create Reckon-Connected Business Apps in AppSheet
Connect to Reckon Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Reckon data.
-
Create CouchDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to CouchDB Data from Klipfolio and build custom visualizations using live CouchDB data.
-
Integrating Cursor with Jira Assets 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.
-
Automate ADP Data Replication to SAP HANA
Use CData Sync to customize and automate ADP data replication to SAP HANA.
-
How to Create Power BI Visual Reports with Real-Time IBM Informix Data
Use CData Power BI Connectors to visualize IBM Informix data in Power BI.
-
Bind Live Confluence Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Confluence data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
DataBind Controls to Google Analytics Data in Delphi
DataBind to Google Analytics data in Delphi with standard data access components and controls.
-
How to integrate Metabase with SingleStore Data
Use CData Connect AI to connect to live SingleStore data and create an interactive dashboard in Metabase from SingleStore data.