For Data Factories connect to GitHub, provide other ways to log in. For example out-of-band authentication could be performed using OAuth Device Code flow or logging in with a GitHub Personal Access Token. For setups where your account to manage Data Factory is not the same as the account you use with GitHub is not the same, it is currently very difficult to connect the two services. Especially in high security environments where Conditional Access etc. impose further restrictions on accounts.

The existing SFTP connector in Azure data factory is not supporting multi-factor authentication. The connector supports either password based authentication or key based authentication. Enterprises are moving towards multi-factor authentication requiring both key and password for SFTP. This is a must have feature given the information security focus.

Now, somebody must get to the dev ADF, open the master branch, and hit “Publish” for the changes to get the “Adf_publish” updated.

Automating “Publish” on the master branch is necessary for improving efficiency and saving more time.

Hi Team,

We do have hundreds of triggers and it will be growing, As part of the BAU support if we need to disable the triggers and there is no option to select All and disable the trigger.

Feature to be added - Can you add a SelectAll option and disable and enable button on the trigger section to do that in one shot.

Thanks
Jawahar

Will be useful to have GitLab integration in Azure Data Factory along with GitHub and Azure Repos as it's one of the most popular tools

The current version of this connector treats any SP List columns that allow multiple values as a "complex type". These are not supported in the connector, so the data in those columns are not available.

Managed Private Endpoints for North Central US Region. Currently documented and available here: https://docs.microsoft.com/en-us/azure/data-factory/managed-virtual-network-private-endpoint

Would like this to circumvent the need to whitelist ADF IP ranges and specify specific internal IP addresses inside of my network to communicate via VPN to secure internal resources.

The default timeout for Copy Activities in Azure Data Factory is 7 days.
We are used to set this property individually to a much lower value for every Copy Activity we use.

More generally speaking it would be great to be able to configure Default Values per Activity Type to adjust those values to local procedures.

This way when developing new pipelines not every property would have been needed to be set individually every time again and again.

So please provide Adjustable, Per Activity - Default Property Values.

Please provide support to use alternate keys to map lookups documented here: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-alternate-key-create-record#using-alternate-keys-to-create-an-entityreference

Would be nice to use an alternate key defined on contact when import accounts through ADF for example

I am loading data dynamically from multiple SQL Server databases. All of the databases share the same table structure. However, there may be some exceptions where one of the databases has a missing column in one of the tables.

When such a situation occurs, I would like to set the Fault Tolerance on to Skip the incompatible column. Meaning, instead of it failing or skipping all the rows (columns), it should skip the single column instead.

That way, instead of losing all the columns, I lose one column, which is not used anyways since it never exists.

Working with ADF is good experience but it can be more user friendly if ADF can support Dark mode because all white is kind of distracting.

I want to perform multiple SQL statements in one run of Lookup activity. For example, execute the command to create a table and read the summary, like this:

create temporary table mytemptable (id number, creation_date date);
select * from mytemptable;

Currently there is a limitation and I get the error message:
ERROR [0A000] Multiple SQL statements in a single API call are not supported; use one API call per statement instead.

It would be great that we could implement our own functions in Mapping DataFlow.
User Functions on Azure Databricks (https://docs.databricks.com/spark/latest/spark-sql/udf-python.html) is a similar great capability.

As inner activities are limited (no if condition in an if condition) please change the if condition activity to have either true or false exit

Now, we can only validate whether it's SSL encrypted manually under Settings from Microsoft Integration Runtime Configuration Manager.

It would be great to have a feature to validate this without checking Microsoft Integration Runtime Configuration Manager.

For example, if there's a return value about the encryption, we could leverage this automate the validating process via a PowerShell script.

Job Clusters are the prefered way to run Databricks Notebooks.

It would be very helpful if the same Databricks Job Cluster could be used for multiple Databricks activities.

For example for all Databricks activities in one pipeline.