CData Software - Knowledge Base
Recent Articles
-
Validate SAS xpt Data with QuerySurge
Access and validate SAS xpt data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous SAP Business One Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Business One replication to PostgreSQL.
-
ETL Shopify in Oracle Data Integrator
This article shows how to transfer Shopify data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Typeform Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Typeform replication to IBM DB2.
-
Integrating Claude Code CLI with ZohoExpense 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 Azure AI Foundry to Talk to Your Google Forms 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 Google Forms data for you.
-
DataBind Controls to Google Sheets Data in C++Builder
DataBind to Google Sheets data in C++Builder with standard components and controls.
-
How to connect SharePoint with OneNote Data through external lists
Provide OneNote data to SharePoint users as an external list.
-
Connect to Impala Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Impala.
-
A PostgreSQL Interface for ShipStation Data using the CData ODBC Driver
Use the SQL Gateway and ShipStation ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Quaderno Data in Power View
Create data visualizations based on Quaderno data in Excel.
-
Connect to Beeminder Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Beeminder.
-
Create Apps from SendGrid Data in Qlik Sense Cloud
Use CData Connect AI to connect to SendGrid Data and build apps from live SendGrid data in Qlik Sense Cloud.
-
Automated Continuous ZendeskSell Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZendeskSell replication to MongoDB.
-
View Reports on Real-Time Reckon Accounts Hosted Data in Power BI Report Server
Use the CData ODBC Driver for Reckon Accounts Hosted to visualize Reckon Accounts Hosted data in Power BI Desktop and then publish them to Power BI Report Server.
-
Work with Live Stripe Data in Power Query
Use CData Connect AI to connect to Stripe data and work with live Stripe data in Microsoft Power Query.
-
Integrate Dify with Live SAP ByDesign 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 SAP ByDesign data.
-
Use the CData Software JDBC Driver for Deel in MicroStrategy Desktop
Connect to Deel data in MicroStrategy Desktop using the CData Software JDBC Driver for Deel.
-
Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Ariba Procurement data.
-
Integrating Xero Data in Talend Cloud Data Management Platform
Connect Xero Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Xero.
-
Build Figshare Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Figshare data and build visualizations in Tableau.
-
Integrate Amazon Athena Data into Power Automate Desktop using CData Connect
CData Connect for Amazon Athena Data enables you to integrate Amazon Athena data into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Oracle Financials Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Financials Cloud data in Python with petl.
-
Build Dashboards with Mode Data in DBxtra
Create dynamic dashboards and perform analytics based on Mode data in DBxtra.
-
Create Zoho Creator-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho Creator Data from Klipfolio and build custom visualizations using live Zoho Creator data.
-
Query SendInBlue Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SendInBlue data from Node.js.
-
Integrating Antigravity CLI with Jodoo data via CData CLI
Connect Jodoo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Power BI Connector for Jumpseller
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize Live Short.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Short.io data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build AI/ML Models with Live MongoDB Data using Dataiku
Connect MongoDB Data with Dataiku using the CData JDBC Driver for MongoDB.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Data 360 data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Data 360.
-
How to Connect to Live LDAP Objects in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live LDAP objects without replication.
-
Connect to ConvertKit from a Connection Pool in WebLogic
Use the CData JDBC Driver for ConvertKit to connect to ConvertKit data from Web applications running on WebLogic.
-
Getting Started with the CData SSIS Components for CockroachDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CockroachDB.
-
Work with PabblySubscriptions Data in FoxPro
Load PabblySubscriptions data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Extract, Transform, and Load OData Services in Informatica PowerCenter
Create a simple Workflow for OData services in Informatica PowerCenter.
-
How to Work with Typeform Data in ETL Validator JDBC
Connect to Typeform from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live FHIR 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 FHIR data for you.
-
Provide OData Services of Microsoft OneDrive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft OneDrive data by developing a WCF Service Application.
-
How to use SQLAlchemy ORM to access Drip Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Drip data.
-
Automate Templated Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Templated data from PowerShell? This article demonstrates how to utilize the Templated Cmdlets for tasks like connecting to Templated data, automating operations, downloading data, and more.
-
Replicate Cloudant Data from PowerShell
Write a quick PowerShell script to query Cloudant data. Use connectivity to the live data to replicate Cloudant data to SQL Server.
-
Import Real-Time LeadDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LeadDesk data in ColdFusion.
-
Integrate Humanity Data in the Pentaho Report Designer
Publish reports based on Humanity data in the Pentaho BI tool.
-
Automated Continuous SAP Hybris C4C Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MongoDB.
-
Connect to ZeroBounce from Asprova with CData Software ODBC Driver for ZeroBounce
This article shows how to connect faster to ZeroBounce data from Asprova.
-
Connect Simplesat Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Simplesat data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Manage Simplesat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Simplesat.
-
Build an OLAP Cube in SSAS from Discord Data
Establish a connection to Discord data data from SQL Server Analysis Services, and use the Discord Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to Zendesk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zendesk data. Leverage the native support for ODBC in PHP.
-
Analyze eBay Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of eBay data and visualize live eBay data in Infragistics Reveal.
-
Create Informatica Mappings From/To an ODBC Data Source for Access
Create an ODBC connection to Access in Informatica and browse and transfer Access data.
-
Provide OData Services of Azure Analysis Services Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure Analysis Services data by developing a WCF Service Application.
-
Natively Connect to Microsoft Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Ads data. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Bitly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bitly data.
-
Integrate Live PostgreSQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to PostgreSQL data and integrate live PostgreSQL data into apps built in Microsoft Power Apps.
-
Marketo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Marketo facts in real time.
-
Build QuickBooks Online-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live QuickBooks Online data without replication.
-
How to integrate Reckon with Apache Airflow
Access and process Reckon data in Apache Airflow using the CData JDBC Driver.
-
How to connect to Google Campaign Manager 360 Data from Spring Boot
Connect to Google Campaign Manager 360 in a Spring Boot Application using the CData JDBC Driver for Google Campaign Manager 360
-
How to create PingOne federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PingOne data in MySQL .
-
Create a Data Access Object for ZendeskSell Data using JDBI
A brief overview of creating a SQL Object API for ZendeskSell data in JDBI.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Outreach.io data.
-
Connect to Vault CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Vault CRM data from Filemaker Pro on Mac.
-
How to connect SharePoint with Microsoft Planner Data through external lists
Provide Microsoft Planner data to SharePoint users as an external list.
-
Integrate Live SFTP Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SFTP data and integrate live SFTP data into apps built in Microsoft Power Apps.
-
Query Oracle Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle data from Node.js.
-
Edit and Search External SQL Server Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SQL Server data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SQL Server Data objects that you can access from apps and the dashboard.
-
Connecting Moonlit Workflow with Oracle Service Cloud 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 Oracle Service Cloud data in real time.
-
How to use SQLAlchemy ORM to access Hive Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Hive data.
-
Operational Reporting on Oracle Financials Cloud Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Financials Cloud data.
-
Connect Coinbase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Coinbase with IBM WebSphere for seamless data integration and connectivity.
-
Load Excel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Excel data to a database.
-
Work with Deel Data in FoxPro
Load Deel data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Templated-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Templated data.
-
Easily Integrate Deel Data in Lazarus Pascal IDE
Learn how to easily integrate live Deel data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Configure the CData JDBC Driver for Clari in a Connection Pool in Tomcat
Connect to Clari data from a connection pool in Tomcat.
-
Access Live CSV 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 CSV data through MCP integration.
-
Trigger SendGrid IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SendGrid with standard wizards in Logic Apps.
-
Connect to AdRoll from a Connection Pool in WebLogic
Use the CData JDBC Driver for AdRoll to connect to AdRoll data from Web applications running on WebLogic.
-
Import Salesforce Data into Microsoft Power Query
The CData API Server offers standards-based web service endpoints that allow a variety of applications to get data from Salesforce. These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into Microsoft Power Query.
-
Visualize AfterShip Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AfterShip data.
-
Zoho Projects Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Projects facts in real time.
-
Automated Continuous ZohoMarketingHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Google BigQuery.
-
Object-Relational Mapping (ORM) with Avalara AvaTax 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 Avalara AvaTax data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Copper Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Copper data replication to OneLake in Microsoft Fabric.
-
Analyze SAP HANA XS Advanced Data in Cognos Analytics
Use CData Connect AI to connect to SAP HANA XS Advanced Data from Cognos Analytics and analyze live SAP HANA XS Advanced data.
-
Trigger REST IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for REST with standard wizards in Logic Apps.
-
Getting Started with the CData ODBC Driver for Mode
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mode.
-
Automated Continuous Postmark Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Postmark replication to Google Cloud SQL.
-
Use Grok to Talk to Your Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Lakebase data for you.
-
Connect Neo4J to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Neo4J data using the CData Python MCP Server.
-
Access Live LinkedIn Data in Excel 365 Online (Excel for the web)
Connect to LinkedIn data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Write a Simple Go Application to work with Mailjet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mailjet data.
-
Create Sage Intacct Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage Intacct data access from reports, embedded analytics, and more.
-
How to integrate Sugar CRM with Apache Airflow
Access and process Sugar CRM data in Apache Airflow using the CData JDBC Driver.
-
Connect to MongoDB Data in HULFT Integrate
Connect to MongoDB as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Act-On
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Act-On.
-
Using the CData Software ODBC Driver for Sage Cloud Accounting in PyCharm
Connect to Sage Cloud Accounting as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Cloud Accounting.
-
How to Connect Flowise AI Agents to Live Adobe Target 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 Adobe Target data without replication.