Skip to content
palandreassen edited this page Mar 27, 2019 · 68 revisions

Getting started with GDPR

1. Table of contents

2. Portal setup

2.1 Setting up

  1. Go to https://portal.sesam.io and click on sign up.

  2. Once you have signed up click on New GDPR portal.

  3. Fill in your contact and payment information.

  4. You will then see your GDPR portal on the dashboard. From here you can add members to your site and administrate your subscription as shown in the picture below.

  1. When inside settings, set name of your GDPR portal and add a description that will be seen by the data subject.
  1. Select GDPR in the left column navigator and fill in your domain name.

The domain name is the internet address (DNS name) where your GDPR data access portal should be available to the users (data subjects in GDPR lingo). You can choose any name you want, as long as it's not already in use by someone else. Your GDPR data access portal will then be available on the web (e.g. https://your-selected-name.sesamdata.com).

  1. Click on Learn more and download the Excel file.

GDPR excel

2.2 Filling out the Excel template

  1. Fill in the Purposes and Datatypes. There are examples for you to follow. Remember to fill in the contact information for the person responsible for each system. This contact will receive a mail when somebody asks for request.

  2. What you really need to identify your systems, which types of personal data are in those systems and what purposes gives you the right to have the personal data.

2.3 Uploading file to portal

  1. Navigate to GDPR in the left column.

  2. Upload the GDPR setup data Excel file after you have filled-in the necessary information.

2.4 Customize your portal

You can customize you portal by uploading your own logo if you want to.

That's it! Your GDPR portal is all set.


3. Data access request

3.1 Request data

  1. The data subject can now log in to your portal to request their data.

The URL will be the one you chose in the setup process, for example yourcompany.sesamdata.com

  1. The data subject can log in with their email or phone number. This is a two-factor secure login that requires the subject to confirm a one-time password. Test logging in yourself!

  2. The data subject can now request their data or ask to be deleted

3.2 Request handling by system owner

  1. The system owners specified in the GDPR Excel setup will receive an email about the request made by the data subject.


  1. Download Request template for handling the access request
  1. Fill in the Request template for the specific data subject. You can use field names that you find fitting and add as many columns as needed. Then save the Excel document.
  1. Upload the filled-in Request template in the portal. The access request is now handled.

  2. The data subject will now be informed via email or text message that the data is available.



3.3 Data subject can view data and execute their rights

When the data subject logs back in he or she can now view their data and execute all their rights.

  • Right of access (art. 15)

  • Consent (art. 7)

  • Right to be forgotten (art. 17)

  • Right to rectification (art. 16)

  • Right to data portability (art. 20)

  • Breach notification (art. 34)

  • Right to object (art. 21)

  • Right to not be subject to automated decision-making (art. 22)

  • Right to restriction of processing (art. 18)

Automation of data request handling

If we have an automatic version of the GDPR platform we can set it up so that it handles data access requests automatically. The data will be delivered to the data subject without human intervention. We can do this because we use the Sesam integration platform with our GDPR platform. Using the Sesam integration platform means we make a copy of all the data we want to make available for the GDPR platform into its Sesam datahub. Once the data is available in the datahub, the system can serve data access requests on it's own.

To set up this automation we need to take care of a few things:

  • Import data from our data systems to the datahub of the GDPR platform
  • Refer to the input pipes of our GDPR platform in our "GDPR setup data automated" excel sheet
  • Update a pre-built pipe

Import data

We have to copy all the data from our source systems that contain data that could be served to our data subjects. We can import this data from different types of sources like databases, APIs, CSV- or XML-files. We do this by creating "input pipes" that copy all the data from a source. The pipes connect to external sources through "systems" in Sesam, which serve connection strings, connection pooling, authentication etc. Take a look at our Getting started with Sesam guide to learn how to configure pipes and systems to connect to external data sources.

For testing purposes We have pre-made a few pipe configurations with embedded test data. We can use these pipes to setup and test the automation with some dummy data before connecting to our real data sources.

Create four new pipes and paste the configurations provided in the links below. We change the values of the first entity of the embedded data in these configs to match our own email address so that we can test the platform as a data subject ourselves.

Purposes and data types

As we fill in the excel sheet with purposes and data types we now also have to specify from which dataset the data is pulled. To do this we need to match the rdf:type in the pipes with the TypeID column in the excel file, like shown in the picture below:

We also need to specify the identifiers in the Excel file. These identifiers are what connects the data in the datasets to the data subject that is requesting their data. As you can see we have chosen EmailAddress in this example, but it could be almost anything. It could also be multiple identifiers separated by comma (no spaces).

Update pre-built pipe

  1. Open pre-built pipe custom-subject-data and update this pipe with all our input datasets. Here we add four datasets salesforce-contact, salesforce-eventrelation, salesforce-lead and salesforce-task as our sources. After updating the pipe it should look like this:
  "_id": "custom-subject-data",
  "type": "pipe",
  "source": {
    "type": "merge",
    "datasets": ["salesforce-contact sc", "salesforce-eventrelation se", "salesforce-lead sl", "salesforce-task st"],
    "equality": [],
    "identity": "first",
    "strategy": "compact",
    "version": 2
  }
  1. Now we can check the output of another pre-built pipe gdpr-subject-data-update (remove the "user" filter to see the complete list of pipes). Check the output of this pipe and you should see all the entities from all four datasets. These entities will eventually go into data subject as per his or her data access request.

  2. That's it! We can now make a request as a data subject using our GDPR portal for the related data stored with the company.

Working with "Related" data type levels:

  1. Until now we are able to fetch data based on "Personal" data type level for corresponding identifier. Now we will see how related data also gets fetched using "Related" data type level. To test this functionality, we have now added a new row for "Related" data type level in our excel sheet as showing below.
  1. Save this excel file and upload to Sesam GDPR node.

  2. Create the new pipe for "Related" level called salesforce-attendee in GDPR node.

  1. Add this dataset entry info to pre-built pipe custom-subject-data.
{
  "_id": "custom-subject-data",
  "type": "pipe",
  "source": {
    "type": "merge",
    "datasets": ["salesforce-contact sc", "salesforce-eventrelation se", "salesforce-lead sl", "salesforce-task st", "salesforce-attendee sa"],
    "equality": [],
    "identity": "first",
    "strategy": "compact",
    "version": 2
  }
}
  1. That's it. You can now make the request and will be able to see all the personal data as well as related data. Make sure you run all the pipes after resetting it to get latest change.

Deletion or change requests

The data subject has the right to be forgotten (deleted) or have their data rectified (changed). To support rectification of data you will have to set up the GDPR data access portal to allow for it. You can read about how to do that in the databrowser guide.

When a deletion or change request is submitted to a manually updated GDPR platform, an email will be sent to the address(es) listed as "Contact" in our uploaded "Purposes and Data types" excel sheet for the relevant data type(s). This recipient of this email needs to be a user in the Sesam portal assigned the "GDPR operations" role. The recipient of the request will then have to manually update the source systems as per the request. Then the GDPR operator will have to reupload a an excel sheet as if a new data access request has been submitted to reflect the changes.

For an automated GDPR platform it is possible to process change and deletion requests automatically by triggering changes or deletions directly in the source systems. See the GDPR platform developer documentation for information about automation and the APIs offered for implementing such a mechanism.

GDPR unstructured data handling

Up to this point we have been working with "structured" data. However, data is not always going to be structured in the real world. Fortunately, Sesam GDPR node also supports handling of GDPR unstructured data. Visit GDPR unstructured data support to learn more about this.