Skip to main content

Using database connection string to connect to database like Oracle. Is there a way to encrypt the user's password? Or does it have to send it through the clear? Are there any other security information when using SQL activities?

Comments

2 comments

  • Jostein Svegården

    It is hard to know the context from your question, but if you use the Run SQL Query activity, your workflow is a server workflow. With a server workflow you could use the Read File activity to read the credentials from a file stored on the server. If you do that, no password will be exposed.

    0
  • Ash Petitjean

    Jostein, Thank you for the response. That is something we can look into utilizing. So, far we just built a demo with databaseconnection.json file in the workflow folder.

    0

Please sign in to leave a comment.