CData Software - Knowledge Base
Recent Articles
-
Connect to Sugar CRM from Asprova with CData Software ODBC Driver for Sugar CRM
This article shows how to connect faster to Sugar CRM data from Asprova.
-
Getting Started with the CData Python Connector for SAP Hybris C4C
Learn to install and license the CData Python Connector
-
Connect to LaunchDarkly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LaunchDarkly using standard SQL.
-
Edit and Search External Google Ad Manager Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Ad Manager to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Ad Manager Data objects that you can access from apps and the dashboard.
-
Automated Continuous Excel Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Excel replication to delimited files (CSV/TSV).
-
Integrating Claude Code with Oracle Service Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Service Cloud within assisted coding and automated development workflows.
-
Getting Started with the CData Tableau Connector for Vercel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to FreeAgent Data from a Connection Pool in JBoss
Integrate FreeAgent into Java servlets: Use the Management Console in JBoss to install the FreeAgent JDBC Driver.
-
Access Live Contentful Data in Coginiti Pro
Connect to and query live Contentful from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Establish a Live Connection with MongoDB Data using Tableau Bridge
The CData ODBC Driver for MongoDB enables you to integrate live MongoDB into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Controls to MarkLogic Data in C++Builder
DataBind to MarkLogic in C++Builder with standard components and controls.
-
Integrate with live Microsoft Exchange Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Exchange in Jitterbit.
-
Integrating Claude Code CLI with Cosmos DB 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.
-
Replicate Multiple Pipeline CRM Accounts via the CData Sync CLI
Replicate multiple Pipeline CRM accounts to one or many databases.
-
Visualize Exact Online 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 Exact Online into TIBCO Spotfire.
-
Import Real-Time Zoho Projects Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Projects in ColdFusion.
-
How to Query Live Lakebase Data in Claude Desktop
Connect to and query live Lakebase Data in Claude Desktop using CData MCP Server.
-
Migrating data from Elorus to Google BigQuery using CData SSIS Components.
Easily push Elorus to Google BigQuery using the CData SSIS Tasks for Elorus and Google BigQuery.
-
Create Apps from BigCommerce Data in Qlik Sense Cloud
Use CData Connect AI to connect to BigCommerce Data and build apps from live BigCommerce in Qlik Sense Cloud.
-
How to Query Live Quickbase Data in Perplexity MacOS Desktop
Connect to and query live Quickbase Data in Perplexity Desktop using CData MCP Server.
-
Explore Geographical Relationships in Office 365 Data with Power Map
Create data visualizations with Microsoft Office 365 in Power Map.
-
Build AI/ML Models with Live ClickUp Data using Dataiku
Connect ClickUp Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous LightSpeedRetail Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to AlloyDB.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Instagram within intelligent workflows.
-
Access Live Reckon Accounts Hosted 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 Reckon Accounts Hosted through MCP integration.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Smartsheet using the Model Context Protocol.
-
Integrate LibreChat with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Salesforce Pardot from within the chat interface.
-
Use the CData ODBC Driver for WordPress from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for WordPress to connect to WordPress from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring WordPress in Excel.
-
Build a Singer.io Tap for Timely With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Timely data using
-
Prepare, Blend, and Analyze Zoom Data in Alteryx Designer (ODBC)
Build workflows to access live Zoom for self-service data analytics.
-
Automated Continuous Oracle Financials Cloud Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to SQLite.
-
How to load SAP HANA data into Elasticsearch via Logstash
Introducing a simple method to load SAP HANA data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Accelo Data from MySQL in Amazon QuickSight
Connect to Accelo and build visualizations of Accelo using a MySQL Connection in Amazon QuickSight.
-
Integrate with Everhour Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Everhour to a JSON file on disk.
-
Back Up Close 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 Close data.
-
LINQ to Vercel 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 Vercel Data Provider.
-
Build BambooHR-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for BambooHR Data and create custom apps in Bubble.
-
Build Voice Agents in ElevenLabs with access to Live SAP Concur Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Concur.
-
Use Dash to Build to Web Apps on Attio Data
Create Python applications that use pandas and Dash to build Attio-connected web apps.
-
Operational Reporting on Redshift Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Redshift.
-
Extend Google Sheets with Sage 300 Data
Make calls to Sage 300 from Google Apps Script via the API Server.
-
Visualize PostgreSQL Data in Tableau
The CData ODBC driver for PostgreSQL enables you integrate PostgreSQL into Tableau dashboards.
-
How to create SparkPost federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SparkPost in MySQL .
-
How to Access Live Accelo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Accelo enables you to integrate Accelo into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live Microsoft Exchange Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Exchange from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Exchange.
-
Create Power BI Reports on Real-Time Qualaroo Data
Use the CData ODBC Driver for Qualaroo to visualize Qualaroo in Power BI Desktop.
-
Integrate Cline with Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MarkLogic from within your IDE.
-
Validate Google Forms Data with QuerySurge
Access and validate Google Forms in QuerySurge using the CData JDBC Driver.
-
Query, Visualize, and Share live SAP Ariba Procurement Data in Redash
Use CData Connect AI to connect to live SAP Ariba Procurement in Redash for querying, visualizing, and sharing.
-
Build a Simple VCL Application for Qualaroo Data
How to build a simple VCL Application to view Qualaroo in RAD Studio using the CData ODBC Driver for Qualaroo.
-
Automated Continuous LeadDesk Replication to MongoDB
Use CData Sync for automated, continuous, customizable LeadDesk replication to MongoDB.
-
Visualize Live Dynamics NAV Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Dynamics NAV using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Agno to Talk to Your BambooHR 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 BambooHR for you.
-
Replicate Acumatica Data to Multiple Databases via the CData Sync CLI
Replicate Acumatica ERP to disparate databases with a single configuration.
-
Write a Simple Go Application to work with Greenhouse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Greenhouse.
-
Trigger Bullhorn CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Bullhorn CRM with standard wizards in Logic Apps.
-
Getting Started with the CData Python Connector for LinkedIn Ads
Learn to install and license the CData Python Connector
-
Build Data Flows from SQL Server to MailChimp through SSIS
Easily push SQL Server data to MailChimp using the CData SSIS Tasks for MailChimp.
-
Build AI/ML Models with Live SharePoint Data using Dataiku
Connect SharePoint Data with Dataiku using the CData JDBC Driver for SharePoint.
-
Integrating OpenCode Terminal with LionDesk 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 with live SAP Hybris C4C Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Hybris C4C in Jitterbit.
-
Migrating data from Confluence to Databricks using CData SSIS Components.
Easily push Atlassian Confluence to Databricks using the CData SSIS Tasks for Confluence and Databricks.
-
Use Microsoft Copilot Studio to talk to your Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apache Avro for you.
-
Validate Vault CRM Data with QuerySurge
Access and validate Veeva Vault & Vault CRM in QuerySurge using the CData JDBC Driver.
-
Migrating data from Greenplum to Snowflake using CData SSIS Components.
Easily push Pivotal GreenPlum to Snowflake using the CData SSIS Tasks for Greenplum and Snowflake.
-
Viewing Azure Analysis Services Data in RAD Studio Data Explorer
How to view Azure Analysis Services in RAD Studio Data Explorer using the CData ODBC Driver for Azure Analysis Services.
-
Build Agents in Relevance AI with Access to Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Epicor Kinetic within intelligent agent workflows.
-
Connect to Cloudant Data in RapidMiner
Integrate IBM Cloudant with standard components and data source configuration wizards in RapidMiner Studio.
-
Migrating data from CircleCI to Google BigQuery using CData SSIS Components.
Easily push CircleCI to Google BigQuery using the CData SSIS Tasks for CircleCI and Google BigQuery.
-
Use Azure AI Foundry to Talk to Your Oracle 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 Oracle Database for you.
-
How to Query FTP Data in MySQL Workbench
Execute MySQL queries against live FTP Servers from MySQL Workbench.
-
Visualize Live Delighted Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Delighted.
-
Connect to Oracle Service Cloud Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build SAP Netweaver Gateway Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Netweaver Gateway and build visualizations in Tableau Cloud.
-
Publish Reports with MariaDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MariaDB.
-
Connect to Tanda Data from a Connection Pool in Jetty
The Tanda JDBC Driver supports connection pooling: This article shows how to connect faster to Tanda from Web apps in Jetty.
-
Integrate Delighted Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Delighted from Informatica Cloud.
-
Use the CData Software ODBC Driver for OnePageCrm in SAS for Real-Time Reporting and Analytics
Connect to real-time OnePageCrm in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OnePageCrm.
-
Import SAS xpt Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAS xpt Data and provide access to live SAS XPORT for custom reports in the Power BI Service.
-
Analyze MarkLogic Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MarkLogic and visualize MarkLogic in SAP Analytics Cloud.
-
Build an OLAP Cube in SSAS from PayPal Data
Establish a connection to PayPal data from SQL Server Analysis Services, and use the PayPal Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Dashboards with Amazon Athena Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amazon Athena in Dundas BI.
-
Import Databricks Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Databricks. In this article, you will use the OData format to import Databricks into Microsoft Power Query.
-
Access Dynamics CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics CRM from your Oracle system.
-
Automated Continuous ConvertKit Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ConvertKit replication to Amazon Redshift.
-
Build Asana-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Asana.
-
Create Reports from Azure Data Lake Storage Data in Looker Studio
Use CData Connect AI to gain access to live Azure Data Lake Storage and create custom reports in Looker Studio.
-
Build a PostgreSQL Interface for Square Data using the CData JDBC Driver
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for Clari
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate Jira Assets Data Replication to SAP HANA
Use CData Sync to customize and automate Jira Assets replication to SAP HANA.
-
How to Seamlessly Import Pushbullet Data into IBM SPSS Modeler
Integrate Pushbullet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Amplitude Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amplitude and the SQL Gateway to access Amplitude from Google Apps Script.
-
Validate Mailgun Data with QuerySurge
Access and validate Mailgun in QuerySurge using the CData JDBC Driver.
-
Access Live RSS Feeds in AWS Lambda (with IntelliJ IDEA)
Connect to live RSS Feeds in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live Redis Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Redis.
-
How to Work with RabbitMQ Data in ETL Validator JDBC
Connect to RabbitMQ from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with VWO 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 to Timely Data in DBVisualizer
Integrate Timely with visual data analysis tools and data connection wizards in DBVisualizer
-
Edit and Search External QuickBooks Time Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of QuickBooks Time to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Time Data objects that you can access from apps and the dashboard.
-
Connect to Unbounce Data in RapidMiner
Integrate Unbounce with standard components and data source configuration wizards in RapidMiner Studio.