CData Software - Knowledge Base

Recent Articles

---

• «
• 1051
• 1052
• 1053
• 1054
• 1055
• 1056
• 1057
• 1058
• 1059
• 1060
• »

• Process & Analyze Campaigner Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Campaigner Data.

• How to work with Azure DevOps Data in Apache Spark using SQL

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

• Use the CData API Server to Access BigCommerce Data in Microsoft PowerPivot

  Use the CData API Server to connect to live BigCommerce in the Power Pivot business intelligence tool.

• Automate ServiceDesk Plus Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access ServiceDesk Plus from PowerShell? This article demonstrates how to utilize the ServiceDesk Plus Cmdlets for tasks like connecting to ServiceDesk Plus, automating operations, downloading data, and more.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live DocuSign using the Model Context Protocol.

• Establish a Live Connection with PDFMonkey Data using Tableau Bridge

  The CData ODBC Driver for PDFMonkey enables you to integrate live PDFMonkey into Tableau Cloud dashboards using the Tableau Bridge.

• Create Reports from Office 365 Data in Looker Studio

  Use CData Connect AI to gain access to live Microsoft Office 365 and create custom reports in Looker Studio.

• Build AI/ML Models with Live ZohoMarketingHub Data using Dataiku

  Connect ZohoMarketingHub Data with Dataiku using the CData API Driver for JDBC.

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

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

• Perform Batch Operations with REST Data in Apache NiFi

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

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

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

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

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

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

• Connect to Slack Data from Blazor Apps

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

• Analyze Zoho Books Data in SAP Analytics Cloud

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

• Connect to Power BI XMLA Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Power BI XMLA Data and connect to Power BI XMLA in Akorbi Digital RunMyProcess.

• Migrating data from Tickspot to Snowflake using CData SSIS Components.

  Easily push Tickspot to Snowflake using the CData SSIS Tasks for Tickspot and Snowflake.

• Use the CData ODBC Driver for Google Ad Manager from SharePoint Excel Services

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

• Access Live MYOB AccountRight Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live MYOB AccountRight data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• A PostgreSQL Interface for Pinecone Data (MySQL Remoting via JDBC)

  Use the Remoting features of the Pinecone JDBC Driver to create a PostgreSQL entry-point for data access.

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

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

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

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

• Extract, Transform, and Load IBM Informix Data in Informatica PowerCenter

  Create a simple Workflow for IBM Informix in Informatica PowerCenter.

• Stream Oracle Data into Apache Kafka Topics

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

• Stream SAS xpt Data into Apache Kafka Topics

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

• Connect to Azure Synapse from Excel & GoogleSheets!

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

• Connect to IBM Cloud Object Storage Data in JRuby

  Create a simple JRuby app with access to live IBM Cloud Object Storage.

• Build Oracle Sales-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Oracle Sales to explore live Oracle Sales Data in Cursor to assist with building Oracle Sales-powered applications.

• Query Freshteam Data as a MySQL Database in Node.js

  Execute MySQL queries against Freshteam from Node.js.

• DataBind Controls to Nethunt Data in Delphi

  DataBind to Nethunt in Delphi with standard data access components and controls.

• How to connect PolyBase to GitHub

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

• Build Dashboards with Moosend Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Moosend in Dundas BI.

• How to Connect Flowise AI Agents to Live Google Search Results via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Search without replication.

• Enable the MongoDB JDBC Driver in KNIME

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

• Consume Bitbucket OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Bitbucket feeds that reflect any changes in SAP Lumira.

• Automated Continuous LaunchDarkly Replication to Oracle

  Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Oracle.

• Publish Oracle Sales-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Oracle Sales.

• Integrate Zoho Inventory Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Zoho Inventory and integrate live Zoho Inventory into your Power Automate tasks.

• Integrate Live MongoDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live MongoDB to Blue Prism using the CData ODBC Driver for MongoDB to create automated workflows for repetitive business tasks.

• Migrating data from Azure Table to Snowflake using CData SSIS Components.

  Easily push Azure Table Storage to Snowflake using the CData SSIS Tasks for Azure Table and Snowflake.

• Connect to Helpscout Data in CloverDX (formerly CloverETL)

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

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

• Visualize Live Pipeliner CRM Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Pipeliner CRM.

• Visualize Google Directory Data in TIBCO Spotfire through OData

  Integrate Google Directory into dashboards in TIBCO Spotfire.

• Automated Continuous MariaDB Replication to SQL Server

  Use CData Sync for automated, continuous, customizable MariaDB replication to SQL Server.

• Connect to MariaDB Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for MariaDB in the Denodo Virtual DataPort Administrator.

• Process & Analyze Paddle Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Paddle Data.

• Use Dash to Build to Web Apps on Active Directory Data

  Create Python applications that use pandas and Dash to build Active Directory-connected web apps.

• How to update Acumatica from Excel

  This article explains how to transfer data from Excel to Acumatica using the Excel Add-In for Acumatica.

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

  Provide connectivity to Google Ads through an SAP BusinessObjects universe.

• Use Databricks Agent Bricks to Talk to Your Google Ads Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Ads for you.

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

  Connect Sage Intacct with Mendix to build apps using the CData JDBC Driver for Sage Intacct.

• Automated Continuous Autopilot Replication to SQLite

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

• Integrating Codex CLI with SAP BusinessObjects BI 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 Square in SpagoBI

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

• Build Dashboards with Zoho Recruit Data in DBxtra

  Create dynamic dashboards and perform analytics based on Zoho Recruit in DBxtra.

• Automated Continuous Amazon DynamoDB Replication to Amazon Redshift

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

• Publish Crystal Reports on PDFMonkey Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PDFMonkey.

• Automated Continuous Facebook Ads Replication to Azure SQL Database

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

• Query Parquet Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Parquet entities in PHP by modeling them as objects.

• Work with Spotify Data in FoxPro

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

• Access Qualaroo Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Qualaroo from your Oracle system.

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

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

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

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

• Use the CData Software JDBC Driver for Sendwithus in MicroStrategy Desktop

  Connect to Sendwithus in MicroStrategy Desktop using the CData Software JDBC Driver for Sendwithus.

• How to create HCL Domino federated tables in MySQL

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

• Integrating Codex CLI with Campaigner 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.

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

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

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

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

• How to connect to Aweber Data in DBVisualizer

  Integrate Aweber with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous Sybase IQ Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Sybase IQ replication to Apache Kafka.

• Connect to Azure Data Lake Storage Data in Jaspersoft Studio

  Execute SQL to remote Azure Data Lake Storage in Jaspersoft Studio.

• Working with SageHR Data in LINQPad

  Execute LINQ queries to SageHR in LINQPad.

• Work with Live Salesforce Pardot Data in Power Query

  Use CData Connect AI to connect to Salesforce Pardot and work with live Salesforce Pardot in Microsoft Power Query.

• Connect to Billsby from a Connection Pool in WebLogic

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

• DataBind FHIR Data to the DevExpress Data Grid

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

• Connect to Shopify Data in ACL Analytics

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

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

• How to Connect Flowise AI Agents to Live Google Analytics 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 Google Analytics without replication.

• Connect to Marketo Data in Aqua Data Studio

  Access Marketo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

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

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

• Query HubDB Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume HubDB entities in PHP by modeling them as objects.

• Use Biml to Build SSIS Tasks to Replicate ClickUp Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ClickUp to SQL Server.

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

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate Gmail actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Connect to Excel Online Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Microsoft Excel Online in Airbyte.

• Build an OLAP Cube in SSAS from Factorial Data

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

• Analyze Calendly Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Calendly in Microsoft R Open.

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

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

• Use Databricks Agent Bricks to Talk to Your Azure Table Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Table Storage for you.

• Replicate Placid Data from PowerShell

  Write a quick PowerShell script to query Placid. Use connectivity to the live data to replicate Placid to SQL Server.

• Visualize Live MailChimp Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live MailChimp into custom reports in Power BI.

• Access Live MySQL Data in TIBCO Data Virtualization

  Use the MySQL Tibco DV Adapter to create a MySQL data source in TIBCO Data Virtualization Studio and gain access to live MySQL from your TDV Server.

• Getting Started with the CData ODBC Driver for Gumroad

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

• Publish Zoom-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Zoom.

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

• Connect to Adobe Analytics Data in RazorSQL

  Connect to Adobe Analytics from wizards and query Adobe Analytics from the GUI in the RazorSQL database management tool.

• Build Apps with Live QuickBooks Time in Adalo using CData Connect AI

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

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

• Integrating Antigravity CLI with BenchmarkEmail via CData CLI

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

• «
• 1051
• 1052
• 1053
• 1054
• 1055
• 1056
• 1057
• 1058
• 1059
• 1060
• »