CData Software - Knowledge Base
Recent Articles
-
Replicate Confluence to Multiple Databases via the CData Sync CLI
Replicate Atlassian Confluence to disparate databases with a single configuration.
-
Automated Continuous CouchDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CouchDB replication to delimited files (CSV/TSV).
-
Connect to Databricks 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 Databricks.
-
Automated Continuous Act-On Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Act-On replication to Amazon S3.
-
PowerShell Scripting to Replicate Box to MySQL
Write a simple PowerShell script to replicate Box to a MySQL database.
-
Excel Spreadsheet Automation on HarperDB with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
JSON Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on JSON facts in real time.
-
Process & Analyze HDFS in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HDFS .
-
Integrate PostgreSQL into Automated Tasks with Power Automate
Use CData Connect AI to connect to PostgreSQL and integrate live PostgreSQL into your Power Automate tasks.
-
Visualize Dynamics 365 in TIBCO Spotfire through OData
Integrate Microsoft Dynamics 365 into dashboards in TIBCO Spotfire.
-
Create OData Services with the Salesforce Data Provider
This article shows how to publish an OData feed of Saleforce data by creating a WCF Service Application. This article uses the ADO.NET Provider for Salesforce, but the same steps will work for any of the CData ADO.NET Providers.
-
Connect to Zoom in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
View Reports on Real-Time LDAP Objects in Power BI Report Server
Use the CData ODBC Driver for LDAP to visualize LDAP in Power BI Desktop and then publish them to Power BI Report Server.
-
Create a Data Access Object for Google Campaign Manager 360 using JDBI
A brief overview of creating a SQL Object API for Google Campaign Manager 360 in JDBI.
-
How to Connect to Live Cassandra in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache Cassandra without replication.
-
Extend Google Sheets with Spark
Make calls to the API Server from Google Apps Script.
-
Build Pipelines with Live Slack in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Slack from Google Cloud Data Fusion, enabling the integration of live Slack into the building and management of effective data pipelines.
-
How to Design SAP HANA Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Automated Continuous Amazon Marketplace Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to OneLake in Microsoft Fabric.
-
Automate TaxJar Replication to Azure Synapse
Use CData Sync to customize and automate TaxJar replication to Azure Synapse.
-
Working with Reckon Accounts Hosted in LINQPad
Execute LINQ queries to Reckon Accounts Hosted in LINQPad.
-
Replicate Microsoft OneLake to Multiple Databases via the CData Sync CLI
Replicate Microsoft OneLake to disparate databases with a single configuration.
-
Use Biml to Build SSIS Tasks to Replicate Sage Cloud Accounting to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage Business Cloud Accounting to SQL Server.
-
Replicate MailChimp to Multiple Databases via the CData Sync CLI
Replicate MailChimp to disparate databases with a single configuration.
-
LINQ to Oracle Eloqua
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 Oracle Eloqua Data Provider.
-
Trigger Databricks IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Access FHIR as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FHIR from your Oracle system.
-
LINQ to Smartsheet
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 Smartsheet Data Provider.
-
Connect to Dynamics 365 from a Connection Pool in Jetty
The Dynamics 365 JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dynamics 365 from Web apps in Jetty.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors for you.
-
Getting Started with the CData PowerShell Cmdlets for EnterpriseDB
-