Thursday, February 18, 2016

#477 REST enabled Oracle Database Cloud Service - my first experiences

I have heard that APEX supports REST so I decided to try this out on my SOA CS environment's
DB CS instance. AS per usual, I studiously avoided reading any documentation.
This should be simple, right?

I created a simple table Customers -

Now, as luck would have it I locked my ADMIN APEX user out.

This I fixed as follows -

ssh into the DB CS machine
start sqlplus

conn system/yourPwd@yourSOADB;

alter session set current_schema = APEX_050000;

select user_id, substr(user_name, 1,10), account_locked from wwv_flow_fnd_user;

update APEX_050000.WWV_FLOW_FND_USER
set web_password = 'yourNewPassword'
where user_name = 'ADMIN'
and user_id = yourUserId;

wwv_flow_security.g_security_group_id := 10;


Then I logged into APEX and created a new workspace.
I then logged into this workspace -

I then clicked on SQL Workshop - RESTful Service -

As you can see, the request is based on the simple query -
Select custname from customers

Click on the Test button to get the URL


I now try this out in Postman -

I can now create a connection to this REST service in ICS.

For ICS, I create a variation of the above -


This REST request retrieves customer name based on custId.

Here is the result, when I test in Postman.

I create a REST connection in ICS based on the above.

See my blog post here  for the steps.

Good article on DB CS REST here

#476 Increasing the DB size on SOA Cloud Service

This is a relatively simply process -

Go to Database Cloud Service Console and select your DB -

Then click the menu option - Scale Up/down

You will see the following message afterwards -

So, now, go to the Java Cloud Service console and Stop/Start your SOA Instance.

Tuesday, February 16, 2016

#475 Oracle at Mobile World

Check it out

if you happen to be in Barcelona 22-25 Feb 2016.

Monday, February 1, 2016

#474 ICS Google Mail adapter


Here is a simple example of the above.
To begin with, I need to set up my OAuth credentials@Google

As you can see, I have obfuscated my Client ID and Client secret, somewhat.
Notice, I have also entered an Authorized redirect URI below.
This will be needed when you click the Provide Consent button on connection creation in ICS.

Now, with this information, I can create the connection to GMAIL in ICS.

I click on Provide Consent and get the confirmation from Google.

Now I use this in an Integration -

Here is the Request mapping -

I am using the PartyId field in the Source message.

uploadType needs to be set to media

raw needs to be set in the following format -

From: emailAddress To: emailAddress Subject: Welcome to ICS Google Mail Adapter! MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, This is your First Mail sent using ICS Google Mail Adapter! Thank You!! Regards, ICS Oracle

 I deploy and test from SOAP-UI -

I monitor in ICS -

Then I check my email inbox -