The SemmleCode Database Setup Wizard can automatically set up and connect to the backend database from within SemmleCode.

If you wish to use the Setup Wizard later, you can access it from the drop-down menu of any SemmleCode view.

If you wish to manually create the database and user that SemmleCode will use, follow the instructions to manually set up a database for SemmleCode.

Once you are done with the wizard, you can view the SemmleCode tutorial on how to run and write queries.

1. First we need to open a SemmleCode view to ensure that the plugin is loaded. Go to Window->Show View->Other... menu in Eclipse.

   

2. In the Show View dialog, select the SemmleCode Quick Query view and press OK.

   

3. Once the Quick Query view opens, a message asking you to run the Setup Wizard will be shown. Click Yes to being the wizard.

   

   In case the message is not shown, you can manually start the Setup Wizard through the dropdown menu of the Quick Query view.

   

4. Click Next to begin the Setup Wizard.

   

5. You will be prompted to select the detection method to find locally installed databases. Select Try to automatically detect a locally installed database and click next to begin the autodetection.

   

6. The Setup Wizard will then try to detect any compatible locally installed database. Once the autodetection process is complete, click Next to proceed.

   

7. You will then be shown a list of of compatible databases that were autodetected. Select the database you wish to connect to, change the settings if you wish, and click Next to continue.

   

8. You will then be asked for the details of the database you wish to connect to.

   If you wish SemmleCode to automatically create the database and user for you, select the option to Create and use the following user and database names. You would need to provide the database name, user name and password that the SemmleCode will use to connect to the database server. SemmleCode would also need the superuser/admin password to be able to create the database and user specified.

   Creating a database for SemmleCode's exclusive use is recommended, as it requires case-sensitive collation which might conflict with the requirements of an existing database.

   Clicking Next would begin the database and user creation process.

   

9. Click Next once the database and user creation is complete.

   

11. SemmleCode should now be properly configured to connect to the database server. Click Finish to complete the wizard.

    

Congratulations! SemmleCode should now be configured for your environment. You can now look at the SemmleCode tutorial on how to run and write queries.