CData Software - Knowledge Base

Recent Articles

---

• «
• 318
• 319
• 320
• 321
• 322
• 323
• 324
• 325
• 326
• 327
• »

• Use the CData Software JDBC Driver for Google Sheets in MicroStrategy Web

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

• Work with Mocean Data in FoxPro

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

• Getting Started with the CData Excel Add-In for Wistia

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

• LINQ to QuickBooks Online 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 QuickBooks Online Data Provider.

• How to publish and share Mouseflow Data dashboards with Tableau Server

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

• Analyze Amazon Marketplace Data in R via ODBC

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

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

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

• Migrating data from Act-On to Google BigQuery using CData SSIS Components.

  Easily push Act-On to Google BigQuery using the CData SSIS Tasks for Act-On and Google BigQuery.

• Automated Continuous Salesforce Pardot Replication to SQL Server

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

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

  Use CData Power BI Connectors to visualize Spotify in Power BI.

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

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

  Execute SQL Server queries against eBay from Node.js.

• A PostgreSQL Interface for Stack Exchange Data using the CData ODBC Driver

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

• Import Real-Time ZohoExpense Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use ZohoExpense in ColdFusion.

• Use Agno to Talk to Your Amazon DynamoDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Amazon DynamoDB for you.

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

• Building Dynamic Web Pages with QuickBooks Time Data Using AngularJS

  Create single-page applications with live connectivity to QuickBooks Time using the CData API Server.

• Build MVC Applications with Connectivity to Email Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Email from an ASP.NET MVC application.

• Analyze Hive Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Apache Hive and visualize live Apache Hive in Infragistics Reveal.

• How to Easily Query Browserless Data in OpenOffice Base

  Connect to Browserless data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• Build Dashboards with Act-On Data in DBxtra

  Create dynamic dashboards and perform analytics based on Act-On in DBxtra.

• Access SAS xpt Data from MySQL in HeidiSQL

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

• DataBind SAP SuccessFactors Data to the DevExpress Data Grid

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

• Migrating data from Quaderno to Google BigQuery using CData SSIS Components.

  Easily push Quaderno to Google BigQuery using the CData SSIS Tasks for Quaderno and Google BigQuery.

• Connect to Exact Online Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Exact Online from Filemaker Pro on Mac.

• Work with ShipEngine Data in FoxPro

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

• Create Dynamic Printify Grids Using the Infragistics XamDataGrid

  Learn how you can connect Printify to Infragistics XamDataGrid to build dynamic grids.

• Build Data Flows from SQL Server to Greenplum through SSIS

  Easily push SQL Server data to Greenplum using the CData SSIS Tasks for Greenplum.

• Design BIRT Reports on Highrise Data

  Provide current Highrise CRM to your embedded analytics.

• How to Access Live Paylocity Data in Visual Studio Code via Cline

  Run CData MCP Server for Paylocity on Windows Subsytem for Linux (WSL) and connect to live Paylocity from the Cline extension in Visual Studio Code.

• Automated Continuous OneNote Data Replication to OneLake in Microsoft Fabric

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

• Build SurveyMonkey Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live SurveyMonkey and build visualizations in Tableau.

• Create Reports from NetSuite Data in Looker Studio

  Use CData Connect AI to gain access to live NetSuite CRM & ERP and create custom reports in Looker Studio.

• How to connect to HubDB Data from Spring Boot

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

• Getting Started with the CData Power BI Connector for Teamgate

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

• Access Tanda Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Tanda.

• Query Elasticsearch Data through ODBC in Node.js

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

• DataBind Charts to SAP Ariba Source Data

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

• Back Up Oracle Service Cloud to SQL Server through SSIS

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

• Explore Geographical Relationships in ZohoPeople Data with Power Map

  Create data visualizations with ZohoPeople in Power Map.

• Access LeadDesk Data from MySQL in PHP

  Connect to LeadDesk through the standard MySQL libraries in PHP.

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

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

• Build Dashboards with SAP Business One Data in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Business One in DBxtra.

• Connect to and Visualize Live Avalara AvaTax Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avalara AvaTax.

• Connect to LaunchDarkly Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for LaunchDarkly and the SQL Gateway to access LaunchDarkly from Google Apps Script.

• Connect to QuickBooks Time Data in NetBeans

  Connect to QuickBooks Time in NetBeans with the data source configuration wizard.

• Replicate ADP Data in Heroku for Use in Salesforce Connect

  Replicate ADP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

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

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

• How to import ShipEngine Data into Apache Solr

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

• Visualize ServiceDesk Plus Data in Tableau

  The CData ODBC driver for ServiceDesk Plus enables you integrate ServiceDesk Plus into Tableau dashboards.

• Getting Started with the CData JDBC Driver for Basecamp

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Basecamp.

• Integrating LlamaIndex with OneNote Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft OneNote in real time.

• Create Dashboards and Visualize Live Salesforce Marketing Data in Geckoboard

  Use CData Connect AI to connect to live Salesforce Marketing Cloud and create dashboards for real-time monitoring and visualization in Geckoboard.

• Bridge Aircall Connectivity with Apache NiFi

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

• Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through OData

  Integrate SAP Netweaver Gateway into dashboards in TIBCO Spotfire.

• Create SSAS Tabular Models from AgileCRM Data

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

• Build Semantic Layer Views for Azure Analysis Services Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services.

• Prepare, Blend, and Analyze Excel Data in Alteryx Designer (ODBC)

  Build workflows to access live Microsoft Excel for self-service data analytics.

• Automated Continuous Clari Replication to MySQL

  Use CData Sync for automated, continuous, customizable Clari replication to MySQL.

• Use Databricks Agent Bricks to Talk to Your SAP BusinessObjects BI Data via CData Connect AI

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

• Analyze API Data in Cognos Analytics

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

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

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

  Use CData Connect AI to connect to live Microsoft SQL Server in the Power Pivot business intelligence tool.

• Viewing Trello Data in RAD Studio Data Explorer

  How to view Trello in RAD Studio Data Explorer using the CData ODBC Driver for Trello.

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

• Getting Started with the CData JDBC Driver for SendGrid

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendGrid.

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

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

• Integrating GitHub Copilot CLI with Optimizely 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.

• Getting Started with the CData Tableau Connector for ElevenLabs

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

• Visualize Excel Online Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel Online.

• Connecting Pipedream with OData Services via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on OData data in real time.

• Connecting Mastra with Google Cloud Storage 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 Google Cloud Storage, no replication required.

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

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

• Stream Excel Data into Apache Kafka Topics

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

• Automated Continuous Microsoft Teams Replication to SingleStore

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

• Visualize MailChimp Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to MailChimp.

• Connect to ZendeskSell Data in RazorSQL

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

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

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

• Integrating OpenCode Terminal with SAP Business Warehouse 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 Query Live Access Data in Perplexity MacOS Desktop

  Connect to and query live Access Data in Perplexity Desktop using CData MCP Server.

• Automated Continuous Tanda Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Tanda replication to Apache Cassandra.

• Getting Started with the CData Python Connector for JobNimbus

  Learn to install and license the CData Python Connector

• Working with Pinecone Data in LINQPad

  Execute LINQ queries to Pinecone in LINQPad.

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

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

• Automated Continuous DocuSign Replication to Amazon S3

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

• Integrate REST Data in Your Informatica Cloud Instance

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

• How to update MailChimp from Excel

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

• Visualize Live Highrise Data in Tableau

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

• Analyze AlloyDB Data in Cognos Analytics

  Use CData Connect AI to connect to AlloyDB Data from Cognos Analytics and analyze live Google AlloyDB.

• Analyze Klaviyo Data in SAP Analytics Cloud

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

• Build an OLAP Cube in SSAS from Printful Data

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

• Automated Continuous Discord Replication to PostgreSQL

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

• Build AI/ML Models with Live Sage Intacct Data using Dataiku

  Connect Sage Intacct Data with Dataiku using the CData JDBC Driver for Sage Intacct.

• Visualize Vault CRM Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Veeva Vault & Vault CRM.

• DataBind Charts to Foursquare Data

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

• Build Cassandra Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Apache Cassandra and build visualizations in Tableau Cloud.

• Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy Desktop

  Connect to SAP Hybris C4C in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Hybris C4C.

• Build Facebook-Connected ETL Processes in Google Data Fusion

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

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

  Execute MySQL queries against Nuclia from Node.js.

• Connect to Exact Online Data from Blazor Apps

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

• «
• 318
• 319
• 320
• 321
• 322
• 323
• 324
• 325
• 326
• 327
• »