Adding an Existing Oracle Database Cloud Service Instance as a Target

Create a data source using an existing Oracle Database Cloud Service instance. Use this service instance as the target where you publish repaired and enriched data.

To add an existing Oracle Database Cloud Service instance as a target:
  1. On the Home or Catalog page, click Create Source.
    The Create Source page appears.
  2. In the Name field, enter a name to identify the source.
    The name must not contain spaces. If you enter a space, then the application changes it to an underscore.
  3. From the Type drop-down list, select Oracle DBCS .
  4. Provide your credentials to access your Oracle Database Cloud Service instance.
    This information appears in the email that you receive when you activate your Oracle Database Cloud Service account.
    1. In the JDBC Connection field, enter the JDBC database connection value.
      This connection is the value that appears in the Overview tab of your Oracle Cloud My Account page. The JDBC connection is in the form jdbc:oracle:thin:@<IP address>:<port>/PDB1.<service name>.
    2. In the Username field, enter the user name.
      This is the user name specified in the email that you receive when you create your account.
    3. In the Password field, enter the password.
      This is the password specified in the email that you receive when you create your account.
    4. In the Driver field, confirm that a driver is provided to access your database instance.
  5. Optionally, click Test to verify that you entered the correct data, and that the connection to the service works.
    A confirmation message appears.
  6. Click Save.
    The Catalog page appears.
The Catalog now shows the data source that you created. Use this target to publish your enhanced or repaired data sets and analyze them in Oracle Database Cloud Service.