Any points / experience you guys have on jdbc vs odbc for suiteAnalytics connect, what you prefer and why and any limitation to both?

I think it depends on how your connecting to retrieve data. If you're using an app which can use ODBC drivers, like Excel on Windows, use those. If you're on a Mac, or trying to connect with a Java-based application, like JetBrains IDE, then you need to use the JDBC driver.