CData Software - Knowledge Base

Recent Articles

---

• «
• 258
• 259
• 260
• 261
• 262
• 263
• 264
• 265
• 266
• 267
• »

• How to Connect to & Open Aha! Data in Microsoft Excel

  This article uses the CData ODBC driver for Aha! to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Automated Continuous Printful Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Printful replication to Google BigQuery.

• How to work with Google Cloud Storage Data in Apache Spark using SQL

  Access and process Google Cloud Storage Data in Apache Spark using the CData Software JDBC Driver.

• Automated Continuous JotForm Replication to Snowflake

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

• Object-Relational Mapping (ORM) with SingleStore 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 SingleStore data into a Java-based ORM framework, Hibernate.

• Import Optimizely Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Optimizely Data and provide access to live Optimizely data for custom reports in the Power BI Service.

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

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

• How to Connect DBeaver to Freshsales via a JDBC Driver

  Manage Freshsales data with visual tools in DBeaver like the query browser.

• Connect to BambooHR Data in NetBeans

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

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

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

• Integrating Claude Code CLI with LinkedIn 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 Foursquare Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Foursquare replication to Google BigQuery.

• Integrating LangGraph with Zoho CRM Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho CRM data within automated workflows.

• Access Live Highrise Data in Coginiti Pro

  Connect to and query live Highrise data from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Visualize ClickUp 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 ClickUp data into TIBCO Spotfire.

• Analyze BigCommerce Data in Cognos Analytics

  Use CData Connect AI to connect to BigCommerce Data from Cognos Analytics and analyze live BigCommerce data.

• Automated Continuous Moosend Replication to Google Cloud SQL

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

• Integrating OpenCode with Bitly 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 Connect Flowise AI Agents to Live Act CRM 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 Act CRM data without replication.

• Access NASA Data from MySQL in HeidiSQL

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

• How to Query Parallel Data in MySQL Workbench

  Execute MySQL queries against live Parallel data from MySQL Workbench.

• Access Live Salesforce Pardot Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Salesforce Pardot data from your Excel spreadsheets.

• Access Live PolarTeamPro Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to PolarTeamPro data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Access Live Optimizely Data in Coginiti Pro

  Connect to and query live Optimizely data from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to Build an ETL App for SAP HANA XS Advanced Data in Python with CData

  Create ETL applications and real-time data pipelines for SAP HANA XS Advanced data in Python with petl.

• Replicate Grafana Data to Multiple Databases

  Replicate Grafana data to disparate databases with a point-and-click configuration.

• Build Adobe Analytics-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Adobe Analytics data and build web apps with connectivity to live Adobe Analytics data.

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

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

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

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

• Getting Started with the CData Tableau Connector for PolarTeamPro

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• Build an OLAP Cube in SSAS from Intercom Data

  Establish a connection to Intercom data data from SQL Server Analysis Services, and use the Intercom Data Provider to build OLAP cubes for use in analytics and reporting.

• Analyze SQL Analysis Services Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of SQL Analysis Services data and visualize SQL Analysis Services data in SAP Analytics Cloud.

• Integrating OpenCode with Avalara AvaTax 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 publish and share Superchat Data dashboards with Tableau Server

  The CData ODBC driver for Superchat enables you integrate Superchat data into Tableau dashboards.

• Automated Continuous Harvest Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Harvest replication to SingleStore.

• Deploy the ADO.NET Provider for Azure Table on an SSRS Report Server

  Connect to Azure Table data 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.

• Replicate Multiple ShipEngine Accounts

  Replicate multiple ShipEngine accounts to one or many databases.

• Query Zoho Books Data in ColdFusion

  Write standard ColdFusion data access code to connect to Zoho Books data.

• Build an OLAP Cube in SSAS from Stack Exchange Data

  Establish a connection to Stack Exchange data data from SQL Server Analysis Services, and use the Stack Exchange Data Provider to build OLAP cubes for use in analytics and reporting.

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

  Connect to your SAP Business One data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• DataBind SAP Concur Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for SAP Concur with the DevExpress Windows Forms and Web controls to provide SAP Concur data to a chart.

• Access HDFS Data from MySQL in HeidiSQL

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

• Query Live ZohoPeople Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ZohoPeople data directly from the development environment.

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

  Provide connectivity to Codat data through an SAP BusinessObjects universe.

• Integrate AfterShip Data in the Pentaho Report Designer

  Publish reports based on AfterShip data in the Pentaho BI tool.

• Connect to Cloudant Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Cloudant and the Script function in FileMaker Pro to connect to Cloudant and work with Cloudant data in your FileMaker application.

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

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

• Connect to ServiceNow Data from PowerBuilder via JDBC

  This article demonstrates how to access ServiceNow data from PowerBuilder using the ServiceNow JDBC Driver.

• How to Work with CampaignMonitor Data in AWS Glue Jobs Using JDBC

  Connect to CampaignMonitor from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to connect and process Wave Financial data from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Wave Financial data.

• How to Visualize Snapchat Ads Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Snapchat Ads data in Python.

• Visualize Xero Data in TIBCO Spotfire through OData

  Integrate Xero data into dashboards in TIBCO Spotfire.

• Query Live Azure Analysis Services Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Azure Analysis Services data directly from the development environment.

• Connect to PagerDuty Data in HULFT Integrate

  Connect to PagerDuty as a JDBC data source in HULFT Integrate

• Access Workday Data from MySQL in PHP

  Connect to Workday through the standard MySQL libraries in PHP.

• Create a Data Access Object for SharePoint Data using JDBI

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

• Build Charts with Spark Data in Clear Analytics

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

• Connect to ServiceNow 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 ServiceNow data.

• Automated Continuous Salesforce Pardot Replication to SQLite

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SQLite.

• Integrate Google Cloud Storage Data in Pentaho Data Integration

  Build ETL pipelines based on Google Cloud Storage data in the Pentaho Data Integration tool.

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

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

• Query Live YouTube Analytics Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live YouTube Analytics data directly from the development environment.

• Integrate Spotify Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Spotify data from Informatica Cloud.

• Connect to Paddle Data in DBeaver

  Use the CData ODBC Driver to connect to Paddle data in DBeaver.

• Connect to xBase Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with xBase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• How to Work with Microsoft Dataverse Data in AWS Glue Jobs Using JDBC

  Connect to Microsoft Dataverse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Getting Started with the CData Excel Add-In for Google Ads

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Ads.

• Query Salesforce Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Salesforce data from Node.js.

• Object-Relational Mapping (ORM) with Freshsales 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 Freshsales data into a Java-based ORM framework, Hibernate.

• Create QuickBooks-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to QuickBooks Data from Klipfolio and build custom visualizations using live QuickBooks data.

• Integrating OpenCode with Jodoo 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 Sage 200 Data with Power Pivot

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

• Create Reports from DB2 Data in Looker Studio

  Use CData Connect AI to gain access to live DB2 data and create custom reports in Looker Studio.

• Analyze Live Dynamics NAV Data in SAS Viya

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

• Connect to Power BI XMLA Data in JRuby

  Create a simple JRuby app with access to live Power BI XMLA data.

• Create Omnisend-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Omnisend Data from Klipfolio and build custom visualizations using live Omnisend data.

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

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

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

• Integrate with live Email Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Email data in Jitterbit.

• Enable the Azure Analysis Services JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Azure Analysis Services data.

• Integrate OnePageCrm Data in Pentaho Data Integration

  Build ETL pipelines based on OnePageCrm data in the Pentaho Data Integration tool.

• Integrate with Apollo Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Apollo data in SnapLogic.

• Visualize ZohoExpense 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 ZohoExpense data into TIBCO Spotfire.

• Publish Google Translate-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Google Translate data.

• Visualize Live Vault CRM Data in the Power BI Service

  Use CData Connect AI to connect to live Vault CRM data and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Live DB2 Data in MicroStrategy through CData Connect AI

  Create a live connection to DB2 Data in CData Connect AI and connect to your DB2 data from MicroStrategy.

• Automated Continuous Short.io Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Short.io replication to Amazon Redshift.

• Work with Brex Data in FoxPro

  Load Brex data into a FoxPro database. This article includes full code and a walk-through of the process.

• How to work with Phoenix Data in Apache Spark using SQL

  Access and process Phoenix Data in Apache Spark using the CData Software JDBC Driver.

• Access Live Adobe Commerce Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Adobe Commerce data into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Commerce data in the Graph Builder and Query Builder.

• Automated Continuous CloudConvert Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable CloudConvert replication to Amazon S3.

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

  Connect to Facebook Ads data from a connection pool in Tomcat.

• Provide OData Services of Pipeliner CRM Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Pipeliner CRM data by developing a WCF Service Application.

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

  Provide connectivity to Egnyte data through an SAP BusinessObjects universe.

• Query Marketo Data through ODBC in Node.js

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

• Getting Started with the CData Tableau Connector for Marketo

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Marketo.

• Create PayPal-Connected Applications in Appsmith

  Connect to PayPal Data via CData Connect AI in Appsmith and create custom business applications with real-time access to PayPal data.

• How to Connect to Live ZohoSubscriptions Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your ZohoSubscriptions data for you.

• Automated Continuous Bitly Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Bitly replication to MongoDB.

• Getting Started with the CData Tableau Connector for Attio

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• «
• 258
• 259
• 260
• 261
• 262
• 263
• 264
• 265
• 266
• 267
• »