Post reply

What is the benefit of SSIS with respect to ETL?

  • February 10, 2012 at 9:34 pm

    #251365

    Generally I understand that SSIS allows for a wide-variety of services/applications to be used with SQL Server. Isn't ETL (extract, transform, load) the importing of raw data into SQL Server? So then SSIS allows for integration of data that was once not SQL Server compatible.

  • February 11, 2012 at 7:58 am

    #1445930

    Typical Uses of Integration Services

    http://msdn.microsoft.com/en-us/library/ms137795.aspx

  • February 11, 2012 at 2:54 pm

    #1445971

    Rowles (2/10/2012)

    Generally I understand that SSIS allows for a wide-variety of services/applications to be used with SQL Server. Isn't ETL (extract, transform, load) the importing of raw data into SQL Server? So then SSIS allows for integration of data that was once not SQL Server compatible.

    SSIS is a software product that allows you to handle data while ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    You can do ETL using SSIS.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 11, 2012 at 9:48 pm

    #1445991

    PaulB-TheOneAndOnly (2/11/2012)

    ...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    Gosh... it's a whole lot more than that. ETL can be used for system to system transfers, importing non-database originated data, exporting for non-database related use and backups, etc, etc.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 12, 2012 at 11:20 am

    #1446055

    Jeff Moden (2/11/2012)

    PaulB-TheOneAndOnly (2/11/2012)

    ...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    Gosh... it's a whole lot more than that. ETL can be used for system to system transfers, importing non-database originated data, exporting for non-database related use and backups, etc, etc.

    mmmhh... nope 😀

    Just for starters, where in "E"xtract "T"ransform and "L"oad you see the "backup" part of it?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 13, 2012 at 12:44 am

    #1446106

    PaulB-TheOneAndOnly (2/12/2012)

    Jeff Moden (2/11/2012)

    PaulB-TheOneAndOnly (2/11/2012)

    ...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    Gosh... it's a whole lot more than that. ETL can be used for system to system transfers, importing non-database originated data, exporting for non-database related use and backups, etc, etc.

    mmmhh... nope 😀

    Just for starters, where in "E"xtract "T"ransform and "L"oad you see the "backup" part of it?

    If you "E"xtract data from the database and "L"oad it into a set of flat files, you have created a "backup" 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 13, 2012 at 8:53 am

    #1446299

    ETL, as was stated previously, is a concept. There is no application called ETL. SSIS is an implementation of ETL. It can, however, do more than just ETL. An ETL process can be written in almost any computer language.

    As far as creating a backup, just copying data from a table to a flat file and saying it's a backup, is a very broad use of the word backup. I could just as easily say, the stack of paper on my desk is a backup. While it's stretching the truth, how easy is it to reload? A true 'backup' should be a no-brainer to reload. It should not require another ETL type program, to read a flat file and transform it back into table data. Besides, there are hundreds of specialized 'backup/reload' applications.

  • February 13, 2012 at 9:44 am

    #1446331

    Koen Verbeeck (2/13/2012)

    PaulB-TheOneAndOnly (2/12/2012)

    Jeff Moden (2/11/2012)

    PaulB-TheOneAndOnly (2/11/2012)

    ...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    Gosh... it's a whole lot more than that. ETL can be used for system to system transfers, importing non-database originated data, exporting for non-database related use and backups, etc, etc.

    mmmhh... nope 😀

    Just for starters, where in "E"xtract "T"ransform and "L"oad you see the "backup" part of it?

    If you "E"xtract data from the database and "L"oad it into a set of flat files, you have created a "backup" 😉

    Guess I'll have to disagree there. It's not always that simple and the data included in the file may only be partial data.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 13, 2012 at 9:46 am

    #1446332

    PaulB-TheOneAndOnly (2/12/2012)

    Jeff Moden (2/11/2012)

    PaulB-TheOneAndOnly (2/11/2012)

    ...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    Gosh... it's a whole lot more than that. ETL can be used for system to system transfers, importing non-database originated data, exporting for non-database related use and backups, etc, etc.

    mmmhh... nope 😀

    Just for starters, where in "E"xtract "T"ransform and "L"oad you see the "backup" part of it?

    Try getting the data from Double-Click.Net sometime and you'll see all 3 processes on steroids. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 13, 2012 at 11:33 am

    #1446407

    PaulB-TheOneAndOnly (2/11/2012)

    Rowles (2/10/2012)

    Generally I understand that SSIS allows for a wide-variety of services/applications to be used with SQL Server. Isn't ETL (extract, transform, load) the importing of raw data into SQL Server? So then SSIS allows for integration of data that was once not SQL Server compatible.

    SSIS is a software product that allows you to handle data while ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.

    You can do ETL using SSIS.

    While the most common application of ETL is to move relational data into a DW and there's extensive data on how to ETL when the destination is a DW, it most certainly is not the only one. Standardizing data from multiple source system into a common Operational Data Store (which is still highlyt normalized) is another example of ETL, which may never involve a DW.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply