CData Software - Knowledge Base

Recent Articles

---

• «
• 585
• 586
• 587
• 588
• 589
• 590
• 591
• 592
• 593
• 594
• »

• How to load Zoho Books data into Elasticsearch via Logstash

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

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

  Execute MySQL queries against CockroachDB from Node.js.

• Automated Continuous Snapchat Ads Replication to PostgreSQL

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

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

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

• How to create Cohere federated tables in MySQL

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

• Integrate Apollo Data into Power Automate Desktop using CData Connect

  CData Connect for Apollo Data enables you to integrate Apollo into workflows built using Microsoft Power Automate Desktop.

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

  Use the CData Connector for SAP in APOS Live Data Gateway to build Semantic Layer Views for SAP ERP/NetWeaver.

• How to update Dynamics 365 from Excel

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

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

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft Dataverse (CDS) through CData Connect AI.

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

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

• How to import Pinecone Data into Apache Solr

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

• Bridge SuiteCRM Connectivity with Apache NiFi

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

• Feed QuickBooks Time Data into FineReport

  How to set QuickBooks Time as a JDBC data source in FineReport.

• Automated Continuous eBay Analytics Replication to SQL Server

  Use CData Sync for automated, continuous, customizable eBay Analytics replication to SQL Server.

• Back Up REST to SQL Server through SSIS

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

• Import and Visualize Clockify Data in Power View

  Create data visualizations based on Clockify in Excel.

• Automate Tasks in Power Automate Using the CData API Server

  Automate MarkLogic actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• How to Connect to Live Snowflake Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Snowflake for you.

• How to Query Live Workday Data in Perplexity MacOS Desktop

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

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

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

• Connect to and Query Adobe Analytics Data in QlikView over ODBC

  Create data visualizations with Adobe Analytics in QlikView.

• Replicate Multiple HelloSign Accounts via the CData Sync CLI

  Replicate multiple HelloSign accounts to one or many databases.

• Connect to Greenplum Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Pivotal GreenPlum in Airbyte.

• Build Dashboards with Avaza Data in DBxtra

  Create dynamic dashboards and perform analytics based on Avaza in DBxtra.

• Moving Data from Dotmailer to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Dotmailer data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Integrate Power BI XMLA with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Power BI XMLA with External Services.

• Connect to Dotmailer Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Dotmailer.

• Visualize Impala Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apache Impala into TIBCO Spotfire.

• Connect Cassandra to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Cassandra with IBM WebSphere for seamless data integration and connectivity.

• Process & Analyze SAS Data Sets Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAS Data Sets Data.

• Integrating GitHub Copilot CLI with Sugar CRM 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 Paylocity from Excel & GoogleSheets!

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

• Use the CData JDBC Driver for Salesforce in MicroStrategy Web

  Connect to Salesforce data in MicroStrategy Web using the CData JDBC Driver for Salesforce.

• Integrating Kiro CLI with Campaigner 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.

• Automated Continuous Jumpseller Data Replication to OneLake in Microsoft Fabric

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

• Getting Started with the CData Tableau Connector for Shortcut

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

• Connect Pinterest Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Pinterest using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Feed Tickspot Data into FineReport

  How to set Tickspot as a JDBC data source in FineReport.

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

• Getting Started with the CData Tableau Connector for BigCommerce

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for BigCommerce.

• Create Data Visualizations in Cognos BI with Strava Data

  Access Strava as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to integrate SAP SuccessFactors LMS with Apache Airflow

  Access and process SAP SuccessFactors LMS in Apache Airflow using the CData JDBC Driver.

• Back Up Adobe Experience Manager to SQL Server through SSIS

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

• Build Data Flows from Databricks to SQL Server using SSIS

  Easily back up Databricks to SQL Server using the SSIS components for Databricks.

• How to Query Live Excel Data in Claude Desktop

  Connect to and query live Excel Data in Claude Desktop using CData MCP Server.

• Build Data Flows from ZeroBounce to SQL Server using SSIS

  Easily back up ZeroBounce to SQL Server using the SSIS components for ZeroBounce.

• DataBind Charts to Shopify Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Shopify 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 WooCommerce to SQL Server through SSIS

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

• Automate QuickBooks Data Replication to SAP HANA

  Use CData Sync to customize and automate QuickBooks Desktop replication to SAP HANA.

• Provide OData Services of ConvertKit Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for ConvertKit by developing a WCF Service Application.

• Automate CloudConvert Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access CloudConvert from PowerShell? This article demonstrates how to utilize the CloudConvert Cmdlets for tasks like connecting to CloudConvert, automating operations, downloading data, and more.

• Connect to Jumpseller Data in Jaspersoft Studio

  Execute SQL to remote Jumpseller in Jaspersoft Studio.

• How to create Visio diagrams from Basecamp Data

  Automatically update Basecamp with the changes you make to Visio master shapes.

• How to connect to Neo4J Data from Spring Boot

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

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

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

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

• Viewing Short.io Data in RAD Studio Data Explorer

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

• Integrate Theia IDE with Live Oracle HCM Cloud Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• Create Sybase Reports on JasperReports Server

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

• Visualize Live Zoho Books Data of Power BI Report Builder in Power BI Service

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

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

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

• Create Oracle Eloqua Reporting Reports on JasperReports Server

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

• Query Power BI XMLA Data in ColdFusion

  Write standard ColdFusion data access code to connect to Power BI XMLA.

• Design BIRT Reports on Discord Data

  Provide current Discord to your embedded analytics.

• How to Connect the Power BI Service to Pinterest: Complete Guide

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

• Use Dash to Build Web Apps on Basecamp Data via CData Connect AI

  Build interactive Dash web apps on live Basecamp using pandas and the CData Connect AI Python SDK.

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

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

• Work with Live SAP Fieldglass Data in Power Query

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

• Connect to Oracle HCM Cloud Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Oracle HCM Cloud from Crystal Reports.

• Connect to SendPulse Data from PowerBuilder via ADO.NET

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

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

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

• Publish Nethunt-Connected Dashboards in Tableau Server via JDBC

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

• Integrate Real-Time Access to FTP in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to FTP Servers in real time.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Microsoft Ads actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Create Reports from CouchDB Data in Looker Studio

  Use CData Connect AI to gain access to live Apache CouchDB and create custom reports in Looker Studio.

• Automated Continuous SAP Fieldglass Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Azure SQL Database.

• Enable the Bullhorn CRM JDBC Driver in KNIME

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

• Explore Geographical Relationships in Coda Data with Power Map

  Create data visualizations with Coda in Power Map.

• Getting Started with the CData JDBC Driver for SharePoint Excel Services

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SharePoint Excel Services.

• Viewing GitHub Data in RAD Studio Data Explorer

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

• Access Act-On Data from MySQL in PHP

  Connect to Act-On through the standard MySQL libraries in PHP.

• Manage Dynamics CRM Data in DBArtisan as a JDBC Source

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

• Automated Continuous Redis Replication to IBM DB2

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

• Analyze CapsuleCRM Data in R via ODBC

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

• Create SAS Data Sets-Connected Nintex Workflows

  Use CData Connect AI to connect to SAS Data Sets Data from Nintex Workflow Cloud and build custom workflows using live SAS Data Sets.

• Analyze Live MongoDB Data in SAS Viya

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

• Integrate IBM Informix Data in the Pentaho Report Designer

  Publish reports based on IBM Informix in the Pentaho BI tool.

• Replicate ClickTime Data to Multiple Databases

  Replicate ClickTime to disparate databases with a point-and-click configuration.

• Connect to Kintone Data as an External Source in Dremio

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

• Connect to and Query Exa Data in QlikView over ODBC

  Create data visualizations with Exa in QlikView.

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

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

• How to Use a Microsoft Access Database to Update Excel Online Data in Real Time

  Update Excel Online data by creating a linked table in Microsoft Access with the CData Excel Online ODBC Driver.

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

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

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

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

• Connect to Outreach.io Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Outreach.io in Google Apps Script.

• How to Connect DBeaver to Teamwork via a JDBC Driver

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

• Connect to SAP ByDesign Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for SAP ByDesign and the SQL Gateway to access SAP Business ByDesign from Google Apps Script.

• Creating SAS xpt-Connected Applications in Unqork

  You can use CData Connect AI to feed SAS XPORT to Unqork and build custom business apps.

• Connect to Okta in SpagoBI

  Create reports featuring live Okta in SpagoBI Studio. Host Okta reports on SpagoBI Server.

• Natively Connect to GitLab Data in PHP

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

• «
• 585
• 586
• 587
• 588
• 589
• 590
• 591
• 592
• 593
• 594
• »