WhereScape RED can load data from Hadoop into an Oracle repository using Oracle's Big Data Connectors Oracle SQL Connector for Hadoop (OSCH) and Oracle Loader for Hadoop (OLH).
RED loads data from Hadoop using Oracle's Big Data connectors via a Hadoop connection on UNIX/Linux from which users can do script-based loads using the drag and drop functionality.
For more details about loading data from Hadoop after the connection is set up in RED, refer to Flat File Load and Flat File Load - Source Screen.
The following two sections describe the connection properties from within RED, using either the Oracle SQL Connector for Hadoop (OSCH) or the Oracle Loader for Hadoop (OLH) connectors.
To do loads from Oracle using the OSCH or OLH connectors, users will need to have the following system prerequisites before setting up a connection within RED:
- Oracle on Linux/Unix Hadoop tools installed on the Oracle Server and configured to connect to the Hadoop client.
- OLH installed.
- OSCH and/or OLH configured to connect to the Hadoop cluster and the Oracle database.
- Hadoop client installed.
- Oracle Wallet created and configured.
- For OSCH - Oracle Directory Objects configured for the database user
- User permissions
Note
For scheduler configuration settings for the database user refer to Unix Scheduler for Native Loads using Oracle's Big Data Connectors in the RED Installation Guide.