topic Re: Set up for Fabric to Azure Data Factory (ADF) ingestion in Pipelines

Set up for Fabric to Azure Data Factory (ADF) ingestion

GuillermoBCN — Tue, 09 Apr 2024 10:16:13 GMT

Hello everyone, i'm new here.

We are working on an integration project in which we will perform ETL logics in a Fabric environment using dataflows. The target system for our integration is a Salesforce system, however i can't see a Salesforce app connector in our Fabric capacity, which resides on Power BI, and given we have an Azure Data Factory where we do have that connector what we wanted was to connect ADF to our Data Warehouse in Fabric, however, for that purpose we need to create a service principal either using an inline authentication or by credencials using a Key vault and secrets.

Since i'm new to Azure and so is our basis team, and i have not permissions to register new apps and need to instruct this to them, we would like to know:

- How to register the app in Azure. Which app should be registered, what info has to be provided. There is no specific guide on the steps to be followed when registering Fabric Warehouse in Azure (Or i couldn't find it).

- Is API access needed?

- Which permissions need to be granted?

Many thanks in advance!

Re: Set up for Fabric to Azure Data Factory (ADF) ingestion

Anonymous — Wed, 10 Apr 2024 07:01:12 GMT

Hi GuillermoBCN ,

Thanks for using Fabric Community.

Did you got a chance to refer this doc?
How to ingest data into Fabric using the Azure Data Factory Copy activity - Microsoft Fabric | Microsoft Learn
Copy and transform data in Microsoft Fabric Lakehouse - Azure Data Factory & Azure Synapse | Microsoft Learn

Hope this is helpful. Please let me know incase of further queries.

Re: Set up for Fabric to Azure Data Factory (ADF) ingestion

Anonymous — Thu, 11 Apr 2024 09:08:45 GMT

Hi GuillermoBCN ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help you.

Re: Set up for Fabric to Azure Data Factory (ADF) ingestion

GuillermoBCN — Thu, 11 Apr 2024 09:12:10 GMT

Hello!

For now it appears our infra team is able to set up our service registration with the guidance you provided - Once we set that up i'll confirm if our integration work or if i need any further details for the configuration.

Many thanks for your help, much appreciated!

Re: Set up for Fabric to Azure Data Factory (ADF) ingestion

Anonymous — Fri, 12 Apr 2024 08:38:30 GMT

Hi GuillermoBCN ,

Thanks for your response.
Please let us know once it works with your case and answered your query. Otherwise we will try to provide further guidance.

Re: Set up for Fabric to Azure Data Factory (ADF) ingestion

GuillermoBCN — Mon, 15 Apr 2024 08:57:14 GMT

Hi,

Yes, it did work 🙂 Marking as accepted solution.

Many thanks!!

Re: Set up for Fabric to Azure Data Factory (ADF) ingestion

Anonymous — Mon, 15 Apr 2024 10:10:31 GMT

Hi GuillermoBCN ,

Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.