CData Software - Knowledge Base
Recent Articles
-
Connect to OnePageCrm Data from PowerBuilder via ADO.NET
This article demonstrates how to access OnePageCrm data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Freshdesk-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Freshdesk Data and create custom apps in Mendix.
-
Build Avalara AvaTax-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Avalara AvaTax data.
-
Automated Continuous Jira Replication to MongoDB
Use CData Sync for automated, continuous, customizable Jira replication to MongoDB.
-
Getting Started with the CData JDBC Driver for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ServiceDesk Plus.
-
Connecting Agentforce with Zoho Books Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zoho Books data for you.
-
Connect to LinkedIn Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live LinkedIn Ads data.
-
Connecting Pipedream with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on FTP data in real time.
-
Getting Started with the CData SSIS Components for ShipStation
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ShipStation.
-
Automated Continuous Yelp Replication to Databricks
Use CData Sync for automated, continuous, customizable Yelp replication to Databricks.
-
How to work with Spark Data in Apache Spark using SQL
Access and process Spark Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Coda Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Coda data in ColdFusion.
-
Create xBase-Connected Nintex Workflows
Use CData Connect AI to connect to xBase Data from Nintex Workflow Cloud and build custom workflows using live xBase data.
-
Write a Simple Go Application to work with Figshare Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Figshare data.
-
How to use SQLAlchemy ORM to access Amazon DynamoDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon DynamoDB data.
-
Import Timely Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Timely Data and provide access to live Timely data for custom reports in the Power BI Service.
-
Build a PostgreSQL Interface for xBase Data using the CData JDBC Driver
Use the Remoting features of the xBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Cursor with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SendGrid data from within the editor.
-
Process & Analyze MongoDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MongoDB Data.
-
Validate MySQL Data with QuerySurge
Access and validate MySQL data in QuerySurge using the CData JDBC Driver.
-
How to integrate Metabase with Cosmos DB Data
Use CData Connect AI to connect to live Cosmos DB data and create an interactive dashboard in Metabase from Cosmos DB data.
-
Excel Spreadsheet Automation on ZohoMarketingHub Data with the QUERY Formula
Pull data from ZohoMarketingHub, automate spreadsheets, and more with the QUERY formula.
-
Connect to Bitbucket Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket data and execute queries in PowerBuilder.
-
Configure the CData JDBC Driver for Marketo in a Connection Pool in Tomcat
Connect to Marketo data from a connection pool in Tomcat.
-
Configure the CData JDBC Driver for Campaigner in a Connection Pool in Tomcat
Connect to Campaigner data from a connection pool in Tomcat.
-
Build Semantic Layer Views for Yelp Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Yelp data.
-
Connect to MYOB AccountRight Data from Crystal Reports
Use CData Connect AI to connect to and report on live MYOB AccountRight data from Crystal Reports.
-
Visualize Redshift Data in Tableau
The CData ODBC driver for Redshift enables you integrate Redshift data into Tableau dashboards.
-
How to Connect to Live Epicor Kinetic Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Epicor Kinetic data for you.
-
A PostgreSQL Interface for Omnisend Data using the CData ODBC Driver
Use the SQL Gateway and Omnisend ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Twilio Data in Python with CData Connect AI
Build ETL pipelines that read and write live Twilio data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Box Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Box.
-
Extract, Transform, and Load Teamgate Data in Informatica PowerCenter
Create a simple Workflow for Teamgate data in Informatica PowerCenter.
-
Stream Azure Data Lake Storage Data into Apache Kafka Topics
Access and stream Azure Data Lake Storage data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to work with SAP BusinessObjects BI Data in Apache Spark using SQL
Access and process SAP BusinessObjects BI Data in Apache Spark using the CData Software JDBC Driver.
-
How to Visualize Keap Data in Python with pandas
Use pandas and other modules to analyze and visualize live Keap data in Python.
-
Automated Continuous FreshBooks Replication to MySQL
Use CData Sync for automated, continuous, customizable FreshBooks replication to MySQL.
-
Automated Continuous Blackbaud FE NXT Replication to Oracle
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Oracle.
-
Automate CSV Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CSV data from PowerShell? This article demonstrates how to utilize the CSV Cmdlets for tasks like connecting to CSV data, automating operations, downloading data, and more.
-
How to connect to eBay Data from IntelliJ
Integrate connectivity to eBay data with wizards in IntelliJ.
-
Publish SuiteCRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SuiteCRM data.
-
How to Build an ETL App for Simplesat Data in Python with CData
Create ETL applications and real-time data pipelines for Simplesat data in Python with petl.
-
Configure the CData JDBC Driver for Kafka in a Connection Pool in Tomcat
Connect to Kafka data from a connection pool in Tomcat.
-
Import SFTP Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SFTP Data and provide access to live SFTP data for custom reports in the Power BI Service.
-
Automated Continuous IBM Informix Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable IBM Informix replication to Google BigQuery.
-
Create Dashboards and Visualize Live Salesforce CRM Analytics Data in Geckoboard
Use CData Connect AI to connect to live Salesforce CRM Analytics data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Import and Visualize Microsoft Ads Data in Power View
Create data visualizations based on Microsoft Ads data in Excel.
-
DataBind Controls to Samanage Data in Delphi
DataBind to Samanage data in Delphi with standard data access components and controls.
-
Natively Connect to Hubstaff Data in PHP
The CData ODBC driver for Hubstaff enables you to create PHP applications with connectivity to Hubstaff data. Leverage the native support for ODBC in PHP.
-
Build Semantic Layer Views for API Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for API data.
-
How to connect to ADP Data from IntelliJ
Integrate connectivity to ADP data with wizards in IntelliJ.
-
Integrating Codex with FHIR 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for WordPress
Provide connectivity to WordPress data through an SAP BusinessObjects universe.
-
How to Connect DBeaver to SageHR via a JDBC Driver
Manage SageHR data with visual tools in DBeaver like the query browser.
-
Access Live Cloudant Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Cloudant data through MCP integration.
-
Connect to ZohoSubscriptions Data in RapidMiner
Integrate ZohoSubscriptions data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with Databricks Data in JReport Designer
Create charts and reports based on Databricks data in JReport Designer.
-
Access Live eBay Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to eBay Analytics data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Write a Simple Go Application to work with Dotmailer Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dotmailer data.
-
Access Live OpenWeatherMap Data in AWS Lambda
Connect to live OpenWeatherMap data in AWS Lambda using the CData JDBC Driver.
-
Integrate SAP Business One Data into Power Automate Desktop using CData Connect
CData Connect for SAP Business One Data enables you to integrate SAP Business One data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Oracle Eloqua to Snowflake using CData SSIS Components.
Easily push Oracle Eloqua data to Snowflake using the CData SSIS Tasks for Oracle Eloqua and Snowflake.
-
Build Charts with MongoDB Data in Clear Analytics
Create dynamic charts and perform analytics based on MongoDB data in Clear Analytics.
-
Integrate with Parquet Data in JReport Designer
Create charts and reports based on Parquet data in JReport Designer.
-
How to use SQLAlchemy ORM to access SingleStore Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SingleStore data.
-
Integrate Devin with Live Highrise 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 Highrise data.
-
Use the CData Software ODBC Driver for SAP Concur in MicroStrategy Desktop
Connect to SAP Concur data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Concur.
-
Using the CData Software ODBC Driver for Opsgenie in PyCharm
Connect to Opsgenie as an ODBC data source in PyCharm using the CData Software ODBC Driver for Opsgenie.
-
Import Real-Time LinkedIn Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LinkedIn data in ColdFusion.
-
Build Dashboards with ZendeskSell Data in DBxtra
Create dynamic dashboards and perform analytics based on ZendeskSell data in DBxtra.
-
Connect to Salesforce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Salesforce data from Filemaker Pro on Mac.
-
Automated Continuous Box Replication to Oracle
Use CData Sync for automated, continuous, customizable Box replication to Oracle.
-
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.
-
Building a Salesforce Churn Analysis Pipeline: Designing Multi-Step AI Agent Workflows with Claude Code and CData CLI
Build a multi-step AI agent pipeline that queries Salesforce for churn risk signals, drafts personalized outreach emails, creates follow-up tasks, and produces an executive digest using Claude Code and CData CLI.
-
Publish Short.io-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Short.io data.
-
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.
-
Connect to Attio Data in ACL Analytics
Connect to Attio data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Attio data.
-
Connect and Visualize Live MailerLite Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MailerLite data into the Databricks platform and create visualization dashboards with real-time MailerLite data.
-
Automated Continuous Telegram Replication to Vertica
Use CData Sync for automated, continuous, customizable Telegram replication to Vertica.
-
Use Dash to Build to Web Apps on BigCommerce Data
Create Python applications that use pandas and Dash to build BigCommerce-connected web apps.
-
Analyze ShipStation Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ShipStation data in Microsoft R Open.
-
Integrate Theia IDE with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SageHR data from within the development environment.
-
Use Dash to Build to Web Apps on Google Drive Data
Create Python applications that use pandas and Dash to build Google Drive-connected web apps.
-
Use JayDeBeApi to access Redis Data in Python
Use standard Python scripting and the development environment of your choice to access live Redis data.
-
How to Access Live Templated Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Templated enables you to integrate Templated data into workflows built using Microsoft Power Automate Desktop.
-
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.
-
Create Informatica Mappings From/To an ODBC Data Source for Workday
Create an ODBC connection to Workday in Informatica and browse and transfer Workday data.
-
Automated Continuous SAP HANA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP HANA replication to IBM DB2.
-
LINQ to Mode 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 Mode Data Provider.
-
Load ChartMogul Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ChartMogul data to a database.
-
Connecting Moonlit Workflow with SAP Fieldglass 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 SAP Fieldglass data in real time.
-
Integrating GitHub Copilot with Exa 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.
-
Build AI/ML Models with Live PagerDuty Data using Dataiku
Connect PagerDuty Data with Dataiku using the CData API Driver for JDBC.
-
Publish Avaza-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Avaza data.
-
Visualize Live Testmonitor Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Testmonitor data.
-
Create Datasets from AdRoll in Domo Workbench and Build Visualizations of AdRoll Data in Domo
Use the CData Software ODBC Driver for AdRoll to create datasets from AdRoll data in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from Cosmos DB to Databricks using CData SSIS Components.
Easily push Cosmos DB data to Databricks using the CData SSIS Tasks for Cosmos DB and Databricks.
-
Link Planio with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Planio data in Filemaker Pro for Mac or Windows.
-
Use Biml to Build SSIS Tasks to Replicate Suadeo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Suadeo data to SQL Server.
-
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.