The CData Excel Add-In for HDFS models HDFS objects as relational tables and views. HDFS objects have relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to HDFS APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Key Features

• The add-in models HDFS entities such as files and permissions as relational views, allowing you to write SQL to query HDFS data.
• Stored procedures allow you to execute operations to HDFS
• Live connectivity to these objects means any changes to your HDFS account are immediately reflected when using the add-in.