Does the MTCBA-G-EN allow for data connectivity over the Internet and support SMS technology as well.

The only way to do SMS on the Ethernet modem is telnet to a TCP port and issue AT commands directly to the modem to send / receive SMS.

It can only do data or SMS, but not both.