CData Software Knowledge Base

Provide OData Services of eBay Analytics from a WCF Application

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

Connect to OneNote in the Denodo Platform

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

Visualize SharePoint Excel Services from Tableau

Use the Tableau Desktop business intelligence tool to connect to SharePoint Excel Services.

Integrate Tableau CRM Analytics in Pentaho Data Integration

Build ETL pipelines based on Tableau CRM Analytics in the Pentaho Data Integration tool.

Publish Reports with SAS xpt in SAP Crystal Reports

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

Using the CData Software ODBC Driver for Pipedrive in PyCharm

Connect to Pipedrive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pipedrive.

Automated Continuous Salesforce Replication to Apache Kafka

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

Automated Continuous QuickBooks Online Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google BigQuery.

Connect to SAP HANA XS Advanced in DBArtisan

Use wizards in DBArtisan to configure SAP HANA XS Advanced as a data source.

Automated Continuous Google Ad Manager Replication to SQL Server

Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQL Server.

How to Query Procore in MySQL Workbench

Execute MySQL queries against live Procore from MySQL Workbench.

Query Amazon DynamoDB in DataGrip

Create a Data Source for Amazon DynamoDB in DataGrip and use SQL to query live Amazon DynamoDB.

Import Sage 200 into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 200. In this article, you will use the OData format to import Sage 200 into Microsoft Power Query.

Integrate with Live Confluence in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Confluence from the MuleSoft Anypoint Platform to integrate live Atlassian Confluence into custom reports and dashboards.

Use the CData Software JDBC Driver for Presto in MicroStrategy

Connect to Presto in MicroStrategy Developer using the CData Software JDBC Driver for Presto.

DataBind Controls to AlloyDB in Delphi

DataBind to Google AlloyDB in Delphi with standard data access components and controls.

Use the CData Software JDBC Driver for Google Cloud Storage in MicroStrategy Web

Connect to Google Cloud Storage in MicroStrategy Web using the CData Software JDBC Driver for Google Cloud Storage.

Create Apps from SurveyMonkey in Qlik Sense Cloud

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

Consume Trello OData Feeds in PowerBuilder

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

Connect to Excel Online in Aqua Data Studio

Access Microsoft Excel Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Manage Twitter in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Twitter.

Access Azure Analysis Services from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Azure Analysis Services from HeidiSQL.

Create Power BI Reports on Real-Time Dynamics 365 Business Central

Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central in Power BI Desktop.

Analyze SAP Concur in R via JDBC

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

Migrating data from Facebook to Databricks using CData SSIS Components.

Easily push Facebook to Databricks using the CData SSIS Tasks for Facebook and Databricks.

Connect to BambooHR in RapidMiner

Integrate BambooHR with standard components and data source configuration wizards in RapidMiner Studio.

Analyze Slack in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Slack and visualize Slack in SAP Analytics Cloud.

Connect to Reckon from PowerBuilder via ADO.NET

This article demonstrates how to access Reckon from Appeon PowerBuilder using the CData ADO.NET Provider for Reckon.

Automated Continuous NetSuite Replication to Apache Kafka

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

Use CData Connect Cloud to Access FHIR in Microsoft Power Pivot

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

Connect to Tally in RapidMiner

Integrate Tally ERP with standard components and data source configuration wizards in RapidMiner Studio.

Connect to NetSuite as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live NetSuite CRM & ERP.

Integrate Exact Online into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Exact Online and integrate live Exact Online into your Power Automate tasks.

Design BIRT Reports on Salesforce Pardot

Provide current Salesforce Pardot to your embedded analytics.

Visualize WooCommerce in TIBCO Spotfire through ODBC

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

Create SendGrid-Connected Business Apps in AppSheet

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

How to connect to Amazon Athena with Squirrel SQL client

Connect to Amazon Athena and execute queries in the Squirrel SQL Client.

Extract, Transform, and Load Kintone in Informatica PowerCenter

Create a simple Workflow for Kintone in Informatica PowerCenter.

Integrate Live Square into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Square and integrate live Square into apps built in Microsoft Power Apps.

Visualize SQL Server in Tableau

The CData ODBC driver for SQL Server enables you integrate Microsoft SQL Server into Tableau dashboards.

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

Discover multiple ways to connect and use Todoist from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

Replicate CockroachDB in Heroku for Use in Salesforce Connect

Replicate CockroachDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Create a Data Access Object for Greenhouse using JDBI

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

Load BigQuery to a Database Using Embulk

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

How to integrate Metabase with Spark

Use CData Connect Cloud to connect to live Apache Spark SQL and create an interactive dashboard in Metabase from Apache Spark SQL.

Visualize Live Shopify in Tableau

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

CData Software - Knowledge Base

Recent Articles