CData Software Knowledge Base

How to Visualize Sugar CRM Data in Python with pandas

Use pandas and other modules to analyze and visualize live Sugar CRM in Python.

Analyze Act-On in R via JDBC

Use standard R functions and the development environment of your choice to analyze Act-On with the CData JDBC Driver for Act-On.

Connect to Facebook Ads from HeidiSQL

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

Integrate with live Instagram in Jitterbit

Use CData Connect Cloud to connect to and integrate live Instagram in Jitterbit.

LDAP Reporting in OBIEE with the LDAP JDBC Driver

Deploy the LDAP JDBC driver on OBIEE to provide real-time reporting across the enterprise.

How to Connect to Twilio in Using Python: 6 Steps

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

Access Google Sheets as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Sheets from your Oracle system.

Connect to Amazon DynamoDB in RapidMiner

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

Provide OData Services of SAP HANA from a WCF Application

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

Connect to Instagram in RapidMiner

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

Prepare, Blend, and Analyze Splunk in Alteryx Designer (Connect Cloud)

Build workflows to access live Splunk for self-service data analytics.

Build MVC Applications with Connectivity to WooCommerce

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

Connect to Google Spanner in RapidMiner

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

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

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

How to Work with SAP in ETL Validator JDBC

Connect to SAP from ETL Validator jobs using the CData Software JDBC Driver.

Replicate Drip to Multiple Databases

Replicate Drip to disparate databases with a point-and-click configuration.

Integrate SingleStore in Pentaho Data Integration

Build ETL pipelines based on SingleStore in the Pentaho Data Integration tool.

Connect to PayPal in the Denodo Platform

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

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Snapchat Ads

Provide connectivity to Snapchat Ads through an SAP BusinessObjects universe.

Visualize SAP SuccessFactors in Tableau

The CData ODBC driver for SAP SuccessFactors enables you integrate SAP SuccessFactors into Tableau dashboards.

Connect to IBM Cloud Data Engine from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time IBM Cloud Data Engine using standard SQL.

Connect to JSON Services in RazorSQL

Connect to JSON from wizards and query JSON from the GUI in the RazorSQL database management tool.

Access Live Google Contacts in Google Sheets via Connect Cloud

Use CData Connect Cloud to gain access to live Google Contacts from your Google Sheets.

Analyze Oracle Sales in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Oracle Sales and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Access Zoho Creator from MySQL in Amazon QuickSight

Connect to Zoho Creator and build visualizations of Zoho Creator using a MySQL Connection in Amazon QuickSight.

Build Amazon DynamoDB-Connected Web Apps in Servoy

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

Viewing Sage 200 in RAD Studio Data Explorer

How to view Sage 200 in RAD Studio Data Explorer using the CData ODBC Driver for Sage 200.

Build Dashboards with Sage 200 in DBxtra

Create dynamic dashboards and perform analytics based on Sage 200 in DBxtra.

Using the CData Software ODBC Driver for Power BI XMLA in PyCharm

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

ETL Airtable in Oracle Data Integrator

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

Import RSS Feeds into Microsoft Power Query

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

Import SAP Hybris C4C into the Power BI Service for Visualizations

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

How to Build an ETL App for Paylocity in Python with CData

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

Connect to HubSpot from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HubSpot, and over 250 other data sources, right inside your Excel and Google spreadsheets!

Connect to Klipfolio in HULFT Integrate

Connect to Klipfolio as a JDBC data source in HULFT Integrate

Add SuiteCRM to Informatica Enterprise Data Catalog

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

Analyze LinkedIn in SAP Analytics Cloud

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

Query SAS Data Sets in ColdFusion

Write standard ColdFusion data access code to connect to SAS Data Sets.

Connect to HBase in JRuby

Create a simple JRuby app with access to live Apache HBase.

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.

Consume Box OData Feeds in PowerBuilder

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

Visualize PayPal in Tableau

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

Create a Data Access Object for eBay Analytics using JDBI

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

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

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

Automate Spark Integration Tasks from PowerShell

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

CData Software - Knowledge Base

Recent Articles