Forum Stats

  • 3,783,593 Users
  • 2,254,807 Discussions
  • 7,880,470 Comments

Discussions

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

svalesmu
svalesmu Member Posts: 48 Blue Ribbon
edited Jul 13, 2017 5:36AM in Java Cloud Service

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

svalesmuAlex-D

Best Answer

  • Alex-D
    Alex-D Member Posts: 800 Gold Badge
    edited Mar 24, 2017 10:20AM Accepted Answer

    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

Answers

  • Alex-D
    Alex-D Member Posts: 800 Gold Badge
    edited Mar 24, 2017 10:20AM Accepted Answer

    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
    svalesmu Member Posts: 48 Blue Ribbon
    edited Mar 27, 2017 2:56AM

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

    Kind regards

  • Alex-D
    Alex-D Member Posts: 800 Gold Badge
    edited Mar 27, 2017 8:27AM

    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 / Month20GB3GB PGA, 3GB SGA120GB / 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/ Month5GB30GB /Month
    svalesmusvalesmu
  • svalesmu
    svalesmu Member Posts: 48 Blue Ribbon
    edited Mar 28, 2017 3:36AM

    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
  • Alex-D
    Alex-D Member Posts: 800 Gold Badge
    edited Mar 28, 2017 4:16AM

    You're welcome

  • 3503740
    3503740 Member Posts: 5
    edited Jul 13, 2017 3:54AM

    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
    Alex-D Member Posts: 800 Gold Badge
    edited Jul 13, 2017 5:36AM

    Could you please create a separate question for your problem?

    Regards

This discussion has been closed.