Who is using the Aras SQL 'Federation ItemType Sample v3-1' and can share experience?
Hi community, Does anyone of you use the 'Federation ItemType Sample v3-1'? It´s a sample project that can be used to access external SQL database data via federation more easily. It basically contains a configuring ItemType that helps to setup the SQL connection faster, so you don´t have to code anything. As far as I know it´s only available for subscribers, but I think also free-users that don´t use this project can benefit from this discussion. The basic concepts of federation are always the same. I really like the project, cause it´s well designed and works fast and reliable. The project is a excellent foundation for federation. But form my POV there are still a lot of useful features missing (or simply weren´t implemented yet). I am looking for people who also use the project and have some experience with it. Maybe you even have enhanced the feature and want to exchange your ideas? I have done a couple of customization and would be happy to exchange them with other users! Enhancement that I have done myself: Keyed_name support for federated items (by default they just can show the id). Very useful, also my implementation is a bit of a dirty hack. So I am looking for way to solve this one a more professional way. Changed existing search mode to support wildcard search in item keyed_name (it´s an extension to the keyed_name support above) Support for integer search modes like >, <, <=, >= . By default you just can search for 'eq' and 'like' values. Support for maxResults, pageSize in the grid . This way users get better feedback when you have restricted the number of returned results Bug fix that prevents MPP to crash when you use a federated relationship in ItemType 'Part'. Bug fix to prevent item Preview crash when you use a federated relationship Enhancement or knowledge that I am looking for: Support for 'sort accross pages' Date Range search mode Enhancement regarding security, e.g. add some kind of permission system. The current Aras project seems to contain a lot of fields and functions that are just placeholders for future features. Or maybe I just don´t know how to use them? Ideas for enhancements or alternative concepts to do this kind of federation Of course also general feedback is helpful: Do you use the feature? If yes, how? Just for simply display of external data, or do you mix-n-merge? What is your experience regarding federation? Maybe you also know some bugs that occur in certain scenarios that I haven´t noticed so far? If you don´t use the project cause you´re not a subscriber you are also invited to join the discussion! If you are familiar with federation, you maybe also know some way to improve the display and work with external data. I assume similar pitfalls as in the project occur when you write your federation code by yourself. So most of the questions and enhancements should also be relevant for users who use a different concept Would be happy to connect and hear your experience! Every input welcomed! Many thanks already! AngelaDigital 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, Bernardo
How to synchronize the data of MPP_process plan with all its releationships with PostgreSQL Database
Hi, I'm a research student and we are doing a university project on PLM, we have an idea of storing and interacting the data of PLM systems with other systems like MES and ERP so we thought to create a central database through which every system will interact with other systems. Now we have to synchronize the data of MPP_process plan with all its releationships with PostgreSQL Database where the central DB is located, we wanna do this as a trail test to sync the data from Aras server into our Central Database and vice-versa. We are thinking not only to export the data for single time, but to Auto update of the data atmost real time. One of my friend from this Aras community suggested me to do by federation services but I don't know how to apply and how it works.! Or you have any other ideas how we can do? someone suggest me how to do. Thanks inadvance.
Federation - Item count
Hello, I've created a federated ItemType to pull in data from an ODBC data source and it seems to be working great apart from one thing: When running a search the status bar at the bottom reports '0 items found', and consequently you can't page through the results. 25 results do actually appear on screen though! Looking at the results in AML Studio I can't see any difference between what my onGet returns and the results of any other query on a normal native ItemType, so I'm not sure how I'm supposed to communicate the number of results (and page number) to the UI. To save uploading all my code, my results are assembled by: Create inn.newItem("my federated type") Set attributes and properties Get AML of new Item and append to string Repeat this for all results Strip the isNew and isTemp attributes from the AML Wrap in <Result> tags Return via inn.newItem().LoadAML(mystring); This is probably the most roundabout way of assembling a result set but I couldn't find any better way that worked at least as far as I've got. Any pointers to documentation on how to do this better, or ideas on how to handle the item count gratefully received. Many thanks in advance, Ben ps. We're on V11 SP5
