Digital twins and large data quantities - what are your performance tips to deal with millions of (federated) datasets?
Hi community, Aras currently posts a lot of digital twin related content and we jumped on the hype train. We right now combine EBOM/MBOM with ERP, production and test data. User can see data of individual products or can do all kinds of reporting over the complete data. We are still at the beginning of this concept. Right now people are mainly interest in reports and calculations. It´s nothing we haven´t done before. Certain data was already federated in Innovator in the past. But users had to connect certain data from the various sources manually or ask an admin to create reports that are more sophisticated. The digital twin concept allows more freedom to approach. But the bottleneck is currently the test data. We do automated tests of electronic components. A few hundreds tests per individual product are common. So the amount of data is very huge (millions+). Certain queries and reports that are currently possible might probably fail in the future due to the increasing amount of data. It´s not an issue right now, but I want to be prepared for the future. What are the best practices to optimize performance regarding large amounts of federated data? I checked the official Platform Specification that is available online. It contains many hints regarding hardware recommendations for a certain amount of users, Vaults, etc. It´s a useful guide, but it doesn´t cover federated data and digital twin use cases yet. What do you recommend? What can we do on database / infrastructure level? 1. Optimize database structures (better query design, indexing, caching, etc.)? 2. Throw more hardware at the problem? This one is not necessarily an Innovator issue. PLM and SQL are designed to deal with a huge amount of data. There are big corporations which thousands of users and endless data vaulted over the whole world. But I would be happy about anyone that can give some additional insights, ideas or recommendations! Many thanks!! Angela
Federating Files in ARAS
Hello, I am currently looking into federating some data coming from another system in ARAS. The objects themselves are already being displayed correctly but now I'm looking into being able to display the main file for each of there objects in ARAS. I wanted to ask if there is a way to "federate" the files while still being able to use the native ARAS file item fields, etc... The amount of files is quite high so if possible I would like to avoid creating File Items for all of them... Thank you, BernardoHow does the permission system work on database level?
Hi Community, In Innovator, we can use permissions to specify which users are allowed to view, edit, or delete an item. I have a federated item type with a custom onGet method. Since SQL federation with onGet bypasses the standard permission system, any restrictions have to be implemented within the SQL query itself. I am wondering whether it is possible to customize my federation solution to support the existing permission framework. In my case, I would like to use the built-in identities such as "Creator", "Owner", and "Manager" to provide a more "natural and consistent permission experience". This leads to the question: How does Innovator actually enforce permissions? In the end, all regular data comes from SQL tables, so Aras must be applying some kind of security logic at the database level. I did some research and discovered the following: In SQL Server, there are "secured" versions of the regular tables that combine the underlying data with the results of the innovator.EvaluatePermissions function. My theory is that when a user requests data (for example, "Show me Parts"), the data is not retrieved directly from the innovator.Part table, but rather through the secured.Part function. Has anyone ever tried to replicate this mechanism in the context of federation? Any tips or ideas? Angela