# Edit the properties file for Metadata Editor

1. On the workstation where you want to run Metadata Editor, [stop Metadata Editor](https://docs.pentaho.com/install/9.3-install/pentaho-configuration/tasks-to-be-performed-by-a-pentaho-administrator/configure-the-design-tools-and-utilities/ba-design-tools/start-and-stop-ba-design-tools) and the **server** if it is running on the same workstation.
2. Navigate to the `metadata-editor/simple_jndi` directory where you installed the Metadata Editor.
3. Edit the `JDBC.properties` file found there.

   If it does not exist, create it according to this example.

   ```xml
   SampleData/type=javax.sql.DataSource
   SampleData/driver=org.hsqldb.jdbcDriver
   SampleData/user=pentaho_user
   SampleData/password=password
   SampleData/url=jdbc:hsqldb:mem:SampleData

   ```

   In the example, `SampleData` is the name of the JNDI connection. Each line must begin with the JNDI connection name and a forward slash (/), followed by these required parameters.

   | Parameter    | Description                                                      |
   | ------------ | ---------------------------------------------------------------- |
   | **type**     | *javax.sql.DataSource* defines the JNDI data source type.        |
   | **driver**   | The driver class name provided by your database vendor.          |
   | **user**     | A user account that can connect to this database.                |
   | **password** | The password for the previously declared user.                   |
   | **url**      | The database connection string provided by your database vendor. |
4. Save and close the file.
5. For these changes to take effect, [restart the Metadata Editor](https://github.com/pentaho/documentation/blob/main/PDIA/9.3/Install/Pentaho%20configuration/Pentaho%20Configuration%20-%20Config%20Overview%20\(article%20cp\)/Tasks%20to%20be%20Performed%20by%20a%20Pentaho%20Administrator%20-%20Config%20Overview/Configure%20the%20Design%20Tools%20and%20Utilities%20\(article%20cp\)/BA%20Design%20Tools%20-%20Config%20Design%20Tools/Start%20and%20stop%20BA%20design%20tools=GUID-A14C7E21-21EB-41B2-AA3B-EE9C8BF8D33B=2=en=.md) and the [Pentaho Server](https://docs.pentaho.com/install/9.3-install/pentaho-configuration/tasks-to-be-performed-by-an-it-administrator/configure-the-pentaho-server/start-and-stop-the-pentaho-server-for-configuration) if it is running on the same workstation.

You now have a properties file that defines a JNDI connection for Metadata Editor. Remember, if you run this tool on more than one workstation, repeat this process on all the other workstations.