CData Software Knowledge Base

Build MVC Applications with Connectivity to Excel

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel from an ASP.NET MVC application.

Create Presto-Connected Nintex Workflows

Use CData Connect Cloud to connect to Presto from Nintex Workflow Cloud and build custom workflows using live Presto.

How to Access TaxJar Using Entity Framework

This article shows how to access TaxJar using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Automated Continuous Cassandra Replication to IBM DB2

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

How to create Dynamics NAV federated tables in MySQL

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

Automated Continuous GitHub Replication to OneLake in Microsoft Fabric

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

Analyze Zenefits with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Zenefits from Power Pivot. You will use the Table Import Wizard to load Zenefits. You can visually build the import query or use any SQL supported by the driver.

How to create an RPA flow for Avalara AvaTax in UiPath Studio

Use the Avalara AvaTax ODBC Driver to create workflows that access real-time Avalara AvaTax without any coding.

How to connect PolyBase to HBase

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache HBase.

Use the CData Software JDBC Driver for Excel in MicroStrategy Desktop

Connect to Microsoft Excel in MicroStrategy Desktop using the CData Software JDBC Driver for Excel.

Create Twitter-Connected Business Apps in AppSheet

Connect to Twitter via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Twitter.

Connect to Xero as an External Source in Dremio

Use the CData JDBC Driver to connect to Xero as an External Source in Dremio.

DataBind Controls to Azure Data Catalog in C++Builder

DataBind to Azure Data Catalog in C++Builder with standard components and controls.

Automate Xero Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Xero Accounting from PowerShell? This article demonstrates how to utilize the Xero Cmdlets for tasks like connecting to Xero Accounting, automating operations, downloading data, and more.

Automated Continuous Epicor Kinetic Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Amazon Redshift.

How to connect to Azure Synapse from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Azure Synapse and work with Azure Synapse in Microsoft Excel on Mac OS X.

Analyze Microsoft Project in Looker

Use CData Connect Cloud to connect to Microsoft Project from Looker and build custom apps using live Microsoft Project.

Provide OData Services of Redshift from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Amazon Redshift by developing a WCF Service Application.

Build an OLAP Cube in SSAS from YouTube Analytics

Establish a connection to YouTube Analytics data from SQL Server Analysis Services, and use the YouTube Analytics Data Provider to build OLAP cubes for use in analytics and reporting.

Publish Sage 200-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Sage 200.

Create Dynamic RSS Grids Using the Infragistics XamDataGrid

Learn how you can connect RSS to Infragistics XamDataGrid to build dynamic grids.

How to Use CData Connect to Access Live Invoiced in Power Automate

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

Operational Reporting on Azure Table from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Azure Table Storage.

Extract, Transform, and Load Reckon Accounts Hosted in Informatica PowerCenter

Create a simple Workflow for Reckon Accounts Hosted in Informatica PowerCenter.

How to connect to Blackbaud FE NXT from IntelliJ

Integrate connectivity to Blackbaud FE NXT with wizards in IntelliJ.

How to create Google Ad Manager federated tables in MySQL

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

Explore Geographical Relationships in Google Analytics with Power Map

Create data visualizations with Google Analytics in Power Map.

Enable the Veeva Vault JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Veeva Vault & Vault CRM.

Automated Continuous Greenplum Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Greenplum replication to Azure SQL.

Connect to SAP Netweaver Gateway from a Connection Pool in WebLogic

Use the CData JDBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway from Web applications running on WebLogic.

Build Pipelines with Live Microsoft Teams in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Microsoft Teams from Google Cloud Data Fusion, enabling the integration of live Microsoft Teams into the building and management of effective data pipelines.

Create SingleStore 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 create Visio diagrams from Cassandra

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

Connect to SAP Hybris C4C in Google Apps Script via SQL Gateway

Use the ODBC Driver for SAP Hybris C4C and the SQL Gateway to access SAP Hybris C4C from Google Apps Script.

Automate Zoho Books Replication to Azure Data Lake

Use CData Sync to customize and automate Zoho Books replication to Azure Data Lake.

Connect to LDAP Objects in Ruby

Connect to LDAP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to connect to TaxJar from Spring Boot

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

Add Sage 300 to Informatica Enterprise Data Catalog

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

View Reports on Real-Time Oracle Eloqua in Power BI Report Server

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

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

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

Automated Continuous Parquet Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Parquet replication to Google Cloud SQL.

Query SAS xpt as a SQL Server in Node.js

Execute SQL Server queries against SAS XPORT from Node.js.

Use Dash to Build to Web Apps on Microsoft Exchange

Create Python applications that use pandas and Dash to build Microsoft Exchange-connected web apps.

Validate IBM Cloud Data Engine with QuerySurge

Access and validate IBM Cloud Data Engine in QuerySurge using the CData JDBC Driver.

Create Apps from GitHub in Qlik Sense Cloud

Use CData Connect Cloud to connect to GitHub and build apps from live GitHub in Qlik Sense Cloud.

Analyze Authorize.Net with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Authorize.Net from Power Pivot. You will use the Table Import Wizard to load Authorize.Net. You can visually build the import query or use any SQL supported by the driver.

Automated Continuous Clio Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Clio replication to Apache Kafka.

Connect to Salesforce in RapidMiner

Integrate Salesforce & Force.com with standard components and data source configuration wizards in RapidMiner Studio.

How to Query Live WooCommerce Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live WooCommerce data in natural language using Python.

Connect to ActiveCampaign from a Connection Pool in WebLogic

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

CData Software - Knowledge Base

Recent Articles