JCS - SaaS Extension & Oracle Database Cloud - Database Schema connection

svalesmu

Hello all,

We've started developing an application for our client in a JCS - SaaS Extension with DD.BB. support.

Our client has purchased a subscription for this plan: Oracle Database Cloud Service - S5, which consists on a DD.BB. schema with Application Express 5.0.4.00.12.

Since we'd like to have access from JCS to the DD.BB., we were wondering how can we establish the connection from our IDE (JDeveloper Studio Edition Version 11.1.1.7.1).

We've been trying to follow several tutorials out there, but all of them implied that the service console had all the DD.BB. and SSH connection parameters, which our service console doesn't.

Could you please advise us on how we may proceed? Is the only way to establish connection between JCS and the DD.BB. is through the use of RESTful WS?

Thank you beforehand for your help.

Kinds regards,

Sergio

Alex-D

Hello,

Yes, the only way to "talk to" Database Schema as a Service is using the REST APIs. In order to be able to connect to the DB through the SQL*NET, you'll need other DBaaS subscription types - regular Database as  a Service or Exadata Express as a service.

Regards

Alex-D

Hello,

Yes, the only way to "talk to" Database Schema as a Service is using the REST APIs. In order to be able to connect to the DB through the SQL*NET, you'll need other DBaaS subscription types - regular Database as  a Service or Exadata Express as a service.

Regards

svalesmu

Thank you very much for your prompt response. We shall then develop our application taking this into consideration.

Kind regards

Alex-D

When you compare pricing, the "Exadata Express service" is actually the same price as "Database schema service", but offers more functionality so really it makes no practical sense to choose the "schema service" today, better go for Exadata Express:

Exadata Express:

"Exadata Express provides a full Oracle Database experience for small and medium sized databases at an attractive entry-level price. The service is provisioned within minutes and fully managed by Oracle. You get one Oracle Database Enterprise Edition plus options, running on Exadata engineered systems, with Oracle Net (SQL*Net) connectivity. Developer benefits include a standard SQL interface, RESTful Web Services, documents & collections interfaces, drivers for popular programming languages, integrated Application Express (APEX) and a range of client tools and IDEs"

https://cloud.oracle.com/en_US/database/exadata-express/pricing

Product	Price	Database Storage Maximum	Database Memory Maximum	Data Transfer Maximum
Exadata Express - X20	$175.00 / Month	20GB	3GB PGA, 3GB SGA	120GB / Month

DB Schema:

"Schema Service provides an Oracle Database schema running in Oracle Cloud, along with pre-configured APEX and RESTful Web Services. It is an ideal platform for creating and running APEX web apps."

https://cloud.oracle.com/en_US/database/schema/pricing

Product	Price	Storage1	Transfer2
Schema S5	$175.00/ Month	5GB	30GB /Month

svalesmu

Thank you very much for this piece of information!

We shall contact our client as I do agree with you that the Exadata Express do offer more functionallity as well as less restrictions, and since we're currently on the development phase, we may still be able to change de DD.BB. instance.

Kind regards

Alex-D

You're welcome

3503740

After getting the trial subscription for Oracle Java Cloud Service-SaaS Extension I received two services Java Cloud Service-SaaS Extension and Database Schema. I don't have any idea how to link those. Also, how to make connections through Jdeveloper 11.1.1.9.0 with the Database Schema. Please suggest the steps as I am unable to figure to out this. It would be of great help if you can share any document. 

Alex-D

Could you please create a separate question for your problem?

Regards