147 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
257 Ratings
147 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

SSIS

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
257 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Feature Set Ratings

    Data Source Connection

    SAP BW

    Feature Set Not Supported
    N/A
    7.6

    SSIS

    76%
    SQL Server Integration Services ranks higher in 2/2 features

    Connect to traditional data sources

    N/A
    0 Ratings
    8.7
    87%
    57 Ratings

    Connecto to Big Data and NoSQL

    N/A
    0 Ratings
    6.4
    64%
    44 Ratings

    Data Transformations

    SAP BW

    Feature Set Not Supported
    N/A
    8.3

    SSIS

    83%
    SQL Server Integration Services ranks higher in 2/2 features

    Simple transformations

    N/A
    0 Ratings
    8.8
    88%
    57 Ratings

    Complex transformations

    N/A
    0 Ratings
    7.8
    78%
    56 Ratings

    Data Modeling

    SAP BW

    Feature Set Not Supported
    N/A
    7.8

    SSIS

    78%
    SQL Server Integration Services ranks higher in 6/6 features

    Data model creation

    N/A
    0 Ratings
    8.6
    86%
    31 Ratings

    Metadata management

    N/A
    0 Ratings
    7.7
    77%
    37 Ratings

    Business rules and workflow

    N/A
    0 Ratings
    7.9
    79%
    46 Ratings

    Collaboration

    N/A
    0 Ratings
    7.6
    76%
    42 Ratings

    Testing and debugging

    N/A
    0 Ratings
    6.9
    69%
    52 Ratings

    feature 1

    N/A
    0 Ratings
    8.0
    80%
    5 Ratings

    Data Governance

    SAP BW

    Feature Set Not Supported
    N/A
    7.4

    SSIS

    74%
    SQL Server Integration Services ranks higher in 2/2 features

    Integration with data quality tools

    N/A
    0 Ratings
    7.9
    79%
    40 Ratings

    Integration with MDM tools

    N/A
    0 Ratings
    6.9
    69%
    40 Ratings

    Attribute Ratings

    • SAP Business Warehouse is rated higher in 1 area: Likelihood to Recommend
    • SQL Server Integration Services is rated higher in 1 area: Support Rating

    Likelihood to Recommend

    9.0

    SAP BW

    90%
    14 Ratings
    8.2

    SSIS

    82%
    57 Ratings

    Likelihood to Renew

    SAP BW

    N/A
    0 Ratings
    10.0

    SSIS

    100%
    3 Ratings

    Usability

    SAP BW

    N/A
    0 Ratings
    9.3

    SSIS

    93%
    8 Ratings

    Performance

    SAP BW

    N/A
    0 Ratings
    8.8

    SSIS

    88%
    12 Ratings

    Support Rating

    8.0

    SAP BW

    80%
    4 Ratings
    8.2

    SSIS

    82%
    14 Ratings

    Implementation Rating

    SAP BW

    N/A
    0 Ratings
    10.0

    SSIS

    100%
    2 Ratings

    Likelihood to Recommend

    SAP

    SAP BW is best for: 1. Large enterprises 2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge) 3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive) SAP BW is less appropriate for: 1. Small enterprises 2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions 3. HANA
    Read full review

    Microsoft

    I highly recommend this product. It has streamlined most business processes by providing useful tools that make work easier. The well-featured dashboard provides graphical integration services that have enhanced faster task and project implementation since it does not require coding. It has transformed data that could lead to poor performance into useful insights for generating new ideas for boosting business performance.
    Read full review

    Pros

    SAP

    • It tracks bin locations for parts which can be really helpful.
    • SAP Business Warehouse tells you who has a part checked out so you can find it.
    • It shows current parts shortages so buyers are flagged to get parts on order based on current demand.
    Read full review

    Microsoft

    • Server Integration Services for SQL Server With the right planning of dataflows, we may aggregate information from many different sources.
    • The solution's package structure allows us to isolate individual functions while reusing the same set of settings everywhere else.
    • The capacity to test solutions in a variety of settings with varying inputs is a potent resource that facilitates the development of solutions that can be reused.
    Read full review

    Cons

    SAP

    • Support comes slow. This is not a limitation of the software itself but could be a symptom from the local office. Once we get support everything works along smoothly.
    • It is always important to review the instructions. This is not a system that does well initially with personalization without review of standard procedures. A log of time can be lost if the technicians and programmers working with the data are not following correct procedures.
    Read full review

    Microsoft

    • API connections are not a native functionality. We use Zappysys extensions but they work only in certain cases.
    • Dependency executions - no simple way to create a hierarchy/chain of executions. Ex: Define if the execution of the child process should be stopped if a parent fails or a certain condition is triggered in the parent process and then redirect to a different part of the chain (think like a flowchart for executions).
    Read full review

    Pricing Details

    SAP BW

    Starting Price

    Editions & Modules

    SAP BW editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      SSIS

      Starting Price

      Editions & Modules

      SSIS editions and modules pricing
      EditionModules

      Footnotes

        Offerings

        Free Trial
        Free/Freemium Version
        Premium Consulting/Integration Services

        Entry-level set up fee?

        No setup fee

        Additional Details

        Likelihood to Renew

        SAP

        No answers on this topic

        Microsoft

        SSIS is responsible for running core business processed managing core business data. It can be managed, improved and expanded using minimal internal resources. It is also able to support all of our current data infrastructure. Replacing SSIS would be time consuming and costly with no apparent ROI.
        Read full review

        Usability

        SAP

        No answers on this topic

        Microsoft

        SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
        Read full review

        Performance

        SAP

        No answers on this topic

        Microsoft

        SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
        Read full review

        Support Rating

        SAP

        SAP BW is a consolidated tool. There are thousands of SAP notes in order to solve your problems and in case do not exist, SAP support will help you on the issue you face.
        Read full review

        Microsoft

        The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
        Read full review

        Implementation Rating

        SAP

        No answers on this topic

        Microsoft

        The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
        Read full review

        Alternatives Considered

        SAP

        SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta replication into SAP Business Warehouse. System governance in SAP Business Warehouse is top-notch with change management support for migration between system landscape from the development system to production system.
        Read full review

        Microsoft

        I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
        Read full review

        Return on Investment

        SAP

        • Exporting of data and reports to Excel is very easy for the end user to interpret and manipulate.
        • Negatively, the speed at which BW retrieves data and reports is very slow and out of date.
        • Addition of daughter application HANA has helped this aging application stay afloat for a few more years. Overall it has been a great tool but it's showing its age very fast.
        Read full review

        Microsoft

        • Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
        • Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
        • The employee number, responsible for data management was reduced from 4 to 1 person
        Read full review

        Add comparison