CData Software - Knowledge Base
Recent Articles
-
Back Up Airtable to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Airtable. In this article, we will employ an SSIS workflow to populate a database with Airtable data.
-
Connecting GenSpark with Snowflake 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.
-
Extract, Transform, and Load PayPal in Informatica PowerCenter
Create a simple Workflow for PayPal in Informatica PowerCenter.
-
Import SharePoint into the Power BI Service for Visualizations
Use CData Connect AI to connect to SharePoint and provide access to live Microsoft SharePoint for custom reports in the Power BI Service.
-
Use the CData ODBC Driver for Smartsheet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Smartsheet to connect to Smartsheet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Smartsheet in Excel.
-
Creating SAP HANA-Connected Applications in Unqork
You can use CData Connect AI to feed SAP HANA to Unqork and build custom business apps.
-
How to work with Kintone in Apache Spark using SQL
Access and process Kintone in Apache Spark using the CData Software JDBC Driver.
-
Create Twilio-Connected Dashboards in Grafana
Connect to Twilio via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twilio.
-
Build Adobe Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Analytics and create custom apps in Mendix.
-
Visualize SAP in TIBCO Spotfire through OData
Integrate SAP ERP/NetWeaver into dashboards in TIBCO Spotfire.
-
Visualize Live Slack in the Power BI Service
Use CData Connect AI to connect to live Slack and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a PostgreSQL Interface for Phoenix using the CData JDBC Driver
Use the Remoting features of the Phoenix JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with ADP using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ADP to a JSON file on disk.
-
Automated Continuous Google Campaign Manager 360 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SingleStore.
-
DataBind Controls to Trello in Delphi
DataBind to Trello in Delphi with standard data access components and controls.
-
Consume HubSpot OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HubSpot feeds that reflect any changes in SAP Lumira.
-
Analyze Kintone in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Kintone and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Replicate EventBrite from PowerShell
Write a quick PowerShell script to query Eventbrite. Use connectivity to the live data to replicate Eventbrite to SQL Server.
-
Automated Continuous Sage 300 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon Redshift.
-
Build Automated Workflows with Live Azure Analysis Services in Workato
Use CData Connect AI to connect to live Azure Analysis Services and build automated workflows in Workato.
-
Publish Crystal Reports on PayPal
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PayPal.
-
Query Google Search Results as a MySQL Database in Node.js
Execute MySQL queries against Google Search from Node.js.
-
How to Connect to Live Google Directory 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 Google Directory without replication.
-
Automated Continuous CockroachDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable CockroachDB replication to SingleStore.
-
Build Semantic Layer Views for Twilio in APOS Live Data Gateway
Use the CData Connector for Twilio in APOS Live Data Gateway to build Semantic Layer Views for Twilio.
-
Automated Continuous CouchDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon S3.
-
Access Live Shippo in AWS Lambda
Connect to live Shippo in AWS Lambda using the CData JDBC Driver.
-
Connect to FHIR 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 FHIR.
-
Use the CData Software JDBC Driver for Act CRM in MicroStrategy Desktop
Connect to Act CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Act CRM.
-
Automate Azure Data Lake Storage Replication to Azure Synapse
Use CData Sync to customize and automate Azure Data Lake Storage replication to Azure Synapse.
-
Getting Started with the CData Excel Add-In for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Hybris C4C.
-
Write a Simple Go Application to work with Salesforce on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce & Force.com.
-
Connect to Asana Using the Script Function in Claris FileMaker Pro
-