Devart has upgraded their SDAC component suite to support Windows and Mac OSX in Delphi XE7 Firemonkey. SDAC is a set of data access components for Microsoft SQL Server. This new version contains a Direct Mode which allows it to run on both Windows and Mac OSX (if you need Android support check out this JDBC wrapper for now). It comes with base components like TMSConnection, TMSQuery, TMSSQL, TMSTable, TMSStoredProc, TMSUpdateSQL, TMSDataSource, TMSTransaction. Specifically for Microsoft SQL Server it has TMSTableData, TMSCompactConnection, TMSChangeNotification, TMSServiceBroker, TMSMetadata, TMSDump, and TMSSQLMonitor components. Lastly it has a TMSEncryptor component for data encryption and decryption. There are a couple different licensing options and there is also a free trial for this commercial component suite. It should also work with Appmethod.
Head over and check out the full feature set for these Microsoft SQL Server data access components in Delphi XE7 Firemonkey.