Getting Started with Oracle NoSQL Database Analytics Integrator

Oracle NoSQL Database Analytics Integrator copies data located in a NoSQL Database Cloud Service table to a database created in the Oracle Autonomous Data Warehouse Cloud Service.

Related Topics

Overview of Oracle NoSQL Database Analytics Integrator

After storing data in the Oracle NoSQL Database Cloud Service you may want to analyze that data using Oracle Analytics; either the cloud-based or the desktop version. Because Oracle Analytics does not currently support Oracle NoSQL Database Cloud Service as a data source, the Oracle NoSQL Database Analytics Integrator can be used to copy data from Oracle NoSQL Database Cloud Service tables to corresponding tables in the Oracle Autonomous Data Warehouse Cloud Service (ADW). Once data from a NoSQL table is copied to the ADW database, all of the tools provided by Oracle Analytics can be used to visualize and analyze that data.

Once you complete the prerequisites for using the Oracle Cloud Infrastructure services, you can install the utility, configure it and execute from the command line of an Oracle Cloud Compute Instance, or even from your local environment.

Download the Oracle NoSQL Database Analytics Integrator from the Oracle Technology Network and install it in the desired compute environment. Once installed, you then have all the classes needed to copy data from the Oracle NoSQL Database Cloud Service to a database in the Oracle Autonomous Data Warehouse.

Typical Workflow for Using Oracle NoSQL Database Analytics Integrator

Table - Analytics Integrator Workflow

Task Description More Information
Create OCI account Sign up for an account on the Oracle Cloud Infrastructure Oracle Cloud Infrastructure - Signup
Create a Compute Instance Create a Compute Instance from which the Oracle NoSQL Database Analytics Integrator can be installed and executed Compute Instance
Create a NoSQL table Create one or more tables in the Oracle NoSQL Database Cloud Service and populate those tables with data. Create and populate a NoSQL table
Create a bucket in OCI Object Storage To set up access to the Oracle Object Storage Service, you need to create a bucket for Object Storage. Create a bucket in Object Storage
Create a database in the Oracle Autonomous Data Warehouse You need to create a database to access the Oracle Cloud Autonomous Data Warehouse from Oracle NoSQL Database Analytics Integrator. Create a database in the Autonomous Data Warehouse
Download and install the client credentials For the Oracle NoSQL Database Analytics Integrator to connect securely to the ADW database, the utility uses the credentials contained in an Oracle Wallet. Install credentials needed for a secure database connection
Generate an authorization token (optional) For user based authentication of the ADW database with Object Storage, you need to generate an authentication token (AUTH_TOKEN) that the database can use to access files in the Object Storage bucket Generate an authorization token for Object Storage
Enable/store the credential the ADW database should use to access the objects in Object Storage If you wish to have the ADW database authenticate with Object Storage using a Resource Principal, then you must perform the prerequisites to use Resource Principal with the ADW database and then you must enable the Resource principal to access Object Storage (see Create a Dynamic Group for the Compute Instance and the ADW database and Create a Policy with appropriate permissions for the dynamic group) and then enable the Resource Principal to access the objects in Object Storage. Alternatively, if you wish to have the ADW database authenticate with Object Storage using the user's AUTH_TOKEN that you generated (see Generate an authorization token for Object Storage), then you must store the AUTH_TOKEN in the ADW database; which will also enable that token to access the objects in Object Storage. Enable the OCI Resource Principal Credential or Store/Enable the User's Object Storage AUTH_TOKEN in the ADW Database
Create a Dynamic group for the Compute Instance and (optionally) the ADW database To authorize your compute instance to perform actions on the NoSQL Service, ObjectStorage, and ADW, a dynamic group must be created and a set of matching rules must be added for your instance. A dynamic group is also required if you wish to employ the OCI Resource Principal when authenticating the ADW database with Object Storage. Create a Dynamic Group for the Compute Instance and the ADW database
Create a Policy with Appropriate Permissions for the Dynamic Group Once a dynamic group is created, you must create a policy that grants permissions to it that allows members of that group to do read, write and management operations. Create a Policy with appropriate permissions for the dynamic group
Install Oracle NoSQL Database Analytics Integrator You can download the Oracle NoSQL Database Analytics Integrator from Oracle Technology Network. Installation
Create a configuration file for the integrator Before you can execute the Oracle NoSQL Database Analytics Integrator, you must first create a configuration file. This configuration file will be used when invoking the utility. Create a configuration file for the integrator
Running the integrator tool The Oracle NoSQL Database Analytics Integrator can be executed by simply typing a command on the command line. Running the integrator tool
Verify Data in the Autonomous Database After executing the Oracle NoSQL Database Analytics Integrator to copy the data from your NoSQL table to the Autonomous Database in ADW, you can verify that the NoSQL table data has been copied correctly. Verify the data in the Oracle Autonomous Database
Verify the data in Oracle Analytics You can connect Oracle Analytics to that database and verify that Oracle Analytics can access and analyze the data in the NoSQL table. Verify the data in Oracle Analytics