While ago, PTC announced a new release of ThingWorx Platform (8.4). Among other exciting features, this release has OOTB support for integration with InfluxDB. At the first glance it’s “only” support for another database, but after taking a closer look, it’s tremendous move, which makes PTC’s IoT environment even more reliable and even better in terms of big data capabilities.


And considering the fact, that IoT is absolutely based on data – it’s a direction we all would like ThingWorx to go. This partnership, one of many strategic moves of PTC in the last years, is presented as “empowering developers to build next-generation IIoT, analytics and monitoring applications”.


We at Transition Technologies PSC believe, that even great leap starts with a small first step. In this case, this first release of Influx support has an opportunity to be itself a groundbreaker for all of those, who don’t believe in big data in ThingWorx. It’s a perfect step to have a background for all further areas, starting with real and historical time monitoring through data aggregation and app metrics up to data analysis or machine learning. Every IoT application craves for data and there are companies, sending daily billions of data points. A whole Internet of Things concept is based on data. Everyone talks about data ingestion, data storage, data analysis. To the present day during ThingWorx projects we had to spend time in order to analyze what data we need to retrieve, how we need to store it, which database engine to use and what mechanisms can increase the performance of the whole system. Now it’s a lot easier. At least when it comes about historical data from our sensors or external systems, we have out-of-the-box feature, which can be easily wired up.


Now your time-series data has a better place to go!


InfluxDB is a well-known open source time-series database platform, which has proven one of the best solutions for large amount of time-value data. Scalable, with available clustering and high availability mechanism, it becomes a great choice for your data, persisting in a high velocity (even up to millions writes per second). It’s a first Time Series DBMS available in ThingWorx, bringing your IoT applications to the whole new level.

 
Wsparcie ThingWorx dla InfluxDB
 

Time Series databases are those designed especially for Internet of Things to support collecting, storing and querying large volume of timestamped data. Of course, we can use other types of database types in such cases, but Time Series DBs resolve specific challenges, such as downsampling data (grouping by time), comparison with other records or joining time series.


Not to mention monitoring capabilities, high compression and retention policies, which allows to help DB administration.


InfluxDB comes in two flavours: community and enterprise edition. The first one is available in open source licensing schema, but with single node. Enterprise edition allows to have a few additional benefits (full support, clustering, incremental backup and others). You don’t even need to define and create a schema, it’s automatically generated based on the data you store!


However, it is worth remembering, that InfluxDB is not to replace standard model databases (PostgreSQL, MS SQL Server) – it is thought to cooperate with them, splitting up the model definition and the data storage. By the way – mentioned model databases are the only ones supported now to work with InfluxDB. What’s more, currently the whole mechanism supports only ThingWorx’s Value Stream and Stream storage options.


What about other storage possibilities?


Currently for ThingWorx we have couple of database options, but – excluding DataStax Enterprise Cassandra – there’s no database specialized in high volume data ingestion. Even mentioned DSE is “only” NoSQL Graph Database. Having some powerful abilities, it is still no match for InfluxDB in time series data storage.

 
Wsparcie ThingWorx dla InfluxDB
 

And what next?


Even having in mind all the limitations of the current release of ThingWorx’s InfluxDB Persistence Provider (come on, it’s a first release!), we at PSC are having great time, pushing this topic to the limits in order to provide best information to all those, who are ready to dig into this topic with us.


This is a very first step, but there are next big plans in the pipeline. Better support for query operations, supporting additional InfluxDB features or improvements in data ingestion through the ThingWorx Platform – just to name most exciting ones. It allows ThingWorx to absorb, persist and analyze a lot more data than ever before.


We are ready, and how about you?

_All posts in this category

blogpost
Articles

Lesson Learned Explained: Implementing a Continuous Innovation Program in the Defense Sector

In the fast-paced aviation and defense industry, one of our clients faced a key challenge: how to accelerate the adoption of modern technologies and maintain competitiveness. The solution? Implementing a Continuous Innovation Program as the foundation of a new business model. A crucial aspect of this program was the continuous testing of state-of-the-art technologies to bring increasingly innovative products to market.

Read more
blogpost
Articles

Lesson Learned Explained: Advanced Digital Manufacturing, AR/VR, and HoloLens in the Pharmaceutical Industry

A pharmaceutical company aimed to enhance its innovation by actively testing modern technologies. A key challenge was skillfully and effectively integrating technological innovations into the production area so that data could be collected and analyzed in real-time. The company wanted to show that it is in the "close peloton" of digitalization of production, thereby increasing its market competitiveness.

Read more
blogpost
Articles

Lesson Learned Explained: Systems Integration and Data Modeling for Improved Semiconductor Manufacturing

A company in the electronics industry specializing in semiconductor manufacturing set a major goal to make improvements that positively affect the quality of final products. A key element was to monitor and identify correlations that would predict the satisfactory quality of products coming off the production line. This was done using data from machines and quality control stations, which was then subjected to in-depth analysis. This enabled the company to better understand which factors affect the quality of their products.

Read more
blogpost
Articles

Lesson Learned Explained: Improving monitoring, production stability, and product quality in the automotive industry

An automotive company needed a solution to monitor production to improve the quality of final products. The key element was identifying issues by analyzing quality data correlated with production data. Special attention was given to the casting and cooling zones, where product quality was particularly variable.

Read more
blogpost
Articles

Lesson Learned Explained: Data visualization in components manufacturing for automatics

A global company in the electrical accessories manufacturing industry used in automation faced the challenge of improving key performance indicators (KPIs), particularly increasing the availability and efficiency of production cells. Each workstation involved multiple stages of assembly and production across various positions and locations, requiring a coordinated approach to managing work, materials, and proper planning.

Read more
blogpost
Articles

Lesson Learned Explained: Digitalization of reporting processes in the glass packaging manufacturing industry

A client, a leader in the glass packaging manufacturing sector, identified the need to implement an integrated production data management system to replace outdated, manual reporting methods.

Read more
blogpost
Articles

Lesson Learned Explained: Improving KPIs in the FMCG Industry through automation and data analysis on semi-automated production lines

Introduction In the highly competitive food and beverage industry, achieving optimal Key Performance Indicators (KPIs) such as availability, performance, and quality is essential for maximizing operational efficiency and profitability. A client operating semi-automated production lines was experiencing persistent underperformance in these KPIs. To address this issue, the company required a robust and precise data-driven approach […]

Read more
blogpost
Articles

Lesson Learned Explained: how proper data collection and storage proved crucial in predictive maintenance

In the aerospace and defense industry, which is characterized by particularly high requirements for precision and reliability, key performance indicators in maintenance, failure prediction or machine condition monitoring, are crucial.

Read more
blogpost
Articles

Industry 4.0 in the context of manufacturing companies

Industry 4.0, also referred to as the fourth industrial revolution, is a concept encompassing a complex process of technological and organizational transformation of companies, which began in 2013.

Read more
blogpost
Articles

OEE: is your company stuck in a manipulation trap?

If you think OEE has no secrets to you and your plant maintain highest OEE results… think again. Harsh truth is that most manufacturing plants’ OEE land somewhere between 35 and 43%. They just don’t know about that.

Read more

Let’s get in touch

Contact us