CData Software - Knowledge Base

Recent Articles

---

• «
• 624
• 625
• 626
• 627
• 628
• 629
• 630
• 631
• 632
• 633
• »

• SharePoint Online: Microsoft IDCRL Authentication Deprecation (SOAP Schema)

  IDCRL retirement impacts SharePoint Online SOAP Schema users. Migrate to REST Schema or apply a temporary extension.

• Connect to Bitly Data from a Connection Pool in Jetty

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

• Access Zoho Books Data from MySQL in Amazon QuickSight

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

• Integrate with Live DocuSign Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to DocuSign from the MuleSoft Anypoint Platform to integrate live DocuSign into custom reports and dashboards.

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

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

• Automated Continuous Stripe Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Stripe replication to MongoDB.

• Automate HBase Data Replication to SAP HANA

  Use CData Sync to customize and automate Apache HBase replication to SAP HANA.

• Access Live Tavily Data in SAS JMP via ODBC

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

• Integrating Codex CLI with Reckon Accounts Hosted 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.

• Access Supabase Data as a Remote Oracle Database

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

• Replicate BambooHR Data from PowerShell

  Write a quick PowerShell script to query BambooHR. Use connectivity to the live data to replicate BambooHR to SQL Server.

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

• Create Reports with Zendesk Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Zendesk.

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

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

• Getting Started with the CData Excel Add-In for Zendesk

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zendesk.

• Process & Analyze Confluence Data in Databricks (AWS)

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

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

• Build Automated Email-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Email and build automated workflows in Zapier.

• Import LDAP Objects into Microsoft Power Query

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

• Create Instagram-Connected Dashboards in Grafana

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

• Working with Exact Online Data in LINQPad

  Execute LINQ queries to Exact Online in LINQPad.

• Access Live PhantomBuster Data in SAS JMP via ODBC

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

• Integrate Phoenix with JetBrains RubyMine using CData JDBC Drivers

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

• Analyze IBM Cloud Object Storage Data in Slingshot with CData API Server

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

• Use Dash to Build to Web Apps on Dropbox Data

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

• Connect to Billsby Data in DBeaver

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

• Analyze SurveyMonkey Data in R via ODBC

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

• Connect to Vault CRM in SpagoBI

  Create reports featuring live Veeva Vault & Vault CRM in SpagoBI Studio. Host Vault CRM reports on SpagoBI Server.

• Integrate Microsoft Exchange Data in Pentaho Data Integration

  Build ETL pipelines based on Microsoft Exchange in the Pentaho Data Integration tool.

• Access Greenhouse Data as a Remote Oracle Database

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

• Use the CData Software JDBC Driver for CapsuleCRM in MicroStrategy Web

  Connect to CapsuleCRM in MicroStrategy Web using the CData Software JDBC Driver for CapsuleCRM.

• Build a Simple VCL Application for MySQL Data

  How to build a simple VCL Application to view MySQL in RAD Studio using the CData ODBC Driver for MySQL.

• Getting Started with the CData ODBC Driver for Microsoft Ads

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

• A PostgreSQL Interface for Epicor Kinetic Data using the CData ODBC Driver

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

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

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

• Connect QuickBooks Online to AI Assistants With the CData Python MCP Server

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

• How to Access Live SAP HANA XS Advanced Data in Visual Studio Code via Cline

  Run CData MCP Server for SAP HANA XS Advanced on Windows Subsytem for Linux (WSL) and connect to live SAP HANA XS Advanced from the Cline extension in Visual Studio Code.

• Migrating data from SAS Data Sets to Google BigQuery using CData SSIS Components.

  Easily push SAS Data Sets to Google BigQuery using the CData SSIS Tasks for SAS Data Sets and Google BigQuery.

• Connect to BenchmarkEmail Data in RazorSQL

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

• Getting Started with the CData Power BI Connector for Microsoft Dataverse

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Dataverse.

• Trigger Certinia IFTTT Flows in Azure App Service

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

• Create Data Visualizations in Cognos BI with Office 365 Data

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

• Access Access Data from MySQL in Amazon QuickSight

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

• Integrate Live Calendly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Calendly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Use the CData ODBC Driver for Azure Data Lake Storage from SharePoint Excel Services

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

• Connect to IBM Cloud Object Storage Data in DBeaver

  Use the CData ODBC Driver to connect to IBM Cloud Object Storage in DBeaver.

• Perform Batch Operations with Amazon DynamoDB Data in Apache NiFi

  Connect to Amazon DynamoDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Write a Simple Go Application to work with Parallel Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Parallel.

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

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

• Connect to Azure Synapse Data in ACL Analytics

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

• How to Connect to Live Dynamics CRM Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Dynamics CRM securely in real time.

• Query Live LinkedIn Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live LinkedIn directly from the development environment.

• Replicate MySQL Data in Heroku for Use in Salesforce Connect

  Replicate MySQL to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to Connect to & Open Google Sheets Data in Microsoft Excel

  This article uses the CData ODBC driver for Google Sheets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Use the CData API Server in Microsoft Power BI

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

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

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

• Back Up CampaignMonitor 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 CampaignMonitor data.

• Visualize Live Freshdesk Data in the Power BI Service

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

• Manage SAP SuccessFactors LMS Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP SuccessFactors LMS.

• How to Access Live NetSuite Data in Visual Studio Code via Cline

  Run CData MCP Server for NetSuite on Windows Subsytem for Linux (WSL) and connect to live NetSuite CRM & ERP from the Cline extension in Visual Studio Code.

• Load Zoho Books Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Books to a database.

• Design BIRT Reports on HelloSign Data

  Provide current HelloSign to your embedded analytics.

• Visualize Salesforce 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 Salesforce & Force.com into TIBCO Spotfire.

• Create SingleStore-Connected Visualizations in Klipfolio

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

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

  Replicate Apache Impala to disparate databases with a single configuration.

• Connect Amazon DynamoDB to IBM WebSphere Using the CData JDBC Driver

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

• Integrate Xero Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Xero Accounting and integrate live Xero Accounting into your Power Automate tasks.

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

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

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

• Automate Vault CRM Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to Azure Data Lake.

• Use Biml to Build SSIS Tasks to Replicate Hacker News Data to SQL Server

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

• Query Certinia Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Certinia from Node.js.

• Query Outreach.io Data through ODBC in Node.js

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

• Create Freshservice-Connected Business Apps in AppSheet

  Connect to Freshservice Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Freshservice.

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

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

  Connect Wrike Data with Dataiku using the CData API Driver for JDBC.

• Replicate Stack Exchange Data to Multiple Databases via the CData Sync CLI

  Replicate Stack Exchange to disparate databases with a single configuration.

• Visualize Live Zoom Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Zoom.

• Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy

  Connect to Adobe Analytics in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Analytics.

• Automated Continuous Act CRM Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Act CRM replication to Azure SQL Database.

• Connect to Amazon DynamoDB Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Amazon DynamoDB in the Denodo Virtual DataPort Administrator.

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

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

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

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

• Replicate Multiple Oracle Eloqua Accounts via the CData Sync CLI

  Replicate multiple Oracle Eloqua accounts to one or many databases.

• Integrate Samanage Data in Pentaho Data Integration

  Build ETL pipelines based on Samanage in the Pentaho Data Integration tool.

• Use the CData ODBC Driver for YouTube Analytics from SharePoint Excel Services

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

• Build MVC Applications with Connectivity to Toggl Data

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

• Visualize HBase Data in TIBCO Spotfire through OData

  Integrate Apache HBase into dashboards in TIBCO Spotfire.

• Build EnterpriseDB-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live EnterpriseDB.

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

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

• DataBind Controls to Amplitude Data in C++Builder

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

• Visualize Live Kintone Data in the Power BI Service

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

• Bridge Jira Assets Connectivity with Apache NiFi

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

• Create Datasets from Sage Cloud Accounting in Domo Workbench and Build Visualizations of Sage Cloud Accounting Data in Domo

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

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

  Provide connectivity to Deel through an SAP BusinessObjects universe.

• Connect to Spotify Data in HULFT Integrate

  Connect to Spotify as a JDBC data source in HULFT Integrate

• Access Live Excel Data in AWS Lambda

  Connect to live Microsoft Excel in AWS Lambda using the CData JDBC Driver.

• Automate Tasks in Power Automate Using the CData API Server

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

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

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

• «
• 624
• 625
• 626
• 627
• 628
• 629
• 630
• 631
• 632
• 633
• »