CData Software Knowledge Base

How to update Dropbox from Excel

This article explains how to transfer data from Excel to Dropbox using the Excel Add-In for Dropbox.

Extend Google Sheets with AlloyDB

Make calls to the API Server from Google Apps Script.

Automate Snowflake Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Snowflake and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

Analyze Backlog in Cognos Analytics

Use CData Connect Cloud to connect to Backlog from Cognos Analytics and analyze live Backlog.

How to Connect to Airtable in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Airtable. Leverage the pyodbc module for ODBC in Python.

How to Connect the Power BI Service to Sage Cloud Accounting: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Automated Continuous Sage Intacct Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Sage Intacct replication to OneLake in Microsoft Fabric.

Integrate with SAP Concur in JReport Designer

Create charts and reports based on SAP Concur in JReport Designer.

Automated Snapchat Ads Replication to Teradata

Use CData Sync to Customize and automate Snapchat Ads replication to Teradata.

Connect to Microsoft Project in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Publish Reports with Sugar CRM in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Sugar CRM.

Build Zendesk-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Zendesk and create custom apps in Mendix.

Build Data Flows from Drip to SQL Server using SSIS

Easily back up Drip to SQL Server using the SSIS components for Drip.

Connect to SFTP in the Denodo Platform

Use CData driver technologies to create a virtual data source for SFTP in the Denodo Virtual DataPort Administrator.

Import Bing Search Results into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Bing Search Results and provide access to live Bing Search for custom reports in the Power BI Service.

Access Live SharePoint in Excel 365 Online (Excel for the web)

Connect to Microsoft SharePoint from Excel 365 Online (Excel for the web) with CData Connect Cloud.

How to Import Data from Sugar CRM into Google Sheets

Import Sugar CRM into a Google spreadsheet that is automatically refreshed.

Create Oracle HCM Cloud-Connected Applications in Appsmith

Connect to Oracle HCM Cloud via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Oracle HCM Cloud.

Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Desktop

Connect to SuiteCRM in MicroStrategy Desktop using the CData Software ODBC Driver for SuiteCRM.

Model, Search, and Visualize Live Amazon DynamoDB in ThoughtSpot

Use CData Connect Cloud to connect to live Amazon DynamoDB for modeling, searching, and visualizing.

Analyze PostgreSQL in Cognos Analytics

Use CData Connect Cloud to connect to PostgreSQL from Cognos Analytics and analyze live PostgreSQL.

Integrate Oracle HCM Cloud into Power Automate Desktop using CData Connect

CData Connect for Oracle HCM Cloud enables you to integrate Oracle HCM Cloud into workflows built using Microsoft Power Automate Desktop.

LINQ to HBase

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the HBase Data Provider.

Build Visualizations of Oracle in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Database in Birst.

ETL HDFS in Oracle Data Integrator

This article shows how to transfer Apache HDFS into a data warehouse using Oracle Data Integrator.

Connect to HDFS in Google Apps Script via SQL Gateway

Use the ODBC Driver for HDFS and the SQL Gateway to access Apache HDFS from Google Apps Script.

Integrate Zoho Books into Power Automate Desktop using CData Connect

CData Connect for Zoho Books enables you to integrate Zoho Books into workflows built using Microsoft Power Automate Desktop.

Connect to Outreach.io from AWS Glue

Use CData Connect Cloud to gain access to live Outreach.io from your AWS Glue jobs.

Access Dropbox from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Dropbox from HeidiSQL.

How to Build an ETL App for Microsoft Dataverse in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Dataverse (CDS) in Python with petl.

Visualize Live Sage 200 in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Sage 200 into custom reports in Power BI.

Connect to Basecamp as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Basecamp.

Use the CData ODBC Driver for Sugar CRM in Microsoft Power Query

You can use the CData Sugar CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sugar CRM into Microsoft Power Query.

Integrate with Excel using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Excel to a JSON file on disk.

Add ConstantContact to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for ConstantContact with the Informatica Enterprise Data Catalog to classify and organize data.

PowerShell Scripting to Replicate Google Spanner to MySQL

Write a simple PowerShell script to replicate Google Spanner to a MySQL database.

Connect to Oracle Financials Cloud in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Use the CData Software JDBC Driver for Veeva Vault in MicroStrategy Desktop

Connect to Veeva Vault & Vault CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Veeva Vault.

Replicate Multiple Zoho Creator Accounts via the CData Sync CLI

Replicate multiple Zoho Creator accounts to one or many databases.

Analyze Live CockroachDB in SAS Viya

Use CData Connect Cloud to connect to CockroachDB from SAS Viya and deploy self-service analytics using live CockroachDB.

Build Charts with Excel Online in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Excel Online in Clear Analytics.

Build Google Ads-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Google Ads and build web apps with connectivity to live Google Ads.

Migrating data from Salesforce Pardot to Snowflake using CData SSIS Components.

Easily push Salesforce Pardot to Snowflake using the CData SSIS Tasks for Salesforce Pardot and Snowflake.

Create SSAS Tabular Models from BigQuery

How to build a SQL Server Analysis Service Tabular Model from Google BigQuery using CData drivers.

Query Sage Cloud Accounting as a SQL Server Database in Node.js

Execute SQL Server queries against Sage Business Cloud Accounting from Node.js.

How to import Highrise into Apache Solr

Use the CData Software JDBC Driver for Highrise in Data Import Handler and create an automated import of Highrise CRM to Apache Solr Enterprise Search platform.

Publish Crystal Reports on QuickBooks Time

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date QuickBooks Time.

Connect to SAS Data Sets in SpagoBI

Create reports featuring live SAS Data Sets in SpagoBI Studio. Host SAS Data Sets reports on SpagoBI Server.

Connect to Google Contacts from a Connection Pool in WebLogic

Use the CData JDBC Driver for Google Contacts to connect to Google Contacts from Web applications running on WebLogic.

How to Import Data from Cassandra into Google Sheets

Import Apache Cassandra into a Google spreadsheet that is automatically refreshed.

Build Charts with ActiveCampaign in Clear Analytics

Create dynamic charts and perform analytics based on ActiveCampaign in Clear Analytics.

Automate SharePoint Excel Services Replication to Azure Data Lake

Use CData Sync to customize and automate SharePoint Excel Services replication to Azure Data Lake.

Write a Simple Go Application to work with SAP HANA XS Advanced on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP HANA XS Advanced.

CData Software - Knowledge Base

Recent Articles