The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Sergey
OneStream Employee
2 years agoSQL table editor : parametrize the source of data ?
Hello,
In the SQL table editor component, we can define namely the Schema Name, Table Name, Table Column Names, Where Clause and Order By Clause :
However, I am using a Table that has encr...
JackLacava
OneStream Employee
2 years agoYou can tweak saving actions in rules, but I don't see how you could possibly inject rules when first loading SQLTableEditor (unless one went the full "v8 way" with service factories and all that, which is kinda experimental still - and even then I don't know if it'd be possible).
What you might be able to do though, is create a separate External Connection and stuff your encripytion requirements in its connection string - which seems doable with stuff like https://learn.microsoft.com/en-us/sql/connect/odbc/using-always-encrypted-with-the-odbc-driver?view=sql-server-ver16 (warning: I've not tested it). Even if it's in the same db as the application, the system should just reconnect using the relevant keys and handle everything transparently.
By the way, kudos for trying to do The Right Thing - in 2023 we should be encrypting everything everywhere all the time...
Related Content
- 3 years ago
- 1 year ago
- 2 months ago
- 2 years ago