CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Flowlu Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Flowlu replication to AlloyDB.
-
Simplesat Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Simplesat facts in real time.
-
Import Google Forms Data Using Azure Data Factory
Use CData Connect AI to connect to Google Forms Data from Azure Data Factory and import live Google Forms data.
-
Access Certinia 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 Certinia data.
-
Build Zoho Projects-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho Projects Data from Zoho Analytics and import live Zoho Projects data.
-
Replicate Multiple Reply.io Accounts
Replicate multiple Reply.io accounts to one or many databases.
-
Integrate Google's Antigravity Agent with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle HCM Cloud data using the Model Context Protocol.
-
Connect to Bugsnag Data in JRuby
Create a simple JRuby app with access to live Bugsnag data.
-
Integrating LlamaIndex with Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Dynamics CRM data in real time.
-
Publish Crystal Reports on Sybase IQ Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sybase IQ data.
-
Automated Continuous Google Sheets Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Sheets replication to delimited files (CSV/TSV).
-
How to connect to Foursquare Data with Squirrel SQL client
Connect to Foursquare data and execute queries in the Squirrel SQL Client.
-
Excel Spreadsheet Automation on Snapchat Ads Data with the QUERY Formula
Pull data from Snapchat Ads, automate spreadsheets, and more with the QUERY formula.
-
Create Data Visualizations in Cognos BI with Amplitude Data
Access Amplitude data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to integrate Redis with Apache Airflow
Access and process Redis data in Apache Airflow using the CData JDBC Driver.
-
How to import Postmark Data into Apache Solr
Use the CData Software JDBC Driver for Postmark in Data Import Handler and create an automated import of Postmark data to Apache Solr Enterprise Search platform.
-
Bridge Contentful Connectivity with Apache NiFi
Access and process Contentful data in Apache NiFi using the CData JDBC Driver.
-
Integrate Devin with Live Zoho Books Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zoho Books data.
-
Automated Bitly Data Replication to Teradata
Use CData Sync to Customize and automate Bitly data replication to Teradata.
-
How to Access Live Amplitude Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amplitude enables you to integrate Amplitude data into workflows built using Microsoft Power Automate Desktop.
-
Create Reports from SageHR Data in Looker Studio
Use CData Connect AI to gain access to live SageHR data and create custom reports in Looker Studio.
-
Integrating Dataiku with Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Gong data.
-
Create Reports from SingleStore Data in Looker Studio
Use CData Connect AI to gain access to live SingleStore data and create custom reports in Looker Studio.
-
Import Real-Time Zoho Books Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Books data in ColdFusion.
-
Connect to Sendwithus Data from PowerBuilder via JDBC
This article demonstrates how to access Sendwithus data from PowerBuilder using the Sendwithus JDBC Driver.
-
Analyze ZohoSubscriptions Data in Cognos Analytics
Use CData Connect AI to connect to ZohoSubscriptions Data from Cognos Analytics and analyze live ZohoSubscriptions data.
-
Getting Started with the CData Excel Add-In for FreeAgent
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FreeAgent.
-
Bind Live MYOB AccountRight Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MYOB AccountRight data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automated Continuous WooCommerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable WooCommerce replication to AlloyDB.
-
Create Informatica Mappings From/To a JDBC Data Source for XML
Create XML data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Square Data from PowerBuilder via JDBC
This article demonstrates how to access Square data from PowerBuilder using the Square JDBC Driver.
-
Integrate Blackbaud FE NXT Data in Pentaho Data Integration
Build ETL pipelines based on Blackbaud FE NXT data in the Pentaho Data Integration tool.
-
Create CouchDB-Connected Business Apps in AppSheet
Connect to CouchDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to CouchDB data.
-
Build AI Agents with Printify Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Printify data through CData Connect AI.
-
Integrate Goose with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Concur data from within the local AI agent.
-
Build Dashboards with Freshsales Data in DBxtra
Create dynamic dashboards and perform analytics based on Freshsales data in DBxtra.
-
How to Work with Calendly Data in ETL Validator JDBC
Connect to Calendly from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from Attio to Snowflake using CData SSIS Components.
Easily push Attio data to Snowflake using the CData SSIS Tasks for Attio and Snowflake.
-
Visualize Live Close Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Close data.
-
Build Visualizations of Simplesat Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Simplesat data in Birst.
-
Connecting GenSpark with Moosend Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Moosend data without any replication or custom integration required.
-
Integrate Devin with Live SFTP Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SFTP data.
-
Integrate with Live VWO Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to VWO from the MuleSoft Anypoint Platform to integrate live VWO data into custom reports and dashboards.
-
LINQ to Unbounce 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 Unbounce Data Provider.
-
Build SingleStore-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SingleStore data.
-
Bill an Invoice with the CData Excel Add-In for QuickBooks
The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.
-
ETL Presto in Oracle Data Integrator
This article shows how to transfer Presto data into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for ConvertKit in MicroStrategy Desktop
Connect to ConvertKit data in MicroStrategy Desktop using the CData Software JDBC Driver for ConvertKit.
-
Greenhouse Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Greenhouse data through CData Connect AI using different applications and tools.
-
Migrating data from Close to Databricks using CData SSIS Components.
Easily push Close data to Databricks using the CData SSIS Tasks for Close and Databricks.
-
Integrate Tanda Data in the Pentaho Report Designer
Publish reports based on Tanda data in the Pentaho BI tool.
-
Connect to Everhour Data in Aqua Data Studio
Access Everhour data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Google Analytics Data from a Connection Pool in JBoss
Integrate Google Analytics data into Java servlets: Use the Management Console in JBoss to install the Google Analytics JDBC Driver.
-
Choosing the Best Method to Connect MongoDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MongoDB data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use CData Connect AI to Access Coda Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Coda data in the Power Pivot business intelligence tool.
-
Rapidly Develop Retently-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 Retently.
-
Automated Continuous ShipStation Replication to Databricks
Use CData Sync for automated, continuous, customizable ShipStation replication to Databricks.
-
Back Up Zoho Creator data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Creator. In this article, we will employ an SSIS workflow to populate a database with Zoho Creator data data.
-
Integrating Claude Code with ZohoPeople Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ZohoPeople data within assisted coding and automated development workflows.
-
Visualize Live Sage Cloud Accounting Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage Cloud Accounting data into custom reports in Power BI.
-
How to integrate Metabase with Coda Data
Use CData Connect AI to connect to live Coda data and create an interactive dashboard in Metabase from Coda data.
-
Bullhorn CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Bullhorn CRM data through CData Connect AI using different applications and tools.
-
Automated Continuous SAP Concur Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Concur replication to delimited files (CSV/TSV).
-
How to connect and process PagerDuty data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PagerDuty data.
-
How to work with Microsoft Dataverse Data in Apache Spark using SQL
Access and process Microsoft Dataverse Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Zoho CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho CRM data from Filemaker Pro on Mac.
-
How to Query Live Couchbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Couchbase data data in natural language using Python.
-
Integrate Live Azure Table 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 Azure Table data from within the IDE.
-
How to Connect to & Open MessageBird Data in Microsoft Excel
This article uses the CData ODBC driver for MessageBird to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to and Query Google Forms Data in QlikView over ODBC
Create data visualizations with Google Forms data in QlikView.
-
Automated Continuous Quaderno Replication to MySQL
Use CData Sync for automated, continuous, customizable Quaderno replication to MySQL.
-
Connect to MessageBird Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to MessageBird.
-
Connect and Visualize Live Jumpseller Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Jumpseller data into the Databricks platform and create visualization dashboards with real-time Jumpseller data.
-
LINQ to GetResponse 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 GetResponse Data Provider.
-
Integrate Theia IDE with Live SAP ByDesign 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 ByDesign data from within the development environment.
-
How to publish and share MongoDB Data dashboards with Tableau Server
The CData ODBC driver for MongoDB enables you integrate MongoDB data into Tableau dashboards.
-
Automated Continuous Gorgias Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Gorgias replication to Azure SQL Database.
-
Build an OLAP Cube in SSAS from SQL Analysis Services Data
Establish a connection to SQL Analysis Services data data from SQL Server Analysis Services, and use the SQL Analysis Services Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect PolyBase to Sugar CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sugar CRM data.
-
Getting Started with the CData ODBC Driver for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft OneDrive.
-
Build MVC Applications with Connectivity to Jira Assets Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jira Assets from an ASP.NET MVC application.
-
Build MVC Applications with Connectivity to Paddle Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Paddle from an ASP.NET MVC application.
-
Build Shortcut-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Shortcut data and build Shortcut-connected web apps with Axios.
-
Integrate with live Cloudant Data in Jitterbit
Use CData Connect AI to connect to and integrate live Cloudant data in Jitterbit.
-
Integrate with Vimeo Data in JReport Designer
Create charts and reports based on Vimeo data in JReport Designer.
-
Integrating Claude Code with PostgreSQL Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on PostgreSQL data within assisted coding and automated development workflows.
-
Getting Started with the CData Tableau Connector for Xero
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Xero.
-
Connect to SAP BusinessObjects BI Data in CloverDX (formerly CloverETL)
Transfer SAP BusinessObjects BI data using the visual workflow in the CloverDX data integration tool.
-
Connect to Exact Online Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Exact Online and the Script function in FileMaker Pro to connect to Exact Online and work with Exact Online data in your FileMaker application.
-
Publish Microsoft Exchange-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Exchange data.
-
Automated Continuous Jira Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Jira replication to Amazon Redshift.
-
Visualize Live Square Data in the Power BI Service
Use CData Connect AI to connect to live Square data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for JSON in MicroStrategy
Connect to JSON services in MicroStrategy Developer using the CData Software ODBC Driver for JSON.
-
DataBind Charts to Autopilot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Autopilot 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.
-
Analyze Google Forms Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Forms data and visualize live Google Forms data in Infragistics Reveal.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Planner Records from SQL Server
Easily push SQL Server data to Microsoft Planner using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Planner or update existing records with data from a SQL Server database.
-
Integrating Codex with GitLab 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 CSV Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CSV from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Singer.io Tap for Impala With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Impala data using the CData Python Connector.
-
Query Cohere Data in ColdFusion
Write standard ColdFusion data access code to connect to Cohere data.