CData Software - Knowledge Base

Recent Articles

---

• «
• 692
• 693
• 694
• 695
• 696
• 697
• 698
• 699
• 700
• 701
• »

• Access Live Cosmos DB Data in Excel 365 Online (Excel for the web)

  Connect to Cosmos DB data from Excel 365 Online (Excel for the web) with CData Connect AI.

• Integrate Google Sheets Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Google Sheets data and integrate live Google Sheets data into your Power Automate tasks.

• Create SAP HANA-Connected Visualizations in Klipfolio

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

• Automated Continuous Zoho CRM Replication to SQL Server

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

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

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

• Connect to Printful Data in Ruby

  Connect to Printful data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Analyze Sybase Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Sybase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Automate Opsgenie Data Replication to Azure Data Lake

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

• Connect to and Query SendPulse Data in QlikView over ODBC

  Create data visualizations with SendPulse data in QlikView.

• Create a Data Access Object for Mistral AI Data using JDBI

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

• Publish Crystal Reports on Impala Data

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

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

• Create Apps from Sage 200 Data in Qlik Sense Cloud

  Use CData Connect AI to connect to Sage 200 Data and build apps from live Sage 200 data in Qlik Sense Cloud.

• Work with Mixpanel Data in FoxPro

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

• Extract, Transform, and Load SAP SuccessFactors Data in Informatica PowerCenter

  Create a simple Workflow for SAP SuccessFactors data in Informatica PowerCenter.

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

• Integrating Antigravity CLI with Oracle Eloqua Reporting data via CData CLI

  Connect Oracle Eloqua Reporting data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Publish SuiteCRM-Connected Dashboards in Tableau Server via JDBC

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

• How to connect to SAS xpt Data in DBVisualizer

  Integrate SAS xpt data with visual data analysis tools and data connection wizards in DBVisualizer

• Choosing the Best Method to Connect Excel to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Excel data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Build Salesforce Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Salesforce data and build visualizations in Tableau Cloud.

• Integrating Cursor with Wistia 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.

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

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

• Integrate OpenCode with Live Excel Online Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Excel Online data from within your AI coding agent.

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

  Connect to Google Sheets data from a connection pool in Tomcat.

• Publish Crystal Reports on Marketo Data

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

• Integrate with Okta Data using Apache Camel2

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

• Analyze Power BI XMLA Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Power BI XMLA data and visualize Power BI XMLA data in SAP Analytics Cloud.

• Manage Wave Financial Data in DBArtisan as a JDBC Source

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

• Connect to SQL Analysis Services Data in NetBeans

  Connect to SQL Analysis Services data in NetBeans with the data source configuration wizard.

• Create Oracle SCM Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Oracle SCM from PowerBI.com to create Power BI Dataflows with real-time data.

• Visualize HBase Data in TIBCO Spotfire through ADO.NET

  Integrate HBase data into dashboards in TIBCO Spotfire.

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

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

• Process & Analyze Discord Data in Databricks (AWS)

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

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

• Integrate Dify with Live Neo4J Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Neo4J data.

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

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

• Automated Continuous Zendesk Replication to SQLite

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

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

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

• How to connect to Salesloft Data from Spring Boot

  Connect to Salesloft in a Spring Boot Application using the CData JDBC Driver for Salesloft

• Access Cvent Data from MySQL in PHP

  Connect to Cvent through the standard MySQL libraries in PHP.

• Replicate Multiple Authorize.Net Accounts

  Replicate multiple Authorize.Net accounts to one or many databases.

• Access Live Jira Data in AWS Lambda

  Connect to live Jira data in AWS Lambda using the CData JDBC Driver.

• Integrate PagerDuty Data in the Pentaho Report Designer

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

• Import Zuora Data into the Power BI Service for Visualizations

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

• Automated Continuous Oracle Eloqua Replication to PostgreSQL

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

• Integrating Antigravity CLI with Clockify data via CData CLI

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

• Provide OData Services of Float Data from a WCF Application

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

• Integrating Claude Code with Dynamics 365 Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Dynamics 365 data within assisted coding and automated development workflows.

• Create Power BI Reports on Real-Time Rootly Data

  Use the CData ODBC Driver for Rootly to visualize Rootly data in Power BI Desktop.

• Connect to Anaplan Data from Blazor Apps

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

• Build SAP Concur Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live SAP Concur data and build visualizations in Tableau.

• How to use SQLAlchemy ORM to access LDAP Objects in Python

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

• Natively Connect to SAP Data in PHP

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

• Process & Analyze MariaDB Data in Databricks (AWS)

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

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

• Integrate with Kafka Data using Apache Camel2

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

• Access MongoDB Data from MySQL in PHP

  Connect to MongoDB through the standard MySQL libraries in PHP.

• Use Microsoft Copilot Studio to talk to your Google Campaign Manager 360 Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Campaign Manager 360 data for you.

• Design BIRT Reports on Tanda Data

  Provide current Tanda data to your embedded analytics.

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

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

• Create Reports with SpaceX Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SpaceX data.

• Create Data Visualizations Based On Google Forms Data in Mode

  Use CData Connect AI to connect to Google Forms Data from Mode and build visualizations using live Google Forms data.

• Bridge SQL Server Connectivity with Apache NiFi

  Access and process SQL Server data in Apache NiFi using the CData JDBC Driver.

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

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

• Build a Simple VCL Application for SAP BusinessObjects BI Data

  How to build a simple VCL Application to view SAP BusinessObjects BI data in RAD Studio using the CData ODBC Driver for SAP BusinessObjects BI.

• Build Voice Agents in ElevenLabs with access to Live Azure DevOps Data

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

• Operational Reporting on Autopilot Data from Spotfire Server

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

• Add LDAP Objects to Informatica Enterprise Data Catalog

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

• Connect to SAP Hybris C4C Data in DBArtisan

  Use wizards in DBArtisan to configure SAP Hybris C4C data as a data source.

• Connect to YouTube Analytics from a Connection Pool in WebLogic

  Use the CData JDBC Driver for YouTube Analytics to connect to YouTube Analytics data from Web applications running on WebLogic.

• Back Up Snowflake data to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Snowflake. In this article, we will employ an SSIS workflow to populate a database with Snowflake data data.

• Use Claude to Talk to Your Microsoft Ads Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Ads data for you.

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

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

• Connect to Live Microsoft Exchange Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to Microsoft Exchange in CData Connect AI and connect to your Microsoft Exchange data from PostgreSQL.

• Replicate Dotmailer Data from PowerShell

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

• How to import JSON Services into Apache Solr

  Use the CData Software JDBC Driver for JSON in Data Import Handler and create an automated import of JSON services to Apache Solr Enterprise Search platform.

• Use CData Connect AI to Access Discord Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Discord data in the Power Pivot business intelligence tool.

• Visualize Live CampaignMonitor Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live CampaignMonitor data.

• Visualize SAP Business One Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SAP Business One data.

• Create Data Visualizations in Cognos BI with ConvertKit Data

  Access ConvertKit data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to Jira Data in the Denodo Platform

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

• Integrate Real-Time Access to Sage Cloud Accounting in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage Cloud Accounting data in real time.

• Automated Continuous Airtable Replication to Local Delimited Files

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

• Integrate SendGrid Data in Pentaho Data Integration

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

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

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

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

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

• Analyze Freshteam Data with Power Pivot

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

• Connect to Workday Data in NetBeans

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

• Integrate Real-Time Access to Oracle HCM Cloud in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle HCM Cloud data in real time.

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

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

• Connecting GenSpark with Dynamics NAV Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dynamics NAV data without any replication or custom integration required.

• Connect to and Query Zoom Data in QlikView over ODBC

  Create data visualizations with Zoom data in QlikView.

• Bridge Intercom Connectivity with Apache NiFi

  Access and process Intercom data in Apache NiFi using the CData JDBC Driver.

• How to Create Power BI Visual Reports with Real-Time SAP Netweaver Gateway Data

  Use CData Power BI Connectors to visualize SAP Netweaver Gateway data in Power BI.

• Automated Continuous HBase Replication to Amazon S3

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

• Build a PostgreSQL Interface for Google Directory Data using the CData JDBC Driver

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

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

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

• Build Visualizations of Stripe Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Stripe data in Birst.

• Connecting Mastra with PingOne 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 PingOne data, no replication required.

• «
• 692
• 693
• 694
• 695
• 696
• 697
• 698
• 699
• 700
• 701
• »