Advanced Configurations

The ports 7780 to 7790 in the host are reserved for the Data Studio interpreters. These ports in the host VM should be available for the interpreters to run.

For more information, see:

Running on a Different Host

If the interpreter docker images are running in a different VM than the Oracle WebLogic Server, then the configurations must be updated to point to the VM. By default, the configurations is set to localhost.

In the Oracle WebLogic Server VM , navigate to the oh_domain/interpreter-scripts folder. Edit the following files and change the value of "host" to the hostname/ip address of the VM that has the docker images running. By default, the entry for "host": "localhost".

  • python.json
  • pgx-java.json
  • pgql.json
  • ore.json
  • markdown.json

In order to have these changes to be in effect, the data studio schema objects need to be truncated. The values will be repopulated when the data studio restarts.

  • Stop the managed server of Oracle Healthcare Translational Research Middle Tier WebLogic.
  • Connect to the data studio schema.
  • Run the drop_datastudio_objects.sql connecting to this data studio schema. This file is available as part of the PgXDataStudio-Docker in the PgXDataStudio/database/scripts folder.
  • Restart the Oracle Healthcare Translational Research Middle Tier WebLogic managed server.