CData Software - Knowledge Base
Recent Articles
-
Integrating LangGraph with SharePoint via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft SharePoint within automated workflows.
-
Consume Drip OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Drip feeds that reflect any changes in SAP Lumira.
-
How to Connect to Live Azure Data Lake Storage 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 Azure Data Lake Storage for you.
-
Integrate Salesforce Pardot into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce Pardot and integrate live Salesforce Pardot into your Power Automate tasks.
-
Automated Continuous QuickBooks Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SQL Server.
-
Connect to Asana from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Asana, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Datasets from Paylocity in Domo Workbench and Build Visualizations of Paylocity in Domo
Use the CData Software ODBC Driver for Paylocity to create datasets from Paylocity in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Google Analytics in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Analytics and connect to Google Analytics in Akorbi Digital RunMyProcess.
-
Query SAS Data Sets in DataGrip
Create a Data Source for SAS Data Sets in DataGrip and use SQL to query live SAS Data Sets.
-
Connect SAP SuccessFactors to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP SuccessFactors using the CData Python MCP Server.
-
Create Bullhorn CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Bullhorn CRM from OutSystems and build custom enterprise apps using live Bullhorn CRM.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Databricks using the Model Context Protocol.
-
Build CockroachDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live CockroachDB and build visualizations in Tableau Cloud.
-
How to load MariaDB data into Elasticsearch via Logstash
Introducing a simple method to load MariaDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Cassandra in Excel 365 Online (Excel for the web)
Connect to Apache Cassandra from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze PostgreSQL in Infragistics Reveal
Use the CData API Server to create an OData API on top of PostgreSQL and visualize live PostgreSQL in Infragistics Reveal.
-
Trigger GitHub IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
How to connect PolyBase to REST
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live REST.
-
Access Live Adobe Analytics in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Analytics from your Google Sheets.
-
Integrate Airtable into Power Automate Desktop using CData Connect
CData Connect for Airtable enables you to integrate Airtable into workflows built using Microsoft Power Automate Desktop.
-
Connect to Harvest from Asprova with CData Software ODBC Driver for Harvest
This article shows how to connect faster to Harvest data from Asprova.
-
How to Create Power BI Visual Reports with Real-Time Reckon Accounts Hosted
Use CData Power BI Connectors to visualize Reckon Accounts Hosted in Power BI.
-
Use the CData SSIS Components to Insert New or Update Existing MariaDB Records from SQL Server
Easily push SQL Server data to MariaDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MariaDB or update existing records with data from a SQL Server database.
-
Build Data Flows from SQL Server to MYOB AccountRight through SSIS
Easily push SQL Server data to MYOB AccountRight using the CData SSIS Tasks for MYOB AccountRight.
-
Connect to Redis from a Connection Pool in JBoss
Integrate Redis into Java servlets: Use the Management Console in JBoss to install the Redis JDBC Driver.
-
PowerShell Scripting to Replicate Gmail to MySQL
Write a simple PowerShell script to replicate Gmail to a MySQL database.
-
Connect to Workday from a Connection Pool in WebLogic
Use the CData JDBC Driver for Workday to connect to Workday from Web applications running on WebLogic.
-
Connect to Live HCL Domino in PostGresSQL Interface through CData Connect AI
Create a live connection to HCL Domino in CData Connect AI and connect to your HCL Domino from PostgreSQL.
-
Connect to BigCommerce in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import and Visualize Snowflake in Power View
Create data visualizations based on Snowflake in Excel.
-
How to connect and process Zoho Creator from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Creator.
-
Connect to CSV from PowerBuilder via ADO.NET
This article demonstrates how to access CSV/TSV Files from Appeon PowerBuilder using the CData ADO.NET Provider for CSV.
-
Integrate Zoho Projects with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Projects with External Services.
-
Automated Continuous Instagram Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Instagram replication to Google Cloud SQL.
-
Connect to Oracle SCM 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 SCM.
-
Query Bitbucket in ColdFusion
Write standard ColdFusion data access code to connect to Bitbucket.
-
Integrate Real-Time Access to Oracle Eloqua in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Eloqua in real time.
-
Integrating LangGraph with DocuSign via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on DocuSign within automated workflows.
-
Automated Continuous TaxJar Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable TaxJar replication to Microsoft Access.
-
Import Greenplum Using Azure Data Factory
Use CData Connect AI to connect to Greenplum from Azure Data Factory and import live Pivotal GreenPlum.
-
Work with Live Google Directory in Power Query
Use CData Connect AI to connect to Google Directory and work with live Google Directory in Microsoft Power Query.
-
How to Access Salesloft Using Entity Framework
This article shows how to access Salesloft using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
DataBind Avro to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Avro with the DevExpress Windows Forms and Web controls to provide Apache Avro to a chart.
-
Enable the Excel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Excel.
-
Write a Simple Go Application to work with LinkedIn Ads on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LinkedIn Ads.
-
Visualize Live SAP Business One in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business One.
-
Bind Live Vault CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Vault CRM data
-
Integrate with SAP Ariba Procurement using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Ariba Procurement to a JSON file on disk.
-
Getting Started with the CData SSIS Components for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Eloqua Reporting.
-
How to use SQLAlchemy ORM to access Zoho Books in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Books.
-
How to Connect DBeaver to Harvest via a JDBC Driver
Manage Harvest with visual tools in DBeaver like the query browser.
-
Load Redshift to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Redshift to a database.
-
Access Live Raisers Edge NXT in Coginiti Pro
Connect to and query live Raisers Edge NXT from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live ADP of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ADP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Dynamics 365 Business Central in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Query Live SAS xpt in Perplexity MacOS Desktop
Connect to and query live SAS xpt in Perplexity Desktop using the CData MCP Server.
-
Automated Continuous Phoenix Replication to SQLite
Use CData Sync for automated, continuous, customizable Phoenix replication to SQLite.
-
Publish Microsoft Project-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Project.
-
Connecting GenSpark with Workday via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Use the CData Software JDBC Driver for Sybase in MicroStrategy Web
Connect to Sybase in MicroStrategy Web using the CData Software JDBC Driver for Sybase.
-
Connect to Impala Using the Script Function in Claris FileMaker Pro
-