CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Pushbullet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pushbullet replication to AlloyDB.
-
Connect to Microsoft Teams Data in ACL Analytics
Connect to Microsoft Teams data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Teams data.
-
Automated Continuous Freshservice Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Freshservice replication to Apache Kafka.
-
Moving Data from SQL Analysis Services to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SQL Analysis Services data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Automated Workflows with Live Authorize.Net Data in Workato
Use CData Connect AI to connect to live Authorize.Net data and build automated workflows in Workato.
-
Validate JSON Services with QuerySurge
Access and validate JSON services in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Notion in MicroStrategy Desktop
Connect to Notion data in MicroStrategy Desktop using the CData Software JDBC Driver for Notion.
-
Getting Started with the CData Python Connector for Stack Exchange
Learn to install and license the CData Python Connector and configure a connection to live Stack Exchange data.
-
Import Real-Time MySQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MySQL data in ColdFusion.
-
How to Query Spotify Data in MySQL Workbench
Execute MySQL queries against live Spotify data from MySQL Workbench.
-
Replicate Amazon Athena Data from PowerShell
Write a quick PowerShell script to query Amazon Athena data. Use connectivity to the live data to replicate Amazon Athena data to SQL Server.
-
Automated Continuous Optimizely Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Optimizely replication to Azure SQL Database.
-
Automate DB2 for i Data Replication to SAP HANA
Use CData Sync to customize and automate DB2 for i data replication to SAP HANA.
-
How to use SQLAlchemy ORM to access SAP Business One Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Business One data.
-
Integrating OpenCode with Certinia 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 Datasets from Sage 300 in Domo Workbench and Build Visualizations of Sage 300 Data in Domo
Use the CData Software ODBC Driver for Sage 300 to create datasets from Sage 300 data in Domo Workbench and then build visualizations in the Domo service.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Instantly
Provide connectivity to Instantly data through an SAP BusinessObjects universe.
-
Integrate with live SAP Ariba Source Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Ariba Source data in Jitterbit.
-
How to Seamlessly Import Jodoo Data into IBM SPSS Modeler
Integrate Jodoo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Design BIRT Reports on Dotmailer Data
Provide current Dotmailer data to your embedded analytics.
-
How to Query Live Perplexity Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Perplexity data data in natural language using Python.
-
DataBind Charts to Scrapfly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Scrapfly 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.
-
Manage Scrapfly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Scrapfly.
-
Establish a Live Connection with PabblySubscriptions Data using Tableau Bridge
The CData ODBC Driver for PabblySubscriptions enables you to integrate live PabblySubscriptions data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create SparkPost-Connected Applications in Appsmith
Connect to SparkPost Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SparkPost data.
-
Connect to Printful Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Printful data in the Denodo Virtual DataPort Administrator.
-
Integrating Codex with Excel Online 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.
-
Interact with Live Airtable Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Airtable data.
-
Explore Geographical Relationships in Qualaroo Data with Power Map
Create data visualizations with Qualaroo data in Power Map.
-
Create Apps from Bright Data Data in Qlik Sense Cloud
Use CData Connect AI to connect to Bright Data Data and build apps from live Bright Data data in Qlik Sense Cloud.
-
Work with Notion Data in FoxPro
Load Notion data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Hacker News in MicroStrategy Web
Connect to Hacker News data in MicroStrategy Web using the CData Software ODBC Driver for Hacker News.
-
Automated Continuous SAP Business One Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Business One replication to Amazon S3.
-
How to Connect Flowise AI Agents to Live FreshBooks 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 FreshBooks data without replication.
-
Use Dash to Build to Web Apps on SAP Business One Data
Create Python applications that use pandas and Dash to build SAP Business One-connected web apps.
-
How to Access Live Wave Financial Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Wave Financial enables you to integrate Wave Financial data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Hubstaff in MicroStrategy Desktop
Connect to Hubstaff data in MicroStrategy Desktop using the CData Software ODBC Driver for Hubstaff.
-
Connect to OData Services as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live OData services.
-
Visualize SharePoint Excel Services Data in TIBCO Spotfire through OData
Integrate SharePoint Excel Services data into dashboards in TIBCO Spotfire.
-
Validate ConstantContact Data with QuerySurge
Access and validate ConstantContact data in QuerySurge using the CData JDBC Driver.
-
Integrating Kiro with Active Directory 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 Apps with Live Oracle Service Cloud Data Using the Low-Code Development Platform of Mendix
Connect Oracle Service Cloud data with Mendix to build apps using the CData JDBC Driver for Oracle Service Cloud.
-
Publish Close-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Close data.
-
Connect to Live Odoo Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Odoo in CData Connect AI and connect to your Odoo data from PostgreSQL.
-
Integrate SAP SuccessFactors Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP SuccessFactors data and integrate live SAP SuccessFactors data into your Power Automate tasks.
-
Build a Simple VCL Application for Adobe Commerce Data
How to build a simple VCL Application to view Adobe Commerce data in RAD Studio using the CData ODBC Driver for Adobe Commerce.
-
Automated Continuous ShipStation Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ShipStation replication to Amazon Redshift.
-
Automate Aha! Data Replication to Azure Data Lake
Use CData Sync to customize and automate Aha! data replication to Azure Data Lake.
-
Import Real-Time Microsoft Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Ads data in ColdFusion.
-
Automated Continuous Shopify Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Shopify replication to Azure SQL Database.
-
Connect to Redshift Data in ACL Analytics
Connect to Redshift data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Redshift data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP BusinessObjects BI
Provide connectivity to SAP BusinessObjects BI data through an SAP BusinessObjects universe.
-
Use Azure AI Foundry to Talk to Your BigQuery 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 BigQuery data for you.
-
Connecting Moonlit Workflow with SAP Ariba Procurement Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Ariba Procurement data in real time.
-
Choosing the Best Method to Connect Zoho Projects to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Projects data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect Flowise AI Agents to Live Timely 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 Timely data without replication.
-
Create Rebilly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Rebilly data access from reports, embedded analytics, and more.
-
Replicate Multiple Moosend Accounts via the CData Sync CLI
Replicate multiple Moosend accounts to one or many databases.
-
Visualize Notion 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 Notion data into TIBCO Spotfire.
-
Integrate with Clio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clio data to a JSON file on disk.
-
How to Access Live Zuora Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zuora enables you to integrate Zuora data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Cline with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage 200 data from within your IDE.
-
Query Brex Data in DataGrip
Create a Data Source for Brex in DataGrip and use SQL to query live Brex data.
-
Use Claude to Talk to Your Zoho Projects 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 Zoho Projects data for you.
-
Integrating Claude Code with SparkPost Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SparkPost data within assisted coding and automated development workflows.
-
Automate Certinia Data Replication to Couchbase
Use CData Sync to Customize and automate Certinia data replication to Couchbase.
-
Visualize ZeroBounce Data in Sisense
Create an ElastiCube in Sisense app with access to ZeroBounce data.
-
Getting Started with the CData Power BI Connector for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Vault CRM.
-
Visualize Live Mocean Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mocean data.
-
Automated Continuous Telegram Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Telegram replication to Azure SQL Database.
-
Access Live Outreach.io Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Outreach.io data from your Excel spreadsheets.
-
Build Moosend-Connected Apps in Choreo
Use CData Connect AI to connect to Moosend Data from Choreo and build custom apps using live Moosend data.
-
Access Live Confluence Data in TIBCO Data Virtualization
Use the Confluence Tibco DV Adapter to create a Confluence data data source in TIBCO Data Virtualization Studio and gain access to live Confluence data from your TDV Server.
-
Integrating Kiro with SendGrid 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 a PostgreSQL Interface for REST Data using the CData JDBC Driver
Use the Remoting features of the REST JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Epicor Kinetic Data in Sisense
Create an ElastiCube in Sisense app with access to Epicor Kinetic data.
-
Connect to Google Sheets Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Sheets to connect to Google Sheets data and execute queries in PowerBuilder.
-
Choosing the Best Method to Connect Stripe to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Stripe data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Mouseflow Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mouseflow replication to Apache Cassandra.
-
Model, Search, and Visualize Live PingOne Data in ThoughtSpot
Use CData Connect AI to connect to live PingOne data for modeling, searching, and visualizing.
-
Connect to xBase Data in JRuby
Create a simple JRuby app with access to live xBase data.
-
Automated Continuous Hacker News Replication to Oracle
Use CData Sync for automated, continuous, customizable Hacker News replication to Oracle.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua data for you.
-
Use the CData Software ODBC Driver for Egnyte in MicroStrategy
Connect to Egnyte data in MicroStrategy Developer using the CData Software ODBC Driver for Egnyte.
-
Replicate SAP Ariba Source Data in Heroku for Use in Salesforce Connect
Replicate SAP Ariba Source data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy Web
Connect to SAP Hybris C4C data in MicroStrategy Web using the CData Software ODBC Driver for SAP Hybris C4C.
-
Use Azure AI Foundry to Talk to Your BigCommerce 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 BigCommerce data for you.
-
Publish LaunchDarkly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LaunchDarkly data.
-
Use the CData ODBC Driver for TaxJar from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for TaxJar to connect to TaxJar data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring TaxJar data in Excel.
-
Integrate Goose with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Paylocity data from within the local AI agent.
-
Automate Eventbrite Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Eventbrite data from PowerShell? This article demonstrates how to utilize the Eventbrite Cmdlets for tasks like connecting to Eventbrite data, automating operations, downloading data, and more.
-
How to Connect to Live SurveyMonkey Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SurveyMonkey data for you.
-
Connect to Live LinkedIn Ads Data in MicroStrategy through CData Connect AI
Create a live connection to LinkedIn Ads Data in CData Connect AI and connect to your LinkedIn Ads data from MicroStrategy.
-
Design BIRT Reports on Simplesat Data
Provide current Simplesat data to your embedded analytics.
-
DBAmp: Serial Number Expiration Date Shows 1999 or Expired
Handling an expiration date of 1999 in DBAmp.
-
Use the CData Software JDBC Driver for ZohoExpense in MicroStrategy
Connect to ZohoExpense data in MicroStrategy Developer using the CData Software JDBC Driver for ZohoExpense.
-
Replicate Bitbucket Data in Heroku for Use in Salesforce Connect
Replicate Bitbucket data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Cohere Data from MySQL in Amazon QuickSight
Connect to Cohere and build visualizations of Cohere data using a MySQL Connection in Amazon QuickSight.
-
Query Supabase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Supabase data from Node.js.
-
Creating QuickBooks Time-Connected Applications in Unqork
You can use CData Connect AI to feed QuickBooks Time data to Unqork and build custom business apps.