Regarding encrypted SqlServer data acquisition
Question

Always we are indebted.

I'm Suzuki Akifumi

At our company, from the DB that uses the encryption function (DecrptBykey / EncryptByKey) of SqlServer in the current system Is it possible to acquire data in combination with OutSystems?

I would like to implement it without using Forge.


The reason is the same DB from in-house systems (including batches) other than OutSystems

Because it needs to be accessed and processed.

I haven't tried it myself, but I believe you should be able to use those encryption functions in stored procedures, which you can write as an SQL query: https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/SQL_Queries.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.