CData Software - Knowledge Base
Recent Articles
-
Automate Acumatica Data Replication to Azure Data Lake
Use CData Sync to customize and automate Acumatica data replication to Azure Data Lake.
-
Connect to Sage 200 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage 200 data using standard SQL.
-
Add Invoiced Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Invoiced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import and Visualize Calendly Data in Power View
Create data visualizations based on Calendly data in Excel.
-
Integrating Gumloop with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MongoDB data within automated workflows.
-
Access Adobe Target Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Adobe Target data from your Oracle system.
-
Build Automated Workflows with Live Microsoft OneDrive Data in Workato
Use CData Connect AI to connect to live Microsoft OneDrive data and build automated workflows in Workato.
-
Integrate Live Cosmos DB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Cosmos DB data to Blue Prism using the CData ODBC Driver for Cosmos DB to create automated workflows for repetitive business tasks.
-
Connect to Quickbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Quickbase.
-
How to Connect PostgreSQL Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live PostgreSQL data in real time using natural language.
-
Using the CData Software ODBC Driver for Aweber in PyCharm
Connect to Aweber as an ODBC data source in PyCharm using the CData Software ODBC Driver for Aweber.
-
Connect to Jira Assets 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 Jira Assets data.
-
Operational Reporting on LeadDesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LeadDesk data.
-
Access Live Telegram Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Telegram data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Viewing Autopilot Data in RAD Studio Data Explorer
How to view Autopilot data in RAD Studio Data Explorer using the CData ODBC Driver for Autopilot.
-
How to Connect to Live Azure Synapse Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Azure Synapse data through natural language.
-
How to Connect Flowise AI Agents to Live Omnisend 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 Omnisend data without replication.
-
Replicate Notion Data to Multiple Databases
Replicate Notion data to disparate databases with a point-and-click configuration.
-
How to use SQLAlchemy ORM to access Excel Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Excel Online data.
-
Build a Singer.io Tap for HDFS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HDFS data using the CData Python Connector.
-
Analyze Stripe Data in Cognos Analytics
Use CData Connect AI to connect to Stripe Data from Cognos Analytics and analyze live Stripe data.
-
Build AI/ML Models with Live Elasticsearch Data using Dataiku
Connect Elasticsearch Data with Dataiku using the CData JDBC Driver for Elasticsearch.
-
Integrating Claude Code with Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Spanner data within assisted coding and automated development workflows.
-
Connect to Omnisend Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Omnisend to connect to Omnisend data and execute queries in PowerBuilder.
-
Connect to Stripe Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Stripe data using standard SQL.
-
Workday Reporting in OBIEE with the Workday JDBC Driver
Deploy the Workday JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Design BIRT Reports on SAP ByDesign Data
Provide current SAP ByDesign data to your embedded analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Short.io
Provide connectivity to Short.io data through an SAP BusinessObjects universe.
-
Integrate REST Data in the Pentaho Report Designer
Publish reports based on REST data in the Pentaho BI tool.
-
Use Grok to Talk to Your Vertica 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 Vertica data for you.
-
Automated Continuous Coda Replication to MongoDB
Use CData Sync for automated, continuous, customizable Coda replication to MongoDB.
-
Replicate Demio Data in Heroku for Use in Salesforce Connect
Replicate Demio data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Building Dynamic Web Pages with Oracle Eloqua Data Using AngularJS
Create single-page applications with live connectivity to Oracle Eloqua using the CData API Server.
-
Query Twitter Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Twitter Ads data from Node.js.
-
Visualize Coinbase Data in Sisense
Create an ElastiCube in Sisense app with access to Coinbase data.
-
Getting Started with the CData Excel Add-In for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CapsuleCRM.
-
How to Connect to Facebook Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook Ads data. Leverage the pyodbc module for ODBC in Python.
-
Build Cosmos DB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Cosmos DB data and build Cosmos DB-connected web apps with Axios.
-
How to Create Power BI Visual Reports with Real-Time Auth0 Data
Use CData Power BI Connectors to visualize Auth0 data in Power BI.
-
Choosing the Best Method to Connect Mistral AI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mistral AI data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Exa Data in Cognos Analytics
Use CData Connect AI to connect to Exa Data from Cognos Analytics and analyze live Exa data.
-
Add PhantomBuster Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PhantomBuster with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Reports with PayPal Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PayPal data.
-
How to create an RPA flow for Email Data in UiPath Studio
Use the Email ODBC Driver to create workflows that access real-time Email data without any coding.
-
Connect to and Query Google Tasks Data in QlikView over ODBC
Create data visualizations with Google Tasks data in QlikView.
-
Connect to SageHR Data in RapidMiner
Integrate SageHR data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Vimeo Data from PowerShell
Write a quick PowerShell script to query Vimeo data. Use connectivity to the live data to replicate Vimeo data to SQL Server.
-
Connect to SAP Ariba Source Data from AWS Glue
Use CData Connect AI to gain access to live SAP Ariba Source data from your AWS Glue jobs.
-
A PostgreSQL Interface for BenchmarkEmail Data (MySQL Remoting via JDBC)
Use the Remoting features of the BenchmarkEmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import MailerLite Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MailerLite Data and provide access to live MailerLite data for custom reports in the Power BI Service.
-
How to publish and share Quaderno Data dashboards with Tableau Server
The CData ODBC driver for Quaderno enables you integrate Quaderno data into Tableau dashboards.
-
Automated Continuous Oracle Eloqua Reporting Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Vertica.
-
Connect to Moosend Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Moosend and work with Moosend data in your FileMaker applications.
-
Integrate with Mode Data in JReport Designer
Create charts and reports based on Mode data in JReport Designer.
-
Access Live Outreach.io 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 Outreach.io data through MCP integration.
-
Automate LightSpeedRetail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LightSpeedRetail data from PowerShell? This article demonstrates how to utilize the LightSpeedRetail Cmdlets for tasks like connecting to LightSpeedRetail data, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy Web
Connect to Customer.io data in MicroStrategy Web using the CData Software ODBC Driver for Customer.io.
-
Model Azure Data Lake Storage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Data Lake Storage, enabling the direct import of real-time Azure Data Lake Storage data.
-
Connect to Xero Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Xero Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Choosing the Best Method to Connect Tickspot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tickspot data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build MYOB AccountRight-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MYOB AccountRight Data and create custom apps in Mendix.
-
Integrating Cursor with Intercom 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.
-
Working with iContact Data in LINQPad
Execute LINQ queries to iContact data in LINQPad.
-
Build Semantic Layer Views for Bitly Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Bitly data.
-
How to connect to SendGrid Data in DBVisualizer
Integrate SendGrid data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Freshdesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshdesk data from Appeon PowerBuilder using the CData ADO.NET Provider for Freshdesk.
-
How to Connect to Live Freshdesk Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Freshdesk data through natural language.
-
Create Splunk-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Splunk Data from OutSystems and build custom enterprise apps using live Splunk data.
-
How to Visualize Salesloft Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesloft data in Python.
-
Integrate PagerDuty Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PagerDuty data from Informatica Cloud.
-
How to Create Power BI Visual Reports with Real-Time TaxJar Data
Use CData Power BI Connectors to visualize TaxJar data in Power BI.
-
Build Browserless-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Browserless data and build web apps with connectivity to live Browserless data.
-
Work with Live QuickBooks Online Data in Power Query
Use CData Connect AI to connect to QuickBooks Online data and work with live QuickBooks Online data in Microsoft Power Query.
-
Write a Simple Go Application to work with Redshift Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Redshift data.
-
Publish Reports with Unbounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce data.
-
Integrate LibreChat with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Acumatica data from within the chat interface.
-
Access Testmonitor Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Testmonitor data.
-
Analyze Workable Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Workable data with the CData JDBC Driver for Workable.
-
Create Zoho CRM-Connected Business Apps in AppSheet
Connect to Zoho CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho CRM data.
-
Connect to Klipfolio from Asprova with CData Software ODBC Driver for Klipfolio
This article shows how to connect faster to Klipfolio data from Asprova.
-
Use Claude to Talk to Your Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Timely data for you.
-
Use the CData Software JDBC Driver for Klipfolio in MicroStrategy Web
Connect to Klipfolio data in MicroStrategy Web using the CData Software JDBC Driver for Klipfolio.
-
Integrate CampaignMonitor Data in Pentaho Data Integration
Build ETL pipelines based on CampaignMonitor data in the Pentaho Data Integration tool.
-
Build a PostgreSQL Interface for OneNote Data using the CData JDBC Driver
Use the Remoting features of the OneNote JDBC Driver to create a PostgreSQL entry-point for data access.
-
Trigger Microsoft Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Ads with standard wizards in Logic Apps.
-
Connect to Oracle Sales Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Sales data from PowerBuilder using the Oracle Sales JDBC Driver.
-
Process & Analyze SAP Business Warehouse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Business Warehouse Data.
-
Connect to Reckon Data from Crystal Reports
Use CData Connect AI to connect to and report on live Reckon data from Crystal Reports.
-
Automated Continuous Clockify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Clockify replication to Amazon S3.
-
Getting Started with the CData ADO.NET Provider for Access
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Access.
-
Integrating Claude Code CLI with Intercom 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 Real-Time Access to Redis in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Redis data in real time.
-
Access Live Brex Data in Coginiti Pro
Connect to and query live Brex data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Consume Salesforce Marketing OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Marketing data as OData feeds from PowerBuilder using the API Server.
-
Use the CData SSIS Components to Insert New or Update Existing Basecamp Records from SQL Server
Easily push SQL Server data to Basecamp using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Basecamp or update existing records with data from a SQL Server database.
-
Connect to Real-Time Oracle Financials Cloud Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Financials Cloud and Dataflow to import and use Oracle Financials Cloud data in Power Apps.
-
How to Access Live Bitbucket Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bitbucket enables you to integrate Bitbucket data into workflows built using Microsoft Power Automate Desktop.
-
Build a Singer.io Tap for Bitly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bitly data using the CData Python Connector.
-
Integrating Claude Code CLI with ServiceNow 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 ChatGPT to Talk to Your Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Analytics data for you.