With epicor you don’t write or read directly from SQL you use their APIS to extract and put that information in while abiding by all their business logic. Writing directly to SQL violates your support agreement among other things.
Here’s a few threads on Rest and how to use it
I have written a library with a few friends that let you interact with the rest API using .NET that can be found here
Where you can find the the entire OpenAPI Style Documentation for the rest interface.
Anything can be done but it is not the best way to accomplish this also if you are in a SaaS environment I very much doubt you’ll have SQL Access. BAQ’s is what you are looking for here for data extracts
Epicor has a REST interface that can talk to anything lanage , framework and tool out there. If you want some stuff that works right out of the box look at Epicor Integration Studio through workato.
You can also look at the API Documentation in your own system at