Oracle Integration Cloud (aka OIC) is like the glue or mortar that makes the different parts of an ecosystem of technology puzzle start to look that they fit. OIC is good for hybrid, multi cloud integration and extensions framework. So, which are those 3 legs or components that OIC provides? With OIC (and sometimes other … Continue reading Explaining the Three Legs of Oracle Integration Cloud (OIC) for Dummies
BI Cloud Extract is a standard tool for extracting data from SaaS (ERP, ...) either incremental or fully approaches. Data is exported to Object Storage as zipped files. Files stored in object storage are encrypted by a key provided by OCI Object Storage administrator role o keys managed by Oracle. Additionally Oracle encrypts data at … Continue reading Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway
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
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
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
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 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
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
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
