CData Software - Knowledge Base
Recent Articles
-
Creating Basecamp-Connected Applications in Unqork
You can use CData Connect AI to feed Basecamp to Unqork and build custom business apps.
-
How to create an RPA flow for Retently Data in UiPath Studio
Use the Retently ODBC Driver to create workflows that access real-time Retently without any coding.
-
Build MailerSend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MailerSend and build web apps with connectivity to live MailerSend.
-
Use the CData ODBC Driver for Freshdesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshdesk to connect to Freshdesk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshdesk in Excel.
-
Create Landbot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Landbot data access from reports, embedded analytics, and more.
-
Migrating data from PagerDuty to Google BigQuery using CData SSIS Components.
Easily push PagerDuty to Google BigQuery using the CData SSIS Tasks for PagerDuty and Google BigQuery.
-
Create Vault CRM-Connected Business Apps in AppSheet
Connect to Vault CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Veeva Vault & Vault CRM.
-
Automated Continuous Tally Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Tally replication to Apache Kafka.
-
Integrating Cursor CLI with Splunk 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 Build an ETL App for Microsoft Exchange Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Exchange in Python with petl and the CData Connect AI Python SDK.
-
Query Live Couchbase 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 Couchbase directly from the development environment.
-
Choosing the Best Method to Connect Snapchat Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Snapchat Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build to Web Apps on OnePageCrm Data
Create Python applications that use pandas and Dash to build OnePageCrm-connected web apps.
-
Seamlessly Bring Google Campaign Manager 360 Data into Retool Using CData Connect AI
Integrate Google Campaign Manager 360 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect Hubstaff Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Hubstaff using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Google Cloud Storage-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Cloud Storage to explore live Google Cloud Storage Data in Claude Code to assist with building Google Cloud Storage-powered applications.
-
How to Access PostgreSQL Through an SSH Server (No PuTTY Required): CData PostgreSQL ODBC Driver
Learn how to connect securely to PostgreSQL (e.g., AWS RDS) via an SSH server using the CData PostgreSQL ODBC Driver — no PuTTY or manual port forwarding required.
-
Build Automated Box-Connected Workflows in Zapier
Use CData Connect AI to connect to live Box and build automated workflows in Zapier.
-
Analyze NetSuite SuiteAnalytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of NetSuite SuiteAnalytics and visualize live NetSuite SuiteAnalytics in Infragistics Reveal.
-
Build SAP Business One-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP Business One to explore live SAP Business One Data in Cursor to assist with building SAP Business One-powered applications.
-
Connect to ZohoExpense Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoExpense from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData Excel Add-In for Bitly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bitly.
-
Visualize Lakebase Data in TIBCO Spotfire through ADO.NET
Integrate Lakebase into dashboards in TIBCO Spotfire.
-
Use Dash to Build Web Apps on Instagram Data via CData Connect AI
Build interactive Dash web apps on live Instagram using pandas and the CData Connect AI Python SDK.
-
Integrate Cline with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live GitHub from within your IDE.
-
Replicate Multiple Instagram Accounts via the CData Sync CLI
Replicate multiple Instagram accounts to one or many databases.
-
Write a Simple Go Application to work with Ontraport Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Ontraport.
-
Connect to IBM Informix Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for IBM Informix in Airbyte.
-
Access ClickUp 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 ClickUp.
-
Create Dynamic Avaza Grids Using the Infragistics XamDataGrid
Learn how you can connect Avaza to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache Phoenix within intelligent workflows.
-
Moving Data from Salesforce Pardot to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce Pardot data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting Mastra with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Amazon Athena, no replication required.
-
Publish Bugsnag-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bugsnag.
-
Query Live Instagram 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 Instagram directly from the development environment.
-
DataBind Controls to SageHR Data in C++Builder
DataBind to SageHR in C++Builder with standard components and controls.
-
How to Seamlessly Import Oracle Eloqua Reporting Data into IBM SPSS Modeler
Integrate Oracle Eloqua Reporting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI/ML Models with Live Cosmos DB Data using Dataiku
Connect Cosmos DB Data with Dataiku using the CData JDBC Driver for Cosmos DB.
-
How to Visualize Basecamp Data in Python with pandas
Use pandas and other modules to analyze and visualize live Basecamp in Python.
-
Access Live REST Data in AWS Lambda
Connect to live REST in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Freshteam Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshteam JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Asana Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Asana into custom reports in Power BI.
-
Publish Reports with QuickBooks Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Online.
-
Connect to Copper Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Copper using standard SQL.
-
How to Connect to Live Trello Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Trello for you.
-
Build Dynamics 365-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dynamics 365 and build Dynamics 365-connected web apps with Axios.
-
Create Power BI Reports on Real-Time CapsuleCRM Data
Use the CData ODBC Driver for CapsuleCRM to visualize CapsuleCRM in Power BI Desktop.
-
How to Work with Sendwithus Data in ETL Validator JDBC
Connect to Sendwithus from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Oracle Sales Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Sales Data in CData Connect AI and connect to your Oracle Sales from MicroStrategy.
-
Automated Continuous HDFS Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon S3.
-
Getting Started with the CData Tableau Connector for Apify
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create FreshBooks-Connected Applications in Appsmith
Connect to FreshBooks Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FreshBooks.
-
Connecting Agentforce with Google Calendar Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Calendar for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Ads
Create Microsoft Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Prepare, Blend, and Analyze SAP Fieldglass Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Fieldglass for self-service data analytics.
-
Automated Continuous IBM Informix Replication to SQL Server
Use CData Sync for automated, continuous, customizable IBM Informix replication to SQL Server.
-
How to Connect to Live MongoDB 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 MongoDB for you.
-
Analyze HCL Domino Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HCL Domino with the CData JDBC Driver for HCL Domino.
-
Validate REST Data with QuerySurge
Access and validate REST in QuerySurge using the CData JDBC Driver.
-
Seamlessly Bring Google Ad Manager Data into Retool Using CData Connect AI
Integrate Google Ad Manager data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Validate Zoho Books Data with QuerySurge
Access and validate Zoho Books in QuerySurge using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Webex Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Webex from an ASP.NET MVC application.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Klaviyo using the Model Context Protocol.
-
Prepare, Blend, and Analyze Phoenix Data in Alteryx Designer (ODBC)
Build workflows to access live Apache Phoenix for self-service data analytics.
-
Integrate Superchat with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Superchat with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Superchat.
-
Connect to Real-Time Asana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Asana and Dataflow to import and use Asana in Power Apps.
-
How to Connect to MySQL Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MySQL. Leverage the pyodbc module for ODBC in Python.
-
Build Paymo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Paymo.
-
Natively Connect to Zoho Inventory Data in PHP
The CData ODBC driver for Zoho Inventory enables you to create PHP applications with connectivity to Zoho Inventory. Leverage the native support for ODBC in PHP.
-
Connect to and Visualize Live Active Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Active Directory.
-
Bind Live IBM Cloud Object Storage Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage data
-
Use the CData ODBC Driver for Redshift from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Amazon Redshift from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon Redshift in Excel.
-
Connect to and Query Azure Synapse Data in QlikView over ODBC
Create data visualizations with Azure Synapse in QlikView.
-
Create Data Visualizations in Cognos BI with Couchbase Data
Access Couchbase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous ConvertKit Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ConvertKit replication to PostgreSQL.
-
Connect to Gumroad Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Data Flows from Adobe Commerce to SQL Server using SSIS
Easily back up Adobe Commerce to SQL Server using the SSIS components for Adobe Commerce.
-
Integrating Codex CLI with SAP Hybris C4C 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 MailChimp-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for MailChimp to explore live MailChimp Data in Claude Code to assist with building MailChimp-powered applications.
-
Automate Codat Data Replication to Couchbase
Use CData Sync to Customize and automate Codat replication to Couchbase.
-
Automate Mailjet Data Replication to Couchbase
Use CData Sync to Customize and automate Mailjet replication to Couchbase.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipeline CRM
Create an ODBC connection to Pipeline CRM in Informatica and browse and transfer Pipeline CRM.
-
Launch the CData Sync Azure VM on Microsoft Azure
Host the Windows edition of CData Sync on Microsoft Azure using the CData Sync Azure VM.
-
Connecting Moonlit Workflow with Redis 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 Redis in real time.
-
Validate PostgreSQL Data with QuerySurge
Access and validate PostgreSQL in QuerySurge using the CData JDBC Driver.
-
Connect to ShipEngine Data in DBArtisan
Use wizards in DBArtisan to configure ShipEngine as a data source.
-
How to Connect the Power BI Service to BenchmarkEmail: Complete Guide
Connect to the CData Software Power BI Connector for BenchmarkEmail from PowerBI.com to provide real-time BenchmarkEmail across the organization.
-
Integrating LlamaIndex with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Asana in real time.
-
How to Connect to Live Oracle Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle Database without replication.
-
Query Pipeliner CRM Data in DataGrip
Create a Data Source for Pipeliner CRM in DataGrip and use SQL to query live Pipeliner CRM.
-
Connect to Smartsheet Data in Google Apps Script via Connect AI
Use CData Connect AI to access Smartsheet in Google Apps Script.
-
Getting Started with the CData Tableau Connector for Stripe
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Stripe.
-
How to work with Google Forms Data in Apache Spark using SQL
Access and process Google Forms Data in Apache Spark using the CData Software JDBC Driver.
-
Rapidly Develop Active Directory-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Active Directory.
-
Query Live NetSuite 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 NetSuite CRM & ERP directly from the development environment.
-
Build QuickBooks-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for QuickBooks to explore live QuickBooks Data in Gemini Code Assist to assist with building QuickBooks-powered applications.
-
Prepare, Blend, and Analyze Miro Data in Alteryx Designer (ODBC)
Build workflows to access live Miro for self-service data analytics.
-
Model Sybase IQ Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sybase IQ, enabling the direct import of real-time Sybase IQ.
-
Build a Singer.io Tap for PolarTeamPro With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PolarTeamPro data using
-
Choosing the Best Method to Connect Teamgate to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teamgate from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.