I have this website that has web server which is Apache Tomcat and its connected MySQL and a console application (C#).

What I planned to do is, this console application will request to web server to get a data from MySQL and web server send data to console application.

Is it possible? How can implement this?

Should I use REST API to get the data in web server?