This topic describes the required settings for connections using the WhereScape Big Data Adapter (BDA).
The WhereScape Big Data Adapter (BDA) is designed as an adapter to RED, focused on executing ELT related processing within the Hadoop/Hive eco-system. For more information about the initial BDA setup, overview of BDA, the prerequisites and step-by-step instructions to set up BDA, refer to the BDA section of the WhereScape RED Installation Guide. The BDA connection settings are always visible on both Hive and Hadoop connection types, which include the BDA server settings.
BDA settings are also displayed for any other database connection types if there is a Hive or Hadoop connection in the data warehouse, but these will only have the JDBC settings displayed.
Important
A Hive connection must exist before BDA settings (Connection > Properties > Big Data Adapter Settings) appear in other database connections.
BDA enables RED to use Sqoop as the load method to load data from Hive and HDFS into the data warehouse and also to load data into Hive as a target.
Only one BDA server connection is supported per Metadata repository.