CData Software - Knowledge Base

Recent Articles

---

• «
• 100
• 101
• 102
• 103
• 104
• 105
• 106
• 107
• 108
• 109
• »

• Prepare, Blend, and Analyze API Data in Alteryx Designer (Connect AI)

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

• Getting Started with the CData Tableau Connector for ConvertAPI

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

• Connect to Zoho Recruit Data in CloverDX (formerly CloverETL)

  Transfer Zoho Recruit using the visual workflow in the CloverDX data integration tool.

• Connect and Visualize Live Odoo Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Odoo ERP into the Databricks platform and create visualization dashboards with real-time Odoo ERP.

• Automated Continuous IBM Informix Replication to PostgreSQL

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

• Automate Invoiced Data Replication to SAP HANA

  Use CData Sync to customize and automate Invoiced replication to SAP HANA.

• Connect to Tally Data in RazorSQL

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

• Build BigCommerce-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for BigCommerce Data and create custom apps in Mendix.

• Connect to Factorial Data from PowerBuilder via JDBC

  This article demonstrates how to access Factorial from PowerBuilder using the Factorial JDBC Driver.

• Viewing Reckon Accounts Hosted Data in RAD Studio Data Explorer

  How to view Reckon Accounts Hosted in RAD Studio Data Explorer using the CData ODBC Driver for Reckon Accounts Hosted.

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

  Execute MySQL queries against Freshservice from Node.js.

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

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

• Integrate Databricks with JetBrains RubyMine using CData JDBC Drivers

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

• Automated Continuous Authorize.Net Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Authorize.Net replication to IBM DB2.

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

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

  Create an ODBC connection to ScrapingBee in Informatica and browse and transfer ScrapingBee.

• Excel Spreadsheet Automation on Pingdom Data with the QUERY Formula

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

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

  Provide connectivity to Eventbrite through an SAP BusinessObjects universe.

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

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

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

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

• Visualize Raisers Edge NXT Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Raisers Edge NXT.

• Connect to Google Analytics in SpagoBI

  Create reports featuring live Google Analytics in SpagoBI Studio. Host Google Analytics reports on SpagoBI Server.

• Consume PhantomBuster OData Feeds in SAP Lumira

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

• Build Adobe Commerce-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Mendix.

• Create Exact Online Reports on JasperReports Server

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

• Connect to CockroachDB Data in Aqua Data Studio

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

• How to Visualize Simplesat Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Simplesat in Python.

• Query PabblySubscriptions Data using the OData SDK for PHP

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

• Visualize SQL Server Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Microsoft SQL Server.

• Publish Crystal Reports on Oracle HCM Cloud Data

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

• How to create an RPA flow for Humanity Data in UiPath Studio

  Use the Humanity ODBC Driver to create workflows that access real-time Humanity without any coding.

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

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

• How to Connect DBeaver to Cloudant via a JDBC Driver

  Manage IBM Cloudant with visual tools in DBeaver like the query browser.

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

• Automated Continuous Dynamics 365 Replication to SingleStore

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

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

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

• Automate Zoho Inventory Data Replication to Azure Synapse

  Use CData Sync to customize and automate Zoho Inventory replication to Azure Synapse.

• Extract, Transform, and Load Microsoft Exchange Data in Informatica PowerCenter

  Create a simple Workflow for Microsoft Exchange in Informatica PowerCenter.

• Automated Continuous SAP BusinessObjects BI Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon Redshift.

• Automated Continuous Mailjet Replication to Local Delimited Files

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

• Analyze Smartsheet Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Smartsheet and visualize live Smartsheet in Infragistics Reveal.

• Bridge Microsoft Entra ID Connectivity with Apache NiFi

  Access and process Microsoft Entra ID in Apache NiFi using the CData JDBC Driver.

• How to connect to MySQL Data from Spring Boot

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

• Sybase Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Sybase facts in real time.

• Import PabblySubscriptions Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access PabblySubscriptions. In this article, you will use the OData format to import PabblySubscriptions into Microsoft Power Query.

• Deploy the ADO.NET Provider for Exact Online on an SSRS Report Server

  Connect to Exact Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Publish Todoist-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Todoist.

• WooCommerce Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to WooCommerce through CData Connect AI using different applications and tools.

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

  Use LlamaIndex to query live HubDB data in natural language using Python.

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

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

• Connect to Harvest from a Connection Pool in WebLogic

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

• Access Live Facebook Data in Google Sheets through Connect Spreadsheets

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

• Model HCL Domino Data Using Azure Analysis Services

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

• How to integrate Metabase with Google Cloud Storage Data

  Use CData Connect AI to connect to live Google Cloud Storage and create an interactive dashboard in Metabase from Google Cloud Storage.

• Integrate Teradata Data in Your Informatica Cloud Instance

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

• Google Calendar Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Calendar through CData Connect AI using different applications and tools.

• Automated Continuous Zoho Creator Replication to Apache Kafka

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

• Back Up Twitter Ads to SQL Server through SSIS

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

• Integrate Azure Table Data in the Pentaho Report Designer

  Publish reports based on Azure Table Storage in the Pentaho BI tool.

• How to Design SAP SuccessFactors Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to SAP SuccessFactors from mobile and tablet Power Apps.

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

• Query Todoist Data in ColdFusion

  Write standard ColdFusion data access code to connect to Todoist.

• DataBind Charts to Shortcut Data

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

• Connect to Quickbase Data in ACL Analytics

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

• Connect to xBase Data in DBArtisan

  Use wizards in DBArtisan to configure xBase as a data source.

• Back Up Sendwithus to SQL Server through SSIS

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

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

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

• How to create ConstantContact federated tables in MySQL

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

• How to Work with Sentry Data in ETL Validator JDBC

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

• DataBind Controls to Hugging Face Data in Delphi

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

• Getting Started with the CData ODBC Driver for Amazon Athena

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

• Automated Continuous Klipfolio Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Klipfolio replication to Google BigQuery.

• Build Charts with Ontraport Data in Clear Analytics

  Create dynamic charts and perform analytics based on Ontraport in Clear Analytics.

• Extend Google Sheets with CloudConvert Data

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

• Integrate with SFTP Data using Apache Camel2

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

• Access Close Data from MySQL in Amazon QuickSight

  Connect to Close and build visualizations of Close using a MySQL Connection in Amazon QuickSight.

• Create Data Visualizations Based On Dynamics CRM Data in Mode

  Use CData Connect AI to connect to Dynamics CRM Data from Mode and build visualizations using live

• ETL PabblySubscriptions in Oracle Data Integrator

  This article shows how to transfer PabblySubscriptions into a data warehouse using Oracle Data Integrator.

• Connect to Nuclia Data in RapidMiner

  Integrate Nuclia with standard components and data source configuration wizards in RapidMiner Studio.

• Work with Live DocuSign Data in Power Query

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

• Query Close Data from Node.js

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

• Build Certinia-Connected Dashboards Using Zoho Analytics

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

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

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

• Use the CData API Server in Microsoft Power BI

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

• Access Live CSV Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live CSV/TSV Files from your Google Sheets.

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

• Connect to Quaderno Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Quaderno from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Automated Continuous Zoom Replication to SQLite

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

• Consume JobNimbus OData Feeds in PowerBuilder

  This article demonstrates how to consume JobNimbus as OData feeds from PowerBuilder using the API Server.

• How to create Sage Intacct federated tables in MySQL

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

• How to connect and process Zoho Recruit from Azure Databricks

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

• Access Live Hive Data in Google Sheets through Connect Spreadsheets

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

• Build Freshdesk-Connected Dashboards Using Zoho Analytics

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

• How to create an RPA flow for Coinbase Data in UiPath Studio

  Use the Coinbase ODBC Driver to create workflows that access real-time Coinbase without any coding.

• Operational Reporting on Oracle Eloqua Reporting Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Eloqua Reporting.

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

  Connect QuickBooks Data with Dataiku using the CData JDBC Driver for QuickBooks.

• Access Live Strava Data in TIBCO Data Virtualization

  Use the CData API Driver for Tibco DV to create a Strava data source in TIBCO Data Virtualization Studio and gain access to live Strava from your TDV Server.

• Analyze Procore Data in Looker

  Use CData Connect AI to connect to Procore Data from Looker and build custom apps using live Procore.

• Connect to Printful Data in JRuby

  Create a simple JRuby app with access to live Printful.

• «
• 100
• 101
• 102
• 103
• 104
• 105
• 106
• 107
• 108
• 109
• »