CData Software - Knowledge Base
Recent Articles
-
Import and Visualize Teamgate Data in Power View
Create data visualizations based on Teamgate in Excel.
-
Integrating GitHub Copilot CLI with HCL Domino 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 Apps with Live Amazon Redshift in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Redshift into the Adalo platform and build custom mobile and web applications with real-time Amazon Redshift.
-
Getting Started with the CData SSIS Components for MessageBird
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MessageBird.
-
Access CampaignMonitor Data from MySQL in Amazon QuickSight
Connect to CampaignMonitor and build visualizations of CampaignMonitor using a MySQL Connection in Amazon QuickSight.
-
Connect to Factorial Data in CloverDX (formerly CloverETL)
Transfer Factorial using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Sentry to Google BigQuery using CData SSIS Components.
Easily push Sentry to Google BigQuery using the CData SSIS Tasks for Sentry and Google BigQuery.
-
Feed ZeroBounce Data into FineReport
How to set ZeroBounce as a JDBC data source in FineReport.
-
How to Seamlessly Import Coda Data into IBM SPSS Modeler
Integrate Coda data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Miro Data in Tableau
The CData ODBC driver for Miro enables you integrate Miro into Tableau dashboards.
-
A PostgreSQL Interface for RSS Feeds (MySQL Remoting via JDBC)
Use the Remoting features of the RSS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage Mailgun Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mailgun.
-
Access Live Azure Analysis Services Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Analysis Services from your Google Sheets.
-
How to Design SAP HANA Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAP HANA from mobile and tablet Power Apps.
-
Getting Started with the CData ADO.NET Provider for Samanage
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to connect to ConstantContact Data from Spring Boot
Connect to ConstantContact in a Spring Boot Application using the CData API Driver for JDBC
-
Bind Live Act CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Act CRM data
-
Integrate HelloSign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HelloSign with External Services.
-
Feed Toggl Data into FineReport
How to set Toggl as a JDBC data source in FineReport.
-
Access Live Phoenix Data in Excel 365 Online (Excel for the web)
Connect to Apache Phoenix from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Use a Microsoft Access Database to Update LDAP Objects in Real Time
Update LDAP data by creating a linked table in Microsoft Access with the CData LDAP ODBC Driver.
-
How to Import Data from Oracle Financials Cloud into Google Sheets
Import Oracle Financials Cloud into a Google spreadsheet that is automatically refreshed.
-
View Reports on Real-Time ShipEngine Data in Power BI Report Server
Use the CData ODBC Driver for ShipEngine to visualize ShipEngine in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access Live Salesforce Data in Visual Studio Code via Cline
Run CData MCP Server for Salesforce on Windows Subsytem for Linux (WSL) and connect to live Salesforce & Force.com from the Cline extension in Visual Studio Code.
-
Migrating data from Google Sheets to Google BigQuery using CData SSIS Components.
Easily push Google Sheets to Google BigQuery using the CData SSIS Tasks for Google Sheets and Google BigQuery.
-
Build Workday-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Workday Data and create custom apps in Mendix.
-
Access Live Stack Exchange Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Stack Exchange in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Monday.com Data in Tableau
The CData ODBC driver for Monday.com enables you integrate Monday.com into Tableau dashboards.
-
How to import Microsoft Dataverse Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Dataverse in Data Import Handler and create an automated import of Microsoft Dataverse (CDS) to Apache Solr Enterprise Search platform.
-
Automated Continuous Salesforce Pardot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Apache Kafka.
-
Access VWO Data from MySQL in Amazon QuickSight
Connect to VWO and build visualizations of VWO using a MySQL Connection in Amazon QuickSight.
-
Integrating OpenCode Terminal with Cassandra 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.
-
DataBind Charts to Suadeo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Suadeo 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.
-
How to Connect Flowise AI Agents to Live GitHub Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live GitHub without replication.
-
Integrating Codex CLI with IBM Cloud Object Storage 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 SSAS Tabular Models from ChargeOver Data
How to build a SQL Server Analysis Service Tabular Model from ChargeOver using CData drivers.
-
Rapidly Develop Adobe Target-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 Adobe Target.
-
How to connect to Klipfolio Data from Spring Boot
Connect to Klipfolio in a Spring Boot Application using the CData API Driver for JDBC
-
Use Dash to Build to Web Apps on Mistral AI Data
Create Python applications that use pandas and Dash to build Mistral AI-connected web apps.
-
Use the CData Software ODBC Driver for Zoho Recruit in MicroStrategy Desktop
Connect to Zoho Recruit in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Recruit.
-
How to Build an ETL App for Zuora Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zuora in Python with petl and the CData Connect AI Python SDK.
-
Create Power BI Reports on Real-Time Salesforce Pardot Data
Use the CData ODBC Driver for Salesforce Pardot to visualize Salesforce Pardot in Power BI Desktop.
-
Access Live Zoho Creator Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Creator into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Creator in the Graph Builder and Query Builder.
-
Getting Started with the CData JDBC Driver for Kintone
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Kintone.
-
Connect to Redis Data in Google Apps Script via Connect AI
Use CData Connect AI to access Redis in Google Apps Script.
-
Access Live GraphQL Data in Coginiti Pro
Connect to and query live GraphQL from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Monday.com Data from MySQL in Amazon QuickSight
Connect to Monday.com and build visualizations of Monday.com using a MySQL Connection in Amazon QuickSight.
-
Integrating Gumloop with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Couchbase within automated workflows.
-
Connect Hubstaff to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hubstaff using the CData Python MCP Server.
-
Build Contentful-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Contentful and build web apps with connectivity to live Contentful.
-
Import Greenplum Data Using Azure Data Factory
Use CData Connect AI to connect to Greenplum Data from Azure Data Factory and import live Pivotal GreenPlum.
-
Deploy the ADO.NET Provider for Oracle Financials Cloud on an SSRS Report Server
Connect to Oracle Financials Cloud from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to Live PostgreSQL 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 PostgreSQL for you.
-
Integrating Codex CLI with Odoo ERP 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.
-
Explore Geographical Relationships in Sage Cloud Accounting Data with Power Map
Create data visualizations with Sage Business Cloud Accounting in Power Map.
-
Visualize Zoho CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho CRM.
-
Object-Relational Mapping (ORM) with Xero Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Xero Accounting into a Java-based ORM framework, Hibernate.
-
Build Drift-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Drift.
-
Connect to Jira Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Jira Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Figshare Data in DBeaver
Use the CData ODBC Driver to connect to Figshare in DBeaver.
-
Connect Microsoft Exchange to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Exchange with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Oracle Eloqua Reporting from Asprova with CData Software ODBC Driver for Oracle Eloqua Reporting
This article shows how to connect faster to Oracle Eloqua Reporting data from Asprova.
-
Getting Started with the CData SSIS Components for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Eloqua.
-
How to Connect to Live PayPal 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 PayPal without replication.
-
Visualize Humanity Data in Sisense
Create an ElastiCube in Sisense app with access to Humanity.
-
Automated Continuous Azure Data Catalog Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to AlloyDB.
-
Access Live PagerDuty Data in AWS Lambda
Connect to live PagerDuty in AWS Lambda using the CData JDBC Driver.
-
Visualize MailChimp 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 MailChimp into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ActiveCampaign.
-
Replicate Jodoo Data to Multiple Databases via the CData Sync CLI
Replicate Jodoo to disparate databases with a single configuration.
-
Publish ZohoMarketingHub-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoMarketingHub.
-
Automated Continuous Bannerbear Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bannerbear replication to Azure SQL Database.
-
How to Connect DBeaver to MailerLite via a JDBC Driver
Manage MailerLite with visual tools in DBeaver like the query browser.
-
Automate Raisers Edge NXT Data Replication to Couchbase
Use CData Sync to Customize and automate Raisers Edge NXT replication to Couchbase.
-
Getting Started with the CData Excel Add-In for Beeminder
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Beeminder.
-
Integrating Cursor CLI with DB2 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 update SAP Concur from Excel
This article explains how to transfer data from Excel to SAP Concur using the Excel Add-In for SAP Concur.
-
Build SAP Hybris C4C-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP Hybris C4C to explore live SAP Hybris C4C Data in Gemini Code Assist to assist with building SAP Hybris C4C-powered applications.
-
Create Airtable Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Airtable data access from reports, embedded analytics, and more.
-
Automated Continuous Wrike Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Wrike replication to PostgreSQL.
-
Working with Amazon S3 Data in LINQPad
Execute LINQ queries to Amazon S3 in LINQPad.
-
Build Google Drive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Drive and build web apps with connectivity to live Google Drive.
-
Bidirectional Access to Elasticsearch Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Elasticsearch in Filemaker Pro for Mac or Windows.
-
Natively Connect to DocuSign Data in PHP
The CData ODBC driver for DocuSign enables you to create PHP applications with connectivity to DocuSign. Leverage the native support for ODBC in PHP.
-
Rapidly Develop DocuSign-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 DocuSign.
-
Access Live Sage Cloud Accounting Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage Business Cloud Accounting from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous EmailOctopus Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Google Cloud SQL.
-
Extract, Transform, and Load Cassandra Data in Informatica PowerCenter
Create a simple Workflow for Apache Cassandra in Informatica PowerCenter.
-
Use Manus AI to Talk to Your Oracle SCM 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 Oracle SCM.
-
Getting Started with the CData SSIS Components for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sugar CRM.
-
Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy Web
Connect to Salesforce Marketing Cloud in MicroStrategy Web using the CData Software ODBC Driver for Salesforce Marketing.
-
Connect to Sybase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sybase Data and connect to Sybase in Akorbi Digital RunMyProcess.
-
Use the CData Software ODBC Driver for Microsoft Entra ID in MicroStrategy Desktop
Connect to Microsoft Entra ID in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Entra ID.
-
Access Mailgun Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mailgun from your Oracle system.
-
Stream ServiceDesk Plus Data into Apache Kafka Topics
Access and stream ServiceDesk Plus in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load Snowflake data into Elasticsearch via Logstash
Introducing a simple method to load Snowflake data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho Inventory using the Model Context Protocol.
-
Build Automated Workflows with Live SAS Data Sets Data in Workato
Use CData Connect AI to connect to live SAS Data Sets and build automated workflows in Workato.
-
Twilio Reporting in OBIEE with the Twilio JDBC Driver
Deploy the Twilio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect and process NetSuite CRM & ERP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live NetSuite CRM & ERP.