ATP

EXERCISING WITH API REST CALLS AND JSON DATA IN AN AUTONOMOUS DATABASE BY DEVELOPING A PROCEDURE SCHEDULED TO BE EXECUTED DAILY THAT COLLECTS CONSUMPTION DATA IN A TABLE FOR REPORTING OR OTHER PURPOSES

IT by javier mugueta29 January, 202128 April, 2021

IT by javier mugueta13 November, 201912 November, 2019

Connecting Visual Builder to an Autonomous Database

Oracle Visual Builder is a visual development tool that comes with its own database. It allows you to create objects for storing data. Those objects are also exposed as REST, making the data model of your application accesible from/to other peers. Visual builder allows the configuration change consisting in connecting to an “external” database, either […]

IT by javier mugueta11 November, 201920 November, 2019

Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage

Oracle autonomous database (ADW/ATP) offers several approaches for storing the data: data online stored in the database internal storage data nearline as external tables in object storage data offline in object storage The autonomous database supports object storage provided by Oracle OCI, Amazon S3 and Azure, with them you can create external tables, external partitioned […]

IT by javier mugueta25 September, 201912 February, 2020

Oracle Autonomous Database: Configuring SQL Developer Web Access for Database Users

Connect to SQL Developer Web as admin user Create a new user, give privileges quotas and the like… create user MYUSER identified by “xxxxxxxxx”; grant connect to MYUSER; GRANT DWROLE TO MYUSER; execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(‘MYUSER’,’1G’); BEGIN ORDS_ADMIN.ENABLE_SCHEMA(p_enabled => TRUE,p_schema => ‘MYUSER’, p_url_mapping_type => ‘BASE_PATH’, p_url_mapping_pattern =>’MYUSER’, p_auto_rest_auth => TRUE); COMMIT; END; / Copy the link of […]

IT by javier mugueta24 September, 20198 October, 2019

Creating a Connection between Oracle Integration (OIC) and Autonomous Database

Connect to ATP and create a new user Grab the ATP connection details and download the wallet(give it a password): Create the connection in OIC providing the values previously gathered Test it That’s all, hope it helps! 🙂

IT by javier mugueta21 September, 201921 September, 2019

Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes

Oracle DB has been supporting JSON for quite some time, but you probably didn’t know it! Let’s se how easy is to start puting and geting json data in it. The most quick way to get a JSON db up and running is creating an Autonomous Transaction Processing instance. Create the instance and forget there […]

IT by javier mugueta22 March, 2019

Microservices Versioning and the “Database per Service Pattern” with Oracle Autonomous Database

The database per service pattern with an Oracle database can be accomplished easily with one instance of Autonomous Database per microservice, a very easy to use and maintain database (relational and JSON). But not only is easy to use and maintain because you don’t have to deal with administration tasks or manage different technologies for persisting […]