Microservices and SODA: JSON Data Stored in an Oracle Database Accessed through‚Äč REST or Java

Simple Oracle Document Access SODA (Simple Oracle Document Access) is a non-SQL style of storing/retrieving JSON data in an Oracle database. It’s so easy to work with SODA! Let’s get started. First, enable ORDS schema in your database. Second, deploy ORDS in K8s (you can also deploy ORDS standalone¬†in your laptop or in a container […]


Install Oracle Data Integration Platform Cloud (aka ODIPC) ODI Agent in an Oracle Cloud DB System

Let’s go ahead: From the ODICP portal download the agent: ssh to the database node sudo¬†su¬†– oracle unzip agent-linux.64.bit.zip Issue the following command (what we are doing now is downloading the SSL certificate of the ODIPC cloud service and importing in cacerts): openssl s_client -showcerts -connect <odipcservernameurl>:443 </dev/null 2>/dev/null|openssl x509 -outform PEM > adipcocporaclecloudcom.crt such […]