Nmbrs logoSailPoint logo

Identity and access management

Nmbrs to SailPoint integration: Dutch personnel records as the IAM source

With an integration between Nmbrs and SailPoint, SailPoint knows new, changed and departed Dutch employees from Nmbrs in time, so access to systems is granted automatically and revoked on the last working day. SailPoint only receives the data it needs for roles, no salary or BSN.

What the integration does

International organisations that manage access worldwide in SailPoint while the Dutch personnel records are in Nmbrs do not know new Dutch colleagues in SailPoint in time. A departure in Nmbrs only reaches SailPoint through a manual report, and roles that rely on department and job are wrong for the Dutch employees.

  1. Payroll processes a new employee in Nmbrs.
  2. KoppelHet completes what SailPoint requires, such as a unique username and a work email address, and checks that nothing is missing.
  3. SailPoint collects the data and creates or updates the employee's identity.
  4. Based on start date, department and job, SailPoint grants the right access in the connected systems.
  5. After the end date SailPoint revokes access. KoppelHet reports employees that SailPoint would reject in advance.
Nmbrs → KoppelHet → SailPointSOURCENmbrsTARGETSailPointKoppelHetmapping · logging · monitoringNmbrs → KoppelHet → SailPointSOURCENmbrsTARGETSailPointKoppelHetmapping · logging · monitoring
Out: Employee as source identity in SailPoint · Unique username, work email and surname · Start and end date · Department, job and manager for roles · Nmbrs company as legal entity

What to watch for with Nmbrs and SailPoint

  • SailPoint requires a username, work email address and surname for every identity. Nmbrs often has no business email for a new employee yet. KoppelHet completes it according to the agreed naming rule, otherwise SailPoint rejects the identity.
  • A global organisation has several HR sources in SailPoint. The priority of the Nmbrs source decides which source wins if someone also appears as an employee elsewhere.
  • Employee numbers in Nmbrs are unique per company, not across the environment. With several Dutch companies KoppelHet makes the username unique with a company code, because SailPoint rejects duplicates.
  • SailPoint reads the data at fixed moments, not when Nmbrs changes. A departure therefore works with a date; access lapses once the end date has passed, even if it was in Nmbrs weeks earlier.
  • SailPoint does not need to write anything back to Nmbrs. KoppelHet delivers the data in a form a standard SailPoint source can read, so the SailPoint team does not have to build its own Nmbrs integration.
  • Nmbrs is a payroll package with BSN, salary and bank details. Only the data needed for roles and joining and leaving goes to SailPoint, so the global IAM platform holds no Dutch payroll data.
  • Roles in SailPoint are usually defined globally, while job names in Nmbrs are Dutch. A lookup table maps each Nmbrs job to the job code that the SailPoint roles use.

This integration is also part of joiner, mover, leaver.

How we build and run it

  • The integration runs on the KoppelHet platform, hosted in a data centre in the EU.
  • Every sync and every error is visible in the functional log; on an error your administrator is notified.
  • A change that cannot go through is not half-applied but queued for another attempt.
  • KoppelHet is ISO 27001 certified. Data travels encrypted and stays on the platform no longer than needed.
  • After go-live we manage the integration and adjust it when your process changes.
  • The integration fits next to your existing integration layer. Only the fields in the design are transferred; the platform keeps no register of its own.

Implementation, architecture and compliance

Implementation and price

This is not an app you switch on. We build the integration for your organisation on our platform, with building blocks we reuse on every project. So it is custom work that does not start from scratch.

A consultant prepares the intake and analyses both systems. We then record the mapping and exceptions field by field, test in the test or acceptance environment and go live at a moment you choose. Costs are a one-off amount for the setup and a monthly amount for platform, monitoring and support.

Price indication · Basic

Leave your work email and you see the price indication right away.

We only use your address to follow up on your question about this integration.

Customer case

How it runs at Decathlon

How these organisations use the integration. The configuration differs for each customer.

Decathlon logo

Decathlon

Retail

Decathlon Netherlands uses Nmbrs as the HR source for SailPoint, so identities and access in the global IAM platform match the Dutch personnel records. A second integration brings employees into Shuttel for business mobility.

Frequently asked questions

Who manages what, the SailPoint team or KoppelHet?

The SailPoint team manages roles and rules in SailPoint. KoppelHet makes sure the Nmbrs data is complete and ready on time, and reports it when something is missing.

What if the manager works in another country?

They are then not in Nmbrs. We agree how SailPoint finds the manager, for example through the email address.

Does this also work for Shuttel or other systems?

Yes. The same Nmbrs source can also go to Shuttel for business mobility. That is a separate integration.

Technical details for IT

For those who want to know how it works under the hood: APIs, fields and sources used.

  • The target is SailPoint Identity Security Cloud. KoppelHet offers the data as an authoritative source, as a flat file (read and aggregate only) or through the Web Services connector for REST.
  • Required attributes uid (User Name), email (Work Email) and lastname; a missing or duplicate attribute causes an identity exception. Every identity belongs to exactly one identity profile; the profile priority decides which source wins.
  • The identity profile maps the attributes to identity attributes and calculates the lifecycle state from start and end date with a transform.
  • Nmbrs is read through the Nmbrs API, without BSN and salary.

Which fields are transferred

The key fields. The full mapping is agreed per customer.

Field in NmbrsField in SailPointNotes
Personeelsnummer met bedrijfscodeuid (User Name)Must be unique; a duplicate uid causes an identity exception
Zakelijk e-mailadresemail (Work Email)Required in SailPoint; empty for many new employees
Achternaam volgens naamstellinglastname
RoepnaamIdentity attribute voor voornaam
FunctieIdentity attribute voor functieBasis for roles
AfdelingIdentity attribute voor afdeling
LeidinggevendeIdentity attribute voor managerReference to the manager's uid
Nmbrs-bedrijfIdentity attribute voor entiteit
Datum in dienst en datum uit dienstLifecycle state via transform

Related

Which systems do you want to connect?

Tell us which systems you use and what should happen automatically. Together we define the smallest working solution, with a clear design and a quote before building.