i didn’t meant the source data I meant the data source which SSIS will use to connect to the data.
How do we secure the data source connection?
Correct me if I’m mistaking with my logic
1. Connect to data source using SSIS
2. Extract data using packages which can be encrypted right?
3. Transform the data using SSIS
4. Load the cleansed data into a data warehouse using SSIS.
5. Analyze the data in the data warehouse using SSAS and generate a tabular model.
6. Connect to SSAS using power BI and generate reports in Power BI reporting server
is this the correct logic?