Integrated Data Management
GEMS creates, distributes and follows-up data requests to other organizations in your supply chain.
A typical GEMS installation will include at least one of the following:-
- External Data Inputs via Web Connector
- Internal Systems including spreadsheets, and sales and ERP/PLM data from systems such as SAP and Oracle
- Supply Chain Data using the supplier portal, your own forms or standard forms such as IPC 1752
External Data Inputs
Data may be obtained directly from external sources in a number of ways including Web Connector & direct updates.
Web Connector
Your larger suppliers may have substance data available on their Websites. Foresite's Web Connector will enable you to automatically pull RoHS compliance data down from those sites into the GEMS database and associate it with the GEMS BOM.
Direct Updates
GEMS can pick up directly from data from external databases / spreadsheets provided you are licensed to retrieve the data. These sources can include other copies of GEMS, subscription data databases and agency/distributor data.
Internal Systems
GEMS interfaces and integrates with all major ERP/MRP/PLM and product specification systems including SAP, Oracle, JBA, Agile, MatrixOne, JD Edwards, and BPCS. GEMS can also integrate with multiple systems simultaneously, either periodic or real-time, to ensure that GEMS is constantly synchronised with back-office systems. GEMS collects the data needed to meet the reporting requirements including Bill of Materials data, supply chain contact details, and sales and purchase information. GEMS may also send summary, compliance or cost data back to other systems.
GEMS may also feed cost and analysis data back if required.
GEMS will pick up Bill of Material Data, Supply Chain contact details , Sales Data (and purchase where applicable) as well any other4 date needed to complete the reporting requirements. The interfaces are often two-way sending summary/compliance/cost data back to the other system.
Supply Chain Data
GEMS will create, distribute and follow-up data requests to other organizations in the supply chain. The GEMS forms library and Data Flow Manager combine to send out different forms, including any or all of IPC 1752 forms, REACH questionnaires or your own forms.