CData Software - Knowledge Base

Recent Articles

---

• «
• 1179
• 1180
• 1181
• 1182
• 1183
• 1184
• 1185
• 1186
• 1187
• 1188
• »

• How to Connect to & Open Mocean Data in Microsoft Excel

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

• Automated Continuous Zendesk Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Zendesk replication to OneLake in Microsoft Fabric.

• Yelp Reporting in OBIEE with the Yelp JDBC Driver

  Deploy the Yelp JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Create a Data Access Object for Webex Data using JDBI

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

• How to connect to CSV Data in DBVisualizer

  Integrate CSV/TSV Files with visual data analysis tools and data connection wizards in DBVisualizer

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

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

• Connecting Agentforce with Oracle Sales 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 Oracle Sales for you.

• Build Charts with Pinterest Data in Clear Analytics

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

• Build Pipelines with Live Jira Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Jira from Google Cloud Data Fusion, enabling the integration of live Atlassian Jira into the building and management of effective data pipelines.

• Natively Connect to eBay Analytics Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to eBay Analytics. Leverage the native support for ODBC in PHP.

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

• How to connect to Azure Table Data with Squirrel SQL client

  Connect to Azure Table Storage and execute queries in the Squirrel SQL Client.

• Analyze Salesforce Pardot Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Salesforce Pardot and visualize Salesforce Pardot in SAP Analytics Cloud.

• Rapidly Develop Coinbase-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 Coinbase.

• Build Charts with Shippo Data in Clear Analytics

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

• Connecting Mastra with MongoDB Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time MongoDB, no replication required.

• Integrating Claude Code CLI with QuickBooks Online 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 Work with FHIR Data in AWS Glue Jobs Using JDBC

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

• How to Create Power BI Visual Reports with Real-Time Sage 300 Data

  Use CData Power BI Connectors to visualize Sage 300 in Power BI.

• How to create Clockify federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Clockify in MySQL .

• Integrate Theia IDE with Live ADP Data via CData Connect AI

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

• Getting Started with the CData SSIS Components for Okta

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Okta.

• Rapidly Develop Strava-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 Strava.

• Build AI Agents with Facebook Ads Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Facebook Ads through CData Connect AI.

• Visualize Live Certinia Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Certinia.

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

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

• Visualize Avro Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Apache Avro.

• Connect to Mixpanel Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Mixpanel as an External Source in Dremio.

• How to create Amazon DynamoDB federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon DynamoDB in MySQL .

• Stream Close Data into Apache Kafka Topics

  Access and stream Close in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Integrate with Greenhouse Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Greenhouse to a JSON file on disk.

• Automate Teamwork Data Replication to SAP HANA

  Use CData Sync to customize and automate Teamwork replication to SAP HANA.

• Natively Connect to Guru Data in PHP

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

• Adobe Analytics Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Adobe Analytics through CData Connect AI using different applications and tools.

• Build Charts with Aircall Data in Clear Analytics

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

• How to Visualize Zoom Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Zoom in Python.

• Build Dashboards with Egnyte Data in DBxtra

  Create dynamic dashboards and perform analytics based on Egnyte in DBxtra.

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

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

• Automated Continuous Vertica Replication to SQLite

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

• Integrate Open WebUI with Live Box Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Box from within the chat interface.

• Design BIRT Reports on CouchDB Data

  Provide current Apache CouchDB to your embedded analytics.

• Rapidly Develop Keap-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 Keap.

• Build Google Search Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Google Search and build visualizations in Tableau Cloud.

• Connect to Cvent Data from AWS Glue

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

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

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

• Working with Salesloft Data in LINQPad

  Execute LINQ queries to Salesloft in LINQPad.

• Automate Clio Data Replication to Azure Data Lake

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

• Work with Snapchat Ads Data in FoxPro

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

• Build Agents in Relevance AI with Access to Live Azure Table Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Table Storage within intelligent agent workflows.

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

  Use CData Connect AI to gain access to live SAP Concur from your Excel spreadsheets.

• How to Connect to Live Odoo 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 Odoo ERP without replication.

• Connect to Real-Time Datadog Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData API Driver for Power BI and Dataflow to import and use Datadog in Power Apps.

• Moving Data from Templated to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Templated data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Integrating Kiro CLI with ZeroBounce 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.

• Build PhantomBuster-Connected ETL Processes in Google Data Fusion

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

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

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

• Automated Continuous Phoenix Replication to Amazon S3

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

• Deploy the ADO.NET Provider for Azure Data Lake Storage on an SSRS Report Server

  Connect to Azure Data Lake Storage 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.

• Connect to Facebook Ads from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Facebook Ads to connect to Facebook Ads from Web applications running on WebLogic.

• Integrate Outreach.io with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Outreach.io with External Services.

• Load SAP Concur Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Concur to a database.

• Connect to Recurly Data in HULFT Integrate

  Connect to Recurly as a JDBC data source in HULFT Integrate

• Connect to and Visualize Live Microsoft OneDrive Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft OneDrive.

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

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

• Automated Continuous Splunk Replication to Local Delimited Files

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

• Connect to Azure Data Catalog Data in CloverDX (formerly CloverETL)

  Transfer Azure Data Catalog using the visual workflow in the CloverDX data integration tool.

• Build Dashboards with SAP Ariba Source Data in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Ariba Source in DBxtra.

• Getting Started with the CData ODBC Driver for Tavily

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tavily.

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

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

• Connect to Workday Data from AWS Glue

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

• Build AI Agents with Basecamp Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Basecamp through CData Connect AI.

• Build Automated Workflows with Live Raisers Edge NXT Data in Workato

  Use CData Connect AI to connect to live Raisers Edge NXT and build automated workflows in Workato.

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

• Load FHIR Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FHIR to a database.

• How to Visualize WooCommerce 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 WooCommerce in Python.

• Create LinkedIn Ads-Connected Visualizations in Klipfolio

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

• Excel Spreadsheet Automation on CloudConvert Data with the QUERY Formula

  Pull data from CloudConvert, automate spreadsheets, and more with the QUERY formula.

• A PostgreSQL Interface for Salesforce CRM Analytics Data using the CData ODBC Driver

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

• Automated Continuous ShipEngine Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable ShipEngine replication to OneLake in Microsoft Fabric.

• Perform Batch Operations with Blackbaud FE NXT Data in Apache NiFi

  Connect to Blackbaud FE NXT and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Build Data Flows from Hugging Face to SQL Server using SSIS

  Easily back up Hugging Face to SQL Server using the SSIS components for Hugging Face.

• Use the CData Software ODBC Driver for Odoo in MicroStrategy Desktop

  Connect to Odoo ERP in MicroStrategy Desktop using the CData Software ODBC Driver for Odoo.

• Analyze Sugar CRM Data in Looker

  Use CData Connect AI to connect to Sugar CRM Data from Looker and build custom apps using live Sugar CRM.

• DataBind Charts to HelloSign Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to HelloSign 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.

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

  Connect to Azure Synapse from a connection pool in Tomcat.

• Connect to Perplexity Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Perplexity to connect to Perplexity and execute queries in PowerBuilder.

• Validate Calendly Data with QuerySurge

  Access and validate Calendly in QuerySurge using the CData JDBC Driver.

• Integrate Cursor with Live Redshift Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon Redshift from within the editor.

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

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

• Build a Simple VCL Application for SAP ByDesign Data

  How to build a simple VCL Application to view SAP Business ByDesign in RAD Studio using the CData ODBC Driver for SAP ByDesign.

• Connect to Bullhorn CRM from Excel & GoogleSheets!

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

• Connecting Moonlit Workflow with AlloyDB 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 Google AlloyDB in real time.

• How to use SQLAlchemy ORM to access Testmonitor Data in Python

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

• Build Klaviyo-Connected ETL Processes in Google Data Fusion

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

• Build Microsoft Ads Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Microsoft Ads and build visualizations in Tableau Cloud.

• Use the CData Software ODBC Driver for Sendwithus in MicroStrategy Web

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

• Integrating Cursor CLI with Tally 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 Productboard in SpagoBI

  Create reports featuring live Productboard in SpagoBI Studio. Host Productboard reports on SpagoBI Server.

• Query Sage Cloud Accounting Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Sage Business Cloud Accounting from Node.js.

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

  Provide connectivity to Veeva Vault & Vault CRM through an SAP BusinessObjects universe.

• «
• 1179
• 1180
• 1181
• 1182
• 1183
• 1184
• 1185
• 1186
• 1187
• 1188
• »