CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for VWO With the CData Python Connector
Learn how to easily build a Singer.io Tap for live VWO data using the CData Python Connector.
-
Automated Continuous Raisers Edge NXT Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon S3.
-
Build MVC Applications with Connectivity to Samanage Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Samanage from an ASP.NET MVC application.
-
Access Live Oracle Sales Data in Excel 365 Online (Excel for the web)
Connect to Oracle Sales data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Pipelines with Live Reckon Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Reckon from Google Cloud Data Fusion, enabling the integration of live Reckon data into the building and management of effective data pipelines.
-
ETL Adobe Experience Manager in Oracle Data Integrator
This article shows how to transfer Adobe Experience Manager data into a data warehouse using Oracle Data Integrator.
-
Connect to SageHR Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SageHR data.
-
Connect to EmailOctopus Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time EmailOctopus data using standard SQL.
-
Build Pipelines with Live CouchDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CouchDB from Google Cloud Data Fusion, enabling the integration of live CouchDB data into the building and management of effective data pipelines.
-
Build Automated Workflows with Live Smartsheet Data in Workato
Use CData Connect AI to connect to live Smartsheet data and build automated workflows in Workato.
-
Query Pingdom Data as a MySQL Database in Node.js
Execute MySQL queries against Pingdom data from Node.js.
-
Access Live MarkLogic Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MarkLogic data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
ETL Todoist in Oracle Data Integrator
This article shows how to transfer Todoist data into a data warehouse using Oracle Data Integrator.
-
Access Coinbase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Coinbase data from your Oracle system.
-
Create Data Visualizations Based On Facebook Ads Data in Mode
Use CData Connect AI to connect to Facebook Ads Data from Mode and build visualizations using live Facebook Ads data.
-
Access AlloyDB Data from MySQL in PHP
Connect to AlloyDB through the standard MySQL libraries in PHP.
-
Use ChatGPT to Talk to Your Moosend 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 Moosend data for you.
-
Enable the JDBC-ODBC Bridge JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with JDBC-ODBC Bridge data.
-
Connecting Moonlit Workflow with ZohoPeople Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ZohoPeople data in real time.
-
How to connect PolyBase to Gumroad
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gumroad data.
-
Connect to Oracle Service Cloud Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Service Cloud to connect to Oracle Service Cloud data and execute queries in PowerBuilder.
-
Use the CData SSIS Components to Insert New or Update Existing Zoho Projects Records from SQL Server
Easily push SQL Server data to Zoho Projects using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho Projects or update existing records with data from a SQL Server database.
-
Use JayDeBeApi to access Redis Data in Python
Use standard Python scripting and the development environment of your choice to access live Redis data.
-
Replicate Multiple Twitter Ads Accounts
Replicate multiple Twitter Ads accounts to one or many databases.
-
Add ZohoDesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoDesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software JDBC Driver for Google Translate in MicroStrategy Web
Connect to Google Translate data in MicroStrategy Web using the CData Software JDBC Driver for Google Translate.
-
How to Connect DBeaver to SAP SuccessFactors LMS via a JDBC Driver
Manage SAP SuccessFactors LMS data with visual tools in DBeaver like the query browser.
-
Publish HelloSign-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HelloSign data.
-
Process & Analyze SQL Server Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SQL Server Data.
-
Natively Connect to Toggl Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Toggl data. Leverage the native support for ODBC in PHP.
-
Build Zoho Creator-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho Creator Data and create custom apps in Bubble.
-
Integrate Devin with Live Certinia Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Certinia data.
-
Connect to Live Oracle Sales Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Sales in CData Connect AI and connect to your Oracle Sales data from PostgreSQL.
-
Create Snapchat Ads-Connected Dashboards in Grafana
Connect to Snapchat Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Snapchat Ads data.
-
Consume Adobe Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Adobe Analytics feeds that reflect any changes in SAP Lumira.
-
Connect to Strava Data from a Connection Pool in JBoss
Integrate Strava data into Java servlets: Use the Management Console in JBoss to install the Strava JDBC Driver.
-
Work with Avalara AvaTax Data in FoxPro
Load Avalara AvaTax data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect Dotmailer to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Dotmailer data using the CData Python MCP Server.
-
Integrate with Live Timely Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Timely from the MuleSoft Anypoint Platform to integrate live Timely data into custom reports and dashboards.
-
Integrate Live Oracle Eloqua Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Eloqua data and integrate live Oracle Eloqua data into apps built in Microsoft Power Apps.
-
Visualize Sage 300 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 Sage 300 data into TIBCO Spotfire.
-
Build Cloudflare-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cloudflare Data and create custom apps in Mendix.
-
Create Vimeo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Vimeo data access from reports, embedded analytics, and more.
-
Integrating Kiro with Dynamics 365 Business Central 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.
-
Natively Connect to MySQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MySQL data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Oracle Financials Cloud in MicroStrategy Web
Connect to Oracle Financials Cloud data in MicroStrategy Web using the CData Software JDBC Driver for Oracle Financials Cloud.
-
Getting Started with the CData Connect AI Python SDK for SharePoint
Install the CData Connect AI Python SDK to read and write live SharePoint data with standard DB-API 2.0 Python code.
-
Use Manus AI to Talk to Your Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Raisers Edge NXT data.
-
Connect to Aweber Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Aweber and work with Aweber data in your FileMaker application.
-
Connect to Nethunt Data in CloverDX (formerly CloverETL)
Transfer Nethunt data using the visual workflow in the CloverDX data integration tool.
-
How to Connect Flowise AI Agents to Live FHIR 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 FHIR data without replication.
-
How to Easily Query Xero Data in OpenOffice Base
Connect to Xero data in OpenOffice Base using the CData ODBC Driver for Xero and generate reports with live data insights.
-
Getting Started with the CData JDBC Driver for Amazon S3
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon S3.
-
Access SAP Ariba Procurement Data from MySQL in PHP
Connect to SAP Ariba Procurement through the standard MySQL libraries in PHP.
-
Integrating Dataiku with Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Blackbaud FE NXT data.
-
Back Up Copper data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Copper data data.
-
Use Dash to Build Web Apps on Smartsheet Data via CData Connect AI
Build interactive Dash web apps on live Smartsheet data using pandas and the CData Connect AI Python SDK.
-
Use the CData Software ODBC Driver for Apify in MicroStrategy
Connect to Apify data in MicroStrategy Developer using the CData Software ODBC Driver for Apify.
-
Connect to Vertica Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Vertica Data and connect to Vertica data in Akorbi Digital RunMyProcess.
-
Process & Analyze LinkedIn Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LinkedIn Ads Data.
-
Use Databricks Agent Bricks to Talk to Your Guru Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Guru data for you.
-
Moving Data from Trello to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Trello data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
REST Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on REST facts in real time.
-
How to Connect to Live Stripe 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 Stripe data for you.
-
Analyze Shopify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Shopify data with the CData JDBC Driver for Shopify.
-
How to use SQLAlchemy ORM to access Access Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Access data.
-
Use Claude to Talk to Your SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP HANA XS Advanced data for you.
-
Connect to and Visualize Live ZendeskSell Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZendeskSell data.
-
Build Charts with Discourse Data in Clear Analytics
Create dynamic charts and perform analytics based on Discourse data in Clear Analytics.
-
Create SAP SuccessFactors LMS-Connected Nintex Workflows
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Nintex Workflow Cloud and build custom workflows using live SAP SuccessFactors LMS data.
-
Connect to ZendeskSell Data in Ruby
Connect to ZendeskSell data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Controls to Pinterest Data in C++Builder
DataBind to Pinterest data in C++Builder with standard components and controls.
-
Getting Started with the CData SSIS Components for Tally
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Tally.
-
How to load Clio data into Elasticsearch via Logstash
Introducing a simple method to load Clio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous ClickUp Replication to Snowflake
Use CData Sync for automated, continuous, customizable ClickUp replication to Snowflake.
-
Provide OData Services of SparkPost Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SparkPost data by developing a WCF Service Application.
-
How to connect PolyBase to Trello
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Trello data.
-
Operational Reporting on Jodoo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Jodoo data.
-
Add SAP Business One Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Business One with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze ServiceDesk Plus Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ServiceDesk Plus data and visualize live ServiceDesk Plus data in Infragistics Reveal.
-
Connect to Azure DevOps Data in HULFT Integrate
Connect to Azure DevOps as a JDBC data source in HULFT Integrate
-
Connect to Avalara AvaTax Data in Jaspersoft Studio
Execute SQL to remote Avalara AvaTax data in Jaspersoft Studio.
-
Connect to Campaigner Data from PowerBuilder via ADO.NET
This article demonstrates how to access Campaigner data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Zuora Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zuora data access from reports, embedded analytics, and more.
-
Object-Relational Mapping (ORM) with Shippo 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 Shippo data into a Java-based ORM framework, Hibernate.
-
Design BIRT Reports on Sage Cloud Accounting Data
Provide current Sage Cloud Accounting data to your embedded analytics.
-
Getting Started with the CData Python Connector for Google Tasks
Learn to install and license the CData Python Connector and configure a connection to live Google Tasks data.
-
How to Connect to Live Slack 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 Slack data for you.
-
Build Data Flows from SQL Server to Sugar CRM through SSIS
Easily push SQL Server data to Sugar CRM using the CData SSIS Tasks for Sugar CRM.
-
Build a Simple VCL Application for Salesforce Marketing Data
How to build a simple VCL Application to view Salesforce Marketing data in RAD Studio using the CData ODBC Driver for Salesforce Marketing.
-
Access Live Grafana Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Grafana data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create SageHR-Connected Business Apps in AppSheet
Connect to SageHR Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SageHR data.
-
How to Build an ETL App for Oracle Eloqua Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Eloqua data in Python with petl.
-
Moving Data from Beeminder to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Beeminder data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use JayDeBeApi to access HubSpot Data in Python
Use standard Python scripting and the development environment of your choice to access live HubSpot data.
-
Integrate Devin with Live Adobe Commerce Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Adobe Commerce data.
-
Load EmailOctopus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load EmailOctopus data to a database.
-
Automate Jira Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Jira data from PowerShell? This article demonstrates how to utilize the Jira Cmdlets for tasks like connecting to Jira data, automating operations, downloading data, and more.
-
Explore Geographical Relationships in PolarTeamPro Data with Power Map
Create data visualizations with PolarTeamPro data in Power Map.
-
Visualize SendPulse 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 SendPulse data into TIBCO Spotfire.