CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for Hive in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Hive.
-
Creating Microsoft Project-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Project to Unqork and build custom business apps.
-
Automated Continuous Adobe Commerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to AlloyDB.
-
Connect to Adobe Analytics from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Analytics to connect to Adobe Analytics and execute queries in PowerBuilder.
-
Automate Raisers Edge NXT Replication to Azure Data Lake
Use CData Sync to customize and automate Raisers Edge NXT replication to Azure Data Lake.
-
Provide OData Services of Hive from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Hive by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Typeform in SAS for Real-Time Reporting and Analytics
Connect to real-time Typeform in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Typeform.
-
Access Salesforce in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Salesforce & Force.com.
-
Connect to Sage Cloud Accounting as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage Cloud Accounting as an External Source in Dremio.
-
Bind Live XML Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live XML data
-
Connect to SAP Business One in JRuby
Create a simple JRuby app with access to live SAP Business One.
-
Getting Started with the CData SSIS Components for Teradata
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teradata.
-
How to work with Azure Analysis Services in Apache Spark using SQL
Access and process Azure Analysis Services in Apache Spark using the CData Software JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP ByDesign
Create SAP ByDesign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Google Sheets in SpagoBI
Create reports featuring live Google Sheets in SpagoBI Studio. Host Google Sheets reports on SpagoBI Server.
-
Edit and Search External HubSpot Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of HubSpot to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create HubSpot objects that you can access from apps and the dashboard.
-
Build a Singer.io Tap for Azure Data Catalog With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Data Catalog data using
-
How to Connect to Live Dynamics CRM 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 Microsoft Dynamics CRM for you.
-
Replicate SingleStore to Multiple Databases via the CData Sync CLI
Replicate SingleStore to disparate databases with a single configuration.
-
DataBind Controls to EnterpriseDB in C++Builder
DataBind to EnterpriseDB in C++Builder with standard components and controls.
-
Consume Microsoft Dataverse OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Dataverse (CDS) as OData feeds from PowerBuilder using the API Server.
-
Build Cosmos DB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Cosmos DB.
-
Automated Continuous Aha! Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aha! replication to delimited files (CSV/TSV).
-
Connect to Email in CloverDX (formerly CloverETL)
Transfer Email using the visual workflow in the CloverDX data integration tool.
-
Create Datasets from Google Contacts in Domo Workbench and Build Visualizations of Google Contacts in Domo
Use the CData Software ODBC Driver for Google Contacts to create datasets from Google Contacts in Domo Workbench and then build visualizations in the Domo service.
-
Use Dash to Build to Web Apps on HubDB
Create Python applications that use pandas and Dash to build HubDB-connected web apps.
-
Query Outreach.io as a SQL Server Database in Node.js
Execute SQL Server queries against Outreach.io from Node.js.
-
Access Live ShipStation in Excel 365 Online (Excel for the web)
Connect to ShipStation from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connecting GenSpark with Splunk 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 hundreds of systems without any replication or custom integration required.
-
Integrating LangGraph with Zoho Creator via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Creator within automated workflows.
-
Connect to Blackbaud FE NXT in Google Apps Script via SQL Gateway
Use the ODBC Driver for Blackbaud FE NXT and the SQL Gateway to access Blackbaud FE NXT from Google Apps Script.
-
LINQ to ServiceNow
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 ServiceNow Data Provider.
-
Connect to ActiveCampaign in Jaspersoft Studio
Execute SQL to remote ActiveCampaign in Jaspersoft Studio.
-
Import PayPal into the Power BI Service for Visualizations
Use CData Connect AI to connect to PayPal and provide access to live PayPal for custom reports in the Power BI Service.
-
Upsert Salesforce Data Using External Id in SSIS
Upsert Salesforce Data Using External Id in SSIS.
-
Access Oracle Sales from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Sales from HeidiSQL.
-
Stream Reckon Accounts Hosted into Apache Kafka Topics
Access and stream Reckon Accounts Hosted in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Email in ETL Validator JDBC
Connect to Email from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous SAS xpt Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable SAS xpt replication to Microsoft Access.
-
Create Oracle Sales-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Sales from Klipfolio and build custom visualizations using live Oracle Sales.
-
Getting Started with the CData PowerShell Cmdlets for Greenhouse
-