CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for HubSpot in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HubSpot.
-
Query Zendesk as a SQL Server Database in Node.js
Execute SQL Server queries against Zendesk from Node.js.
-
Publish Instagram-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Instagram.
-
Using Mail Merge with Salesforce, SharePoint, or Google Contacts
The CData ODBC Drivers can be used from tools like Mail Merge in Microsoft Word to access live data from various sources (QuickBooks, Salesforce, SharePoint etc.). This article uses the CData ODBC Driver for Salesforce with Mail Merge, but this procedure can be follwoed for other CData ODBC drivers.
-
Automated Continuous Snapchat Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Google Cloud SQL.
-
How to Seamlessly Import Marketo Data into IBM SPSS Modeler
Integrate Marketo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Operational Reporting on Excel from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Excel.
-
Create YouTube Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to YouTube Analytics from Klipfolio and build custom visualizations using live YouTube Analytics.
-
Seamlessly Bring Amazon Athena into Retool Using CData Connect AI
Integrate Amazon Athena data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Getting Started with the CData Excel Add-In for BambooHR
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BambooHR.
-
Access Vault CRM as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Veeva Vault & Vault CRM from your Oracle system.
-
Connect and Visualize Live GraphQL Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live GraphQL into the Databricks platform and create visualization dashboards with real-time GraphQL.
-
Import Azure Data Lake Storage into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Data Lake Storage. In this article, you will use the OData format to import Azure Data Lake Storage into Microsoft Power Query.
-
Create Data Visualizations Based On DocuSign in Mode
Use CData Connect AI to connect to DocuSign from Mode and build visualizations using live
-
Visualize Salesforce in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Salesforce & Force.com into TIBCO Spotfire.
-
How to Connect to & Open SAP ByDesign in Microsoft Excel
This article uses the CData ODBC driver for SAP ByDesign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Data Flows from MailChimp to SQL Server using SSIS
Easily back up MailChimp to SQL Server using the SSIS components for MailChimp.
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy
Connect to Apache Parquet in MicroStrategy Developer using the CData Software JDBC Driver for Parquet.
-
Build Semantic Layer Views for Google Contacts in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Contacts.
-
Access Live FHIR in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FHIR from your Excel spreadsheets.
-
Excel Spreadsheet Automation on Oracle SCM with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software JDBC Driver for Calendly in MicroStrategy Desktop
Connect to Calendly in MicroStrategy Desktop using the CData Software JDBC Driver for Calendly.
-
Create Informatica Mappings From/To a JDBC Data Source for FHIR
Create FHIR data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live Avalara AvaTax from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Avalara AvaTax for you.
-
A PostgreSQL Interface for Cosmos DB (MySQL Remoting via JDBC)
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live MongoDB Using the Low-Code Development Platform of Mendix
-