ODBC connectors don't offer the same suite of functions that native MSSQL might for a given language. This was annoyingly true for me at my last place of employment. MSSQL/T-SQL horsecrap for "BI" since everyone "knows" MSSQL is better.

As usual, these things are the decisions of the architects, not the analysts. As such...