Add SQL Connection as reusable Connection in Data Integration Framework

[CFI-Novicell]

Is your feature request related to a problem? Please describe.
When creating an Integration Activity, which uses the SQL Provider, I must manually add the SQL Connection String information to the activity. This makes it difficult to manage multiple activities and connections no matter if the connection is the same or different.
Also potentially sensitive information (connection string) is stored in the Activity definition file and accessible via Assets/Files and included in source control!

Describe the solution you'd like
I would like to be able to create a named SQL Connection and add it to the "Connections" area under "Integration". And be able to reuse that across multiple activities by referencing the name.

[DynamicRas]

Hi Christian,

You can setup the providers on group level and inherit from the group on the child activities.

We are looking into on making the integration assets more secure / inaccessible from the outside.

Will this fix the issue you face?

BR
Rasmus Sanggaard

[CFI-Novicell]

Thank you, Rasmus.

I obviously hadn't noticed that possibility, and it does solve the first part of the issue :)

Having the option of creating a shared "connection" with settings relevant for the specific environment, would still be nice. F.ex. staging and production environments having the same activities but referencing different SQL servers.

/Christian