We're looking for a solution to connect to BC using ODBC for my team. We managed to get the connection working but its unbelievably SLOW. Like 2-3 minutes for a select statement.

We have enterprise BC so we shouldn't have any rate limiting issues, is there a place we can look at the logs, or is this a common problem?