Source data security

  • hurricaneDBA

    SSCarpal Tunnel

    Points: 4755

    Hi Everyone

    i was asked to build a data warehouse which uses SSIS to ETL data from 5-6 data sources

    my main issue with my design is how do I deal with authorization control for the data sources being loaded into the data warehouse? I mean when I load all the data from all the data sources how do I segregate the data in the DW? So I get all data from finance separate from HR, etc.

    I’m interested in the security best practice here

     

    kal

  • Eric M Russell

    SSC Guru

    Points: 124967

    It's unclear if you're asking a modeling question or a security question. For example, are you asking how grant DW users access only to financial data but not HR ?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • hurricaneDBA

    SSCarpal Tunnel

    Points: 4755

    Hi Eric

    I’m asking a security question about how SSIS keeps the source data secure? SSIS we’ll use packages and connection managers to access the data sources and extract and load data into the DW right?

    how is this secured from unauthorized users?

     

    kal

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply