CData Software - Knowledge Base
Recent Articles
-
Connect to Azure Analysis Services in DBArtisan
Use wizards in DBArtisan to configure Azure Analysis Services as a data source.
-
Integrate Couchbase into Power Automate Desktop using CData Connect
CData Connect for Couchbase enables you to integrate Couchbase into workflows built using Microsoft Power Automate Desktop.
-
How to work with Microsoft Planner in Apache Spark using SQL
Access and process Microsoft Planner in Apache Spark using the CData Software JDBC Driver.
-
Seamlessly Bring Azure Data Lake Storage into Retool Using CData Connect AI
Integrate Azure Data Lake Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Explore Geographical Relationships in Snowflake with Power Map
Create data visualizations with Snowflake in Power Map.
-
Import and Visualize LDAP Objects in Power View
Create data visualizations based on LDAP in Excel.
-
How to update Kintone from Excel
This article explains how to transfer data from Excel to Kintone using the Excel Add-In for Kintone.
-
Validate SQL Analysis Services with QuerySurge
Access and validate SQL Analysis Services in QuerySurge using the CData JDBC Driver.
-
Connect to Google Directory in SpagoBI
Create reports featuring live Google Directory in SpagoBI Studio. Host Google Directory reports on SpagoBI Server.
-
Edit and Search Bullhorn CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Bullhorn CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Bullhorn CRM objects that you can access from apps and the dashboard.
-
Process & Analyze SFTP in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SFTP .
-
Integrate Live Oracle Service Cloud into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle Service Cloud from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle Service Cloud.
-
How to Use a Microsoft Access Database to Update Microsoft Teams in Real Time
Update Microsoft Teams data by creating a linked table in Microsoft Access with the CData Microsoft Teams ODBC Driver.
-
Connect to Oracle SCM in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle SCM and the SQL Gateway to access Oracle SCM from Google Apps Script.
-
Bridge Google Cloud Storage Connectivity with Apache NiFi
Access and process Google Cloud Storage in Apache NiFi using the CData JDBC Driver.
-
Access Live Salesforce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Jira Assets in Google Apps Script via SQL Gateway
Use the ODBC Driver for Jira Assets and the SQL Gateway to access Jira Assets from Google Apps Script.
-
Connect and Query Live MongoDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MongoDB into Databricks
-
Analyze Zoho Books in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Books and visualize live Zoho Books in Infragistics Reveal.
-
Query MailChimp from Node.js
Use the OData endpoint of the CData API Server to connect to your MailChimp and perform CRUD operations on MailChimp from Node.js.
-
ETL Microsoft Dataverse in Oracle Data Integrator
This article shows how to transfer Microsoft Dataverse (CDS) into a data warehouse using Oracle Data Integrator.
-
Connect to YouTube Analytics from AWS Glue
Use CData Connect AI to gain access to live YouTube Analytics from your AWS Glue jobs.
-
Publish Reports with Excel in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Excel.
-
Connect to Greenhouse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Greenhouse to connect to Greenhouse from Web applications running on WebLogic.
-
Connect to and Visualize Live Microsoft Teams in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Teams.
-
Automated Continuous Quickbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Quickbase replication to Snowflake.
-
Back Up Microsoft Excel to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel data.
-
Build Data Flows from SQL Server to Oracle Eloqua through SSIS
Easily push SQL Server data to Oracle Eloqua using the CData SSIS Tasks for Oracle Eloqua.
-
How to use SQLAlchemy ORM to access CockroachDB in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CockroachDB.
-
Connect to Google Campaign Manager 360 in RazorSQL
Connect to Google Campaign Manager 360 from wizards and query Google Campaign Manager 360 from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Tableau Connector for NetSuite
-