Source data security

  • hurricaneDBA

    SSCarpal Tunnel

    Points: 4744

    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: 124909

    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 ?


    "The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."

  • hurricaneDBA

    SSCarpal Tunnel

    Points: 4744

    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