The Business Case for ETL Studio in Spar Nord ?· The Business Case for ETL Studio in Spar Nord Bank…

  • Published on
    03-Aug-2018

  • View
    212

  • Download
    0

Transcript

  • The Business Case for ETL Studio in Spar Nord Bank

    Jens Borch ChristiansenSpar Nord Bank A/S

  • Agenda

    Current situation Business requirements Architecture Use of SAS ETL Studio Evaluation of SAS ETL Studio Examples

  • Current situation

    Facts of lifeMultiple and incoherent data sourcesLimited control over data extracts from major backend transaction systemsData delivery times are not exactMany redeliveries of data from backend systemsNo single definition of reality

  • Current situation

    Existing data warehouseHomemade end user web solutionsHomemade batch environmentAd hoc data modelAd hoc ETL (extract, transform and load) processes written in Base SAS

    Broad Base SAS access to dataMany manually distributed ad hoc paper based reportsScarce documentation

  • Business requirements

    Unified definition of RealityWell documented data model and data loadsThe ability to easily trace data from DW to sourceFewer homemade solutionsEffective data loadsBetter control over access to dataBetter separation between developers and administrators

  • ArchitectureKerne

    FED

    Midas

    Axapta

    Kundemappe

    Data adgang (data acces)

    Data staging area

    EntrepriseData Warehouse

    Mart 1

    Mart 2

    Mart 3

    Financial ManagementSolution etc.

    Mart 4HRM

  • Use of SAS ETL Studio

    Data staging area loaded using simple SAScopy job

    Custom ETL transformations done using SAS macros in order to leverage existing SAS knowledge

  • Use of SAS ETL Studio

    All documentation in SAS ETL Studio ER mode diagrams extracted from ETL

    Studio using Computer AssociatesAllFusion ERwin Data Modeler

    Extensive use of links to external documentation

  • Evaluation of SAS ETL Studio

    Powerful tool for ETL documentation Currently requires many userwritten

    transformations Rich set of possibilities for creating

    userwritten transformations Easy to deduce relationships between

    source and target tabels

  • Evaluation of SAS ETL Studio

    Not as flexible as Base SAS

    Requires some Base SAS knowledge to use effectively

    Less control over code Great potential

  • Example

  • Contact information

    Jens Borch Christiansenjbc@sparnord.dk

  • Trademarks

    SAS

    Computer Associates AllFusion ERwinData Modeler

    The Business Case for ETL Studio in Spar Nord BankAgendaCurrent situationCurrent situationBusiness requirementsArchitectureUse of SAS ETL StudioUse of SAS ETL StudioEvaluation of SAS ETL StudioEvaluation of SAS ETL StudioExampleContact informationTrademarks

Recommended

View more >