CData Software - Knowledge Base
Recent Articles
-
Access Live SAP SuccessFactors LMS Data in Coginiti Pro
Connect to and query live SAP SuccessFactors LMS data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Operational Reporting on Typeform Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Typeform data.
-
Build Azure Synapse-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 Azure Synapse data without replication.
-
Query Live Paylocity 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 Paylocity data through a conversational interface.
-
Use Dash to Build to Web Apps on Anaplan Data
Create Python applications that use pandas and Dash to build Anaplan-connected web apps.
-
How to Work with Tanda Data in ETL Validator JDBC
Connect to Tanda from ETL Validator jobs using the CData Software JDBC Driver.
-
LINQ to Zoho Creator 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 Zoho Creator Data Provider.
-
Connect to Workday Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Workday and the SQL Gateway to access Workday data from Google Apps Script.
-
Integrating Amazon Athena Data in Talend Cloud Data Management Platform
Connect Amazon Athena Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon Athena.
-
Analyze SQL Analysis Services Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SQL Analysis Services data in Microsoft R Open.
-
Connect to Live Redshift Data in MicroStrategy through CData Connect AI
Create a live connection to Redshift Data in CData Connect AI and connect to your Redshift data from MicroStrategy.
-
Visualize ZohoDesk 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 ZohoDesk data into TIBCO Spotfire.
-
Integrate VWO Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live VWO data from Informatica Cloud.
-
Access Live Wave Financial Data in AWS Lambda
Connect to live Wave Financial data in AWS Lambda using the CData JDBC Driver.
-
Enable the Procore JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Procore data.
-
Integrate Theia IDE with Live Procore 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 Procore data from within the development environment.
-
Analyze SQL Server Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SQL Server data in Microsoft R Open.
-
Connect SAP SuccessFactors LMS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP SuccessFactors LMS with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData SSIS Components for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics NAV.
-
Integrate with Live AgileCRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to AgileCRM from the MuleSoft Anypoint Platform to integrate live AgileCRM data into custom reports and dashboards.
-
Integrate OpenCode with Live BigQuery Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live BigQuery data from within your AI coding agent.
-
Use the CData ODBC Driver for Mixpanel in Microsoft Power Query
You can use the CData Mixpanel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mixpanel data into Microsoft Power Query.
-
Import Real-Time ConvertAPI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ConvertAPI data in ColdFusion.
-
Bridge iContact Connectivity with Apache NiFi
Access and process iContact data in Apache NiFi using the CData JDBC Driver.
-
Easily Integrate Avro Data in Lazarus Pascal IDE
Learn how to easily integrate live Avro data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Amazon Athena Data in TIBCO Data Virtualization
Use the Amazon Athena Tibco DV Adapter to create a Amazon Athena data data source in TIBCO Data Virtualization Studio and gain access to live Amazon Athena data from your TDV Server.
-
Build Voice Agents in ElevenLabs with access to Live Figshare Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Figshare data.
-
Automate Tanda Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tanda data from PowerShell? This article demonstrates how to utilize the Tanda Cmdlets for tasks like connecting to Tanda data, automating operations, downloading data, and more.
-
Search External Greenhouse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Greenhouse data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Greenhouse Data objects that you can access from apps and the dashboard.
-
Connect to ConstantContact Data from HeidiSQL
Use CData Connect AI to connect to and query live ConstantContact data from HeidiSQL.
-
Integrate with PhantomBuster Data in JReport Designer
Create charts and reports based on PhantomBuster data in JReport Designer.
-
View Reports on Real-Time Simplesat Data in Power BI Report Server
Use the CData ODBC Driver for Simplesat to visualize Simplesat data in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Exa to Snowflake using CData SSIS Components.
Easily push Exa data to Snowflake using the CData SSIS Tasks for Exa and Snowflake.
-
How to integrate xBase with Apache Airflow
Access and process xBase data in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Twilio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio data.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce CRM Analytics
Create Salesforce CRM Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Cohere Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cohere data from your Oracle system.
-
Establish a Live Connection with Anaplan Data using Tableau Bridge
The CData ODBC Driver for Anaplan enables you to integrate live Anaplan data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Office 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Office 365 data access from reports, embedded analytics, and more.
-
Visualize Live Microsoft Entra ID Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Entra ID data.
-
Create Teradata Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Teradata from PowerBI.com to create Power BI Dataflows with real-time data.
-
Configure the CData JDBC Driver for CampaignMonitor in a Connection Pool in Tomcat
Connect to CampaignMonitor data from a connection pool in Tomcat.
-
How to Connect to Live GitLab Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your GitLab data for you.
-
Integrating Boomi Agentstudio with SendGrid Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SendGrid data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Build an ETL App for Timely Data in Python with CData Connect AI
Extract and transform live Timely data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Dify with Live AgileCRM 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 AgileCRM data.
-
Integrate with Live Salesforce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce from the MuleSoft Anypoint Platform to integrate live Salesforce data into custom reports and dashboards.
-
Excel Spreadsheet Automation on Jira Data with the QUERY Formula
Pull data from Jira, automate spreadsheets, and more with the QUERY formula.
-
How to Query Intercom Data in MySQL Workbench
Execute MySQL queries against live Intercom data from MySQL Workbench.
-
Getting Started with the CData ADO.NET Provider for Pipedrive
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Pipedrive.
-
Automated Continuous Dynamics CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SQL Server.
-
Create Datasets from Dynamics NAV in Domo Workbench and Build Visualizations of Dynamics NAV Data in Domo
Use the CData Software ODBC Driver for Dynamics NAV to create datasets from Dynamics NAV data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Testmonitor Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Testmonitor replication to delimited files (CSV/TSV).
-
Analyze BambooHR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BambooHR data and visualize live BambooHR data in Infragistics Reveal.
-
Getting Started with the CData ODBC Driver for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SurveyMonkey.
-
Replicate Shortcut Data to Multiple Databases via the CData Sync CLI
Replicate Shortcut data to disparate databases with a single configuration.
-
Pipeline CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pipeline CRM facts in real time.
-
Analyze QuickBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for QuickBooks from Power Pivot. You will use the Table Import Wizard to load QuickBooks data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Codex with Tickspot 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 Yelp-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Yelp Data from OutSystems and build custom enterprise apps using live Yelp data.
-
Integrate with Telegram Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Telegram data to a JSON file on disk.
-
Build MVC Applications with Connectivity to VWO Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access VWO from an ASP.NET MVC application.
-
Query Instantly Data as a MySQL Database in Node.js
Execute MySQL queries against Instantly data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Asana
Provide connectivity to Asana data through an SAP BusinessObjects universe.
-
Provide OData Services of Notion Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Notion data by developing a WCF Service Application.
-
How to Visualize OneNote Data in Python with pandas
Use pandas and other modules to analyze and visualize live OneNote data in Python.
-
Replicate Multiple Quaderno Accounts via the CData Sync CLI
Replicate multiple Quaderno accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for Customer.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Customer.io.
-
Interact with Live Stripe Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Stripe data.
-
Create Salesforce Marketing Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Marketing data access from reports, embedded analytics, and more.
-
Automated Continuous Elorus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Elorus replication to PostgreSQL.
-
How to Connect to FreshBooks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FreshBooks data. Leverage the pyodbc module for ODBC in Python.
-
Automate Oracle SCM Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle SCM data replication to Azure Synapse.
-
Consume Amazon Athena OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon Athena feeds that reflect any changes in SAP Lumira.
-
Process & Analyze Attio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Attio Data.
-
DataBind Adobe Experience Manager Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Experience Manager with the DevExpress Windows Forms and Web controls to provide Adobe Experience Manager data to a chart.
-
Automated Continuous Adobe Commerce Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MySQL.
-
Use JayDeBeApi to access Zoho Recruit Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Recruit data.
-
Connect to Klipfolio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Klipfolio and the SQL Gateway to access Klipfolio data from Google Apps Script.
-
Integrating OpenCode with Paymo 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 Recurly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Recurly to connect to Recurly data from Web applications running on WebLogic.
-
Link ShipStation with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ShipStation data in Filemaker Pro for Mac or Windows.
-
Integrating LangChain with Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Anaplan data within automated workflows.
-
How to create an RPA flow for ZendeskSell Data in UiPath Studio
Use the ZendeskSell ODBC Driver to create workflows that access real-time ZendeskSell data without any coding.
-
Query Live eBay 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 eBay data directly from the development environment.
-
Publish Reckon-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Reckon data.
-
Create MailerLite-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MailerLite Data from OutSystems and build custom enterprise apps using live MailerLite data.
-
Integrate Google's Antigravity Agent with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAS Data Sets data using the Model Context Protocol.
-
Import Real-Time GitLab Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GitLab data in ColdFusion.
-
Connect to Dynamics NAV Data in ACL Analytics
Connect to Dynamics NAV data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dynamics NAV data.
-
Choosing the Best Method to Connect SharePoint Excel Services to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SharePoint Excel Services data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MailerLite
Provide connectivity to MailerLite data through an SAP BusinessObjects universe.
-
How to Query Live Azure Data Catalog Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Data Catalog data data in natural language using Python.
-
Design BIRT Reports on Greenhouse Data
Provide current Greenhouse data to your embedded analytics.
-
Use the CData Software ODBC Driver for Planio in MicroStrategy Web
Connect to Planio data in MicroStrategy Web using the CData Software ODBC Driver for Planio.
-
Easily Integrate Google Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Analytics data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create CapsuleCRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to CapsuleCRM Data from Klipfolio and build custom visualizations using live CapsuleCRM data.
-
Use the CData Software JDBC Driver for Mistral AI in MicroStrategy Web
Connect to Mistral AI data in MicroStrategy Web using the CData Software JDBC Driver for Mistral AI.
-
Use Agno to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your ActiveCampaign data for you.
-
Access Live Basecamp Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Basecamp data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.