The Internet of Things (IoT) ecosystem is emerging rapidly. From the connectivity perspective, it is the vehicle towards connecting massive number of devices to the Internet; whereas, from the application perspective, it paves the way towards collecting huge amounts of data and enabling novel information-based services. The connectivity infrastructure that will support the IoT ecosystem is composed of both expansions applied in the well-deployed mobile network infrastructures, and dedicated deployments provided by vertical-specific setups. In the latter case, the Low-Power Wide Area Networks (LPWANs) have become a cost-effective solution, incorporating efficient technologies for wireless connectivity and control. In this context, a comprehensive study is provided to assist on the currently increasing research and development interest in the area of LPWANs. The study provides state-of-the-art work as well as research directions and tools for the most representative LPWAN technologies. Supporting the concept of openness in the IoT ecosystem, the study targets connectivity solutions that operate in unlicensed spectrum bands, such as the LoRa/LoRaWAN systems, and describes the most recent cloud and open-sourced solutions for IoT service and data management.