Would like to see Connectors (Database) put into Orchestrator as an Asset, similar to Credentials, so that the ID and Password for the DB Connection can be secured and encrypted, instead of being an Activity withing Studio.
Could you tell us more about how you would see it?
An example of such asset would help our team fully understand the use-case.
Well, I guess it is not so much a “Database Connector”, but a more secure way to store the Connection String, to make it an Asset, similar to the way Credentials are stored. We can currently create a “Text” Asset, but cannot encrypt it like we can when creating a “Credential” and the Password is encrypted.
When using the Database Connection Activity, the ConnectionString Property is simply a string, so the User ID and PWD is exposed. My proposal is to either allow an Asset Type of “Text” to be encrypted (checkbox) or to create a new Asset Type of “DB_Connection” so that the connection string can be encrypted, plus as an Asset it is more Global and re-usable across Automations.