CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Printify in MicroStrategy
Connect to Printify data in MicroStrategy Developer using the CData Software JDBC Driver for Printify.
-
Create SAP Concur Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Concur data access from reports, embedded analytics, and more.
-
Connect to Shopify in SpagoBI
Create reports featuring live Shopify data in SpagoBI Studio. Host Shopify reports on SpagoBI Server.
-
Visualize Vault CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Vault CRM data.
-
Visualize ActiveCampaign Data in TIBCO Spotfire through OData
Integrate ActiveCampaign data into dashboards in TIBCO Spotfire.
-
Use Manus AI to Talk to Your Google Drive 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 Google Drive data.
-
Integrate Theia IDE with Live Box 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 Box data from within the development environment.
-
Analyze SingleStore Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SingleStore data and visualize live SingleStore data in Infragistics Reveal.
-
Integrating Kiro with SAP Ariba Procurement 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.
-
Automated Continuous IBM Informix Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to Google Cloud SQL.
-
How to Access Live Azure Table Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Table enables you to integrate Azure Table data into workflows built using Microsoft Power Automate Desktop.
-
Add Gorgias Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gorgias with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Unbounce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Unbounce replication to Google Cloud SQL.
-
Integrating Cursor with HelloSign 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.
-
Connect to LightSpeedRetail Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LightSpeedRetail data.
-
Connect to Salesforce Marketing Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Salesforce Marketing data.
-
Build Visualizations of Zoho CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho CRM data in Birst.
-
Build LDAP-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for LDAP Objects and create custom apps in Bubble.
-
Connect to and Query Quickbase Data in QlikView over ODBC
Create data visualizations with Quickbase data in QlikView.
-
Integrate Aweber with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Aweber with External Services.
-
Create Reports from Google Analytics Data in Looker Studio
Use CData Connect AI to gain access to live Google Analytics data and create custom reports in Looker Studio.
-
Connect to SAP ByDesign Data from a Connection Pool in Jetty
The SAP ByDesign JDBC Driver supports connection pooling: This article shows how to connect faster to SAP ByDesign data from Web apps in Jetty.
-
Object-Relational Mapping (ORM) with Freshdesk 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 Freshdesk data into a Java-based ORM framework, Hibernate.
-
Build Pipelines with Live SAP Ariba Procurement Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Ariba Procurement from Google Cloud Data Fusion, enabling the integration of live SAP Ariba Procurement data into the building and management of effective data pipelines.
-
Connect to Live Greenhouse Data in MicroStrategy through CData Connect AI
Create a live connection to Greenhouse Data in CData Connect AI and connect to your Greenhouse data from MicroStrategy.
-
How to connect to Insightly Data from IntelliJ
Integrate connectivity to Insightly data with wizards in IntelliJ.
-
Replicate Multiple Azure Data Catalog Accounts
Replicate multiple Azure Data Catalog accounts to one or many databases.
-
DataBind Controls to Tally Data in C++Builder
DataBind to Tally data in C++Builder with standard components and controls.
-
Integrating LangChain with SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP ByDesign data within automated workflows.
-
Replicate Demio Data to Multiple Databases via the CData Sync CLI
Replicate Demio data to disparate databases with a single configuration.
-
Automated Continuous SAP Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP replication to IBM DB2.
-
Connect to Redis Data in Claris FileMaker Pro
Use the CData ODBC Driver for Redis in FileMaker Pro to connect to Redis and work with Redis data in your FileMaker applications.
-
Automated Continuous Oracle Sales Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Vertica.
-
Write a Simple Go Application to work with Clockify Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Clockify data.
-
Automated Continuous Nethunt Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Nethunt replication to IBM DB2.
-
Query Paymo Data as a MySQL Database in Node.js
Execute MySQL queries against Paymo data from Node.js.
-
Integrating LlamaIndex with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Excel Online data in real time.
-
Operational Reporting on Coda Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Coda data.
-
Build xBase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live xBase data and build visualizations in Tableau.
-
Validate Omnisend Data with QuerySurge
Access and validate Omnisend data in QuerySurge using the CData JDBC Driver.
-
How to Build an ETL App for Microsoft OneDrive Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft OneDrive data in Python with petl.
-
Integrate with live Google Directory Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Directory data in Jitterbit.
-
Automated Continuous Flowlu Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Flowlu replication to Amazon Redshift.
-
Automated Continuous Dotmailer Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dotmailer replication to Azure SQL Database.
-
Connect to SpaceX Data in Jaspersoft Studio
Execute SQL to remote SpaceX data in Jaspersoft Studio.
-
Build MVC Applications with Connectivity to SharePoint Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SharePoint from an ASP.NET MVC application.
-
Automated Continuous Salesloft Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesloft replication to Vertica.
-
How to Connect Authorize.Net Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Authorize.Net data in real time using natural language.
-
Visualize Live Retently Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Retently data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for CapsuleCRM in SAS for Real-Time Reporting and Analytics
Connect to real-time CapsuleCRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CapsuleCRM.
-
Use CData Connect AI to Access Certinia Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Certinia data in the Power Pivot business intelligence tool.
-
Bridge Salesforce Connectivity with Apache NiFi
Access and process Salesforce data in Apache NiFi using the CData JDBC Driver.
-
Build Data Flows from SQL Server to TaxJar through SSIS
Easily push SQL Server data to TaxJar using the CData SSIS Tasks for TaxJar.
-
Integrate Trae with Live Google Campaign Manager 360 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Campaign Manager 360 data from within the AI-powered IDE.
-
Bind Live PostgreSQL Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PostgreSQL data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build an OLAP Cube in SSAS from Google Analytics Data
Establish a connection to Google Analytics data data from SQL Server Analysis Services, and use the Google Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Marketo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Marketo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Power BI Connector for Amazon S3
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon S3.
-
Connect to and Visualize Live GraphQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GraphQL data.
-
Connect to Twilio Data from AWS Glue
Use CData Connect AI to gain access to live Twilio data from your AWS Glue jobs.
-
Integrating Kiro with Invoiced 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.
-
Integrate Okta with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Okta with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Okta data.
-
How to Build an ETL App for Perigon Data in Python with CData
Create ETL applications and real-time data pipelines for Perigon data in Python with petl.
-
Build Automated ServiceNow-Connected Workflows in Zapier
Use CData Connect AI to connect to live ServiceNow data and build automated workflows in Zapier.
-
How to connect Amazon QuickSight to Smartsheet Data
Create a connection to Smartsheet data in CData Connect AI and insert Smartsheet data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect Amazon QuickSight to Active Directory Data
Create a connection to Active Directory data in CData Connect AI and insert Active Directory data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Mode-Connected Business Apps in AppSheet
Connect to Mode Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Mode data.
-
DataBind Controls to Facebook Ads Data in C++Builder
DataBind to Facebook Ads data in C++Builder with standard components and controls.
-
Connecting Agentforce with Toggl 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 Toggl data for you.
-
Automated Continuous Helpscout Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Helpscout replication to Apache Kafka.
-
DataBind Controls to Egnyte Data in C++Builder
DataBind to Egnyte data in C++Builder with standard components and controls.
-
How to Connect DBeaver to HelloSign via a JDBC Driver
Manage HelloSign data with visual tools in DBeaver like the query browser.
-
How to import Amazon S3 Data into Apache Solr
Use the CData Software JDBC Driver for Amazon S3 in Data Import Handler and create an automated import of Amazon S3 data to Apache Solr Enterprise Search platform.
-
Replicate Multiple Paymo Accounts via the CData Sync CLI
Replicate multiple Paymo accounts to one or many databases.
-
How to Connect to Live Google Forms 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 Google Forms data for you.
-
Connect to CouchDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access CouchDB data in Google Apps Script.
-
Use JayDeBeApi to access Greenhouse Data in Python
Use standard Python scripting and the development environment of your choice to access live Greenhouse data.
-
Create Data Visualizations Based On PayPal Data in Mode
Use CData Connect AI to connect to PayPal Data from Mode and build visualizations using live PayPal data.
-
DataBind Controls to SAP HANA Data in C++Builder
DataBind to SAP HANA data in C++Builder with standard components and controls.
-
Excel Spreadsheet Automation on Guru Data with the QUERY Formula
Pull data from Guru, automate spreadsheets, and more with the QUERY formula.
-
Build MySQL-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MySQL data.
-
Connect to Email Data in Aqua Data Studio
Access Email data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Mixpanel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mixpanel data.
-
Create Data Visualizations Based On Attio Data in Mode
Use CData Connect AI to connect to Attio Data from Mode and build visualizations using live Attio data.
-
Access Live Pushbullet Data in Coginiti Pro
Connect to and query live Pushbullet data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData SSIS Components to Insert New or Update Existing Gmail Records from SQL Server
Easily push SQL Server data to Gmail using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Gmail or update existing records with data from a SQL Server database.
-
Create Wistia-Connected Dashboards in Grafana
Connect to Wistia Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Wistia data.
-
Create Reports from Dynamics NAV Data in Looker Studio
Use CData Connect AI to gain access to live Dynamics NAV data and create custom reports in Looker Studio.
-
Integrate Redshift Data in the Pentaho Report Designer
Publish reports based on Redshift data in the Pentaho BI tool.
-
Enable the Greenplum JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Greenplum data.
-
Visualize Live Aweber Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Aweber data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Goose with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Tavily data from within the local AI agent.
-
Integrate Real-Time Access to Google Sheets in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Sheets data in real time.
-
Extract, Transform, and Load Facebook Data in Informatica PowerCenter
Create a simple Workflow for Facebook data in Informatica PowerCenter.
-
A PostgreSQL Interface for Timely Data (MySQL Remoting via JDBC)
Use the Remoting features of the Timely JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Dynamics CRM to Google BigQuery using CData SSIS Components.
Easily push Dynamics CRM data to Google BigQuery using the CData SSIS Tasks for Dynamics CRM and Google BigQuery.
-
Query OnePageCrm Data in DataGrip
Create a Data Source for OnePageCrm in DataGrip and use SQL to query live OnePageCrm data.
-
Create Reports from Zoom Data in Looker Studio
Use CData Connect AI to gain access to live Zoom data and create custom reports in Looker Studio.
-
Easily Integrate Teradata Data in Lazarus Pascal IDE
Learn how to easily integrate live Teradata data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Reports with ShipStation Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipStation data.