CData Software - Knowledge Base
Recent Articles
-
PayPal Reporting in OBIEE with the PayPal JDBC Driver
Deploy the PayPal JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Informatica Mappings From/To an ODBC Data Source for Paymo
Create an ODBC connection to Paymo in Informatica and browse and transfer Paymo data.
-
Connect Printify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Printify data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for Sendwithus
Create Sendwithus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for ZohoDesk in MicroStrategy Web
Connect to ZohoDesk data in MicroStrategy Web using the CData Software ODBC Driver for ZohoDesk.
-
How to use SQLAlchemy ORM to access GitLab Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GitLab data.
-
Analyze Google Campaign Manager 360 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Campaign Manager 360 data in Microsoft R Open.
-
Connect to PhantomBuster Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PhantomBuster data.
-
Interact with Live XML Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live XML data.
-
Create SSAS Tabular Models from Demio Data
How to build a SQL Server Analysis Service Tabular Model from Demio data using CData drivers.
-
How to connect to OnePageCrm Data from IntelliJ
Integrate connectivity to OnePageCrm data with wizards in IntelliJ.
-
Automated Continuous Google Sheets Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Sheets replication to SQL Server.
-
Connect to Bannerbear Data from HeidiSQL
Use CData Connect AI to connect to and query live Bannerbear data from HeidiSQL.
-
Connect to Apollo Data in RapidMiner
Integrate Apollo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Tableau Connector for Productboard
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Import Real-Time Google Ad Manager Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Ad Manager data in ColdFusion.
-
How to Connect to Live Apify 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 Apify data for you.
-
Query Live Dropbox Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Dropbox data through a conversational interface.
-
Build AI/ML Models with Live Nethunt Data using Dataiku
Connect Nethunt Data with Dataiku using the CData API Driver for JDBC.
-
How to Access Spotify Data Using Entity Framework
This article shows how to access Spotify data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dashboards and Visualize Live IBM Cloud Object Storage Data in Geckoboard
Use CData Connect AI to connect to live IBM Cloud Object Storage data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Tavily Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Tavily replication to delimited files (CSV/TSV).
-
Choosing the Best Method to Connect Pingdom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pingdom data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Pipedrive Data from MySQL in PHP
Connect to Pipedrive through the standard MySQL libraries in PHP.
-
Automated Continuous Nethunt Replication to MongoDB
Use CData Sync for automated, continuous, customizable Nethunt replication to MongoDB.
-
Automated Continuous PagerDuty Replication to MySQL
Use CData Sync for automated, continuous, customizable PagerDuty replication to MySQL.
-
Build Semantic Layer Views for HubSpot Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HubSpot data.
-
How to integrate Printful with Apache Airflow
Access and process Printful data in Apache Airflow using the CData JDBC Driver.
-
Connect to Active Directory in SpagoBI
Create reports featuring live Active Directory data in SpagoBI Studio. Host Active Directory reports on SpagoBI Server.
-
Use Databricks Agent Bricks to Talk to Your xBase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your xBase data for you.
-
Publish Crystal Reports on Foursquare Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Foursquare data.
-
Connect to HDFS Data from HeidiSQL
Use CData Connect AI to connect to and query live HDFS data from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jumpseller
Provide connectivity to Jumpseller data through an SAP BusinessObjects universe.
-
Automated Continuous Mixpanel Replication to Vertica
Use CData Sync for automated, continuous, customizable Mixpanel replication to Vertica.
-
Replicate Multiple MYOB AccountRight Accounts via the CData Sync CLI
Replicate multiple MYOB AccountRight accounts to one or many databases.
-
Feed Adobe Commerce Data into FineReport
How to set Adobe Commerce data as a JDBC data source in FineReport.
-
Connect to Bitbucket from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bitbucket to connect to Bitbucket data from Web applications running on WebLogic.
-
How to connect to Placid Data with Squirrel SQL client
Connect to Placid data and execute queries in the Squirrel SQL Client.
-
Integrating Cursor with LeadDesk 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.
-
Use the CData Software ODBC Driver for Close in MicroStrategy
Connect to Close data in MicroStrategy Developer using the CData Software ODBC Driver for Close.
-
Use Microsoft Copilot Studio to talk to your Discord 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 Discord data for you.
-
Automate Avaza Data Replication to SAP HANA
Use CData Sync to customize and automate Avaza data replication to SAP HANA.
-
Automated Continuous Mode Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mode replication to PostgreSQL.
-
Publish Reports with QuickBooks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP ByDesign
Provide connectivity to SAP ByDesign data through an SAP BusinessObjects universe.
-
Create RSS-Connected Business Apps in AppSheet
Connect to RSS Feeds via CData Connect AI in Google AppSheet and create custom business applications with real-time access to RSS feeds.
-
Connect to FHIR Data from Crystal Reports
Use CData Connect AI to connect to and report on live FHIR data from Crystal Reports.
-
Connect to Live Notion Data in MicroStrategy through CData Connect AI
Create a live connection to Notion Data in CData Connect AI and connect to your Notion data from MicroStrategy.
-
Getting Started with the CData Python Connector for Short.io
Learn to install and license the CData Python Connector and configure a connection to live Short.io data.
-
How to load Grafana data into Elasticsearch via Logstash
Introducing a simple method to load Grafana data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to PDFMonkey Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PDFMonkey data in the Denodo Virtual DataPort Administrator.
-
Integrating OpenCode with CloudConvert 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 to SageHR Data in HULFT Integrate
Connect to SageHR as a JDBC data source in HULFT Integrate
-
Build Semantic Layer Views for eBay Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for eBay data.
-
Build ZohoSubscriptions-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoSubscriptions data and build web apps with connectivity to live ZohoSubscriptions data.
-
How to Visualize CapsuleCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live CapsuleCRM data in Python.
-
Access Live Klipfolio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Klipfolio data into the statistical analysis tools available in SAS JMP. This article shows how to use Klipfolio data in the Graph Builder and Query Builder.
-
Build Apps with Live Shortcut data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Shortcut data into the Adalo platform and build custom mobile and web applications with real-time Shortcut data.
-
How to update Shopify from Excel
This article explains how to transfer data from Excel to Shopify using the Excel Add-In for Shopify.
-
How to Connect to Live Mode 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 Mode data for you.
-
Integrate Dify with Live Microsoft Planner 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 Microsoft Planner data.
-
Back Up Sybase data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase. In this article, we will employ an SSIS workflow to populate a database with Sybase data data.
-
Query Twitter Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Twitter Ads entities in PHP by modeling them as objects.
-
Access Timely Data from MySQL in Amazon QuickSight
Connect to Timely and build visualizations of Timely data using a MySQL Connection in Amazon QuickSight.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Entra ID Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Entra ID data to SQL Server.
-
Getting Started with the CData SSIS Components for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP ByDesign.
-
Use Dash to Build Web Apps on Dynamics 365 Data via CData Connect AI
Build interactive Dash web apps on live Dynamics 365 data using pandas and the CData Connect AI Python SDK.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Onfleet
Provide connectivity to Onfleet data through an SAP BusinessObjects universe.
-
Process & Analyze iContact Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live iContact Data.
-
Build AI Agents with Timely Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Timely data through CData Connect AI.
-
Connect to and Visualize Live Microsoft Teams Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Teams data.
-
Integrating Cursor with Browserless 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.
-
Work with LinkedIn Ads Data in FoxPro
Load LinkedIn Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use JayDeBeApi to access Cohere Data in Python
Use standard Python scripting and the development environment of your choice to access live Cohere data.
-
Integrating Antigravity CLI with SAP SuccessFactors data via CData CLI
Connect SAP SuccessFactors data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Apps from SAP BusinessObjects BI Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP BusinessObjects BI Data and build apps from live SAP BusinessObjects BI data in Qlik Sense Cloud.
-
DataBind Raisers Edge NXT Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Raisers Edge NXT with the DevExpress Windows Forms and Web controls to provide Raisers Edge NXT data to a chart.
-
Connect to Pipeline CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pipeline CRM data using standard SQL.
-
Automated Continuous Power BI XMLA Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to AlloyDB.
-
Create Data Visualizations Based On SAP Business Warehouse Data in Mode
Use CData Connect AI to connect to SAP Business Warehouse Data from Mode and build visualizations using live SAP Business Warehouse data.
-
Build GraphQL-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GraphQL data.
-
Object-Relational Mapping (ORM) with Strava 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 Strava data into a Java-based ORM framework, Hibernate.
-
Build Dashboards with EnterpriseDB Data in DBxtra
Create dynamic dashboards and perform analytics based on EnterpriseDB data in DBxtra.
-
Build Data Flows from Stack Exchange to SQL Server using SSIS
Easily back up Stack Exchange data to SQL Server using the SSIS components for Stack Exchange.
-
How to load ZarMoney data into Elasticsearch via Logstash
Introducing a simple method to load ZarMoney data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from Parquet to Databricks using CData SSIS Components.
Easily push Parquet data to Databricks using the CData SSIS Tasks for Parquet and Databricks.
-
How to Access Live Greenplum Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Greenplum enables you to integrate Greenplum data into workflows built using Microsoft Power Automate Desktop.
-
Access Samanage 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 Samanage data.
-
Use Agno to Talk to Your Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Shippo data for you.
-
ETL Jira Assets in Oracle Data Integrator
This article shows how to transfer Jira Assets data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Deel Replication to Databricks
Use CData Sync for automated, continuous, customizable Deel replication to Databricks.
-
How to Access Live Coda Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Coda enables you to integrate Coda data into workflows built using Microsoft Power Automate Desktop.
-
Integrate LibreChat with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoom data from within the chat interface.
-
Consume Zuora OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zuora feeds that reflect any changes in SAP Lumira.
-
How to Seamlessly Import Quickbase Data into IBM SPSS Modeler
Integrate Quickbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query Sybase Data in QlikView over ODBC
Create data visualizations with Sybase data in QlikView.
-
Build Charts with Google Translate Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Translate data in Clear Analytics.
-
Model, Search, and Visualize Live Azure Synapse Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Synapse data for modeling, searching, and visualizing.
-
Enable the ConstantContact JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ConstantContact data.
-
Connect to Azure Table Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Table Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.