CData Software - Knowledge Base

Recent Articles

---

• «
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• »

• Connect to Highrise from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Highrise CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Connect to Paylocity Data in CloverDX (formerly CloverETL)

  Transfer Paylocity using the visual workflow in the CloverDX data integration tool.

• Manage Gumroad Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Gumroad.

• How to Query Live Harvest Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Harvest data in natural language using Python.

• Connect to ActiveCampaign Data in NetBeans

  Connect to ActiveCampaign in NetBeans with the data source configuration wizard.

• Integrating Antigravity CLI with Reckon Accounts Hosted via CData CLI

  Connect Reckon Accounts Hosted to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Create a Data Access Object for Jumpseller Data using JDBI

  A brief overview of creating a SQL Object API for Jumpseller in JDBI.

• Automated Continuous SparkPost Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable SparkPost replication to Google Cloud SQL.

• Publish Trello-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Trello.

• Automated Continuous Copper Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Copper replication to delimited files (CSV/TSV).

• Connect to SendPulse Data from a Connection Pool in JBoss

  Integrate SendPulse into Java servlets: Use the Management Console in JBoss to install the SendPulse JDBC Driver.

• Access Live Auth0 Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Auth0 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Connect to Freshdesk Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Freshdesk. Leverage the pyodbc module for ODBC in Python.

• Use Dash to Build to Web Apps on Microsoft Dataverse Data

  Create Python applications that use pandas and Dash to build Microsoft Dataverse-connected web apps.

• Connect to Moosend Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Moosend using standard SQL.

• Use the CData ODBC Driver for Pinecone in Microsoft Power Query

  You can use the CData Pinecone ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pinecone into Microsoft Power Query.

• Connect EmailOctopus to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect EmailOctopus with IBM WebSphere for seamless data integration and connectivity.

• Automated Continuous SAP Hybris C4C Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to delimited files (CSV/TSV).

• Configure the CData JDBC Driver for Outlook in a Connection Pool in Tomcat

  Connect to Outlook from a connection pool in Tomcat.

• Use the CData Software ODBC Driver for Authorize.Net in MicroStrategy Desktop

  Connect to Authorize.Net in MicroStrategy Desktop using the CData Software ODBC Driver for Authorize.Net.

• How to Connect the Power BI Service to LeadDesk: Complete Guide

  Connect to the CData Software Power BI Connector for LeadDesk from PowerBI.com to provide real-time LeadDesk across the organization.

• Create Informatica Mappings From/To a JDBC Data Source for Supabase

  Create Supabase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Automated Continuous HDFS Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable HDFS replication to Azure SQL Database.

• Zoho Recruit Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Zoho Recruit facts in real time.

• Build Voice Agents in ElevenLabs with access to Live Presto Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Presto.

• Access Gong Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Gong from HeidiSQL.

• Add SAP Fieldglass Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SAP Fieldglass with the Informatica Enterprise Data Catalog to classify and organize data.

• Use the CData ODBC Driver for Kintone in Microsoft Power Query

  You can use the CData Kintone ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Kintone into Microsoft Power Query.

• Design BIRT Reports on ChargeOver Data

  Provide current ChargeOver to your embedded analytics.

• LINQ to Snapchat Ads 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 Snapchat Ads Data Provider.

• Use the CData Software ODBC Driver for Attio in SAS for Real-Time Reporting and Analytics

  Connect to real-time Attio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Attio.

• Build Google Forms-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Forms.

• Integrate Theia IDE with Live Microsoft Teams Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• Build Apps with Live BigQuery Data Using the Low-Code Development Platform of Mendix

  Connect Google BigQuery with Mendix to build apps using the CData JDBC Driver for BigQuery.

• Connect to GitLab Data in ACL Analytics

  Connect to GitLab via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GitLab.

• Write a Simple Go Application to work with SuiteCRM Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SuiteCRM.

• Query Strava Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Strava from Node.js.

• Write a Simple Go Application to work with Google Sheets Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Sheets.

• How to Query Live Flowlu Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Flowlu data in natural language using Python.

• Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy Web

  Connect to Sugar CRM in MicroStrategy Web using the CData Software ODBC Driver for Sugar CRM.

• Create FHIR-Connected Business Apps in AppSheet

  Connect to FHIR Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to FHIR.

• How to load ZohoExpense data into Elasticsearch via Logstash

  Introducing a simple method to load ZohoExpense data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Getting Started with the CData Power BI Connector for OData

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for OData.

• Integrate QuickBooks Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Desktop from Informatica Cloud.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Search

  Provide connectivity to Google Search through an SAP BusinessObjects universe.

• Integrating Claude Code CLI with SharePoint 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.

• Integrating OpenCode Terminal with Pipeline CRM 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.

• Access Live Microsoft Ads Data in AWS Lambda

  Connect to live Microsoft Ads in AWS Lambda using the CData JDBC Driver.

• Automated Continuous Google Campaign Manager 360 Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to IBM DB2.

• How to Access Live Salesforce CRM Analytics Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Salesforce CRM Analytics enables you to integrate Salesforce CRM Analytics into workflows built using Microsoft Power Automate Desktop.

• Edit and Search QuickBooks Online External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of QuickBooks Online to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create QuickBooks Online objects that you can access from apps and the dashboard.

• Query Google Calendar Data as a MySQL Database in Node.js

  Execute MySQL queries against Google Calendar from Node.js.

• Access Live Oracle Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Oracle Database from your Excel spreadsheets.

• Visualize Google Translate Data in Tableau

  The CData ODBC driver for Google Translate enables you integrate Google Translate into Tableau dashboards.

• How to connect PolyBase to Box

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Box.

• Connect to Cloudant Data from AWS Glue

  Use CData Connect AI to gain access to live IBM Cloudant from your AWS Glue jobs.

• Explore Geographical Relationships in Onfleet Data with Power Map

  Create data visualizations with Onfleet in Power Map.

• Use the CData ODBC Driver for CapsuleCRM from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for CapsuleCRM to connect to CapsuleCRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CapsuleCRM in Excel.

• Build Charts with Clockify Data in Clear Analytics

  Create dynamic charts and perform analytics based on Clockify in Clear Analytics.

• Analyze HDFS Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for HDFS from Power Pivot. You will use the Table Import Wizard to load Apache HDFS. You can visually build the import query or use any SQL supported by the driver.

• Automate Amazon S3 Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Amazon S3 replication to Azure Data Lake.

• Getting Started with the CData Connect AI Python SDK for Act-On

  Install the CData Connect AI Python SDK to read and write live Act-On with standard DB-API 2.0 Python code.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed CockroachDB to Power BI dashboards. Simply drag and drop CockroachDB into data visuals on the Power BI canvas.

• Connect to Vault CRM Data in DBeaver

  Use the CData ODBC Driver to connect to Veeva Vault & Vault CRM in DBeaver.

• Integrating Claude Code CLI with PingOne 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.

• Analyze Live CockroachDB Data in SAS Viya

  Use CData Connect AI to connect to CockroachDB from SAS Viya and deploy self-service analytics using live CockroachDB.

• Replicate Multiple BambooHR Accounts via the CData Sync CLI

  Replicate multiple BambooHR accounts to one or many databases.

• How to Connect to Live Oracle Sales Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle Sales for you.

• How to connect SharePoint with SAP SuccessFactors LMS Data through external lists

  Provide SAP SuccessFactors LMS to SharePoint users as an external list.

• View Reports on Real-Time Wave Financial Data in Power BI Report Server

  Use the CData ODBC Driver for Wave Financial to visualize Wave Financial in Power BI Desktop and then publish them to Power BI Report Server.

• Build Semantic Layer Views for Discord Data in APOS Live Data Gateway

  Use the CData Connector for Discord in APOS Live Data Gateway to build Semantic Layer Views for Discord.

• Analyze SFTP Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SFTP with the CData JDBC Driver for SFTP.

• How to Connect to Live Azure Table 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 Azure Table Storage for you.

• How to create an RPA flow for Supabase Data in UiPath Studio

  Use the Supabase ODBC Driver to create workflows that access real-time Supabase without any coding.

• Replicate CSV Data from PowerShell

  Write a quick PowerShell script to query CSV/TSV Files. Use connectivity to the live data to replicate CSV/TSV Files to SQL Server.

• Connect to Coinbase from Asprova with CData Software ODBC Driver for Coinbase

  This article shows how to connect faster to Coinbase data from Asprova.

• Publish Retently-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Retently.

• Create SSAS Tabular Models from Teamwork Data

  How to build a SQL Server Analysis Service Tabular Model from Teamwork using CData drivers.

• Operational Reporting on Certinia Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Certinia.

• Connect Acumatica Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Acumatica ERP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Extend Google Sheets with Zuora Data

  Make calls to Zuora from Google Apps Script via the API Server.

• How to Build an ETL App for Dynamics 365 Business Central Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Dynamics 365 Business Central in Python with petl and the CData Connect AI Python SDK.

• Build Apps with Live Oracle HCM Cloud in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Oracle HCM Cloud into the Adalo platform and build custom mobile and web applications with real-time Oracle HCM Cloud.

• Natively Connect to Gorgias Data in PHP

  The CData ODBC driver for Gorgias enables you to create PHP applications with connectivity to Gorgias. Leverage the native support for ODBC in PHP.

• Use the CData Software JDBC Driver for Moosend in MicroStrategy Web

  Connect to Moosend in MicroStrategy Web using the CData Software JDBC Driver for Moosend.

• Automated Continuous Oracle Service Cloud Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Apache Kafka.

• Automated Continuous SAP HANA XS Advanced Replication to SQL Server

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQL Server.

• How to Work with Copper Data in ETL Validator JDBC

  Connect to Copper from ETL Validator jobs using the CData Software JDBC Driver.

• Visualize Live HubSpot Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live HubSpot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to use SQLAlchemy ORM to access Stack Exchange Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Stack Exchange.

• Import Real-Time Oracle Service Cloud Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Oracle Service Cloud in ColdFusion.

• How to Work with Google Analytics Data in ETL Validator JDBC

  Connect to Google Analytics from ETL Validator jobs using the CData Software JDBC Driver.

• Enable the FreshBooks JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with FreshBooks.

• Automated Continuous PivotalTracker Replication to Snowflake

  Use CData Sync for automated, continuous, customizable PivotalTracker replication to Snowflake.

• Integrating Strava Data in Talend Cloud Data Management Platform

  Connect Strava Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• Build Charts with Excel Online Data in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Excel Online in Clear Analytics.

• A PostgreSQL Interface for Couchbase Data using the CData ODBC Driver

  Use the SQL Gateway and Couchbase ODBC Driver to create a PostgreSQL entry-point for data access.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Synapse within intelligent workflows.

• How to Connect to Live ADP 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 ADP for you.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Table

  Provide connectivity to Azure Table Storage through an SAP BusinessObjects universe.

• «
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• »