CData Software - Knowledge Base
Recent Articles
-
Import Zoho CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho CRM Data and provide access to live Zoho CRM data for custom reports in the Power BI Service.
-
Access Live Freshsales Data in Coginiti Pro
Connect to and query live Freshsales data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate SAP Ariba Procurement Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Procurement data from Informatica Cloud.
-
Connecting Pipedream with Mailjet Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Mailjet data in real time.
-
Automated Continuous Zoom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoom replication to Apache Kafka.
-
Getting Started with the CData Excel Add-In for Couchbase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Couchbase.
-
Integrating Cursor 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.
-
Building Dynamic Web Pages with Microsoft Planner Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Planner using the CData API Server.
-
Query Salesforce Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce data.
-
How to Use a Microsoft Access Database to Update Box Data in Real Time
Update Box data by creating a linked table in Microsoft Access with the CData Box ODBC Driver.
-
Connect to Teamgate Data in NetBeans
Connect to Teamgate data in NetBeans with the data source configuration wizard.
-
Build Lakebase-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 Lakebase data without replication.
-
Use the CData Software ODBC Driver for SAP Fieldglass in MicroStrategy
Connect to SAP Fieldglass data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Fieldglass.
-
How to connect PolyBase to Highrise
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Highrise data.
-
Integrate Trae with Live Typeform Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Typeform data from within the AI-powered IDE.
-
Create Google Sheets-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Sheets Data from Klipfolio and build custom visualizations using live Google Sheets data.
-
Create Informatica Mappings From/To a JDBC Data Source for Okta
Create Okta data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Highrise Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Highrise data and build visualizations in Tableau Cloud.
-
Connect to Sybase IQ from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sybase IQ data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous ClickUp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ClickUp replication to IBM DB2.
-
Getting Started with the CData Excel Add-In for Marketo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Marketo.
-
Connect to Spark Data in CloverDX (formerly CloverETL)
Transfer Spark data using the visual workflow in the CloverDX data integration tool.
-
Import Real-Time Clari Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Clari data in ColdFusion.
-
How to connect to Paddle Data with Squirrel SQL client
Connect to Paddle data and execute queries in the Squirrel SQL Client.
-
Analyze SQL Analysis Services Data in Cognos Analytics
Use CData Connect AI to connect to SQL Analysis Services Data from Cognos Analytics and analyze live SQL Analysis Services data.
-
Integrate Cursor with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Directory data from within the editor.
-
SAP Business Warehouse Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Business Warehouse data through CData Connect AI using different applications and tools.
-
How to publish and share SAP Hybris C4C Data dashboards with Tableau Server
The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C data into Tableau dashboards.
-
Build MVC Applications with Connectivity to Mocean Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mocean from an ASP.NET MVC application.
-
Connect to Excel Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Excel Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Helpscout Data in TIBCO Spotfire through ADO.NET
Integrate Helpscout data into dashboards in TIBCO Spotfire.
-
Connect Float to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Float with IBM WebSphere for seamless data integration and connectivity.
-
Choosing the Best Method to Connect ZendeskSell to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZendeskSell data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Live Marketo 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 Marketo data directly from the development environment.
-
Integrating Cursor with Microsoft Teams 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.
-
Visualize Raisers Edge NXT Data in Sisense
Create an ElastiCube in Sisense app with access to Raisers Edge NXT data.
-
Connecting to Cloud Storage Platforms Using the CData Access Driver
Learn how to connect Microsoft Access files stored in cloud platforms like Google Drive, SharePoint and S3 using the CData Access JDBC Driver.
-
Automated Continuous Access Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Access replication to Apache Kafka.
-
Use the CData Software ODBC Driver for Jira Assets in MicroStrategy Desktop
Connect to Jira Assets data in MicroStrategy Desktop using the CData Software ODBC Driver for Jira Assets.
-
Connect MYOB AccountRight Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MYOB AccountRight data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino data in MicroStrategy Developer using the CData Software ODBC Driver for HCL Domino.
-
Connect to Avalara AvaTax Data in Claris FileMaker Pro
Use the CData ODBC Driver for Avalara AvaTax in FileMaker Pro to connect to Avalara AvaTax and work with Avalara AvaTax data in your FileMaker applications.
-
Access Live Optimizely Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Optimizely data from your Google Sheets.
-
Automated Continuous Stack Exchange Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Stack Exchange replication to delimited files (CSV/TSV).
-
Operational Reporting on PabblySubscriptions Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PabblySubscriptions data.
-
Create Confluence Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Confluence from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Dropbox Data in RazorSQL
Connect to Dropbox from wizards and query Dropbox data from the GUI in the RazorSQL database management tool.
-
Build Google Analytics-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 Google Analytics data without replication.
-
Integrating LlamaIndex with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Redis data in real time.
-
Query Phoenix Data in ColdFusion
Write standard ColdFusion data access code to connect to Phoenix data.
-
Write a Simple Go Application to work with Microsoft Planner Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Planner data.
-
Automated Continuous Zoho Creator Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Google BigQuery.
-
Create Cloudflare-Connected Nintex Workflows
Use CData Connect AI to connect to Cloudflare Data from Nintex Workflow Cloud and build custom workflows using live Cloudflare data.
-
Automated Continuous Act-On Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Act-On replication to Apache Kafka.
-
Replicate Multiple Mailjet Accounts
Replicate multiple Mailjet accounts to one or many databases.
-
Build Basecamp-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Basecamp data.
-
Connect to Samanage Data from a Connection Pool in JBoss
Integrate Samanage data into Java servlets: Use the Management Console in JBoss to install the Samanage JDBC Driver.
-
Feed Landbot Data into FineReport
How to set Landbot data as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for CSV in MicroStrategy Web
Connect to CSV data in MicroStrategy Web using the CData Software ODBC Driver for CSV.
-
Visualize Kintone 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 Kintone data into TIBCO Spotfire.
-
Viewing Perplexity Data in RAD Studio Data Explorer
How to view Perplexity data in RAD Studio Data Explorer using the CData ODBC Driver for Perplexity.
-
Build a Simple VCL Application for PostgreSQL Data
How to build a simple VCL Application to view PostgreSQL data in RAD Studio using the CData ODBC Driver for PostgreSQL.
-
Integrating OpenCode with ZohoExpense 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 GitHub Copilot with Google Ad Manager 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.
-
Analyze Avaza Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avaza from Power Pivot. You will use the Table Import Wizard to load Avaza data. You can visually build the import query or use any SQL supported by the driver.
-
Connecting GenSpark with Dynamics CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dynamics CRM data without any replication or custom integration required.
-
Integrating Dataiku with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Dynamics 365 data.
-
Create Data Visualizations in Cognos BI with Oracle Service Cloud Data
Access Oracle Service Cloud data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Visualize SingleStore Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SingleStore data in Python.
-
Use Manus AI to Talk to Your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on GraphQL data.
-
Create a Data Access Object for Okta Data using JDBI
A brief overview of creating a SQL Object API for Okta data in JDBI.
-
Migrating data from Active Directory to Databricks using CData SSIS Components.
Easily push Active Directory data to Databricks using the CData SSIS Tasks for Active Directory and Databricks.
-
How to Connect the Power BI Service to Instagram: Complete Guide
Connect to the CData Software Power BI Connector for Instagram from PowerBI.com to provide real-time Instagram data across the organization.
-
Import Real-Time Opsgenie Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Opsgenie data in ColdFusion.
-
Analyze Azure Data Lake Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Data Lake Storage data in Microsoft R Open.
-
Create Reports from SendGrid Data in Looker Studio
Use CData Connect AI to gain access to live SendGrid data and create custom reports in Looker Studio.
-
Integrate Live Oracle HCM Cloud Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle HCM Cloud from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle HCM Cloud data.
-
Use the CData Software ODBC Driver for Hugging Face in MicroStrategy Web
Connect to Hugging Face data in MicroStrategy Web using the CData Software ODBC Driver for Hugging Face.
-
Use Dash to Build Web Apps on Confluence Data via CData Connect AI
Build interactive Dash web apps on live Confluence data using pandas and the CData Connect AI Python SDK.
-
How to Connect DBeaver to Highrise via a JDBC Driver
Manage Highrise data with visual tools in DBeaver like the query browser.
-
How to publish and share Impala Data dashboards with Tableau Server
The CData ODBC driver for Impala enables you integrate Impala data into Tableau dashboards.
-
Connect Mailgun Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mailgun data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Prepare, Blend, and Analyze Paymo Data in Alteryx Designer (ODBC)
Build workflows to access live Paymo data for self-service data analytics.
-
Extract, Transform, and Load Simplesat Data in Informatica PowerCenter
Create a simple Workflow for Simplesat data in Informatica PowerCenter.
-
Automated Continuous IBM Cloud Object Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Google BigQuery.
-
Build SAP Ariba Procurement-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Ariba Procurement data.
-
Analyze Klipfolio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Klipfolio data with the CData JDBC Driver for Klipfolio.
-
Getting Started with the CData Connect AI Python SDK for Amazon Marketplace
Install the CData Connect AI Python SDK to read live Amazon Marketplace data with standard DB-API 2.0 Python code.
-
Choosing the Best Method to Connect QuickBooks Time to SQL Server: 5 Options Explained
Discover multiple ways to connect and use QuickBooks Time data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect PolyBase to Eventbrite
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Eventbrite data.
-
Create a Data Access Object for XML Data using JDBI
A brief overview of creating a SQL Object API for XML data in JDBI.
-
Connect to Webflow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Webflow and the SQL Gateway to access Webflow data from Google Apps Script.
-
Connect to ChartMogul Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ChartMogul data using standard SQL.
-
Connect Helpscout to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Helpscout with IBM WebSphere for seamless data integration and connectivity.
-
View Reports on Real-Time Azure Table Data in Power BI Report Server
Use the CData ODBC Driver for Azure Table to visualize Azure Table data in Power BI Desktop and then publish them to Power BI Report Server.
-
LINQ to Bugsnag 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 Bugsnag Data Provider.
-
Build AI/ML Models with Live Shopify Data using Dataiku
Connect Shopify Data with Dataiku using the CData JDBC Driver for Shopify.
-
How to Connect to ZohoExpense Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoExpense data. Leverage the pyodbc module for ODBC in Python.
-
Access Freshservice 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 Freshservice data.
-
Visualize Zoho Books Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Books data.