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;
commit;
/

begin
wwv_flow_security.g_security_group_id := 10;
wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
commit;

end;

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

https://yourIPAddress/ords/yourDB/yourAPEXWorkspace/niall/customers

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 -

https://yourIPAddress/ords/yourDB/yourAPEXWorkspace/niall/customer/1

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

Introduction














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 -