CData Software - Knowledge Base
Recent Articles
-
Query, Visualize, and Share live Splunk in Redash
Use CData Connect AI to connect to live Splunk in Redash for querying, visualizing, and sharing.
-
A PostgreSQL Interface for LinkedIn (MySQL Remoting via JDBC)
Use the Remoting features of the LinkedIn JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to pipe BigQuery to CSV in PowerShell
Use standard PowerShell cmdlets to access BigQuery tables.
-
Use the CData API Server to Access Bing Ads in Microsoft PowerPivot
Use the CData API Server to connect to live Bing Ads in the Power Pivot business intelligence tool.
-
Query Drift as a MySQL Database in Node.js
Execute MySQL queries against Drift from Node.js.
-
How to Create Power BI Visual Reports with Real-Time MailChimp
Use CData Power BI Connectors to visualize MailChimp in Power BI.
-
Build Semantic Layer Views for HCL Domino in APOS Live Data Gateway
Use the CData Connector for HCL Domino in APOS Live Data Gateway to build Semantic Layer Views for HCL Domino.
-
How to pipe Pinterest to CSV in PowerShell
Use standard PowerShell cmdlets to access Pinterest tables.
-
Automated Shippo Replication to Teradata
Use CData Sync to Customize and automate Shippo replication to Teradata.
-
Connect to Google Cloud Storage from PowerBuilder via ADO.NET
This article demonstrates how to access Google Cloud Storage from Appeon PowerBuilder using the CData ADO.NET Provider for Google Cloud Storage.
-
Analyze Dropbox in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dropbox with the CData JDBC Driver for Dropbox.
-
Access Live Oracle Service Cloud Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Service Cloud data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Live Spark in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Apache Spark SQL for you.
-
Getting Started with the CData SSIS Components for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon Marketplace.
-
How to connect to Twilio with Squirrel SQL client
Connect to Twilio and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on MariaDB
Create Python applications that use pandas and Dash to build MariaDB-connected web apps.
-
Build a Simple VCL Application for HubDB
How to build a simple VCL Application to view HubDB in RAD Studio using the CData ODBC Driver for HubDB.
-
Build Charts with Twitter in Clear Analytics
Create dynamic charts and perform analytics based on Twitter in Clear Analytics.
-
How to Access Databricks Using Entity Framework
This article shows how to access Databricks using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Microsoft Dataverse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Google BigQuery.
-
Integrating Gumloop with Greenplum via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Pivotal GreenPlum within automated workflows.
-
How to integrate Act CRM with Apache Airflow
Access and process Act CRM in Apache Airflow using the CData JDBC Driver.
-
Access Live Zoho Books in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Books from your Excel spreadsheets.
-
Analyze SAP Concur in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Concur and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
How to create Visio diagrams from Instagram
Automatically update Instagram with the changes you make to Visio master shapes.
-
Use Agno to Talk to Your ShipStation via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your ShipStation for you.
-
DataBind SAP to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SAP with the DevExpress Windows Forms and Web controls to provide SAP ERP/NetWeaver to a chart.
-
Automated Continuous Greenplum Replication to Vertica
Use CData Sync for automated, continuous, customizable Greenplum replication to Vertica.
-
Build Harvest-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Harvest and build web apps with connectivity to live Harvest.
-
Edit and Search Google Sheets External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Sheets objects that you can access from apps and the dashboard.
-
How to Visualize Excel Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Excel Online in Python.
-
Extend Google Sheets with Klipfolio
Make calls to the API Server from Google Apps Script.
-
Create Google Search-Connected Business Apps in AppSheet
Connect to Google Search Results via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Search.
-
Use the CData Software ODBC Driver for ActiveCampaign in SAS for Real-Time Reporting and Analytics
Connect to real-time ActiveCampaign in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ActiveCampaign.
-
Bidirectional Access to Dropbox from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Dropbox in Filemaker Pro for Mac or Windows.
-
Create Paylocity-Connected Dashboards in Grafana
Connect to Paylocity via CData Connect AI in Grafana and create custom business dashboards with real-time access to Paylocity.
-
Access Live Monday.com in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Monday.com from your Excel spreadsheets.
-
Integrate Trello with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Trello with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Trello.
-
How to Visualize SAP Ariba Procurement Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Ariba Procurement in Python.
-
Access Live SAP Fieldglass in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Fieldglass in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect Amazon QuickSight to Monday.com
Create a connection to Monday.com in CData Connect AI and insert Monday.com into Amazon QuickSight SPICE to build interactive dashboards.
-
Prepare, Blend, and Analyze Oracle Financials Cloud in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Financials Cloud for self-service data analytics.
-
Add NetSuite to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for NetSuite with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Zendesk into Blue Prism for Intelligent Robotic Process Automation (RPA)
-