AWS IoT SiteWise Enhances Data Access with Advanced SQL and ODBC Driver
Seattle, WA – July 23, 2025 – Amazon Web Services (AWS) today announced a significant advancement for AWS IoT SiteWise, its managed service that makes it easy to collect, organize, and analyze data from industrial equipment at scale. The newly introduced Advanced SQL query capabilities and an ODBC driver dramatically expand the ways customers can access, query, and integrate their IoT data, empowering them with greater flexibility and deeper insights into their industrial operations.
This latest enhancement addresses a growing need within the industrial sector for more sophisticated data analysis and seamless integration with existing business intelligence and analytics tools. With the introduction of Advanced SQL support, users can now leverage a richer set of SQL functions and expressions to perform complex queries directly against their IoT SiteWise data. This includes the ability to utilize window functions for sophisticated time-series analysis, common table expressions (CTEs) for breaking down complex queries into more manageable parts, and advanced aggregation functions to derive more granular and meaningful insights.
The addition of an Open Database Connectivity (ODBC) driver is equally transformative. This driver acts as a bridge, allowing customers to connect a wide range of familiar business intelligence (BI) tools, data visualization platforms, and analytics applications directly to their AWS IoT SiteWise data store. This means that users can now readily integrate industrial IoT data into their existing workflows, whether it’s for creating custom dashboards in tools like Tableau or Power BI, performing ad-hoc analysis in SQL clients, or feeding data into data warehousing solutions. The ODBC driver eliminates the need for complex data extraction and transformation pipelines, streamlining the path from raw sensor data to actionable business intelligence.
Prior to this update, accessing and analyzing AWS IoT SiteWise data often involved more programmatic approaches or custom data processing. The Advanced SQL capabilities and the ODBC driver democratize data access, making it more accessible to a broader range of users, including data analysts, business users, and operational teams, who may not have extensive programming expertise.
This evolution of AWS IoT SiteWise is a testament to AWS’s commitment to providing powerful and flexible solutions for the industrial IoT landscape. By enabling more advanced querying and simplifying data integration, AWS is empowering organizations to unlock the full potential of their industrial data, leading to improved operational efficiency, predictive maintenance, enhanced product quality, and faster decision-making.
Customers can now explore these new features to gain deeper insights into their industrial processes, optimize asset performance, and drive innovation within their organizations. This advancement further solidifies AWS IoT SiteWise as a leading platform for industrial data management and analytics.
AWS IoT SiteWise Query API adds advanced SQL support and ODBC driver
AI has delivered the news.
The answer to the following question is obtained from Google Gemini.
Amazon published ‘AWS IoT SiteWise Query API adds advanced SQL support and ODBC driver’ at 2025-07-23 20:33. Please write a detailed article about this news in a polite tone with relevant information. Please reply in English with the article only.