CData Software - Knowledge Base
Recent Articles
-
Integrate Live Paylocity Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Paylocity data from within the IDE.
-
Connect to Jodoo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Jodoo data in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Todoist Data using the CData ODBC Driver
Use the SQL Gateway and Todoist ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Azure AI Foundry to Talk to Your Grafana 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 Grafana data for you.
-
Replicate Multiple NetSuite Accounts
Replicate multiple NetSuite accounts to one or many databases.
-
Enable the Oracle Financials Cloud JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Financials Cloud data.
-
Connect to SFTP Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SFTP data.
-
Active Directory Reporting in OBIEE with the Active Directory JDBC Driver
Deploy the Active Directory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SAP Ariba Procurement Data in RazorSQL
Connect to SAP Ariba Procurement from wizards and query SAP Ariba Procurement data from the GUI in the RazorSQL database management tool.
-
Integrate Goose with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live CSV data from within the local AI agent.
-
Automated Continuous Klaviyo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Klaviyo replication to delimited files (CSV/TSV).
-
Automated Omnisend Data Replication to Teradata
Use CData Sync to Customize and automate Omnisend data replication to Teradata.
-
Integrate Mailjet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mailjet data from Informatica Cloud.
-
Create Datasets from Dynamics 365 in Domo Workbench and Build Visualizations of Dynamics 365 Data in Domo
Use the CData Software ODBC Driver for Dynamics 365 to create datasets from Dynamics 365 data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Multiple Cloudant Accounts via the CData Sync CLI
Replicate multiple Cloudant accounts to one or many databases.
-
Interact with Live Sage Cloud Accounting Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Sage Cloud Accounting data.
-
Create Sugar CRM-Connected Applications in Appsmith
Connect to Sugar CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sugar CRM data.
-
Automated Continuous ADP Replication to MongoDB
Use CData Sync for automated, continuous, customizable ADP replication to MongoDB.
-
Use the CData ODBC Driver for Webflow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Webflow to connect to Webflow data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Webflow data in Excel.
-
Analyze Dynamics 365 Data in Cognos Analytics
Use CData Connect AI to connect to Dynamics 365 Data from Cognos Analytics and analyze live Dynamics 365 data.
-
Build Visualizations of Bullhorn CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bullhorn CRM data in Birst.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy Desktop
Connect to SharePoint data in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint.
-
Integrate Dynamics CRM Data in Pentaho Data Integration
Build ETL pipelines based on Dynamics CRM data in the Pentaho Data Integration tool.
-
Integrating Boomi Agentstudio with Dynamics 365 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Dynamics 365 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate Epicor Kinetic Data Replication to Couchbase
Use CData Sync to Customize and automate Epicor Kinetic data replication to Couchbase.
-
Integrating Kiro with Jumpseller 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.
-
Automate JSON Services Replication to SAP HANA
Use CData Sync to customize and automate JSON services replication to SAP HANA.
-
Automate Klaviyo Data Replication to Azure Synapse
Use CData Sync to customize and automate Klaviyo data replication to Azure Synapse.
-
Seamlessly Bring Spark Data into Retool Using CData Connect AI
Integrate Spark data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize PolarTeamPro Data in TIBCO Spotfire through ADO.NET
Integrate PolarTeamPro data into dashboards in TIBCO Spotfire.
-
Create Facebook-Connected Dashboards in Grafana
Connect to Facebook Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Facebook data.
-
Use JayDeBeApi to access Printful Data in Python
Use standard Python scripting and the development environment of your choice to access live Printful data.
-
Visualize Reckon Accounts Hosted Data in TIBCO Spotfire through OData
Integrate Reckon Accounts Hosted data into dashboards in TIBCO Spotfire.
-
Integrate BenchmarkEmail Data in Pentaho Data Integration
Build ETL pipelines based on BenchmarkEmail data in the Pentaho Data Integration tool.
-
Natively Connect to Excel Online Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Excel Online data. Leverage the native support for ODBC in PHP.
-
Visualize Live Oracle HCM Cloud Data in the Power BI Service
Use CData Connect AI to connect to live Oracle HCM Cloud data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Real-Time Twilio Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Twilio data in ColdFusion.
-
Back Up Tavily data 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 Tavily data data.
-
How to Connect to Live Act CRM Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Act CRM data for you.
-
How to connect Amazon QuickSight to Sybase IQ Data
Create a connection to Sybase IQ data in CData Connect AI and insert Sybase IQ data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Onfleet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Onfleet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Onfleet data.
-
How to Easily Query QuickBooks Data in OpenOffice Base
Connect to QuickBooks data in OpenOffice Base using the CData ODBC Driver for QuickBooks and generate reports with live data insights.
-
Automated Continuous eBay Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable eBay Analytics replication to IBM DB2.
-
Connect to XML Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for XML and the Script function in FileMaker Pro to connect to XML and work with XML data in your FileMaker application.
-
Create a Data Access Object for HBase Data using JDBI
A brief overview of creating a SQL Object API for HBase data in JDBI.
-
Create Apps from CSV Data in Qlik Sense Cloud
Use CData Connect AI to connect to CSV Data and build apps from live CSV data in Qlik Sense Cloud.
-
How to Query Live Splunk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Splunk data data in natural language using Python.
-
Build Voice Agents in ElevenLabs with access to Live Google Campaign Manager 360 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Campaign Manager 360 data.
-
Create SSAS Tabular Models from Hacker News Data
How to build a SQL Server Analysis Service Tabular Model from Hacker News data using CData drivers.
-
Automate Shippo Data Replication to SAP HANA
Use CData Sync to customize and automate Shippo data replication to SAP HANA.
-
Build Zendesk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zendesk data and build visualizations in Tableau.
-
Query Mode Data as a SQL Server Database in Node.js
Execute SQL Server queries against Mode data from Node.js.
-
Link Monday.com with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Monday.com data in Filemaker Pro for Mac or Windows.
-
Query SAP Ariba Procurement Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Ariba Procurement data.
-
How to Build an ETL App for Box Data in Python with CData Connect AI
Build ETL pipelines that read and write live Box data in Python with petl and the CData Connect AI Python SDK.
-
DataBind Controls to MongoDB Data in Delphi
DataBind to MongoDB data in Delphi with standard data access components and controls.
-
Automated Continuous Mode Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mode replication to SQL Server.
-
Build Visualizations of AlloyDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of AlloyDB data in Birst.
-
Automated Continuous Dynamics CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to MongoDB.
-
Automate Aha! Data Replication to Azure Synapse
Use CData Sync to customize and automate Aha! data replication to Azure Synapse.
-
Automated Continuous eBay Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable eBay Analytics replication to SingleStore.
-
Import OData Services into the Power BI Service for Visualizations
Use CData Connect AI to connect to OData Services and provide access to live OData services for custom reports in the Power BI Service.
-
Analyze Live Optimizely Data in SAS Viya
Use CData Connect AI to connect to Optimizely data from SAS Viya and deploy self-service analytics using live Optimizely data.
-
Integrating Codex with Calendly 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 Live Oracle Service Cloud Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Service Cloud data securely in real time.
-
Integrating GitHub Copilot with MongoDB 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.
-
Integrating Codex with Factorial 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.
-
Import Real-Time HCL Domino Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HCL Domino data in ColdFusion.
-
Migrating data from Perplexity to Google BigQuery using CData SSIS Components.
Easily push Perplexity data to Google BigQuery using the CData SSIS Tasks for Perplexity and Google BigQuery.
-
Using the CData Software ODBC Driver for Slack in PyCharm
Connect to Slack as an ODBC data source in PyCharm using the CData Software ODBC Driver for Slack.
-
Build Attio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Attio data and build web apps with connectivity to live Attio data.
-
Build GraphQL-Connected Apps in Choreo
Use CData Connect AI to connect to GraphQL Data from Choreo and build custom apps using live GraphQL data.
-
Migrating data from DB2 to Databricks using CData SSIS Components.
Easily push DB2 data to Databricks using the CData SSIS Tasks for DB2 and Databricks.
-
LINQ to Google Search Results
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 Google Search Data Provider.
-
How to Connect the Power BI Service to Calendly: Complete Guide
Connect to the CData Software Power BI Connector for Calendly from PowerBI.com to provide real-time Calendly data across the organization.
-
Integrating Gumloop with Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Drive data within automated workflows.
-
Connect to Microsoft Planner Data in JRuby
Create a simple JRuby app with access to live Microsoft Planner data.
-
How to create SpaceX federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SpaceX data in MySQL .
-
Connect to Sybase Data in Jaspersoft Studio
Execute SQL to remote Sybase data in Jaspersoft Studio.
-
Replicate Multiple Gong Accounts
Replicate multiple Gong accounts to one or many databases.
-
Connect to Demio Data in NetBeans
Connect to Demio data in NetBeans with the data source configuration wizard.
-
Build Dashboards with Insightly Data in DBxtra
Create dynamic dashboards and perform analytics based on Insightly data in DBxtra.
-
Migrating data from SageHR to Databricks using CData SSIS Components.
Easily push SageHR data to Databricks using the CData SSIS Tasks for SageHR and Databricks.
-
How to Connect to Live MongoDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MongoDB data securely in real time.
-
How to connect to Presto Data from IntelliJ
Integrate connectivity to Presto data with wizards in IntelliJ.
-
Access LDAP Objects 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 LDAP objects.
-
Connect to Onfleet Data in JRuby
Create a simple JRuby app with access to live Onfleet data.
-
How to Connect DBeaver to BigCommerce via a JDBC Driver
Manage BigCommerce data with visual tools in DBeaver like the query browser.
-
Automated Continuous SingleStore Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SingleStore replication to PostgreSQL.
-
Provide OData Services of GitLab Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for GitLab data by developing a WCF Service Application.
-
Import and Visualize AgileCRM Data in Power View
Create data visualizations based on AgileCRM data in Excel.
-
A PostgreSQL Interface for SpaceX Data using the CData ODBC Driver
Use the SQL Gateway and SpaceX ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Facebook Ads Data in CloverDX (formerly CloverETL)
Transfer Facebook Ads data using the visual workflow in the CloverDX data integration tool.
-
Integrate Theia IDE with Live SAP BusinessObjects BI 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 SAP BusinessObjects BI data from within the development environment.
-
Publish Codat-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Codat data.
-
Integrate AlloyDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AlloyDB with External Services.
-
Automated Continuous Smartsheet Replication to SQL Server
Use CData Sync for automated, continuous, customizable Smartsheet replication to SQL Server.
-
Visualize Parquet 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 Parquet data into TIBCO Spotfire.
-
Integrate WordPress Data in Pentaho Data Integration
Build ETL pipelines based on WordPress data in the Pentaho Data Integration tool.
-
Getting Started with the CData Connect AI Python SDK for Reckon Accounts Hosted
Install the CData Connect AI Python SDK to read and write live Reckon Accounts Hosted data with standard DB-API 2.0 Python code.