Data Source Explorer

The Data Source Explorer allows you to create and manage any number of data sources in a central location and to integrate them into your project when required.

Open Data Source Explorer

  1. In the menu, select Window > Show View > Other…​.

  2. In the following dialog, select Data Management > Data Source Explorer.

    image not found

Connect to data source

  1. Double-click the data source you want to connect to.
    image not found

Edit data manually

With the Data Source Explorer, you can easily change the data in your database tables..

  1. Right-click on a table whose data you want to edit, e.g. CUSTOMERS.

  2. In the following context menu, select > Data > Edit.

  3. Right-click a data field and choose > Edit Value in the context menu.

  4. Edit the data field and press the Enter key to apply the change.

  5. Click Save.

    image not found

Options (context menu):

  • Revert - Reverts the last change.

  • Refresh - Reloads the data of the selected table.

  • EditValue - Sets the edit mode for the selected data field.

  • Set Null - Assigns the null value to the selected data field.

  • Insert Row - Adds a new record at the end.

  • Delete Row - Deletes the selected record.

  • Save - Saves the changes in the database table.

Store passwords encrypted

Passwords are usually stored encrypted. To manually enter the encrypted passwords in a USER table, you can use a online hash generator.