Oracle Autonomous Database: Configuring SQL Developer Web Access to 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 “xxxxxxxxxx“; 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 … Continue reading Oracle Autonomous Database: Configuring SQL Developer Web Access to Database Users

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): TNS Name in connection details is the value to provide in the OIC connection wizzard Create the connection in OIC providing the values previously gathered Service Name is the value of TNS Name in the … Continue reading Creating a Connection between Oracle Integration (OIC) and Autonomous Database

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 … Continue reading Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes

oke-cluster-start-stop, a kubectl Plugin for starting/stopping all the Compute Nodes of an OKE Cluster


If you want to start or stop all of your OKE data plane cluster nodes you must go to all the nodes and execute the action one by one. The current post depicts a kubectl plugin extension created for helping you to start/stop your oke clusters. NOTES: The tool has been developed and tested in … Continue reading oke-cluster-start-stop, a kubectl Plugin for starting/stopping all the Compute Nodes of an OKE Cluster

Oracle SaaS | Analysing the Structure and Morphology of the REST API Methods


Oracle SaaS API's have a structure that is equal for all the "business entities" across the different modules (Finance, Loyalty, Supply Chain, …) such as invoices, expenses, loyalty transactions and so on. Let's analyze the pattern. In this episode, we are focusing on the "Get all xxx" methods because it conforms a pattern that we'll … Continue reading Oracle SaaS | Analysing the Structure and Morphology of the REST API Methods

Near Real Time Data Driven SaaS Integration with Streaming | Part 2: Extracting/Publishing Data Changes to Streaming Topics


As we mentioned in a previous post, the idea here is to develop a construct that seeks for changes in the SaaS data system and publishes those changes to a stream for later consumption from other systems over there. Indeed, as we see in the diagram, there is a block in which we are executing a program … Continue reading Near Real Time Data Driven SaaS Integration with Streaming | Part 2: Extracting/Publishing Data Changes to Streaming Topics

Oracle Integration Cloud | Integrating Applications Through Robotics Process Automation


Robotics Process Automation (RPA) is a technology that allows to automate the human-machine dialog. How many of you have seen end users working with several User Interface apps "at the same time"? The lack of integration between our systems and apps is because several reasons, such as failed IT implementations, niche, legacy or obsolete solutions, … Continue reading Oracle Integration Cloud | Integrating Applications Through Robotics Process Automation