CData Software - Knowledge Base
Recent Articles
-
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.
-
Using the CData Software ODBC Driver for EnterpriseDB in PyCharm
Connect to EnterpriseDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for EnterpriseDB.
-
Integrate Google's Antigravity Agent with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Workday data using the Model Context Protocol.
-
Publish Azure Table-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Table data.
-
Build Apps with Live Pushbullet Data Using the Low-Code Development Platform of Mendix
Connect Pushbullet data with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData ODBC Driver for Mode
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mode.
-
Connect to FreshBooks Data from Crystal Reports
Use CData Connect AI to connect to and report on live FreshBooks data from Crystal Reports.
-
Analyze Pinecone Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pinecone from Power Pivot. You will use the Table Import Wizard to load Pinecone data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Testmonitor Data Replication to Teradata
Use CData Sync to Customize and automate Testmonitor data replication to Teradata.
-
Automated Continuous Kafka Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Kafka replication to Google Cloud SQL.
-
Build AI Agents with OneNote Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live OneNote data through CData Connect AI.
-
Use Biml to Build SSIS Tasks to Replicate Typeform Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Typeform data to SQL Server.
-
Integrating LangGraph with Microsoft Planner Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Planner data within automated workflows.
-
Connect to Authorize.Net Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Authorize.Net to connect to Authorize.Net data and execute queries in PowerBuilder.
-
Build Dashboards with Google Tasks Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Tasks data in Dundas BI.
-
Build XML-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live XML data and build XML-connected web apps with Axios.
-
DataBind Controls to ZohoPeople Data in C++Builder
DataBind to ZohoPeople data in C++Builder with standard components and controls.
-
Use Manus AI to Talk to Your eBay 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 eBay data.
-
Connect to Gong Data from a Connection Pool in JBoss
Integrate Gong data into Java servlets: Use the Management Console in JBoss to install the Gong JDBC Driver.
-
How to create Visio diagrams from Microsoft Planner Data
Automatically update Microsoft Planner data with the changes you make to Visio master shapes.
-
How to connect SharePoint with Bitbucket Data through external lists
Provide Bitbucket data to SharePoint users as an external list.
-
Create Apps from ZohoInvoice Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoInvoice Data and build apps from live ZohoInvoice data in Qlik Sense Cloud.
-
Use Databricks Agent Bricks to Talk to Your Spark Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Spark data for you.
-
Query Live WooCommerce 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 WooCommerce data directly from the development environment.
-
Automate Gong Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Gong data from PowerShell? This article demonstrates how to utilize the Gong Cmdlets for tasks like connecting to Gong data, automating operations, downloading data, and more.
-
How to Seamlessly Import VWO Data into IBM SPSS Modeler
Integrate VWO data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Connect AI Python SDK for YouTube Analytics
Install the CData Connect AI Python SDK to read and write live YouTube Analytics data with standard DB-API 2.0 Python code.
-
How to Use a Microsoft Access Database to Update Sugar CRM Data in Real Time
Update Sugar CRM data by creating a linked table in Microsoft Access with the CData Sugar CRM ODBC Driver.
-
How to integrate Metabase with Vault CRM Data
Use CData Connect AI to connect to live Vault CRM data and create an interactive dashboard in Metabase from Vault CRM data.
-
Build Paylocity Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Paylocity data and build visualizations in Tableau Cloud.
-
Add Google Forms Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Forms with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze BigQuery Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BigQuery data in Microsoft R Open.
-
Automated Blackbaud FE NXT Data Replication to Teradata
Use CData Sync to Customize and automate Blackbaud FE NXT data replication to Teradata.
-
Automated Continuous Workday Replication to Databricks
Use CData Sync for automated, continuous, customizable Workday replication to Databricks.
-
Integrate with ZendeskSell Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZendeskSell data to a JSON file on disk.
-
Getting Started with the CData SSIS Components for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LightSpeedRetail.
-
Build Semantic Layer Views for Microsoft OneDrive Data in APOS Live Data Gateway
Use the CData Connector for Microsoft OneDrive in APOS Live Data Gateway to build Semantic Layer Views for Microsoft OneDrive data.
-
Build Automated Workflows with Live Dynamics NAV Data in Workato
Use CData Connect AI to connect to live Dynamics NAV data and build automated workflows in Workato.
-
Integrating LlamaIndex with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Jira Assets data in real time.
-
Deploy the ADO.NET Provider for Landbot on an SSRS Report Server
Connect to Landbot data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Create Cosmos DB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cosmos DB data access from reports, embedded analytics, and more.
-
Connect to Oracle Eloqua Data in CloverDX (formerly CloverETL)
Transfer Oracle Eloqua data using the visual workflow in the CloverDX data integration tool.
-
CData API Server Overview
A detailed overview of CData API Server and its ability to create REST APIs for cloud and on-prem data.
-
Working with Office 365 Data in LINQPad
Execute LINQ queries to Office 365 data in LINQPad.
-
Analyze Microsoft Exchange Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Exchange Data from Cognos Analytics and analyze live Microsoft Exchange data.
-
Create Apify-Connected Dashboards in Grafana
Connect to Apify Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apify data.
-
Create Dynamic ZohoPeople Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoPeople to Infragistics XamDataGrid to build dynamic grids.
-
Connect to REST Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to REST.
-
Work with Calendly Data in FoxPro
Load Calendly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate DocuSign Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to DocuSign data and integrate live DocuSign data into your Power Automate tasks.
-
Build Dashboards with Adobe Commerce Data in DBxtra
Create dynamic dashboards and perform analytics based on Adobe Commerce data in DBxtra.
-
Stream IBM Informix Data into Apache Kafka Topics
Access and stream IBM Informix data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Stream AlloyDB Data into Apache Kafka Topics
Access and stream AlloyDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Google Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Analytics data.
-
Create Datasets from TaxJar in Domo Workbench and Build Visualizations of TaxJar Data in Domo
Use the CData Software ODBC Driver for TaxJar to create datasets from TaxJar data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy Web
Connect to Sybase data in MicroStrategy Web using the CData Software ODBC Driver for Sybase.
-
How to connect and process Bitbucket data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bitbucket data.
-
Connect Postmark to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Postmark data using the CData Python MCP Server.
-
Integrating Claude Code CLI with ZohoDesk 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 Zendesk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zendesk Data and create custom apps in Bubble.
-
How to Work with ChargeOver Data in AWS Glue Jobs Using JDBC
Connect to ChargeOver from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Goose with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live DB2 data from within the local AI agent.
-
Replicate Egnyte Data from PowerShell
Write a quick PowerShell script to query Egnyte data. Use connectivity to the live data to replicate Egnyte data to SQL Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Couchbase
Create Couchbase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Create Power BI Visual Reports with Real-Time CapsuleCRM Data
Use CData Power BI Connectors to visualize CapsuleCRM data in Power BI.
-
Automated Continuous Amazon Athena Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Amazon S3.
-
Use Biml to Build SSIS Tasks to Replicate Azure DevOps Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure DevOps data to SQL Server.
-
Automated Continuous Marketo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Marketo replication to Apache Kafka.
-
Automated Continuous BigCommerce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable BigCommerce replication to Apache Kafka.
-
Migrating data from Pipedrive to Google BigQuery using CData SSIS Components.
Easily push Pipedrive data to Google BigQuery using the CData SSIS Tasks for Pipedrive and Google BigQuery.
-
Build Automated Workflows with Live Workday Data in Workato
Use CData Connect AI to connect to live Workday data and build automated workflows in Workato.
-
How to connect and process Wistia data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Wistia data.
-
How to create Visio diagrams from Sage Intacct Data
Automatically update Sage Intacct data with the changes you make to Visio master shapes.
-
Integrating Cursor with Sage Intacct 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 Data Flows from SurveyMonkey to SQL Server using SSIS
Easily back up SurveyMonkey data to SQL Server using the SSIS components for SurveyMonkey.
-
Build Visualizations of OneNote Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OneNote data in Birst.
-
Feed SAP Ariba Procurement Data into FineReport
How to set SAP Ariba Procurement data as a JDBC data source in FineReport.
-
Query Highrise Data as a MySQL Database in Node.js
Execute MySQL queries against Highrise data from Node.js.
-
Use Azure AI Foundry to Talk to Your Microsoft Dataverse 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 Microsoft Dataverse data for you.
-
Automate Omnisend Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Omnisend data from PowerShell? This article demonstrates how to utilize the Omnisend Cmdlets for tasks like connecting to Omnisend data, automating operations, downloading data, and more.
-
Operational Reporting on MessageBird Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MessageBird data.
-
Import Adobe Commerce Data Using Azure Data Factory
Use CData Connect AI to connect to Adobe Commerce Data from Azure Data Factory and import live Adobe Commerce data.
-
Integrate ZohoInvoice with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoInvoice with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoInvoice data.
-
Getting Started with the CData Python Connector for ClickTime
Learn to install and license the CData Python Connector and configure a connection to live ClickTime data.
-
Integrating Gumloop with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Synapse data within automated workflows.
-
Connect to PabblySubscriptions Data in Aqua Data Studio
Access PabblySubscriptions data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Snowflake Data in Aqua Data Studio
Access Snowflake data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Model Confluence Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Confluence, enabling the direct import of real-time Confluence data.
-
Create Zendesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zendesk data access from reports, embedded analytics, and more.
-
Access Live Discord Data in AWS Lambda
Connect to live Discord data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Perplexity Replication to SQLite
Use CData Sync for automated, continuous, customizable Perplexity replication to SQLite.
-
Build an OLAP Cube in SSAS from Zoho Projects Data
Establish a connection to Zoho Projects data data from SQL Server Analysis Services, and use the Zoho Projects Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Cursor with Anaplan 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.
-
Manage Paylocity Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Paylocity.
-
Create Adobe Commerce-Connected Applications in Appsmith
Connect to Adobe Commerce Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Commerce data.
-
Connect to Opsgenie Data in RapidMiner
Integrate Opsgenie data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze ZohoPeople Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ZohoPeople data and visualize ZohoPeople data in SAP Analytics Cloud.
-
Create Datasets from Simplesat in Domo Workbench and Build Visualizations of Simplesat Data in Domo
Use the CData Software ODBC Driver for Simplesat to create datasets from Simplesat data in Domo Workbench and then build visualizations in the Domo service.
-
Build Yelp-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Yelp Data from Zoho Analytics and import live Yelp data.
-
Create Dynamic Paylocity Grids Using the Infragistics XamDataGrid
Learn how you can connect Paylocity to Infragistics XamDataGrid to build dynamic grids.