Accessing the Oracle Cloud Autonomous Data Warehouse

Create a database in the Autonomous Data Warehouse

You need to create a database to access the Oracle Cloud Autonomous Data Warehouse from Oracle NoSQL Database Analytics Integrator. To create a database in the Oracle Cloud Autonomous Data Warehouse, go to the Oracle Cloud Console and do the following:

Select Oracle Database from the menu on the left side of the display.
Select Autonomous Data Warehouse.

Description of the illustration oci-orcldb.png
Select the Compartment in which to create the database.
Click Create Autonomous Database.
Enter the Basic Information for the Autonomous Database; for example,
- Compartment: enter the compartment name selected above.
- Display name: the name to display on the console; for example, NoSqlToAdwDb.
- Database name: the name to use when connecting to the database; ex. NoSqlToAdwDb (cannot be more than 14 characters).
Description of the illustration crtadb-dbname.png
Choose the Data Warehouse workload type.
Choose the Shared Infrastructure deployment type.

Description of the illustration crtadb-wltype.png
Choose the default configuration for the database.

Description of the illustration crtadb-param.png
Set a Password under Create Administrator Credentials.

Description of the illustration crtadb-admin.png
Choose Allow secure access from everywhere for Access Type.
Choose the appropriate license type. If you have your own license, then choose Bring Your Own License (BYOL).
Click Create Autonomous Database.

Description of the illustration crtadb-network.png

Related Topics

Generate an authorization token for Object Storage

Install credentials needed for a secure database connection

Connections to the database you created in the Autonomous Data Warehouse must be secure. In order for the Oracle NoSQL Database Analytics Integrator to connect securely to the ADW database, the utility uses the credentials contained in an Oracle Wallet.

To obtain the Oracle Wallet, go to the Oracle Cloud Console and do the following:

Select Oracle Database from the menu on the left side of the display.
Select Autonomous Data Warehouse.

Description of the illustration oci-orcldb.png
Select the Compartment in which the database is located.
Click on the link with the display name you entered when creating the database.

Description of the illustration adb-listdb.png
Click Service Console.

Description of the illustration adb-srvconsole.png
Click on the Administration link on the left of the display.
Select Download Client Credentials (Wallet) and enter the administrative password set during database creation.

Description of the illustration adb-adminstration.png
Save the file (zip) to a safe location.

The zip file that is produced includes the following items:

The network configuration files (tnsnames.ora and sqlnet.ora) needed to connect to the database.
The auto-open SSO wallet file, cwallet.sso.
The PKCS12 file, ewallet.p12 which is protected by the wallet password you provided when you downloaded the zip file via the Oracle Cloud Console.
The Java keystore and trustore files, keystore.js and truststore.jks; protected by the wallet password.
The file ojdbc.properties, which specifies the wallet-related Java system property required for connecting to the database via JDBC.
A README file containing wallet expiration information.

After obtaining the wallet zip file, make note of the password and store the wallet in any environment from where you will be connecting to the database. Additionally, to use the Oracle NoSQL Database Analytics Integrator, the extracted contents of the wallet zip file must be installed in the environment where you will be executing the utility. For example, if you are executing the utility from an Oracle Cloud Compute Instance, you should extract the contents of the zip file in any directory on that instance. Then use the path to that directory as the value of the parameter databaseWallet in the database section of the utility’s configuration file.

Enable the Resource Principal Credential or Store/Enable the User's Object Storage AUTH_TOKEN in the ADW Database

After retrieving data from the desired NoSQL Cloud Service table and writing that data to Parquet files in Object Storage, the Oracle NoSQL Database Analytics Integrator uses subprograms from the Oracle PL/SQL DBMS_CLOUD package to retrieve the Parquet files from Object Storage. It then loads the data contained in those files to a table in the database you created in the Oracle Cloud Autonomous Data Warehouse.

Before the Oracle NoSQL Database Analytics Integrator can do this, you must provide a way for the ADW database to authenticate with Object Storage for access to those Parquet files. The ADW database can authenticate with the Object Storage service in one of two ways: using the OCI Resource Principal or a user-specific AUTH_TOKEN that either you or the system administrator generates. The authentication mechanism you decide to use is enabled by executing the following steps from the Oracle Cloud Console.

Select Oracle Database from the menu on the left side of the display.
Select Autonomous Data Warehouse.

Description of the illustration oci-orcldb.png
Select the Compartment in which the database is located.
Click on the link with the display name you entered when creating the database.

Description of the illustration adb-listdb.png
Click Service Console.

Description of the illustration adb-srvconsole.png
Select Development from the menu on the left side of the display.

Description of the illustration adb-development.png
Select Database Actions and login to the database; for example,
- Username: ADMIN
- Password: <password-set-during-database-creation>
Description of the illustration dbactions-login.png
Select the item SQL.

Description of the illustration dbactions-sqlsheet.png
From the window labeled [Worksheet]*, if you wish to authenticate the ADW database with Object Storage using the Resource Principal, then execute the following procedure.
```
EXEC DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL();
```
Description of the illustration dbactions-resource-principal.png
Alternatively, if you wish to perform the authentication using the AUTH_TOKEN that either the system administrator provided to you or you generated yourself, then execute the procedure,
```
BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL (
credential_name => 'NOSQLADWDB_OBJ_STORE_CREDENTIAL',
username => '<your-Oracle-Cloud-username>',
password => '<cut-and-paste-the-AUTH_TOKEN>'
);
END;
```
Description of the illustration dbactions-worksheet.png

The DBMS_CLOUD_ADMIN.ENABLE_RESOURCE_PRINCIPAL procedure enables the OCI Resource Principal (named OCI$RESOURCE_PRINCIPAL) for use by the ADW database when authenticating with an OCI resource such as Object Storage. The DBMS_CLOUD.CREATE_CREDENTIAL procedure encrypts the specified AUTH_TOKEN credential and stores it in a table in the database named adwc_user. Whichever procedure you employ, that procedure needs to be executed only once; after which the same credential name can be specified for all transfers from Object Storage to the ADW database.

Note:

When the ADW database uses the OCI Resource Principal to authenticate with Object Storage, the name of the credential is OCI$RESOURCE_PRINCIPAL. Alternatively, when using the AUTH_TOKEN to authenticate with Object Storage, the name of the credential is the value you specify for the credential_name parameter in the DBMS_CLOUD.CREATE_CREDENTIAL procedure. But note that the value shown above (NOSQLADWDB_OBJ_STORE_CREDENTIAL) is only an example. You can use any name you wish. Thus, the dbmsCredentialName parameter in the configuration file should contain either the value OCI$RESOURCE_PRINCIPAL, or the name you specify here for the credential_name parameter; depending on the authentication mechanism you choose to employ for authenticating the ADW database with Object Storage.