I am trying to set up an ODBC or JDBC direct connection from ArcGIS Pro  and ArcGIS Enterprise Server; has anyone done this successfully?

I was able to make DSN successful connection, but no tables are being delivered; I did not use a connection string. I just set it up within the Simba Park driver ODBC.  I noticed there was no spot to actually select a schema.

I suspect this might be a case if anyone knows how to configure that driver to do this or another way I would very much appreciate it

I am also concerned that there might be a performance hit regardless if I make the connection.

anyone who has done this before?