Solution:
1. Data Extraction: Utilized an API to extract salary data from SAP SuccessFactors.
2. Data Encryption: Employed Python cryptography libraries to encrypt the sensitive
salary data before storage.
3. Data Loading: Loaded the encrypted data into Amazon Redshift, ensuring compliance
with data security protocols.
4. Decryption Logic: Developed a secure decryption mechanism in Power BI using a
dedicated decryption key to provide controlled access to the data for reporting purposes.
5. Key Management: Automated the sharing of the decryption key via email daily,
ensuring secure access without exposing the key within the Matillion environment.