Install Oracle NoSQL Database Analytics Integrator
Prerequisites
- You need to have Java 11 or higher.
- Sign up for an account on the Oracle Cloud Infrastructure. See Oracle Cloud Infrastructure - Signup for more details.
- Create a Compute Instance from which the Oracle NoSQL Database Analytics Integrator can be installed and executed. See Compute Instance for more information.
- Create one or more tables in the Oracle NoSQL Database Cloud Service and populate those tables with data. See Create and populate a NoSQL table for more details.
- Create a bucket in OCI Object Storage. See Create a bucket in object Storage for more details.
- Create a database in the Oracle Autonomous Data Warehouse (ADW). See Create a database in the Autonomous Data Warehouse for more details.
- Download and install the client credentials (wallet) needed to establish a secure connection to the ADW database. See Install credentials needed for a secure database connection for more details.
- If you wish to employ user-to-service based authentication instead of service-to-service based authentication (via the OCI Resource Principal), then generate an authorization token to facilitate authentication of the ADW database with Object Storage. See Generate an authorization token for Object Storage for more details .
- Enable/store the credential the ADW database should use to access the objects in Object Storage - that is, either enable the OCI Resource Principal Credential or Store/Enable the User's Object Storage AUTH_TOKEN in the ADW Database. See Enable the OCI Resource Principal Credential or Store/Enable the User's Object Storage AUTH_TOKEN in the ADW Database for more details.
- Create a Dynamic group for the Compute Instance and (optionally) the ADW database. See Create a Dynamic Group for the Compute Instance and optionally the ADW Database for more details.
- Create a Policy with Appropriate Permissions for the Dynamic Group. See Create a Policy with appropriate permissions for the dynamic group for more details.
After you have satisfied all of the prerequisites for using the Oracle NoSQL Database Analytics Integrator, you can then install and configure the utility. You can then execute the utility to copy the contents of your tables in the NoSQL Cloud Service to the Autonomous Data Warehouse so that you can analyze the data using Oracle Analytics.
Installation
You can download the Oracle NoSQL Database Analytics Integrator from Oracle Technology
Network.You can install it in the desired compute environment; which can be
an Oracle Cloud Compute Instance or your own local environment, outside of the Oracle
Cloud. The utility’s installation package is provided as either a compressed tar file or
a zip file; for example, nosqlanalytics-<version>.tar.gz or
nosqlanalytics-<version>.zip. If you decide to install the
utility on an Oracle Cloud Compute Instance, then after downloading the desired
installation package, you should remote copy that package to the compute instance.
scp ~/Downloads/nosqlanalytics-1.0.1.zip opc@<public-ip-address>:/home/opc
ssh opc@<public-ip-address>
unzip nosqlanalytics-1.0.1.zip/home/opc/nosqlanalytics-1.0.1.
Note:
If you install the utility on an Oracle Cloud Compute instance, then the utility can be executed using either your own security credentials or an Oracle Cloud Instance Principal. But if you install the utility outside of the Oracle Cloud Infrastructure for testing purposes, then you must use your own Oracle Cloud security credentials to run the utility. You should execute the utility from your local environment only when the NoSQL tables that you want to copy are small in size.Related Topics