Insight generation based on retrieved PLM data
Provided are systems and methods that can extract part data from a PLM database and suggest changes to the manufacturing of the part. In one example, the method may include querying a database for a plurality of values of a part to be manufactured from a plurality of fields of computer-aided design (CAD) file stored in the database, mapping the plurality of fields of the CAD file to a plurality of corresponding fields of a host platform based on a type of the database, extracting the plurality of values from the CAD file and transferring the plurality of values to the mapped plurality of corresponding fields of the host platform, determining changes to one or more manufacturing attributes of the part to be manufactured based on the transferred plurality of values, and outputting the changes to a display.
1. A computing system comprising:
a processor configured to
receive a query from a host platform via an agent installed on a product lifecycle management (PLM) database, wherein the query comprises a request for a plurality of values of a part to be extracted from a plurality of fields of a PLM object stored in the PLM database, wherein the host platform is connected to the agent via a computer network, and the plurality of fields comprise a plurality of field names in a format of the host platform,
translate, via the agent installed at the PLM database, the plurality of field names in the format of the host platform into a plurality of field names in a format of an application programming interface (API) of the PLM database,
execute, via the agent installed at the PLM database, an API call on the PLM database based on the plurality of translated field names to extract the plurality of values of the part from the plurality of translated field names within the PLM object stored in the PLM database, and
transfer the plurality of values extracted from the agent installed at the PLM database to the host platform,
determine changes to one or more manufacturing attributes of the part to be manufactured based on the transferred plurality of values, and
output the changes to a display.
2. The computing system of claim 1 , wherein the processor is configured to generate one or more API calls via the agent installed at the PLM database which identify the plurality of field names in the format of the API of the PLM database and transmit the one or more API calls to the PLM database.
3. The computing system of claim 1 , wherein the processor is configured to map fields from the PLM database to corresponding fields of the host platform via the agent installed at the PLM database based on a type of the PLM database.
4. The computing system of claim 1 , wherein the processor is configured to transmit a query statement, via the agent installed at the PLM database, to the PLM database which includes a part identifier value, a part number value, and a revision number value, of the part to be manufactured.
5. The computing system of claim 1 , wherein the processor is configured to generate different mappings based on whether the API call is to be executed on an API of a first type of PLM database or an API of a second type of PLM database.
6. The computing system of claim 1 , wherein the processor is configured to identify changes to one or more attributes of the part to be manufactured to reduce cost of manufacturing, and display the identified changes via a user interface.
7. A method comprising:
receiving a query from a host platform via an agent installed on a product lifecycle management (PLM) database, wherein the query comprises a request for a plurality of values of a part to be extracted from a plurality of fields of a PLM object stored in the PLM database where the agent is installed, the host platform is connected to the agent installed at the PLM database via a computer network, and the plurality of fields comprise a plurality of field names in a format of the host platform;
translating, via the agent installed on the PLM database, the plurality of field names in the format of the host platform into a plurality of field names in a format of an application programming interface (API) of the PLM database;
executing, via the agent installed on the PLM database, an API call on the PLM database based on the plurality of translated field names to extract the plurality of values of the part from the plurality of translated field names within the PLM object stored in the PLM database;
transferring the plurality of values extracted from the agent installed at the PLM database to the host platform;
determining changes to one or more manufacturing attributes of the part to be manufactured based on the transferred plurality of values; and
outputting the changes to a display.
8. The method of claim 7 , wherein the executing comprises generating one or more API calls via the agent installed on the PLM database which identify the plurality of field names in the format of the API of the PLM database and transmitting the one or more API calls to the PLM database.
9. The method of claim 7 , wherein the translating comprises mapping fields from the PLM database to corresponding fields of the host platform via the agent installed on the PLM database, where the corresponding fields of the host platform have different field names than the fields from the PLM database.
10. The method of claim 7 , wherein the executing comprises transmitting a query statement, via the agent installed at the PLM database, to the PLM database which includes a part identifier value, a part number value, and a revision number value, of the part to be manufactured.
11. The method of claim 7 , wherein the translating comprises translating the plurality of field names in the format of the host platform into the plurality of translated field names in the format of the PLM database via an agent installed in an intervening computing system between the PLM database and the host platform.
12. The method of claim 7 , wherein the mapping the plurality of fields comprises generating different mappings based on whether the API call is to be executed on an API of a first type of PLM database or an API of a second type of PLM database.
13. The method of claim 7 , wherein the determining comprises identifying changes to one or more attributes of the part to be manufactured to reduce cost of manufacturing, and displaying the identified changes via a user interface.
14. A non-transitory computer-readable medium that includes instructions which when executed by a processor cause a computer to perform a method comprising:
receiving a query from a host platform via an agent installed on a product lifecycle management (PLM) database, wherein the query comprises a request for a plurality of values of a part to be extracted from a plurality of fields of a PLM object stored in the PLM database where the agent is installed, wherein the plurality of fields comprise a plurality of field names in a format of Hail the host platform;
translating, via the agent installed at the PLM database, the plurality of field names in the format of the host platform into a plurality of field names in a format of an application programming interface (API) of the PLM database;
executing, via the agent installed at the PLM database, an API call on the PLM database based on the plurality of translated field names to extract the plurality of values of the part from the plurality of translated field names within the PLM object stored in the PLM database;
transferring the plurality of values extracted from the agent installed at the PLM database to the host platform;
determining changes to one or more manufacturing attributes of the part to be manufactured based on the transferred plurality of values; and
outputting the changes to a display.
15. The non-transitory computer-readable medium of claim 14 , wherein the executing comprises generating one or more API calls via the agent installed at the PLM database which identify the plurality of field names in the format of the API of the PLM database and transmitting the one or more API calls to the PLM database.
16. The non-transitory computer-readable medium of claim 14 , wherein the translating comprises mapping fields from the PLM database to corresponding fields of the host platform via the agent installed at the PLM database, where the corresponding fields of the host platform have different field names than the fields from the PLM database.
17. The non-transitory computer-readable medium of claim 14 , wherein the executing comprises transmitting a query statement, via the agent installed at the PLM database, to the PLM database which includes a part identifier value, a part number value, and a revision number value, of the part to be manufactured.