Creating Connections

Most of a time when you want to use an activity, you will also want to connect to some external data store, whether that's a SQL database, REST API, or Data Lake. Connections in Insight Factory allow you to encapsulate the secret names and configuration values you need to connect to these sources into a single entity, a Connection, which can be used in your tasks and task groups.

Creating a connection

Simply navigate to the connections page, and click the New Connection button. This will open a form where you give your connection a name and select what type of connection it is. We support a great number of external data sources like SQL Server, Oracle, SAP and many more.

Once you know your connection type, you then fill out the specific properties for that connection, which are often names of secrets that you have stored in your Key Vault. Depending on the connection, a Data Factory Integration Runtime may also be required.

Testing a connection

Within the connection form, you can also test your connection to verify that the connection properties you have entered are correct and the connection can be established.

Please note that this feature is not supported by a small number of connection providers, such as Power BI and Azure Functions.