CData Software - Knowledge Base

Recent Articles

---

• «
• 563
• 564
• 565
• 566
• 567
• 568
• 569
• 570
• 571
• 572
• »

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

  Use CData Connect AI to gain access to live Xero Accounting from your Excel spreadsheets.

• Build Visualizations of Samanage Data in Birst

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

• How to connect to SAP Business Warehouse Data with Squirrel SQL client

  Connect to SAP Business Warehouse and execute queries in the Squirrel SQL Client.

• How to Access Live WooCommerce Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for WooCommerce enables you to integrate WooCommerce into workflows built using Microsoft Power Automate Desktop.

• DataBind Charts to SQL Analysis Services Data

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

• Access Live SAS xpt Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAS XPORT through MCP integration.

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

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

• Use Grok to Talk to Your SurveyMonkey 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 SurveyMonkey for you.

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

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

• Demio Reporting in OBIEE with the Demio JDBC Driver

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

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

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

• Connecting GenSpark with Amazon Marketplace Data via CData Connect AI MCP Server

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

• Access Beeminder Data from MySQL in PHP

  Connect to Beeminder through the standard MySQL libraries in PHP.

• Connect to Google Drive Data in NetBeans

  Connect to Google Drive in NetBeans with the data source configuration wizard.

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

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

• Connect to Sybase IQ Data in Jaspersoft Studio

  Execute SQL to remote Sybase IQ in Jaspersoft Studio.

• Access Live SAP Fieldglass Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate SAP Fieldglass into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Fieldglass in the Graph Builder and Query Builder.

• Access Live Exact Online Data in Tableau with CData API Server

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

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

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

• How to integrate Salesforce Pardot with Apache Airflow

  Access and process Salesforce Pardot in Apache Airflow using the CData JDBC Driver.

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

• Connecting GenSpark with Facebook Data via CData Connect AI MCP Server

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

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

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

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

• Import Real-Time Invoiced Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Invoiced in ColdFusion.

• Connect to Act-On Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Act-On from Appeon PowerBuilder using the CData ADO.NET Provider for Act-On.

• Query SFTP Data through ODBC in Node.js

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

• Access Live Wave Financial Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Wave Financial into the statistical analysis tools available in SAS JMP. This article shows how to use Wave Financial in the Graph Builder and Query Builder.

• Access Live HDFS Data in Coginiti Pro

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

• Bidirectional Access to Highrise Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Highrise CRM in Filemaker Pro for Mac or Windows.

• Integrating LlamaIndex with Okta Data via CData Connect AI

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

• Use Dash to Build to Web Apps on Gorgias Data

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

• Getting Started with the CData Connect AI Python SDK for Exact Online

  Install the CData Connect AI Python SDK to read and write live Exact Online with standard DB-API 2.0 Python code.

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

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

• Build Visualizations of Email Data in Birst

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

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

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

• Create Google Forms Dataflows on PowerBI.com

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

• Automated Continuous SAP Fieldglass Replication to SQLite

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

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

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

• Build Visualizations of MailerLite Data in Birst

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

• Visualize Live Zoho CRM Data in the Power BI Service

  Use CData Connect AI to connect to live Zoho CRM and create custom reports in the Power BI Service through the On-Premises Gateway.

• Getting Started with the CData ADO.NET Provider for Phoenix

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Phoenix.

• Getting Started with the CData SSIS Components for Pinterest

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

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

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

• How to Work with Float Data in ETL Validator JDBC

  Connect to Float from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Codat Data from a Connection Pool in Jetty

  The Codat JDBC Driver supports connection pooling: This article shows how to connect faster to Codat from Web apps in Jetty.

• Automate Aweber Data Replication to Azure Synapse

  Use CData Sync to customize and automate Aweber replication to Azure Synapse.

• Easily Integrate LinkedIn Data in Lazarus Pascal IDE

  Learn how to easily integrate live LinkedIn in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Continuous HDFS Replication to Apache Cassandra

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

• Connect to and Query SharePoint Excel Services Data in QlikView over ODBC

  Create data visualizations with SharePoint Excel Services in QlikView.

• Connect to Authorize.Net Data in Jaspersoft Studio

  Execute SQL to remote Authorize.Net in Jaspersoft Studio.

• Connect to SageHR Data in JRuby

  Create a simple JRuby app with access to live SageHR.

• Visualize ZarMoney Data from Tableau

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

• Connect to JSON Services as an External Source in Dremio

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

• Automated Continuous Airtable Replication to Apache Kafka

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

• Create Informatica Mappings From/To an ODBC Data Source for Zoho Inventory

  Create an ODBC connection to Zoho Inventory in Informatica and browse and transfer Zoho Inventory.

• Connect to NASA Data in DBeaver

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

• Connecting GenSpark with Google Contacts Data via CData Connect AI MCP Server

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

• Connect to Outreach.io from a Connection Pool in WebLogic

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

• Replicate Clari Data to Multiple Databases via the CData Sync CLI

  Replicate Clari to disparate databases with a single configuration.

• Integrate LibreChat with Live Google Calendar Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Calendar from within the chat interface.

• Getting Started with the CData JDBC Driver for ZohoInvoice

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

• Extend Google Sheets with WordPress Data

  Make calls to WordPress from Google Apps Script via the API Server.

• How to load CircleCI data into Elasticsearch via Logstash

  Introducing a simple method to load CircleCI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Use Manus AI to Talk to Your Salesforce CRM Analytics Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Salesforce CRM Analytics.

• Analyze Amazon Athena Data in Infragistics Reveal

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

• How to Connect to Live Certinia 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 Certinia through natural language.

• How to connect and process Notion from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Notion.

• Create SAP HANA Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP HANA data access from reports, embedded analytics, and more.

• Build Workday-Connected Apps in Choreo

  Use CData Connect AI to connect to Workday Data from Choreo and build custom apps using live Workday.

• Work with Trello Data in FoxPro

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

• Design BIRT Reports on QuickBooks Time Data

  Provide current QuickBooks Time to your embedded analytics.

• Automated Continuous OnePageCrm Replication to SingleStore

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

• Query LinkedIn Data in ColdFusion

  Write standard ColdFusion data access code to connect to LinkedIn.

• Automated Continuous Clari Replication to Databricks

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

• Automated Continuous Microsoft Exchange Replication to SingleStore

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

• Create a Data Access Object for Bright Data Data using JDBI

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

• Automated Continuous Moosend Replication to Local Delimited Files

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

• Model, Search, and Visualize Live BambooHR Data in ThoughtSpot

  Use CData Connect AI to connect to live BambooHR for modeling, searching, and visualizing.

• Connect to SAS xpt Data in RazorSQL

  Connect to SAS xpt from wizards and query SAS XPORT from the GUI in the RazorSQL database management tool.

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

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

• Getting Started with the CData Power BI Connector for Clockify

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

• Enable the RSS JDBC Driver in KNIME

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

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

• Easily Integrate Exa Data in Lazarus Pascal IDE

  Learn how to easily integrate live Exa in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• How to Connect to Live Acumatica 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 Acumatica ERP through natural language.

• Analyze ServiceNow Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze ServiceNow with the CData JDBC Driver for ServiceNow.

• Integrating OpenCode Terminal with Teamwork 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 Connect the Power BI Service to Contentful: Complete Guide

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

• Use JayDeBeApi to access ZarMoney Data in Python

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

• Analyze Live Jira Assets Data in SAS Viya

  Use CData Connect AI to connect to Jira Assets from SAS Viya and deploy self-service analytics using live Jira Assets.

• How to connect to Reckon Data with Squirrel SQL client

  Connect to Reckon and execute queries in the Squirrel SQL Client.

• Validate eBay Data with QuerySurge

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

• Publish Crystal Reports on Chargebee Data

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

• Integrate with TaxJar Data using Apache Camel2

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

• Automated Continuous MessageBird Replication to Vertica

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

• Connect to Presto Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Presto from Crystal Reports.

• Migrating data from Elasticsearch to Databricks using CData SSIS Components.

  Easily push Elasticsearch to Databricks using the CData SSIS Tasks for Elasticsearch and Databricks.

• Getting Started with the CData ADO.NET Provider for SAP

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP.

• Query, Visualize, and Share live Asana Data in Redash

  Use CData Connect AI to connect to live Asana in Redash for querying, visualizing, and sharing.

• «
• 563
• 564
• 565
• 566
• 567
• 568
• 569
• 570
• 571
• 572
• »