CData Software - Knowledge Base

Recent Articles

---

• «
• 175
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• »

• Excel Spreadsheet Automation on ZohoInvoice Data with the QUERY Formula

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

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

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

• Getting Started with the CData Python Connector for Oracle Eloqua Reporting

  Learn to install and license the CData Python Connector

• How to Easily Query Procore Data in OpenOffice Base

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

• How to Connect to Live SAP HANA Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP HANA through natural language.

• Trigger BigQuery IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for BigQuery with standard wizards in Logic Apps.

• Excel Spreadsheet Automation on ServiceDesk Plus Data with the QUERY Formula

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

• Automated Continuous RSS Replication to Snowflake

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

• Connecting Pipedream with Microsoft Dataverse Data 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 Microsoft Dataverse data in real time.

• How to Build an ETL App for Aweber Data in Python with CData

  Create ETL applications and real-time data pipelines for Aweber in Python with petl.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Brex to Power BI dashboards. Simply drag and drop Brex into data visuals on the Power BI canvas.

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

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

• Integrate ZohoDesk with External Services using SnapLogic

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

• Build Facebook Ads-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Facebook Ads Data from Zoho Analytics and import live Facebook Ads.

• Automated Continuous Yelp Replication to Google Cloud SQL

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

• Natively Connect to Google Forms Data in PHP

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

• Connect to SAP Ariba Source Data in RapidMiner

  Integrate SAP Ariba Source with standard components and data source configuration wizards in RapidMiner Studio.

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

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

• Enable the WooCommerce JDBC Driver in KNIME

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

• Use the CData ODBC Driver for Azure Synapse from SharePoint Excel Services

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

• Create Reports from SAP BusinessObjects BI Data in Looker Studio

  Use CData Connect AI to gain access to live SAP BusinessObjects BI and create custom reports in Looker Studio.

• Integrate Real-Time Access to Salesforce Data 360 in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Data 360 in real time.

• Connect to Quickbase Data in DBeaver

  Use the CData ODBC Driver to connect to Quickbase in DBeaver.

• Manage Pipeliner CRM Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Pipeliner CRM.

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

• How to Connect DBeaver to GitLab via a JDBC Driver

  Manage GitLab with visual tools in DBeaver like the query browser.

• Use Grok to Talk to Your Google Calendar Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Calendar for you.

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

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

• Access Live SharePoint Data in Coginiti Pro

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

• Integrating Certinia Data in Talend Cloud Data Management Platform

  Connect Certinia Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Certinia.

• Automate Kafka Data Replication to Azure Synapse

  Use CData Sync to customize and automate Apache Kafka replication to Azure Synapse.

• Connect Beeminder to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Beeminder using the CData Python MCP Server.

• Access SAP Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP ERP/NetWeaver from your Oracle system.

• Connect to Sage Cloud Accounting Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Sage Business Cloud Accounting from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Cloud Accounting.

• Getting Started with the CData JDBC Driver for Brex

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

• DataBind Dynamics 365 Data to the DevExpress Data Grid

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

• Create Datasets from Google Drive in Domo Workbench and Build Visualizations of Google Drive Data in Domo

  Use the CData Software ODBC Driver for Google Drive to create datasets from Google Drive in Domo Workbench and then build visualizations in the Domo service.

• DataBind Controls to Mailgun Data in C++Builder

  DataBind to Mailgun in C++Builder with standard components and controls.

• Connect to Salesforce CRM Analytics from Asprova with CData Software ODBC Driver for Salesforce CRM Analytics

  This article shows how to connect faster to Salesforce CRM Analytics data from Asprova.

• Create Wrike Dataflows on PowerBI.com

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

• Connect to Google Ads Data from PowerBuilder via ODBC

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

• How to Access Data from a SharePoint List Based on a Custom View

  We use Server Explorer in Visual Studio to show how the CData provider data model exposes custom views of SharePoint lists.

• Process & Analyze Google Contacts Data in Databricks (AWS)

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

• Automated Continuous CockroachDB Replication to Amazon S3

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

• Integrate Aha! with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Aha! with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Aha!.

• How to connect SharePoint with Humanity Data through external lists

  Provide Humanity to SharePoint users as an external list.

• How to create Box federated tables in MySQL

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

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

  Provide connectivity to Aha! through an SAP BusinessObjects universe.

• Use JayDeBeApi to access EmailOctopus Data in Python

  Use standard Python scripting and the development environment of your choice to access live EmailOctopus.

• Integrate CircleCI with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate CircleCI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CircleCI.

• Extract, Transform, and Load Mocean Data in Informatica PowerCenter

  Create a simple Workflow for Mocean in Informatica PowerCenter.

• Connect to Workable Data in HULFT Integrate

  Connect to Workable as a JDBC data source in HULFT Integrate

• Automated Continuous CSV Replication to SingleStore

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

• Import and Visualize Codat Data in Power View

  Create data visualizations based on Codat in Excel.

• Integrate with live BigCommerce Data in Jitterbit

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

• Build Google Sheets-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Google Spreadsheets to explore live Google Sheets Data in Claude Code to assist with building Google Sheets-powered applications.

• Connect to Gorgias Data from a Connection Pool in JBoss

  Integrate Gorgias into Java servlets: Use the Management Console in JBoss to install the Gorgias JDBC Driver.

• DB2 Reporting in OBIEE with the DB2 JDBC Driver

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

• Create a Data Access Object for Cloudant Data using JDBI

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

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

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

• Model Cosmos DB Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cosmos DB, enabling the direct import of real-time Azure Cosmos DB.

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

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

• Build Dashboards with Oracle HCM Cloud Data in DBxtra

  Create dynamic dashboards and perform analytics based on Oracle HCM Cloud in DBxtra.

• Use the CData API Server to Access SAP HANA XS Advanced Data in Microsoft PowerPivot

  Use the CData API Server to connect to live SAP HANA XS Advanced in the Power Pivot business intelligence tool.

• How to Query Live Spark Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Apache Spark SQL data in natural language using Python.

• How to connect to HelloSign Data from Spring Boot

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

• Visualize Cosmos DB Data in Sisense

  Create an ElastiCube in Sisense app with access to Azure Cosmos DB.

• Edit and Search Spotify External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Spotify to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Spotify objects that you can access from apps and the dashboard.

• Build Dashboards with Azure Data Catalog Data in DBxtra

  Create dynamic dashboards and perform analytics based on Azure Data Catalog in DBxtra.

• Connecting Mastra with CSV 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 CSV/TSV Files, no replication required.

• Connect to LaunchDarkly Data in RazorSQL

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

• Automate Exa Data Replication to Couchbase

  Use CData Sync to Customize and automate Exa replication to Couchbase.

• Integrate DocuSign with External Services using SnapLogic

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

• Connect to Google Ads Data in Ruby

  Connect to Google Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to connect to eBay Data in DBVisualizer

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

• Automate Instagram Data Replication to Azure Data Lake

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

• Access Live EnterpriseDB Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live EnterpriseDB from your Google Sheets.

• Connect to Oracle SCM Data in Jaspersoft Studio

  Execute SQL to remote Oracle SCM in Jaspersoft Studio.

• How to Seamlessly Import ZendeskSell Data into IBM SPSS Modeler

  Integrate ZendeskSell data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

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

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

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

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

• Connect to Google Search from Excel & GoogleSheets!

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

• How to Easily Query Salesloft Data in OpenOffice Base

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

• Automated Continuous Amazon S3 Replication to Snowflake

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

• Process & Analyze Microsoft Ads Data in Databricks (AWS)

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

• Access SendGrid Data from MySQL in HeidiSQL

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

• Integrate with Authorize.Net Data in JReport Designer

  Create charts and reports based on Authorize.Net in JReport Designer.

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

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

• Visualize VWO Data from Tableau

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

• Import Basecamp Data Using Azure Data Factory

  Use CData Connect AI to connect to Basecamp Data from Azure Data Factory and import live Basecamp.

• Natively Connect to Cloudflare Data in PHP

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

• A PostgreSQL Interface for Autopilot Data using the CData ODBC Driver

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

• Use Agno to Talk to Your Highrise 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 Highrise CRM for you.

• Explore Geographical Relationships in Box Data with Power Map

  Create data visualizations with Box in Power Map.

• Query Coda Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Coda and perform CRUD operations on Coda from Node.js.

• Natively Connect to Monday.com Data in PHP

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

• Connect to ZohoSubscriptions Data as an External Source in Dremio

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

• Build Apps with Live Facebook Ads in Adalo using CData Connect AI

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

• Build Trello-Powered Applications in Cursor with CData MCP Server

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

• Query Zendesk Data through ODBC in Node.js

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

• «
• 175
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• »