SSIS equivalent of Data factories and Resource Groups?

rbhatup 1 Reputation point
2023-01-02T02:15:46.923+00:00

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
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,654 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Nandan Hegde 36,156 Reputation points MVP Volunteer Moderator
    2023-01-02T03:35:04.363+00:00

    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>

    0 comments No comments

  2. ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator
    2023-01-03T07:09:22.097+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.