SSIS equivalent of Data factories and Resource Groups?

Question

I have plenty of experience in SSDT and SSIS, and I've recently been learning how to create ETL packages with ADF.

I'm trying to understand how I should name Data factories and Resource Groups.

So in SSDT, for example, the structure would look like this. Are data factories and resoure groups similar to solutions and projects?

Sales (Solution)

Sales_Reports (project)

  **Shared Data Sources**  

     SalesDB.rds  

  **Reports**  

     TotalSales.rdl  

     SalesPerCust.rdl  

Sales_ETL_Packages (project)

  **Connection Managers**  

  **SSIS Packages**  

     ReadFromCsv.dtsx  
     ImportFromOracle.dtsx

Answer 1

Hey,
Resource group is basically a logical container for related Azure offerings unlike a Visual studio project which can host only related items.
Meaning in Visual studio project, you can only add similar objects like in case of SSIS only SSIS objects or in case of database, only database objects.
But in case of a resource group, you can have multiple Azure offerings like Data factory, Azure SQL database etc.
So ideally every team has its own way of renaming a resource group and it is not a specific way.
Some name the RG based on the environment like <TeamName><UAT> etc
Some keep it specific to use case like <AttritionPrediction><Prod>

Answer 2

Hi @rbhatup ,

Thank you for posting query in Microsoft Q&A Platform.

Thank you @Nandan Hegde , very nicely explained here. In addition to that in simple words, ** Resource Group is like a folder in which different instances of azure offering you can place. ADF is one of Azure offering instance.**

Inside, ADF we will have pipelines. These are ETL pipelines. In one Azure Data factory you can have multiple EL pipelines. So in a way you can compare ADF name as solution name and pipeline name as package name may be. Its just to give a ruff idea. but as mentioned by Nandan, ADF and visual studio solutions are two different entities all to gether.

Kindly check below videos of mine, which gives you better understanding.
Resource group in Azure
Azure Data factory Overview
Create your First Azure Data Factory
Pipelines and Activities in Azure Data Factory

Hope this helps. Please let me know if any further queries.

--------------

Please consider hitting Accept Answer button. Accepted answers help community as well.