The Oracle SQLDeveloper

Oracle SQL Developer is included as a third party product during the initial installation of WorkZone Content Server.

The Oracle SQL Developer is a free integrated development environment that developers, technicians, and database administrators can use to edit, develop and manage On-Premise and Cloud-based Oracle databases.

 

The Oracle SQL Developer distribution consists of the SQLDeveloper program folder that contains all required components, downloaded from Oracle. The Oracle SQL Developer environment is located and run from the SQLDeveloper folder, found on the installed web server in C:\Program Files (x86)\KMD\WorkZone\Program\.

Install and set up SQLDeveloper

The WZSetupFiles folder of the SQLDeveloper folder contains optional setup/configuration files for the SQL Developer environment, including the following files:

• Product-preferences.xml: Stores UI parameters for the SQLDeveloper user interaction for a more convenient user interface setup.
• ReadMe: Contains instructions for installing the optional setup/configuration files.
• connections.json: Contains a predefined database setup of DB01.

You can set up the database when you run SQL Developer the first time instead of using the connections.json file.