CData Software - Knowledge Base
Recent Articles
-
Connect to Lakebase from PowerBuilder via JDBC
This article demonstrates how to access Lakebase from PowerBuilder using the Lakebase JDBC Driver.
-
Connect to Printful in the Denodo Platform
Use CData driver technologies to create a virtual data source for Printful in the Denodo Virtual DataPort Administrator.
-
How to connect to CouchDB from IntelliJ
Integrate connectivity to Apache CouchDB with wizards in IntelliJ.
-
Create Dynamic Adobe Commerce Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Commerce to Infragistics XamDataGrid to build dynamic grids.
-
Create SharePoint-Connected Business Apps in AppSheet
Connect to SharePoint via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft SharePoint.
-
A PostgreSQL Interface for Google Calendar using the CData ODBC Driver
Use the SQL Gateway and Google Calendar ODBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze MailChimp in Alteryx Designer (ODBC)
Build workflows to access live MailChimp for self-service data analytics.
-
Integrate NetSuite in Pentaho Data Integration
Build ETL pipelines based on NetSuite CRM & ERP in the Pentaho Data Integration tool.
-
Prepare, Blend, and Analyze Azure Active Directory in Alteryx Designer (ODBC)
Build workflows to access live Azure Active Directory for self-service data analytics.
-
Create Microsoft Teams-Connected Applications in Appsmith
Connect to Microsoft Teams via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Teams.
-
Automated Continuous Box Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Box replication to IBM DB2.
-
Access Live Dynamics CRM in Coginiti Pro
Connect to and query live Microsoft Dynamics CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Quickbase 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 Quickbase.
-
Automate Google Sheets Replication to SAP HANA
Use CData Sync to customize and automate Google Sheets replication to SAP HANA.
-
Process & Analyze Tally in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Tally .
-
Connect to DocuSign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from DocuSign, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Query Live Reckon Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Reckon data in natural language using Python.
-
Validate FTP with QuerySurge
Access and validate FTP Servers in QuerySurge using the CData JDBC Driver.
-
Access Shippo from MySQL in PHP
Connect to Shippo through the standard MySQL libraries in PHP.
-
Build Act CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act CRM and build Act CRM-connected web apps with Axios.
-
Automated Continuous Spark Replication to SQLite
Use CData Sync for automated, continuous, customizable Spark replication to SQLite.
-
Extend Google Sheets with Printful
Make calls to the API Server from Google Apps Script.
-
Connecting Mastra with Adobe Commerce via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Load ConstantContact to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ConstantContact to a database.
-
View Reports on Real-Time SAP ByDesign in Power BI Report Server
Use the CData ODBC Driver for SAP ByDesign to visualize SAP Business ByDesign in Power BI Desktop and then publish them to Power BI Report Server.
-
Publish Reports with Acumatica in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Acumatica ERP.
-
Automated Continuous Google Search Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Search replication to Amazon S3.
-
Build Semantic Layer Views for Snowflake in APOS Live Data Gateway
Use the CData Connector for Snowflake in APOS Live Data Gateway to build Semantic Layer Views for Snowflake.
-
Connect to Couchbase in ACL Analytics
Connect to Couchbase via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Couchbase.
-
How to Connect the Power BI Service to Redshift: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
DataBind Azure Active Directory to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Azure Active Directory with the DevExpress Windows Forms and Web controls to provide Azure Active Directory to a chart.
-
Import Redis into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Redis. In this article, you will use the OData format to import Redis into Microsoft Power Query.
-
Use ChatGPT to Talk to Your Zoho Creator via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Zoho Creator for you.
-
Integrate Office 365 in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Office 365 from Informatica Cloud.
-
Automated Continuous Sage Cloud Accounting Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to delimited files (CSV/TSV).
-
How to Work with Cassandra in AWS Glue Jobs Using JDBC
Connect to Cassandra from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ADO.NET Provider for QuickBooks Time
-