CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI 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.
-
Connect to Redshift Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Redshift and the Script function in FileMaker Pro to connect to Redshift and work with Amazon Redshift in your FileMaker application.
-
Integrating Calendly Data in Talend Cloud Data Management Platform
Connect Calendly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Consume Snapchat Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Snapchat Ads as OData feeds from PowerBuilder using the API Server.
-
Integrating Cursor CLI with Power BI XMLA 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 and Query Autopilot Data in QlikView over ODBC
Create data visualizations with Autopilot in QlikView.
-
Connect to SendPulse Data in DBArtisan
Use wizards in DBArtisan to configure SendPulse as a data source.
-
Automated Continuous Zoho CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Google Cloud SQL.
-
Connect to MarkLogic Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MarkLogic and the SQL Gateway to access MarkLogic from Google Apps Script.
-
Visualize TigerGraph Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to TigerGraph.
-
View Reports on Real-Time FreshBooks Data in Power BI Report Server
Use the CData ODBC Driver for FreshBooks to visualize FreshBooks in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Live Salesforce Pardot Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Pardot from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Pardot.
-
Automated Continuous Freshteam Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshteam replication to SQL Server.
-
Automated Continuous SQL Server Replication to MongoDB
Use CData Sync for automated, continuous, customizable SQL Server replication to MongoDB.
-
Object-Relational Mapping (ORM) with Aweber 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 Aweber into a Java-based ORM framework, Hibernate.
-
Analyze Live Dropbox Data in SAS Viya
Use CData Connect AI to connect to Dropbox from SAS Viya and deploy self-service analytics using live Dropbox.
-
Build Epicor Kinetic-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Epicor Kinetic.
-
Integrate Oracle HCM Cloud Data in the Pentaho Report Designer
Publish reports based on Oracle HCM Cloud in the Pentaho BI tool.
-
Integrating Google Sheets Data in Talend Cloud Data Management Platform
Connect Google Sheets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Sheets.
-
Integrate Parquet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Parquet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Parquet.
-
Extend Google Sheets with MongoDB Data
Make calls to MongoDB from Google Apps Script via the API Server.
-
Automated Continuous Impala Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Impala replication to IBM DB2.
-
Automated Continuous Hubstaff Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Hubstaff replication to AlloyDB.
-
Integrating Boomi Agentstudio with QuickBooks Online Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to QuickBooks Online, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Provide OData Services of Oracle Sales Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Sales by developing a WCF Service Application.
-
Integrating Codex CLI with Google Drive 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 and Visualize Live Zoho Books Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Books.
-
Automated Continuous Twitter Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Twitter Ads replication to SingleStore.
-
Getting Started with the CData JDBC Driver for Testmonitor
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Testmonitor.
-
Use JayDeBeApi to access Access Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Access.
-
Replicate Paymo Data from PowerShell
Write a quick PowerShell script to query Paymo. Use connectivity to the live data to replicate Paymo to SQL Server.
-
How to create an RPA flow for Hugging Face Data in UiPath Studio
Use the Hugging Face ODBC Driver to create workflows that access real-time Hugging Face without any coding.
-
Use Manus AI to Talk to Your Cloudant 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 IBM Cloudant.
-
Extract, Transform, and Load Notion Data in Informatica PowerCenter
Create a simple Workflow for Notion in Informatica PowerCenter.
-
Visualize Suadeo Data in Tableau
The CData ODBC driver for Suadeo enables you integrate Suadeo into Tableau dashboards.
-
How to Build an ETL App for Asana Data in Python with CData
Create ETL applications and real-time data pipelines for Asana in Python with petl.
-
How to Connect the Power BI Service to Teamgate: Complete Guide
Connect to the CData Software Power BI Connector for Teamgate from PowerBI.com to provide real-time Teamgate across the organization.
-
Query Confluence Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Atlassian Confluence and perform CRUD operations on Confluence from Node.js.
-
Connect to CampaignMonitor 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 CampaignMonitor and work with CampaignMonitor in your FileMaker application.
-
How to Build an ETL App for Stripe Data in Python with CData Connect AI
Build ETL pipelines that read and write live Stripe in Python with petl and the CData Connect AI Python SDK.
-
Publish Microsoft OneDrive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft OneDrive.
-
Automated Continuous MYOB AccountRight Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Amazon Redshift.
-
Integrate Microsoft OneDrive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft OneDrive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft OneDrive.
-
Build Paylocity-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Paylocity.
-
Connect to Teamwork Data in RapidMiner
Integrate Teamwork with standard components and data source configuration wizards in RapidMiner Studio.
-
Rapidly Develop SFTP-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SFTP.
-
Connect and Query Live YouTube Analytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics into Databricks
-
Visualize AdRoll Data in TIBCO Spotfire through ADO.NET
Integrate AdRoll into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Zoho Books
Learn to install and license the CData Python Connector
-
Natively Connect to Spotify Data in PHP
The CData ODBC driver for Spotify enables you to create PHP applications with connectivity to Spotify. Leverage the native support for ODBC in PHP.
-
How to use SQLAlchemy ORM to access Couchbase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Couchbase.
-
Build GitLab-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to GitLab Data from Zoho Analytics and import live GitLab.
-
How to Query OpenWeatherMap Data in MySQL Workbench
Execute MySQL queries against live OpenWeatherMap from MySQL Workbench.
-
Integrate Live LinkedIn Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to LinkedIn from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live LinkedIn.
-
Visualize Helpscout Data in Sisense
Create an ElastiCube in Sisense app with access to Helpscout.
-
Connect to Aha! Data from a Connection Pool in Jetty
The Aha! JDBC Driver supports connection pooling: This article shows how to connect faster to Aha! from Web apps in Jetty.
-
Connect to ActiveCampaign Data in JRuby
Create a simple JRuby app with access to live ActiveCampaign.
-
Replicate GitHub Data to Multiple Databases
Replicate GitHub to disparate databases with a point-and-click configuration.
-
How to Access Live Printful Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Printful enables you to integrate Printful into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with Flowlu 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.
-
Visualize Pushbullet Data in TIBCO Spotfire through ADO.NET
Integrate Pushbullet into dashboards in TIBCO Spotfire.
-
Connect to Amazon S3 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon S3 as an External Source in Dremio.
-
Integrating OpenCode Terminal with PagerDuty 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.
-
Query Sage 300 Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage 300.
-
Import Real-Time TigerGraph Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use TigerGraph in ColdFusion.
-
Automate Power BI XMLA Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Power BI XMLA from PowerShell? This article demonstrates how to utilize the Power BI XMLA Cmdlets for tasks like connecting to Power BI XMLA, automating operations, downloading data, and more.
-
Connect to Adobe Target Data in JRuby
Create a simple JRuby app with access to live Adobe Target.
-
Publish Vimeo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Vimeo.
-
Build MVC Applications with Connectivity to Gong Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gong from an ASP.NET MVC application.
-
Replicate Campaigner Data from PowerShell
Write a quick PowerShell script to query Campaigner. Use connectivity to the live data to replicate Campaigner to SQL Server.
-
Build SurveyMonkey-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SurveyMonkey and build web apps with connectivity to live SurveyMonkey.
-
Create Apify Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Apify from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Power BI XMLA Data from PowerBuilder via ADO.NET
This article demonstrates how to access Power BI XMLA from Appeon PowerBuilder using the CData ADO.NET Provider for Power BI XMLA.
-
Import SAS xpt Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAS XPORT. In this article, you will use the OData format to import SAS XPORT into Microsoft Power Query.
-
Analyze Amazon S3 Data in Cognos Analytics
Use CData Connect AI to connect to Amazon S3 Data from Cognos Analytics and analyze live Amazon S3.
-
Access Live Zoho CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho CRM from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for Freshdesk in MicroStrategy
Connect to Freshdesk in MicroStrategy Developer using the CData Software JDBC Driver for Freshdesk.
-
Visualize Live MarkLogic Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MarkLogic using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Process & Analyze Zoho Inventory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Inventory Data.
-
Connect to and Visualize Live Google Contacts Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Contacts.
-
ETL Dynamics 365 Business Central in Oracle Data Integrator
This article shows how to transfer Dynamics 365 Business Central into a data warehouse using Oracle Data Integrator.
-
Visualize eBay Data in Sisense
Create an ElastiCube in Sisense app with access to eBay.
-
How to Easily Query Microsoft Entra ID Data in OpenOffice Base
Connect to Microsoft Entra ID data in OpenOffice Base using the CData ODBC Driver for Microsoft Entra ID and generate reports with live data insights.
-
Create Power BI Reports on Real-Time Supabase Data
Use the CData ODBC Driver for Supabase to visualize Supabase in Power BI Desktop.
-
Create Zoho CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho CRM Data from Nintex Workflow Cloud and build custom workflows using live Zoho CRM.
-
Replicate Aweber Data to Multiple Databases via the CData Sync CLI
Replicate Aweber to disparate databases with a single configuration.
-
How to connect PolyBase to Sentry
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sentry.
-
Query Box Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Box from Node.js.
-
Moving Data from MariaDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MariaDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Microsoft Planner Data in JReport Designer
Create charts and reports based on Microsoft Planner in JReport Designer.
-
Integrating Claude Code CLI with Azure Analysis Services 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.
-
How to connect to Instantly Data from Spring Boot
Connect to Instantly in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating OpenCode Terminal with ActiveCampaign 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.
-
Integrate Omnisend Data in Pentaho Data Integration
Build ETL pipelines based on Omnisend in the Pentaho Data Integration tool.
-
Integrating Antigravity CLI with Microsoft Ads via CData CLI
Connect Microsoft Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Easily Integrate Discourse Data in Lazarus Pascal IDE
Learn how to easily integrate live Discourse in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to & Open AlloyDB Data in Microsoft Excel
This article uses the CData ODBC driver for AlloyDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Cosmos DB 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 Azure Cosmos DB into TIBCO Spotfire.
-
Integrate Real-Time Access to QuickBooks Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Online in real time.
-
How to connect to Klaviyo Data in DBVisualizer
Integrate Klaviyo with visual data analysis tools and data connection wizards in DBVisualizer