Encrypted Strings
The Encrypted Strings screen in AnalyticsCreator provides a secure way to manage and store sensitive information such as connection strings, credentials, or authentication tokens. These values are encrypted within the repository to ensure they are never exposed in plain text during ETL processing or deployment.
Encrypted strings can be referenced by other components (for example, connection objects, deployment configurations, or parameters) without revealing their actual content. Only authorized users can decrypt or modify these entries.
The screen consists of a searchable list where you can view, add, and manage existing encrypted strings.
| ID | Column | Description |
|---|---|---|
| 1 | Name | The logical name of the encrypted string. This identifier is used when referencing the encrypted value within the project (for example, MSSQL or AzureBlob). |
| 2 | Encrypted String | The secured value stored in encrypted form. This field cannot be viewed directly but can be decrypted by authorized users if necessary. |
| 3 | Protected | Indicates whether the string is protected from modification. When checked, only users with elevated privileges can alter or delete the encrypted value. |
| 4 | Decrypt Button | Allows authorized users to temporarily decrypt and view the content of the selected encrypted string for verification or troubleshooting purposes. |
Search Criteria: Use the search field to quickly locate specific encrypted strings by name. The list filters dynamically as you type, allowing easy management even with many entries.
Security Notes
- Encrypted strings are stored in a secured section of the repository and cannot be accessed without decryption rights.
- Only users with the required permissions (as defined in User Groups) can create, modify, or decrypt entries.
- Encryption ensures compliance with security best practices and data protection policies (e.g., for GDPR and internal audit requirements).
- When exporting or deploying projects, encrypted values remain secure and cannot be reverse-engineered from DACPAC or SSIS packages.
Screen Overview:
