April 10, 2019 at 2:24 pm
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
April 10, 2019 at 5:50 pm
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
April 11, 2019 at 5:49 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply