Linking 4d server in SSMS & SQL Syntax

Product :4D - 4D Server
4D : v13.2
OS : Windows

I am trying to link to our 4d from a sql server so that I can use ssms to access data as that is what I am more accustomed to doing. Is this possible with just the ODBC drivers? I am looking to access the 4d data in Crystal Reports and in a few other ways but would prefer to work with the data in sql.