How to connect to an external database like MSSQL or oracle with Spring boot?

It is done in the following steps.

Step 1 -

The first step to connect the database like Oracle or MySql is adding the dependency for your database connector to pom.xml.

Step 2 -

The next step is the elimination of H2 Dependency from pom.xml

Step 3 -

Step 3 includes the schema and table to establish your database.

Step 4 -

The next step is configuring of the database by using Configure application.properties to connect to your database.

Step 5-

And the last step is to restart your device and your connection is ready to use.