CData Software - Knowledge Base

Recent Articles

---

• «
• 755
• 756
• 757
• 758
• 759
• 760
• 761
• 762
• 763
• 764
• »

• Build Apps with Live Lakebase in Adalo using CData Connect AI

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

• Create Bullhorn CRM-Connected Dashboards in Grafana

  Connect to Bullhorn CRM via CData Connect AI in Grafana and create custom business dashboards with real-time access to Bullhorn CRM.

• Extending QuickBooks Online Reporting

  The CData Data Providers for QuickBooks Online make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Item Profitability Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.

• A PostgreSQL Interface for IBM Cloud Object Storage using the CData ODBC Driver

  Use the SQL Gateway and IBM Cloud Object Storage ODBC Driver to create a PostgreSQL entry-point for data access.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for PayPal

  Provide connectivity to PayPal through an SAP BusinessObjects universe.

• Connect to OneNote as an External Source in Dremio

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

• How to create Sybase federated tables in MySQL

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

• Connect to Blackbaud FE NXT in Ruby

  Connect to Blackbaud FE NXT in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Build Pipelines with Live SAP HANA in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to SAP HANA from Google Cloud Data Fusion, enabling the integration of live SAP HANA into the building and management of effective data pipelines.

• Analyze Live Google Drive in SAS Viya

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

• Visualize Invoiced in TIBCO Spotfire through ADO.NET

  Integrate Invoiced into dashboards in TIBCO Spotfire.

• Query EnterpriseDB using the OData SDK for PHP

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

• How to work with Excel Online in Apache Spark using SQL

  Access and process Excel Online in Apache Spark using the CData Software JDBC Driver.

• Use ChatGPT to Talk to Your Adobe Commerce via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Adobe Commerce for you.

• Trigger Acumatica IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

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

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

• Automated Continuous Jira Replication to Apache Kafka

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

• How to Connect to ClickUp in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the pyodbc module for ODBC in Python.

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

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

• Create BigCommerce-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to BigCommerce from Klipfolio and build custom visualizations using live BigCommerce.

• How to publish and share Square dashboards with Tableau Server

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

• Automate IBM Cloud Object Storage Replication to Couchbase

  Use CData Sync to Customize and automate IBM Cloud Object Storage replication to Couchbase.

• Access PingOne as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PingOne from your Oracle system.

• How to Connect Flowise AI Agents to Live Odoo via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.

• Integrating Claude Code with Shopify via CData Connect AI

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

• Connect to Zoho Creator from Excel & GoogleSheets!

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

• Automate YouTube Analytics Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live YouTube Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Edit and Search External Hive Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Apache Hive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Hive objects that you can access from apps and the dashboard.

• How to connect SharePoint with Access through external lists

  Provide Microsoft Access to SharePoint users as an external list.

• Build Apps with Live Apache Cassandra in Adalo using CData Connect AI

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

• Build AI Agents with Airtable Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can

• Automate Azure Active Directory Replication to Couchbase

  Use CData Sync to Customize and automate Azure Active Directory replication to Couchbase.

• Build Visualizations of XML in Birst

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

• Build Agents in Relevance AI with Access to Live Odoo via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Odoo ERP within intelligent agent workflows.

• Choosing the Best Method to Connect Azure Data Catalog to SQL Server: 5 Options Explained

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

• Create Data Visualizations Based On Amazon S3 in Mode

  Use CData Connect AI to connect to Amazon S3 from Mode and build visualizations using live

• Connect to Power BI XMLA through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Power BI XMLA using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Visualize MYOB AccountRight in Sisense

  Create an ElastiCube in Sisense app with access to MYOB AccountRight.

• Build a PostgreSQL Interface for SharePoint using the CData JDBC Driver

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

• Analyze Cosmos DB in Looker

  Use CData Connect AI to connect to Cosmos DB from Looker and build custom apps using live Azure Cosmos DB.

• Bidirectional Access to Trello from FileMaker Pro

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

• Access Live Power BI XMLA in AWS Lambda

  Connect to live Power BI XMLA in AWS Lambda using the CData JDBC Driver.

• Publish Oracle HCM Cloud-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle HCM Cloud.

• Extract, Transform, and Load Unbounce in Informatica PowerCenter

  Create a simple Workflow for Unbounce in Informatica PowerCenter.

• Query, Visualize, and Share live Azure Analysis Services in Redash

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

• Integrating Gumloop with Airtable via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Airtable within automated workflows.

• Build Charts with Calendly in Clear Analytics

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

• Using the CData Software ODBC Driver for Sybase in PyCharm

  Connect to Sybase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase.

• Model, Search, and Visualize Live Zoho Projects in ThoughtSpot

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

• Access Live Azure Table in AWS Lambda (with IntelliJ IDEA)

  Connect to live Azure Table Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Analyze Dynamics 365 in R via JDBC

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

• Manage Oracle Eloqua Reporting in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Oracle Eloqua Reporting.

• Connect to Square as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Square.

• Automated Continuous SAP Ariba Procurement Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Google Cloud SQL.

• How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central through natural language.

• How to pipe QuickBooks Time to CSV in PowerShell

  Use standard PowerShell cmdlets to access QuickBooks Time tables.

• Build MVC Applications with Connectivity to Databricks

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

• Reckon Accounts Hosted Cloud Connectivity

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

• Analyze Neo4J in Slingshot with CData API Server

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

• Replicate Multiple CouchDB Accounts via the CData Sync CLI

  Replicate multiple CouchDB accounts to one or many databases.

• Work with SAP Fieldglass in FoxPro

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

• Getting Started with the CData ODBC Driver for MongoDB

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

• Access Workday from MySQL in PHP

  Connect to Workday through the standard MySQL libraries in PHP.

• Use the CData SSIS Components to Insert New or Update Existing Zoho CRM Records from SQL Server

  Easily push SQL Server data to Zoho CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho CRM or update existing records with data from a SQL Server database.

• Automated Continuous Google Sheets Replication to OneLake in Microsoft Fabric

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

• Extend Google Sheets with Azure DevOps

  Make calls to the API Server from Google Apps Script.

• Automated GitHub Replication to Teradata

  Use CData Sync to Customize and automate GitHub replication to Teradata.

• Create Bing Ads-Connected Nintex Workflows

  Use CData Connect AI to connect to Bing Ads from Nintex Workflow Cloud and build custom workflows using live Bing Ads.

• Integrate Excel in the Pentaho Report Designer

  Publish reports based on Microsoft Excel in the Pentaho BI tool.

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

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

• Integrate Live Azure Data Lake Storage into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 755
• 756
• 757
• 758
• 759
• 760
• 761
• 762
• 763
• 764
• »