SECOR Database

SECOR DATABASE is your company-specific semiconductor database: A first step towards a transparent supply chain – supported by the SECOR SaaS App (all commodity semiconductors, various standards, … scalable)

In order to future-proof your semiconductor management, the following questions may arise after consultation with the procurement, logistics and development departments:

  • Which semiconductors have a particularly high supply chain risk?
  • How can we proactively prevent the next semiconductor bottleneck (alternatively: the next semiconductor crisis)?
  • What quantities do we define as discontinued batch sizes and spare parts stockpiling?
  • How can we mitigate bottlenecks? (Exchange market, “Design for RESILIENCE”, … in compliance with antitrust law…)
  • How should we react to the “take or pay” demands of semiconductor manufacturers, how should we deal with “non-cancellable, non-refundable” contracts (duration 1-5 years)?
  • Is there no other solution than scrapping the existing surplus stock or continuing to store it?

After the first round of talks, further questions arise:

  • Which components are used in which of the parts we produce?
  • Which supplier receives which different components for which vehicle?
  • Where does the upstream supplier produce a component that was critical in the last crisis?

You quickly realise that without transparency in the supply chain, the limited resources in the team cannot be managed sensibly.

BRIEF Without a semiconductor database, semiconductor management is inconceivable.

SECOR DATABASE offers you the opportunity to efficiently and cost-effectively gain an overview step by step in order to be able to answer the above questions. SECOR DATABASE was designed by long-standing experts from the international IT, semiconductor, supply chain and automotive industries and implemented as SaaS (Software as a Service). The painful experiences from the semiconductor crisis (2021 to 2023) helped to perfect the software and prepare it for crises.

Why SECOR Database?

INCREASED
TRANSPARENCY

Overview of components manufactured in the company and their contents (preliminary products): Which semiconductors are in which component?

Where else is
the semiconductor installed?

Parameter search, where (e.g. customer, OEM, vehicle) is the part/component installed everywhere? Also, which components are in which target product (e.g. vehicle type)?

Unique
data basis

The same data fields are used throughout the company to create transparency in the supply chain. For risk analyses in the event of changed framework conditions, their effects can be better estimated in a comparable manner for different scenarios of relocations of individual stages of the supply chain, e.g. earthquake risks, acts of war, changed shipping routes, …

Fact-based
decision-making

In a crisis, different options can be evaluated, from the use of alternative semiconductors to the redistribution of scarce semiconductors within the company’s own production programme. This results in faster decision-making processes. In a bottleneck, time is a decisive competitive advantage. This has also been demonstrated by past natural disasters (earthquake in Japan, acts of war …) where the semiconductor crises could have been significantly smaller. Framework conditions can be better assessed and therefore lead to more sustainable decisions.

SECOR DATABASE use cases

In which other components in the company is this semiconductor still used? (Where-used list)
Enables the Purchasing, Logistics and Sales task force to adjust internal call-offs in the event of a bottleneck. Prevents safety stocks of another component with the bottleneck component from being stored in your own warehouse. This reduces the bottleneck.

In the bottleneck – a short query in SECOR search to see whether alternatives are conceivable. A suitable component with this alternative component could be found in the SECOR database. An internal change to the call-offs can then be checked and the bottleneck reduced if necessary.

Internal evaluation of the supplier parts that were critical in the last crisis. How critical are these with the current RESILIENCE risk assessment, is another supplier recommended if necessary, or should SECOR RESILIENCE be taken into account in future awards?

More efficient and regular monitoring of the delivery commitment with the current End of Production (EoP) dates of the semiconductor suppliers. The EoP dates are regularly updated via the SECOR PLATFORM. This means no more surprises, no more last-minute actions regarding changes to the BOM.

After an earthquake, the management wants to analyse which suppliers are affected by this region. By analysing all suppliers in the SECOR DATABASE with regard to their production location, the suppliers, sub-suppliers, etc. can be filtered out at the touch of a button.

IMPORTANT: All of the above analysis results, which are displayed in lists and tables in the SECOR DATABASE, can be exported as CSV or Excel files for further processing in your company. Optionally, graphics can be created in the SECOR Dashboard according to your regular analyses.

Discover how business analyses can change the way you work

The SECOR Dashboard gives you a real-time overview of the company-wide SECOR DATABASE – i.e. a visualisation of all components with semiconductors. Components without semiconductors can also be recorded, e.g. for calculating the SECOR RESILIENCE rate.
03 Ii Abbildung Datbase 01 Dashboard Lang 1

You get answers to the following questions at a glance:

  • How many bottlenecks are currently in the company? Which semiconductor type is responsible for this?
  • Which semiconductor comes from which production site in which country?
  • How many components contain ASIC single source semiconductors?
  • How many components would be ready for a RESILIENCE rate if a customer were to make this a short-term delivery condition or in an upcoming tender? Which SECOR RESILIENCE criterion is maintained?
  • What is the EoP date of a semiconductor before the end of the delivery commitment for a component? (Without banking risk of a bottleneck or demolition)
  • … individual graphics can be added

The main features of secor database

The SECOR DATABASE basically maps three levels
03 Ii Abbildung Datbase 02 Liste

1. Component view: (tier-1 supplier level, e.g. esp control unit)

Input of the most important parameters via import function, structured CSV and Excel file as a template for download, from the company-specific IT system (e.g. ERP system from SAP) or the machine-readable parts lists (BOM – Bill of Material). Alternatively, manually per component using selection fields with various drop-down menus via semiconductor categories, HL manufacturers, automotive-specific component clusters, automotive manufacturers (OEMs), vehicle types, …

An assembly or component entered/recorded once can be linked multi-directionally with several components, therefore only a single entry is necessary. 

2. Assembly view (level sub-supplier of an upstream product such as printed circuit board)

Can also be edited using the import/export function or entered manually. In the supply chain, the assemblies are linked “upwards” with components and “downwards” with components (multiple links are possible in each case).
03 Ii Abbildung Datbase 02 Liste
03 Ii Abbildung Datbase 02 Liste

3. Component view (level semiconductor manufacturer e.g. microprocessor or sensor)​

Can be entered both manually and via the import/export function. In the supply chain, they are linked “upwards” with the assembly; multiple linking is possible. All commodity semiconductors in the SECOR PLATFORM can be accessed efficiently and linked with just one click. ASIC single source semiconductors, semiconductors individually designed for a user, are of course not to be found there. The SECOR semiconductor matrix provides an overview of the semiconductors currently recorded on the SECOR PLATFORM

take the next step​

Would you like to gain first experience with SECOR DATABASE?
Bring transparency to your supply chain step by step…

With pleasure, we look forward to it! Please click here to register free of charge
Register now

If you have any questions, please contact us directly at info@secor-sct.com

Your data is safe with us. We use the Hetzner cloud, so all servers in the EU are managed 100% in accordance with the GDPR. Your company-specific data is protected by two-factor authentication.