CData Software - Knowledge Base
Recent Articles
-
Automate TaxJar Replication to SAP HANA
Use CData Sync to customize and automate TaxJar replication to SAP HANA.
-
DataBind Charts to Google Drive
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Drive 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.
-
Build MVC Applications with Connectivity to Smartsheet
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Smartsheet from an ASP.NET MVC application.
-
Work with BambooHR in FoxPro
Load BambooHR into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect Flowise AI Agents to Live Databricks 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.
-
Enable the MarkLogic JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MarkLogic.
-
Automate Zoho Books Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zoho Books and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Google Sheets Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Sheets replication to Oracle.
-
Connect to and Query SAP in QlikView over ODBC
Create data visualizations with SAP ERP/NetWeaver in QlikView.
-
Use Microsoft Copilot Studio to talk to your Microsoft Project via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Project for you.
-
Visualize Live Microsoft Teams in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Teams.
-
Access Snapchat Ads as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Snapchat Ads from your Oracle system.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Snowflake within intelligent workflows.
-
Access Live SAP Concur in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur from your Google Sheets.
-
Query Printful in DataGrip
Create a Data Source for Printful in DataGrip and use SQL to query live Printful.
-
Integrate Google Sheets in the Pentaho Report Designer
Publish reports based on Google Sheets in the Pentaho BI tool.
-
How to use SQLAlchemy ORM to access Odoo in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Odoo ERP.
-
Build AI Agents with SQL Server Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Work with Live NetSuite in Power Query
Use CData Connect AI to connect to NetSuite CRM & ERP and work with live NetSuite CRM & ERP in Microsoft Power Query.
-
Analyze Phoenix in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Phoenix and visualize live Apache Phoenix in Infragistics Reveal.
-
Automated Continuous IBM Informix Replication to SingleStore
Use CData Sync for automated, continuous, customizable IBM Informix replication to SingleStore.
-
Create Apps from SAP SuccessFactors in Qlik Sense Cloud
Use CData Connect AI to connect to SAP SuccessFactors and build apps from live SAP SuccessFactors in Qlik Sense Cloud.
-
Provide OData Services of Salesforce Marketing from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce Marketing Cloud by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Printify in MicroStrategy Web
Connect to Printify in MicroStrategy Web using the CData Software ODBC Driver for Printify.
-
Automated Continuous OData Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OData replication to Azure SQL Database.
-
Create Datasets from Dropbox in Domo Workbench and Build Visualizations of Dropbox in Domo
Use the CData Software ODBC Driver for Dropbox to create datasets from Dropbox in Domo Workbench and then build visualizations in the Domo service.
-
Work with YouTube Analytics in FoxPro
Load YouTube Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SAP SuccessFactors LMS as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP SuccessFactors LMS.
-
How to Connect to Live Power BI XMLA from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Power BI XMLA for you.
-
Use ChatGPT to Talk to Your Facebook Ads via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Facebook Ads for you.
-
Connect to Azure Table in RapidMiner
Integrate Azure Table Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
Outreach.io Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Outreach.io through CData Connect AI using different applications and tools.
-
Automated Continuous Google Contacts Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Contacts replication to Google Cloud SQL.
-
Connect to Twilio in ACL Analytics
Connect to Twilio via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Twilio.
-
Query Monday.com as a SQL Server Database in Node.js
Execute SQL Server queries against Monday.com from Node.js.
-
Create Dashboards and Visualize Live Google Calendar in Geckoboard
Use CData Connect AI to connect to live Google Calendar and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Query Klipfolio from Node.js
Use the OData endpoint of the CData API Server to connect to your Klipfolio and perform CRUD operations on Klipfolio from Node.js.
-
Build Dynamics 365 Business Central-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics 365 Business Central and create custom apps in Mendix.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Hybris C4C using the Model Context Protocol.
-
Model Zoho Books Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Books, enabling the direct import of real-time Zoho Books.
-
How to Access Live SAP SuccessFactors LMS in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP SuccessFactors LMS enables you to integrate SAP SuccessFactors LMS into workflows built using Microsoft Power Automate Desktop.
-
Access Live Box in AWS Lambda (with IntelliJ IDEA)
Connect to live Box in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build AI Agents with Databricks Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Use Claude to Talk to Your Sugar CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Sugar CRM for you.
-
Build Access-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Access and build web apps with connectivity to live Microsoft Access.
-
Automate Basecamp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Basecamp from PowerShell? This article demonstrates how to utilize the Basecamp Cmdlets for tasks like connecting to Basecamp, automating operations, downloading data, and more.
-
Stream Oracle SCM into Apache Kafka Topics
Access and stream Oracle SCM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Paylocity in Looker
Use CData Connect AI to connect to Paylocity from Looker and build custom apps using live Paylocity.
-
Manage Google Campaign Manager 360 in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Campaign Manager 360.
-
How to connect and process Blackbaud FE NXT from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Blackbaud FE NXT.
-
Access Live Google Drive Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Drive data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to SQL Analysis Services in SpagoBI
Create reports featuring live SQL Analysis Services in SpagoBI Studio. Host SQL Analysis Services reports on SpagoBI Server.
-
Todoist Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Todoist facts in real time.
-
Connect to Salesforce in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Salesforce Pardot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to PostgreSQL.
-
Connect to Freshdesk as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshdesk.
-
Stream Microsoft Dataverse into Apache Kafka Topics
Access and stream Microsoft Dataverse (CDS) in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Microsoft Dataverse from a Connection Pool in JBoss
Integrate Microsoft Dataverse (CDS) into Java servlets: Use the Management Console in JBoss to install the Microsoft Dataverse JDBC Driver.
-
Trigger AlloyDB IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build Odoo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Odoo and create custom apps in Mendix.
-
Manage SAP SuccessFactors LMS in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP SuccessFactors LMS.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Email
Provide connectivity to Email through an SAP BusinessObjects universe.
-
How to Import Data from Email into Google Sheets
Import Email into a Google spreadsheet that is automatically refreshed.
-
Connect and Query Live Splunk Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Splunk into Databricks
-
Use the CData Software ODBC Driver for Blackbaud FE NXT in SAS for Real-Time Reporting and Analytics
Connect to real-time Blackbaud FE NXT in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Natively Connect to XML in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to XML Files. Leverage the native support for ODBC in PHP.
-
How to Connect the Power BI Service to Google Search: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Zoho Inventory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Google BigQuery.
-
Create Reports from SAP Ariba Source in Looker Studio
Use CData Connect AI to gain access to live SAP Ariba Source and create custom reports in Looker Studio.
-
Integrate Live Raisers Edge NXT into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Raisers Edge NXT from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Raisers Edge NXT.
-
How to publish and share Google Contacts dashboards with Tableau Server
The CData ODBC driver for Google Contacts enables you integrate Google Contacts into Tableau dashboards.
-
Automated Continuous SAP Fieldglass Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SQL Server.
-
DataBind Charts to Calendly
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Calendly 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.
-
Bind Live YouTube Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live YouTube Analytics data
-
Use the CData Software ODBC Driver for Facebook in MicroStrategy Desktop
Connect to Facebook in MicroStrategy Desktop using the CData Software ODBC Driver for Facebook.
-
Automated Continuous Freshdesk Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshdesk replication to Databricks.
-
Connect to Oracle Service Cloud from Asprova with CData Software ODBC Driver for Oracle Service Cloud
This article shows how to connect faster to Oracle Service Cloud data from Asprova.
-
Visualize Pinterest in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Pinterest into TIBCO Spotfire.
-
Build Data Flows from SQL Server to Dynamics 365 Business Central through SSIS
Easily push SQL Server data to Dynamics 365 Business Central using the CData SSIS Tasks for Dynamics 365 Business Central.
-
Connect to Google Cloud Storage Using the Script Function in Claris FileMaker Pro
-