From February 2017

Embed/Integrate Oracle Content&Experience Cloud Service in your web/mobile apps


Oracle Content & Experience Cloud (formerly Documents Cloud + Sites Cloud) is a very productive, secure and ease to use set of tools for managing content and documents from anywhere with multiple devices putting all the data synced and kept safe in a centralized repository.

Today I’m gonna show you how easy is to integrate a Documents visual component in your apps.

Ingredients:

  • If you don’t have one, Grab a Content & Experience Cloud Account here
  • HTML/JavaScript toolkit, for example JET

Follow email instructions to set up your account and get started using the web interface (in addition follow instructions in the web interface on how to set up your mobile or desktop client for IOS, Android, Windows or Mac in a few minutes).

docsCS01.png

Then create a nice user interface and put the following in an iframe:

https://docs-<youridentitydomain>.documents.<yourassigneddatacenter>.oraclecloud.com/documents/embed/folder/<folderId>/<foldername>/nameasc?originalReferrer=

The information in bold are parameters to gather from your own env

Now, as an administrator in [user]/Administration option you need to configure the remote client IP’s you allow for embedding the user interface as follows:

docscs05

And here we have the resulting page:

docsCS03.png

All the funtionalities that the cloud service offers are exposed in your web app, and responsive! Resize your browser and see!

docscs04

Of course, you have a complete REST API just in case you want to build your own component.

What else may you need? For better user sign on experience take a look to the possibilities that offers Identity Cloud Service

Enjoy 😉

node-oracledb: Connect Node program to Oracle Database Cloud Service in 30 minutes


If you want to execute sequel code against ORCL DB from Node your approach is node-oracledb. To get started follow setup instructions here.

Follow the steps I made to get it running in my new Mac here but documentation explains how to do it for a bunch of platforms.

NOTE: You need an oracle client, in my case I installed instant client. Steps are included in the mentioned doco.

Download the  zip or git clone this repo: [ https://github.com/oracle/node-oracledb.git ]

Ask for or grab your database connections details from the DBCS MyServices portal, then open examples directory with the latest trendy editor and edit dbconfig.js to point to your DBCS instance for example (settings are ficticious):

module.exports = {
 user : process.env.NODE_ORACLEDB_USER || "scott",
 password : process.env.NODE_ORACLEDB_PASSWORD || "tiger",
 connectString : process.env.NODE_ORACLEDB_CONNECTIONSTRING || "329.944.719.908/PDB1.contoso.oraclecloud.internal",
 externalAuth : process.env.NODE_ORACLEDB_EXTERNALAUTH ? true : false
};

Now you can test a couple of examples immediately:

MacBook-Pro-de-javier:examples javiermugueta$ node connect.js 

Connection was successful!

MacBook-Pro-de-javier:examples javiermugueta$ node select1.js 

[ { name: 'DEPARTMENT_ID' }, { name: 'DEPARTMENT_NAME' } ]

[ [ 180, 'Construction' ] ]

That’s all Folks!

Enjoy 😉