Capturing SQL calls sent to a remote server from application

First of all, I’m not well versed in SQL anything at all. Closest I’ve ever needed to get was storing and retrieving data from a local SQLite db.

In essence I think I have a simple problem but it’s hard to orient yourself when everything is new.

My main tool at work is an ERP software, which is basically a front end to an SQL db.

Problem I have with it is that it’s very clumsy and doesn’t allow automation of even the most basic tasks.

What I want to do, is bypass the front-end completely and interact directly with the db to automate most of my tasks with python.

I can connect to the database just fine from python environment, but the schema is gigantic, there’s no way I’ll be able to find whatever it is I might be looking for.

So I need to capture the call front-end sends when I click a button (telling it to display specific set of data) to use that call as a guide.

Basically, how can I, an SQL noob, capture calls that a desktop application sends to a remote server?

Edit 1: My job is mostly analytical, so all of my automation will be for retrieval, analysis and visualization. I’m not very likely to mess anything up.

Edit 2: Tried running a Profiler and got the message:

"In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission."

I’m not a sysadmin, don’t have an alter trace permission and reeeally don’t feel like asking for it 😀