Data Extractor

Course Objective:

The purpose of the course is to give participants specialist knowledge about our integrated Data Extractor tool and the Dimension database that it is used.

During the course, the participants will be presented to the SimCorp Dimension Database Structure and the Data Extractor tools. The course will be a mixture of theory, SimCorp Dimension presentations, and hands-on exercises.

Main Learning Topics:

Database Structures

  • Static Data and Reference data
  • Holdings and Holding Keys
  • Portfolio Calculations
  • Dictionary

Data Extractor (DEX)

  • Extraction Definitions
  • Extraction Setup
  • Extracts Exporter
  • Extracts Viewer and Validator

Advanced features

  • In line views
  • Advanced Extraction Definitions
  • Formulas
  • User Schema management
  • Extracts based on user defined extract tables (DEX on DEX)

Pre-requisites:

Basic database understanding (tables, fields, SQL, joins) Preferably knowledge equalling SimCorp Dimension Technical User Academy.

Duration:

Days: 2
Daily training hours: 9 - 17

How to register for this course

Click your preferred date below and register by filling out the form.

If no date is found for your preferred course please contact coursebooking@simcorp.com to request the course.