CData Software - Knowledge Base
Recent Articles
-
Use the CData SSIS Components to Insert New or Update Existing Google Drive Records from SQL Server
Easily push SQL Server data to Google Drive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Drive or update existing records with data from a SQL Server database.
-
Visualize SAP HANA Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP HANA data.
-
Connect to Coinbase Data in Aqua Data Studio
Access Coinbase data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
QuickBooks Time Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to QuickBooks Time data through CData Connect AI using different applications and tools.
-
Build Visualizations of Calendly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Calendly data in Birst.
-
Connecting Moonlit Workflow with Azure Data Lake Storage 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 Azure Data Lake Storage data in real time.
-
Build a Singer.io Tap for Quaderno With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Quaderno data using the CData Python Connector.
-
How to Work with Harvest Data in ETL Validator JDBC
Connect to Harvest from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating LlamaIndex with Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Testmonitor data in real time.
-
Integrate Google's Antigravity Agent with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live GitHub data using the Model Context Protocol.
-
Connect to Helpscout Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Helpscout to connect to Helpscout data and execute queries in PowerBuilder.
-
Access Live OData Services in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live OData services from your Excel spreadsheets.
-
Getting Started with the CData Excel Add-In for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ActiveCampaign.
-
How to connect PolyBase to Klaviyo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Klaviyo data.
-
Model SAP Fieldglass Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Fieldglass, enabling the direct import of real-time SAP Fieldglass data.
-
Create SAP Business Warehouse-Connected Applications in Appsmith
Connect to SAP Business Warehouse Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Business Warehouse data.
-
Build Automated Campaigner-Connected Workflows in Zapier
Use CData Connect AI to connect to live Campaigner data and build automated workflows in Zapier.
-
Build AI/ML Models with Live Google Search Data using Dataiku
Connect Google Search Data with Dataiku using the CData JDBC Driver for Google Search.
-
Use the CData Software JDBC Driver for Opsgenie in MicroStrategy Web
Connect to Opsgenie data in MicroStrategy Web using the CData Software JDBC Driver for Opsgenie.
-
Connect to Freshsales Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshsales to connect to Freshsales data and execute queries in PowerBuilder.
-
Analyze Everhour Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Everhour from Power Pivot. You will use the Table Import Wizard to load Everhour data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy Web
Connect to Jira data in MicroStrategy Web using the CData Software ODBC Driver for Jira.
-
Design BIRT Reports on Redis Data
Provide current Redis data to your embedded analytics.
-
Object-Relational Mapping (ORM) with Kintone 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 Kintone data into a Java-based ORM framework, Hibernate.
-
How to Work with Google Spanner Data in ETL Validator JDBC
Connect to Google Spanner from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Query SuiteCRM Data in MySQL Workbench
Execute MySQL queries against live SuiteCRM data from MySQL Workbench.
-
Connect to Timely Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Timely data from Filemaker Pro on Mac.
-
How to Query Zendesk Data in MySQL Workbench
Execute MySQL queries against live Zendesk data from MySQL Workbench.
-
Rapidly Develop Parallel-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 Parallel.
-
Import Real-Time ShipEngine Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ShipEngine data in ColdFusion.
-
Automated Continuous SparkPost Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SparkPost replication to Amazon S3.
-
Integrate TigerGraph with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate TigerGraph with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to TigerGraph data.
-
Create Datasets from Nethunt in Domo Workbench and Build Visualizations of Nethunt Data in Domo
Use the CData Software ODBC Driver for Nethunt to create datasets from Nethunt data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Cline with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Athena data from within your IDE.
-
How to update MariaDB from Excel
This article explains how to transfer data from Excel to MariaDB using the Excel Add-In for MariaDB.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy Desktop
Connect to Slack data in MicroStrategy Desktop using the CData Software JDBC Driver for Slack.
-
DataBind Controls to REST Data in Delphi
DataBind to REST data in Delphi with standard data access components and controls.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OpenWeatherMap data.
-
Build LDAP Visualizations in Tableau Desktop
Use CData Connect AI to connect to live LDAP objects and build visualizations in Tableau.
-
Build Automated SAP Concur-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Concur data and build automated workflows in Zapier.
-
Create Sendwithus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sendwithus from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind REST Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for REST with the DevExpress Windows Forms and Web controls to provide REST data to a chart.
-
Rapidly Develop Amazon S3-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 Amazon S3.
-
Access Avaza Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Avaza data from HeidiSQL.
-
Process & Analyze Freshteam Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Freshteam Data.
-
Integrate Live SharePoint Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SharePoint data and integrate live SharePoint data into apps built in Microsoft Power Apps.
-
Visualize Productboard Data in Sisense
Create an ElastiCube in Sisense app with access to Productboard data.
-
Getting Started with the CData ODBC Driver for VWO
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for VWO.
-
Build a Simple VCL Application for Accelo Data
How to build a simple VCL Application to view Accelo data in RAD Studio using the CData ODBC Driver for Accelo.
-
Access Live ZohoPeople Data in AWS Lambda
Connect to live ZohoPeople data in AWS Lambda using the CData JDBC Driver.
-
How to create Highrise federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Highrise data in MySQL .
-
Integrate Cloudflare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cloudflare data from Informatica Cloud.
-
Automate Google Contacts Data Replication to SAP HANA
Use CData Sync to customize and automate Google Contacts data replication to SAP HANA.
-
Using the CData Software ODBC Driver for Qualaroo in PyCharm
Connect to Qualaroo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Qualaroo.
-
Bridge Basecamp Connectivity with Apache NiFi
Access and process Basecamp data in Apache NiFi using the CData JDBC Driver.
-
How to publish and share Presto Data dashboards with Tableau Server
The CData ODBC driver for Presto enables you integrate Presto data into Tableau dashboards.
-
Build Charts with Cohere Data in Clear Analytics
Create dynamic charts and perform analytics based on Cohere data in Clear Analytics.
-
Feed Mode Data into FineReport
How to set Mode data as a JDBC data source in FineReport.
-
Build AI/ML Models with Live RSS Data using Dataiku
Connect RSS Data with Dataiku using the CData JDBC Driver for RSS.
-
Build a Singer.io Tap for Microsoft Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Ads data using the CData Python Connector.
-
Automated Continuous Presto Replication to MySQL
Use CData Sync for automated, continuous, customizable Presto replication to MySQL.
-
Connect to Avalara AvaTax Data in Aqua Data Studio
Access Avalara AvaTax data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in Chargebee Data with Power Map
Create data visualizations with Chargebee data in Power Map.
-
Build Apps with Live ClickUp Data Using the Low-Code Development Platform of Mendix
Connect ClickUp data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Stripe Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Stripe replication to Google Cloud SQL.
-
Automated Continuous Xero Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Xero replication to PostgreSQL.
-
Automated Continuous Onfleet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Onfleet replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Web
Connect to Sentry data in MicroStrategy Web using the CData Software ODBC Driver for Sentry.
-
Integrate Live Sybase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sybase data to Blue Prism using the CData ODBC Driver for Sybase to create automated workflows for repetitive business tasks.
-
How to Connect to SAP Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP data. Leverage the pyodbc module for ODBC in Python.
-
Know Your LLM (Series): ChatGPT
Comprehensive guide to ChatGPT models for enterprise AI. Learn integration patterns with CData Connect AI, model selection criteria, security compliance, and industry use cases for natural-language-to-SQL generation.
-
Automate Aweber Data Replication to SAP HANA
Use CData Sync to customize and automate Aweber data replication to SAP HANA.
-
Query Live PolarTeamPro Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live PolarTeamPro data through a conversational interface.
-
Automated Continuous Miro Replication to Snowflake
Use CData Sync for automated, continuous, customizable Miro replication to Snowflake.
-
Automated Continuous Teamgate Replication to Oracle
Use CData Sync for automated, continuous, customizable Teamgate replication to Oracle.
-
Connect to Excel Online Data from AWS Glue
Use CData Connect AI to gain access to live Excel Online data from your AWS Glue jobs.
-
Connect to ZohoMarketingHub from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ZohoMarketingHub data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to BenchmarkEmail in SpagoBI
Create reports featuring live BenchmarkEmail data in SpagoBI Studio. Host BenchmarkEmail reports on SpagoBI Server.
-
A PostgreSQL Interface for Confluence Data using the CData ODBC Driver
Use the SQL Gateway and Confluence ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SuiteCRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access SuiteCRM data from Appeon PowerBuilder using the CData ADO.NET Provider for SuiteCRM.
-
Validate Figshare Data with QuerySurge
Access and validate Figshare data in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Marketo
Create Marketo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to integrate Metabase with Cassandra Data
Use CData Connect AI to connect to live Cassandra data and create an interactive dashboard in Metabase from Cassandra data.
-
Bridge HelloSign Connectivity with Apache NiFi
Access and process HelloSign data in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Neo4J in a Connection Pool in Tomcat
Connect to Neo4J data from a connection pool in Tomcat.
-
Connect to FTP Data in Jaspersoft Studio
Execute SQL to remote FTP data in Jaspersoft Studio.
-
Integrate ADP Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ADP data from Informatica Cloud.
-
How to integrate Aircall with Apache Airflow
Access and process Aircall data in Apache Airflow using the CData JDBC Driver.
-
Connect to and Visualize Live Office 365 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Office 365 data.
-
Import and Visualize Google Cloud Storage Data in Power View
Create data visualizations based on Google Cloud Storage data in Excel.
-
Build Apps with Live OneNote Data Using the Low-Code Development Platform of Mendix
Connect OneNote data with Mendix to build apps using the CData JDBC Driver for OneNote.
-
Visualize Zoho Inventory Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Inventory data.
-
Integrating Cursor with Recurly 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 Visualize Google Sheets Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Sheets data in Python.
-
How to Connect the Power BI Service to Asana: Complete Guide
Connect to the CData Software Power BI Connector for Asana from PowerBI.com to provide real-time Asana data across the organization.
-
Automated Continuous SAP Ariba Procurement Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Amazon S3.
-
Integrate LibreChat with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAS xpt data from within the chat interface.
-
Integrating Boomi Agentstudio with Microsoft Entra ID Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Entra ID data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect and Visualize Live ZohoInvoice Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ZohoInvoice data into the Databricks platform and create visualization dashboards with real-time ZohoInvoice data.
-
Analyze ZarMoney Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZarMoney from Power Pivot. You will use the Table Import Wizard to load ZarMoney data. You can visually build the import query or use any SQL supported by the driver.