CData Software Knowledge Base

View Reports on Real-Time SharePoint in Power BI Report Server

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

Rapidly Develop xBase-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.

Building Dynamic Web Pages with Twitter Ads Using AngularJS

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

Access Live Blackbaud FE NXT in Google Sheets via Connect Cloud

Use CData Connect Cloud to gain access to live Blackbaud FE NXT from your Google Sheets.

How to Connect the Power BI Service to Avalara AvaTax: Complete Guide

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

Create a Data Access Object for Facebook using JDBI

A brief overview of creating a SQL Object API for Facebook in JDBI.

Automate PingOne Integration Tasks from PowerShell

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

Connect to Blackbaud FE NXT in CloverDX (formerly CloverETL)

Transfer Blackbaud FE NXT using the visual workflow in the CloverDX data integration tool.

How to connect PolyBase to Google Ad Manager

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Ad Manager.

Connect to Azure Synapse in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Azure Synapse and connect to Azure Synapse in Akorbi Digital RunMyProcess.

Automate Raisers Edge NXT Replication to SAP HANA

Use CData Sync to customize and automate Raisers Edge NXT replication to SAP HANA.

Publish Google Search-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Google Search.

Automated Continuous Dynamics NAV Replication to Databricks

Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Databricks.

Create Hive-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Hive from Klipfolio and build custom visualizations using live Apache Hive.

Stream SuiteCRM into Apache Kafka Topics

Access and stream SuiteCRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Load ShipStation to a Database Using Embulk

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

Use the CData API Server to Access QuickBooks Online in Microsoft PowerPivot

Use the CData API Server to connect to live QuickBooks Online in the Power Pivot business intelligence tool.

How to Seamlessly Import Clio Data into IBM SPSS Modeler

Integrate Clio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

Visualize Neo4J in TIBCO Spotfire through ADO.NET

Integrate Neo4J into dashboards in TIBCO Spotfire.

Query Sage 50 UK as a MySQL Database in Node.js

Execute MySQL queries against Sage 50 UK from Node.js.

Automated Continuous Shopify Replication to SingleStore

Use CData Sync for automated, continuous, customizable Shopify replication to SingleStore.

Connect to PingOne as an External Source in Dremio

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

Operational Reporting on Hive from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Apache Hive.

Connect to SAS xpt in Jaspersoft Studio

Execute SQL to remote SAS XPORT in Jaspersoft Studio.

Integrate with Tally in JReport Designer

Create charts and reports based on Tally ERP in JReport Designer.

Import Outreach.io Using Azure Data Factory

Use CData Connect Cloud to connect to Outreach.io from Azure Data Factory and import live Outreach.io.

Automated Klaviyo Replication to Teradata

Use CData Sync to Customize and automate Klaviyo replication to Teradata.

Consume Gmail OData Feeds in PowerBuilder

This article demonstrates how to consume Gmail as OData feeds from PowerBuilder using the API Server.

Use the CData API Server to Access JotForm in Microsoft PowerPivot

Use the CData API Server to connect to live JotForm in the Power Pivot business intelligence tool.

Connect to Wave Financial in DBArtisan

Use wizards in DBArtisan to configure Wave Financial as a data source.

Back Up Oracle Eloqua to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua data.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Workday

Provide connectivity to Workday through an SAP BusinessObjects universe.

Integrate Real-Time Access to HDFS in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache HDFS in real time.

Import SAP HANA into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to SAP HANA and provide access to live SAP HANA for custom reports in the Power BI Service.

Automated Continuous Teradata Replication to Oracle

Use CData Sync for automated, continuous, customizable Teradata replication to Oracle.

Connect to Airtable as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Airtable.

Connect to Calendly from Blazor Apps

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

Replicate Multiple PostgreSQL Accounts

Replicate multiple PostgreSQL accounts to one or many databases.

Analyze Excel in R via JDBC

Use standard R functions and the development environment of your choice to analyze Microsoft Excel with the CData JDBC Driver for Excel.

Connect to Salesforce Marketing as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Marketing Cloud.

Import Real-Time Neo4J via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Neo4J in ColdFusion.

Automate Presto Replication to Couchbase

Use CData Sync to Customize and automate Presto replication to Couchbase.

How to Work with CSV in AWS Glue Jobs Using JDBC

Connect to CSV from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

How to connect to Google Search Results with Squirrel SQL client

Connect to Google Search and execute queries in the Squirrel SQL Client.

Work with Live Cassandra in Power Query

Use CData Connect Cloud to connect to Apache Cassandra and work with live Apache Cassandra in Microsoft Power Query.

Visualize XML in TIBCO Spotfire through OData

Integrate XML Files into dashboards in TIBCO Spotfire.

How to connect SharePoint with DocuSign through external lists

Provide DocuSign to SharePoint users as an external list.

Operational Reporting on JDBC-ODBC Bridge from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote JDBC-ODBC Bridge.

Build Zoom-Connected Web Apps in Servoy

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

Analyze IBM Cloud Data Engine in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze IBM Cloud Data Engine in Microsoft R Open.

How to Query Live Power BI XMLA Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Power BI XMLA data in natural language using Python.

Analyze Google Analytics with Power Pivot

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

CData Software - Knowledge Base

Recent Articles