CData Software Knowledge Base

Build Twilio-Connected Web Apps in Servoy

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

Connect to PostgreSQL from HeidiSQL

Use CData Connect Cloud to connect to and query live PostgreSQL from HeidiSQL.

Migrating data from Twitter to Snowflake using CData SSIS Components.

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

Build Shopify-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Shopify.

Automate Azure Active Directory Replication to Couchbase

Use CData Sync to Customize and automate Azure Active Directory replication to Couchbase.

Use CData Connect Cloud to Access Bullhorn CRM in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Bullhorn CRM in the Power Pivot business intelligence tool.

How to publish and share QuickBooks Time dashboards with Tableau Server

The CData ODBC driver for QuickBooks Time enables you integrate QuickBooks Time into Tableau dashboards.

Connect to Google Directory in ACL Analytics

Connect to Google Directory via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Google Directory.

Seamlessly Bring Google Calendar into Retool Using CData Connect Cloud

Integrate Google Calendar data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

How to connect to IBM Cloud Object Storage in DBVisualizer

Integrate IBM Cloud Object Storage with visual data analysis tools and data connection wizards in DBVisualizer

How to Build an ETL App for Zoho Projects in Python with CData

Create ETL applications and real-time data pipelines for Zoho Projects in Python with petl.

Building Dynamic Web Pages with MarkLogic Using AngularJS

Create single-page applications with live connectivity to MarkLogic using the CData API Server.

How to update SQLite from Excel

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

Visualize Live PostgreSQL in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live PostgreSQL.

How to create Azure Analysis Services federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Analysis Services in MySQL .

Validate Facebook Ads with QuerySurge

Access and validate Facebook Ads in QuerySurge using the CData JDBC Driver.

Migrating data from Microsoft Project to Google BigQuery using CData SSIS Components.

Easily push Microsoft Project to Google BigQuery using the CData SSIS Tasks for Microsoft Project and Google BigQuery.

Rapidly Develop MongoDB-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

Visualize Shopify in Sisense

Create an ElastiCube in Sisense app with access to Shopify.

Create Reports with WordPress in SAP Crystal Reports

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

Extend Google Sheets with QuickBooks Time

Make calls to the API Server from Google Apps Script.

Replicate Procore from PowerShell

Write a quick PowerShell script to query Procore. Use connectivity to the live data to replicate Procore to SQL Server.

How to connect to Redis with Squirrel SQL client

Connect to Redis and execute queries in the Squirrel SQL Client.

How to Connect to Azure Analysis Services in Using Python: 6 Steps

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

Visualize Instagram in TIBCO Spotfire through ADO.NET

Integrate Instagram into dashboards in TIBCO Spotfire.

How to connect to Calendly from Spring Boot

Connect to Calendly in a Spring Boot Application using CData JDBC Calendly Driver

How to Access Live Authorize.Net in Power Automate Desktop via ODBC

The CData ODBC Driver for Authorize.Net enables you to integrate Authorize.Net into workflows built using Microsoft Power Automate Desktop.

Extend Google Sheets with MySQL

Make calls to the API Server from Google Apps Script.

Trigger Wave Financial IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

Integrate with Monday.com using Apache Camel2

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

Add Aha to Informatica Enterprise Data Catalog

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

Automated Continuous Google Ads Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Google Ads replication to Amazon S3.

Connect to Live Microsoft Teams in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Microsoft Teams in CData Connect Cloud and connect to your Microsoft Teams from PostgreSQL.

Create CockroachDB Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

How to Import Data from Freshdesk into Google Sheets

Import Freshdesk into a Google spreadsheet that is automatically refreshed.

Connect to Office 365 from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Office 365 using standard SQL.

Build Dashboards with Bullhorn CRM in DBxtra

Create dynamic dashboards and perform analytics based on Bullhorn CRM in DBxtra.

Create Yahoo! Japan Data Solution-Connected Dashboards in Grafana

Connect to Yahoo! Japan Data Solution via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Yahoo! Japan Data Solution.

Connect to Paylocity in DBeaver

Use the CData ODBC Driver to connect to Paylocity in DBeaver.

Establish a Live Connection with TigerGraph using Tableau Bridge

The CData ODBC Driver for TigerGraph enables you to integrate live TigerGraph into Tableau Cloud dashboards using the Tableau Bridge.

Build a Singer.io Tap for Dynamics CRM With the CData Python Connector

Learn how to easily build a Singer.io Tap for live Dynamics CRM data using

How to create Visio diagrams from HBase

Automatically update Apache HBase with the changes you make to Visio master shapes.

Access Dynamics 365 in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Dynamics 365.

Automated Continuous GitHub Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable GitHub replication to Microsoft Access.

Use the CData Software JDBC Driver for NetSuite in MicroStrategy

Connect to NetSuite CRM & ERP in MicroStrategy Developer using the CData Software JDBC Driver for NetSuite.

Create Data Visualizations in Cognos BI with Cassandra

Access Apache Cassandra as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Write a Simple Go Application to work with Azure Data Lake Storage on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Lake Storage.

Automated Continuous Xero Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.

Bind Live EventBrite Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live EventBrite data

Load Microsoft Project to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Project to a database.

Choosing the Best Method to Connect Microsoft Dataverse to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Microsoft Dataverse (CDS) from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

Use CData Connect Cloud to Access Google Spanner in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Google Spanner in the Power Pivot business intelligence tool.

Create Amazon S3-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Amazon S3 from Klipfolio and build custom visualizations using live Amazon S3.

Connect to Phoenix in HULFT Integrate

Connect to Phoenix as a JDBC data source in HULFT Integrate

How to connect to Avalara AvaTax from IntelliJ

Integrate connectivity to Avalara AvaTax with wizards in IntelliJ.

View Reports on Real-Time Monday.com in Power BI Report Server

Use the CData ODBC Driver for Monday.com to visualize Monday.com in Power BI Desktop and then publish them to Power BI Report Server.

How to Connect DBeaver to LinkedIn Ads via a JDBC Driver

Manage LinkedIn Ads with visual tools in DBeaver like the query browser.

Feed IBM Cloud Object Storage into FineReport

How to set IBM Cloud Object Storage as a JDBC data source in FineReport.

Integrate Real-Time Access to Google Campaign Manager 360 in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Campaign Manager 360 in real time.

Replicate Multiple Power BI XMLA Accounts via the CData Sync CLI

Replicate multiple Power BI XMLA accounts to one or many databases.

Use the CData Software JDBC Driver for Oracle Eloqua in MicroStrategy Desktop

Connect to Oracle Eloqua in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Eloqua.

How to Connect the Power BI Service to Zuora: Complete Guide

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

Replicate ActiveCampaign from PowerShell

Write a quick PowerShell script to query ActiveCampaign. Use connectivity to the live data to replicate ActiveCampaign to SQL Server.

Natively Connect to Oracle HCM Cloud in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Oracle HCM Cloud. Leverage the native support for ODBC in PHP.

How to create CockroachDB federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for CockroachDB in MySQL .

A PostgreSQL Interface for HubSpot using the CData ODBC Driver

Use the SQL Gateway and HubSpot ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Bullhorn CRM in HULFT Integrate

Connect to Bullhorn CRM as a JDBC data source in HULFT Integrate

Visualize ConstantContact in TIBCO Spotfire through ADO.NET

Integrate ConstantContact into dashboards in TIBCO Spotfire.

Integrate Google Spanner with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Google Spanner with External Services.

Model SAP Ariba Procurement Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and SAP Ariba Procurement, enabling the direct import of real-time SAP Ariba Procurement.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Vault CRM

Provide connectivity to Veeva Vault & Vault CRM through an SAP BusinessObjects universe.

Visualize Snowflake in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Snowflake into TIBCO Spotfire.

Integrate Oracle Sales into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Oracle Sales and integrate live Oracle Sales into your Power Automate tasks.

CData Software - Knowledge Base

Recent Articles