CData Software - Knowledge Base
Recent Articles
-
Access Live OneNote Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to OneNote data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Google Contacts Data to Multiple Databases via the CData Sync CLI
Replicate Google Contacts data to disparate databases with a single configuration.
-
Integrating Claude Code CLI with Pipeline CRM 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.
-
Perform Batch Operations with Sugar CRM Data in Apache NiFi
Connect to Sugar CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Live Sage Intacct Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sage Intacct from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sage Intacct data.
-
Visualize Live Wistia Data in the Power BI Service
Use CData Connect AI to connect to live Wistia data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Manus AI to Talk to Your Basecamp 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 Basecamp data.
-
Analyze SingleStore Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SingleStore data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Dynamic Beeminder Grids Using the Infragistics XamDataGrid
Learn how you can connect Beeminder to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Trae with Live Procore Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Procore data from within the AI-powered IDE.
-
Visualize LinkedIn Data in Tableau
The CData ODBC driver for LinkedIn enables you integrate LinkedIn data into Tableau dashboards.
-
Import and Visualize Zoho CRM Data in Power View
Create data visualizations based on Zoho CRM data in Excel.
-
A PostgreSQL Interface for Salesloft Data using the CData ODBC Driver
Use the SQL Gateway and Salesloft ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for FHIR
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FHIR.
-
Replicate Quaderno Data in Heroku for Use in Salesforce Connect
Replicate Quaderno data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
A PostgreSQL Interface for Paylocity Data using the CData ODBC Driver
Use the SQL Gateway and Paylocity ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to BambooHR Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to BambooHR data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Import Real-Time CloudConvert Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CloudConvert data in ColdFusion.
-
Replicate ZarMoney Data to Multiple Databases
Replicate ZarMoney data to disparate databases with a point-and-click configuration.
-
Integrate Cline with Live Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Anaplan data from within your IDE.
-
Automated Continuous ActiveCampaign Replication to MongoDB
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to MongoDB.
-
Integrate Google's Vertex AI Agent with Live ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ZohoSubscriptions data within intelligent workflows.
-
Connect to Real-Time Authorize.Net Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Authorize.Net and Dataflow to import and use Authorize.Net data in Power Apps.
-
Provide OData Services of BigCommerce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for BigCommerce data by developing a WCF Service Application.
-
Import Real-Time Hugging Face Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Hugging Face data in ColdFusion.
-
Getting Started with the CData Python Connector for Adobe Analytics
Learn to install and license the CData Python Connector and configure a connection to live Adobe Analytics data.
-
Automated Continuous Hubstaff Replication to MySQL
Use CData Sync for automated, continuous, customizable Hubstaff replication to MySQL.
-
Query, Visualize, and Share live Power BI XMLA Data in Redash
Use CData Connect AI to connect to live Power BI XMLA data in Redash for querying, visualizing, and sharing.
-
Connect to Todoist from a Connection Pool in WebLogic
Use the CData JDBC Driver for Todoist to connect to Todoist data from Web applications running on WebLogic.
-
Getting Started with the CData Power BI Connector for MarkLogic
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MarkLogic.
-
Use Manus AI to Talk to Your Mode 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 Mode data.
-
Integrate Live Adobe Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Adobe Analytics data and integrate live Adobe Analytics data into apps built in Microsoft Power Apps.
-
Automated Continuous SurveyMonkey Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SurveyMonkey data replication to OneLake in Microsoft Fabric.
-
Prepare, Blend, and Analyze Attio Data in Alteryx Designer (ODBC)
Build workflows to access live Attio data for self-service data analytics.
-
ClickUp Reporting in OBIEE with the ClickUp JDBC Driver
Deploy the ClickUp JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to use SQLAlchemy ORM to access Clio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clio data.
-
Import MariaDB Data Using Azure Data Factory
Use CData Connect AI to connect to MariaDB Data from Azure Data Factory and import live MariaDB data.
-
Edit and Search External AlloyDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of AlloyDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create AlloyDB Data objects that you can access from apps and the dashboard.
-
Build Data Flows from Pingdom to SQL Server using SSIS
Easily back up Pingdom data to SQL Server using the SSIS components for Pingdom.
-
Integrate Live SharePoint Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SharePoint data from within the IDE.
-
How to Query Live SAP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP data data in natural language using Python.
-
Analyze Bright Data Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bright Data data with the CData JDBC Driver for Bright Data.
-
Analyze Redshift Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redshift from Power Pivot. You will use the Table Import Wizard to load Redshift data. You can visually build the import query or use any SQL supported by the driver.
-
How to create an RPA flow for Marketo Data in UiPath Studio
Use the Marketo ODBC Driver to create workflows that access real-time Marketo data without any coding.
-
Automate WooCommerce Data Replication to Azure Data Lake
Use CData Sync to customize and automate WooCommerce data replication to Azure Data Lake.
-
Integrating GitHub Copilot with Dynamics NAV 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.
-
Import Real-Time Google Campaign Manager 360 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Campaign Manager 360 data in ColdFusion.
-
Access Live TaxJar Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live TaxJar data from your Google Sheets.
-
Use Dash to Build to Web Apps on Planio Data
Create Python applications that use pandas and Dash to build Planio-connected web apps.
-
Integrate Devin with Live Pinterest 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 Pinterest data.
-
Extract, Transform, and Load Missive Data in Informatica PowerCenter
Create a simple Workflow for Missive data in Informatica PowerCenter.
-
Getting Started with the CData SSIS Components for Placid
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Placid.
-
How to Seamlessly Import Elasticsearch Data into IBM SPSS Modeler
Integrate Elasticsearch data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Antigravity CLI with Active Directory data via CData CLI
Connect Active Directory data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Wave Financial Data from PowerShell
Write a quick PowerShell script to query Wave Financial data. Use connectivity to the live data to replicate Wave Financial data to SQL Server.
-
Migrating data from Redshift to Snowflake using CData SSIS Components.
Easily push Redshift data to Snowflake using the CData SSIS Tasks for Redshift and Snowflake.
-
Create Informatica Mappings From/To a JDBC Data Source for IBM Cloud Object Storage
Create IBM Cloud Object Storage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect DBeaver to Moosend via a JDBC Driver
Manage Moosend data with visual tools in DBeaver like the query browser.
-
Bridge PingOne Connectivity with Apache NiFi
Access and process PingOne data in Apache NiFi using the CData JDBC Driver.
-
Visualize Aweber Data in Tableau
The CData ODBC driver for Aweber enables you integrate Aweber data into Tableau dashboards.
-
Connect to Hacker News Data from a Connection Pool in Jetty
The Hacker News JDBC Driver supports connection pooling: This article shows how to connect faster to Hacker News data from Web apps in Jetty.
-
Integrate with live SharePoint Data in Jitterbit
Use CData Connect AI to connect to and integrate live SharePoint data in Jitterbit.
-
Visualize Guru Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Guru data.
-
Build Automated HubSpot-Connected Workflows in Zapier
Use CData Connect AI to connect to live HubSpot data and build automated workflows in Zapier.
-
Integrate Google's Vertex AI Agent with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Drive data within intelligent workflows.
-
Visualize Live PingOne Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PingOne data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access Flowlu Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Flowlu data.
-
Connect to Real-Time Attio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Attio data in Power Apps.
-
Query Live Hive 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 Hive data through a conversational interface.
-
Build MVC Applications with Connectivity to Azure DevOps Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure DevOps from an ASP.NET MVC application.
-
Integrate Hive Data into Power Automate Desktop using CData Connect
CData Connect for Hive Data enables you to integrate Hive data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Real-Time Gorgias Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Gorgias data in Power Apps.
-
Object-Relational Mapping (ORM) with Jira 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 Jira data into a Java-based ORM framework, Hibernate.
-
Connect to Sage Intacct Data in HULFT Integrate
Connect to Sage Intacct as a JDBC data source in HULFT Integrate
-
Connect to SFTP Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SFTP Data and connect to SFTP data in Akorbi Digital RunMyProcess.
-
Connect to Salesforce Pardot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce Pardot data using standard SQL.
-
Connect to Workday Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Workday data.
-
Create Cloudant-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cloudant Data from OutSystems and build custom enterprise apps using live Cloudant data.
-
Access Live Kafka Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Kafka data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Clari Data from MySQL in PHP
Connect to Clari through the standard MySQL libraries in PHP.
-
Automated Continuous Amazon Marketplace Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQLite.
-
Automate Vimeo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Vimeo data from PowerShell? This article demonstrates how to utilize the Vimeo Cmdlets for tasks like connecting to Vimeo data, automating operations, downloading data, and more.
-
Integrate Live Google Drive Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Drive data from within the IDE.
-
Replicate Multiple Sage 300 Accounts via the CData Sync CLI
Replicate multiple Sage 300 accounts to one or many databases.
-
How to Build an ETL App for Google Contacts Data in Python with CData
Create ETL applications and real-time data pipelines for Google Contacts data in Python with petl.
-
Choosing the Best Method to Connect Teradata to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teradata data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Provide OData Services of eBay Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for eBay Analytics data by developing a WCF Service Application.
-
Build Semantic Layer Views for Simplesat Data in APOS Live Data Gateway
Use the CData Connector for Simplesat in APOS Live Data Gateway to build Semantic Layer Views for Simplesat data.
-
Connect to Discord Data in DBeaver
Use the CData ODBC Driver to connect to Discord data in DBeaver.
-
Build Semantic Layer Views for xBase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for xBase data.
-
Integrating Claude Code CLI with MailerSend 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 DBeaver to Facebook Ads via a JDBC Driver
Manage Facebook Ads data with visual tools in DBeaver like the query browser.
-
Integrate Live Bullhorn CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Bullhorn CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Bullhorn CRM data.
-
Create Dashboards and Visualize Live RSS Feeds in Geckoboard
Use CData Connect AI to connect to live RSS feeds and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Billsby-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Billsby data.
-
Back Up EmailOctopus 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 EmailOctopus data data.
-
Use the CData ODBC Driver for Short.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Short.io to connect to Short.io data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Short.io data in Excel.
-
Natively Connect to ChargeOver Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ChargeOver data. Leverage the native support for ODBC in PHP.
-
Query Live Freshdesk Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Freshdesk data directly from the development environment.
-
Integrating GitHub Copilot 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.