I want to connect to a Microsoft SQL Server with UiPath Studio with a credential asset from Orchestrator and not with Windows Authentication.
To test this, I created a Credential Asset in Orchestrator, fetched it with “Get Credential” and stored the username in a String and the Password in a SecureString. Then I wanted to Connect to the Database via the UiPath Database Connect Activity (UiPath.Database.Activities). This requires a Connection String, which I don’t know how to create with the SecureString-password from Orchestrator.
Question: What’s the best option to connect to the SQL-Server with a technical User centrally stored in Orchestrator? Is there another Activity which I am missing? Can I create the Connectionstring somehow?
Thanks in advance,