CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for FHIR in APOS Live Data Gateway
Use the CData Connector for FHIR in APOS Live Data Gateway to build Semantic Layer Views for FHIR.
-
Visualize Azure Active Directory in Sisense
Create an ElastiCube in Sisense app with access to Azure Active Directory.
-
How to connect and process Zoho Projects from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Projects.
-
Use the CData Software ODBC Driver for Salesforce Data Cloud in MicroStrategy
Connect to Salesforce Data Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Data Cloud.
-
Automated Continuous SAP SuccessFactors Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Apache Cassandra.
-
Access Live SAP BusinessObjects BI in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP BusinessObjects BI from your Excel spreadsheets.
-
Analyze Cvent in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cvent in Microsoft R Open.
-
Connect to Adobe Analytics in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Analytics in the Denodo Virtual DataPort Administrator.
-
Connect to Amazon S3 as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon S3.
-
Visualize MYOB AccountRight in TIBCO Spotfire through ADO.NET
Integrate MYOB AccountRight into dashboards in TIBCO Spotfire.
-
How to connect SharePoint with Smartsheet through external lists
Provide Smartsheet to SharePoint users as an external list.
-
Build Visualizations of SAP in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP ERP/NetWeaver in Birst.
-
Consume WordPress OData Feeds in PowerBuilder
This article demonstrates how to consume WordPress as OData feeds from PowerBuilder using the API Server.
-
Build Cvent-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cvent.
-
Replicate Microsoft Planner from PowerShell
Write a quick PowerShell script to query Microsoft Planner. Use connectivity to the live data to replicate Microsoft Planner to SQL Server.
-
Access PingOne from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PingOne from HeidiSQL.
-
Integrate ActiveCampaign in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ActiveCampaign from Informatica Cloud.
-
Automated Continuous Monday.com Replication to SQLite
Use CData Sync for automated, continuous, customizable Monday.com replication to SQLite.
-
Automate MailChimp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailChimp from PowerShell? This article demonstrates how to utilize the MailChimp Cmdlets for tasks like connecting to MailChimp, automating operations, downloading data, and more.
-
Connect to Google Drive in CloverDX (formerly CloverETL)
Transfer Google Drive using the visual workflow in the CloverDX data integration tool.
-
Automate Neo4J Replication to SAP HANA
Use CData Sync to customize and automate Neo4J replication to SAP HANA.
-
View Reports on Real-Time Bing Ads in Power BI Report Server
Use the CData ODBC Driver for Bing Ads to visualize Bing Ads in Power BI Desktop and then publish them to Power BI Report Server.
-
How to update ADP from Excel
This article explains how to transfer data from Excel to ADP using the Excel Add-In for ADP.
-
Connect to DB2 from PowerBuilder via JDBC
This article demonstrates how to access IBM DB2 from PowerBuilder using the DB2 JDBC Driver.
-
Access Live Workday in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Workday through MCP integration.
-
Access Dropbox from MySQL in Amazon QuickSight
Connect to Dropbox and build visualizations of Dropbox using a MySQL Connection in Amazon QuickSight.
-
Connect and Visualize Live Tableau CRM Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Tableau CRM Analytics into the Databricks platform and create visualization dashboards with real-time Tableau CRM Analytics.
-
How to Import Data from DocuSign into Google Sheets
Import DocuSign into a Google spreadsheet that is automatically refreshed.
-
Create Monday.com Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect Azure Data Lake Storage to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Azure Data Lake Storage data in real time using natural language.
-
Connect to Oracle Sales as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle Sales.
-
Excel Spreadsheet Automation on Shopify with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Shippo using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shippo to a JSON file on disk.
-
Access Live Google Calendar in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Calendar from your Google Sheets.
-
How to Connect Flowise AI Agents to Live Azure Analysis Services 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.
-
Analyze CockroachDB in Looker
Use CData Connect AI to connect to CockroachDB from Looker and build custom apps using live CockroachDB.
-
Build a PostgreSQL Interface for SAP Concur using the CData JDBC Driver
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze JotForm in R via JDBC
Use standard R functions and the development environment of your choice to analyze JotForm with the CData JDBC Driver for JotForm.
-
Connect to Databricks in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Datasets from Harvest in Domo Workbench and Build Visualizations of Harvest in Domo
Use the CData Software ODBC Driver for Harvest to create datasets from Harvest in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Act-On in Pentaho Data Integration
Build ETL pipelines based on Act-On in the Pentaho Data Integration tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Xero Accounting within intelligent workflows.
-
Integrate Real-Time Access to Oracle Service Cloud in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Service Cloud in real time.
-
Automated Continuous Oracle Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle replication to SQL Server.
-
Integrate Cline with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Dynamics 365 from within your IDE.
-
Connect to SAP BusinessObjects BI from Asprova with CData Software ODBC Driver for SAP BusinessObjects BI
This article shows how to connect faster to SAP BusinessObjects BI data from Asprova.
-
Access IBM Informix from MySQL in PHP
Connect to IBM Informix through the standard MySQL libraries in PHP.
-
Connect to Snapchat Ads in Claris FileMaker Pro
-