TrustRadius: an HG Insights company

SAP Business One vs. SQL Server Integration Services (SSIS)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    SAP Business One

    Score8.5 out of 10
    N/ASAP Business One is an integrated enterprise resource planning (ERP) solution for small and medium-sized businesses, The product encompasses functionality around sales, customer relationships, inventory, operations, financials and human resources.

    $99

    per month

    SSIS

    Score8 out of 10
    N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
    Pricing
    SAP Business OneSSIS
    Editions & Modules
    Limited
    $99.00
    per month
    Starter
    $110.00
    per month
    Pro
    $132.00
    per month
    No answers on this topic
    Offerings
    Pricing Offerings
    SAP Business OneSSIS
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    SAP Business OneSSIS
    Payroll Management
    Comparison of Payroll Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.9
    12 Ratings
    27% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Pay calculation10.011 Ratings00 Ratings
    Benefit plan administration10.09 Ratings00 Ratings
    Direct deposit files9.510 Ratings00 Ratings
    Customization
    Comparison of Customization features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.9
    40 Ratings
    27% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    API for custom integration9.738 Ratings00 Ratings
    Plug-ins10.037 Ratings00 Ratings
    Security
    Comparison of Security features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.9
    44 Ratings
    16% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Single sign-on capability9.736 Ratings00 Ratings
    Role-based user permissions10.043 Ratings00 Ratings
    Reporting & Analytics
    Comparison of Reporting & Analytics features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.0
    45 Ratings
    18% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Dashboards8.940 Ratings00 Ratings
    Standard reports9.345 Ratings00 Ratings
    Custom reports8.941 Ratings00 Ratings
    General Ledger and Configurable Accounting
    Comparison of General Ledger and Configurable Accounting features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    5.9
    46 Ratings
    27% below category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Accounts payable9.746 Ratings00 Ratings
    Accounts receivable10.045 Ratings00 Ratings
    Global Financial Support9.928 Ratings00 Ratings
    Primary and Secondary Ledgers8.831 Ratings00 Ratings
    Journals and Reconciliations9.638 Ratings00 Ratings
    Configurable Accounting9.436 Ratings00 Ratings
    Standardized Processes9.641 Ratings00 Ratings
    Inventory Management
    Comparison of Inventory Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.4
    45 Ratings
    16% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Inventory tracking9.745 Ratings00 Ratings
    Automatic reordering9.931 Ratings00 Ratings
    Location management10.041 Ratings00 Ratings
    Order Management
    Comparison of Order Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    8.1
    43 Ratings
    2% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Pricing9.941 Ratings00 Ratings
    Order entry9.943 Ratings00 Ratings
    Credit card processing9.724 Ratings00 Ratings
    Cost of goods sold9.742 Ratings00 Ratings
    Order Orchestration10.033 Ratings00 Ratings
    Subledger and Financial Process
    Comparison of Subledger and Financial Process features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    7.4
    39 Ratings
    2% below category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Billing Management9.734 Ratings00 Ratings
    Cash and Asset Management10.030 Ratings00 Ratings
    Travel & Expense Management9.823 Ratings00 Ratings
    Budgetary Control & Encumbrance Accounting9.928 Ratings00 Ratings
    Period Close9.535 Ratings00 Ratings
    Project Financial Management
    Comparison of Project Financial Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    7.0
    19 Ratings
    8% below category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Budgeting and Forecasting7.017 Ratings00 Ratings
    Project Costing7.016 Ratings00 Ratings
    Cost Capture7.016 Ratings00 Ratings
    Capital Project Management7.011 Ratings00 Ratings
    Customer Contract Compliance7.014 Ratings00 Ratings
    Project Revenue Recognition6.116 Ratings00 Ratings
    Project Execution Management
    Comparison of Project Execution Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.1
    17 Ratings
    25% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Project Planning and Scheduling9.916 Ratings00 Ratings
    Task Insight for Project Managers9.913 Ratings00 Ratings
    Project Mobile Functionality9.612 Ratings00 Ratings
    Definable Resource Pools9.810 Ratings00 Ratings
    Grants Management
    Comparison of Grants Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    8.4
    16 Ratings
    12% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Award Lifecycle Management10.010 Ratings00 Ratings
    Procurement
    Comparison of Procurement features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    8.5
    19 Ratings
    18% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Bids Analyzed and Compared9.912 Ratings00 Ratings
    Contract Authoring10.013 Ratings00 Ratings
    Contract Repository9.211 Ratings00 Ratings
    Requisitions-to-Purchase Orders Integrated9.615 Ratings00 Ratings
    Supplier Management9.614 Ratings00 Ratings
    Risk Management
    Comparison of Risk Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    8.6
    11 Ratings
    24% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Risk Repository9.59 Ratings00 Ratings
    Control Management9.110 Ratings00 Ratings
    Control Efficiency Assessments9.19 Ratings00 Ratings
    Issue Detection9.110 Ratings00 Ratings
    Remediation and Certification10.07 Ratings00 Ratings
    Logistics
    Comparison of Logistics features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    8.1
    25 Ratings
    15% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Transportation Planning and Optimization9.917 Ratings00 Ratings
    Transportation Execution Management9.515 Ratings00 Ratings
    Trade and Customs Management9.615 Ratings00 Ratings
    Fulfillment Management9.718 Ratings00 Ratings
    Warehouse Workforce Management9.816 Ratings00 Ratings
    Manufacturing
    Comparison of Manufacturing features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.2
    21 Ratings
    21% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Production Process Design9.719 Ratings00 Ratings
    Production Management10.019 Ratings00 Ratings
    Configuration Management9.715 Ratings00 Ratings
    Work Execution9.817 Ratings00 Ratings
    Manufacturing Costs9.817 Ratings00 Ratings
    Supply Chain
    Comparison of Supply Chain features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    8.0
    27 Ratings
    9% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Forecasting8.625 Ratings00 Ratings
    Inventory Planning8.227 Ratings00 Ratings
    Performance Monitoring8.121 Ratings00 Ratings
    Product Lifecycle Management
    Comparison of Product Lifecycle Management features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    9.6
    19 Ratings
    26% above category average
    SQL Server Integration Services (SSIS)
    -
    Ratings
    Proposal Management8.115 Ratings00 Ratings
    Product Master Data Management9.317 Ratings00 Ratings
    Data Source Connection
    Comparison of Data Source Connection features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    -
    Ratings
    SQL Server Integration Services (SSIS)
    7.0
    56 Ratings
    18% below category average
    Connect to traditional data sources00 Ratings9.056 Ratings
    Connecto to Big Data and NoSQL00 Ratings5.043 Ratings
    Data Transformations
    Comparison of Data Transformations features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    -
    Ratings
    SQL Server Integration Services (SSIS)
    6.8
    56 Ratings
    18% below category average
    Simple transformations00 Ratings8.956 Ratings
    Complex transformations00 Ratings4.755 Ratings
    Data Modeling
    Comparison of Data Modeling features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    -
    Ratings
    SQL Server Integration Services (SSIS)
    7.5
    54 Ratings
    6% below category average
    Data model creation00 Ratings9.028 Ratings
    Metadata management00 Ratings6.035 Ratings
    Business rules and workflow00 Ratings7.145 Ratings
    Collaboration00 Ratings9.140 Ratings
    Testing and debugging00 Ratings6.451 Ratings
    Data Governance
    Comparison of Data Governance features of SAP Business One and SQL Server Integration Services (SSIS)
    Feature
    SAP Business One
    -
    Ratings
    SQL Server Integration Services (SSIS)
    5.4
    43 Ratings
    40% below category average
    Integration with data quality tools00 Ratings6.238 Ratings
    Integration with MDM tools00 Ratings4.638 Ratings
    Best Alternatives
    SAP Business OneSSIS
    Small Businesses
    Zoho One
    Score9.2 out of 10
    Skyvia
    Score10 out of 10
    Medium-sized Companies
    Zoho One
    Score9.2 out of 10
    IBM InfoSphere Information Server
    Score10 out of 10
    Enterprises
    Microsoft Dynamics AX (discontinued)
    Score4.8 out of 10
    SolarWinds Task Factory
    Score8.3 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    SAP Business OneSSIS
    Likelihood to Recommend
    9.0
    (51 ratings)
    8.0
    (56 ratings)
    Likelihood to Renew
    4.6
    (9 ratings)
    9.0
    (4 ratings)
    Usability
    9.1
    (15 ratings)
    8.0
    (11 ratings)
    Availability
    9.0
    (3 ratings)
    -
    (0 ratings)
    Performance
    8.0
    (1 ratings)
    8.8
    (6 ratings)
    Support Rating
    9.0
    (11 ratings)
    8.0
    (8 ratings)
    In-Person Training
    7.7
    (2 ratings)
    -
    (0 ratings)
    Online Training
    4.5
    (2 ratings)
    -
    (0 ratings)
    Implementation Rating
    2.8
    (24 ratings)
    10.0
    (2 ratings)
    Ease of integration
    9.0
    (1 ratings)
    -
    (0 ratings)
    Product Scalability
    9.0
    (2 ratings)
    -
    (0 ratings)
    Vendor post-sale
    8.0
    (1 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    8.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    SAP Business OneSSIS
    Likelihood to Recommend
    SAP
    SAP Business One would be more useful if it contained tools to acommodate the growing need of online sales. A more complete shipping module which handles tracking numbers with the common couriers would be great. A built in warehouse management system would be great designed to be used with barcode scanners
    Incentivized
    Read full review
    Microsoft
    As I mentioned earlier SQL Server Integration Services is suitable if you want to manage data from different applications. It really helps in fetching the data and generating reports. Its automation make it very easy and time efficient. It works well with large database as well. But it doesn't work well with real time data, it will take some time to gather the real time data. I would not recommend using it in a real time/fast-paced environment.
    Incentivized
    Read full review
    Pros
    SAP
    • SAP Business One is more suitable for small and medium scale enterprises
    • SAP Business One is : analytics, mobile technologies, cloud technologies
    • SAP Business One has exceptional performance in handling business functions such as purchasing and operations and customer relationship management
    • An important key features of SAP Business One is Reporting and Analytics.
    Incentivized
    Read full review
    Microsoft
    • Standard ETL use cases for daily loads
    • Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
    • Creating outgoing data files and writing them to Vendor FTPs
    • Easy Active Directory integration for seamless connections to SQL Server
    • CI/CD by hosting the code on visualstudio.com
    Incentivized
    Read full review
    Cons
    SAP
    • Following a bench mark process - this seems contradicting to flexibility however we have wished we could follow more of an industry benchmark. Our challenge as a small company has been knowing how to properly use the system. We have discovered that we have set up the system wrong based and are using it improperly which has cause a lot work to correct.
    • Better live reporting options - current we are on prem SQL. Yes SAP is moving to HANA however smaller companies like ourselves are not ready for that. We need to be able to maintain our existing SQL DB. We also have a demand for live BI Reporting. It has been difficult to do this with our current set up.
    • Error handling - have found it very difficult to troubleshoot. Errors are not always clear and answers are hard to find.
    Incentivized
    Read full review
    Microsoft
    • Connection managers for online data sources can be tricky to configure.
    • Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
    • Mapping destination using OLE DB command is difficult as destination columns are unnamed.
    • Excel or flat file connections are limited by version and type.
    Incentivized
    Read full review
    Likelihood to Renew
    SAP
    As I said before, it is a first level tool, well developed, and with very strong development support, although the learning curve, its implementation, the cost-benefit ratio, the price and the user experience is not the most suitable for small and medium-sized companies. It is a company with extensive experience, market positioning, technical support and expanded use
    Incentivized
    Read full review
    Microsoft
    Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
    Incentivized
    Read full review
    Usability
    SAP
    I would like to give 8 out of 10 rating for SAP Business One because SAP Business One is a good choice for the mostly used business management solutions for the small and medium-sized companies. SAP Business One can help in optimizing the existing business process and enables streamline business processes for the daily activities for all users across the entire organization. The importance realization of SAP Business One implementation is based on the selection of the good reputation partner and its approach for the entire implementation. SAP Business One is a user-friendly and easy to use Enterprise system that the organization can benefit its features and functionalities by utilizing it.
    Incentivized
    Read full review
    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.
    Incentivized
    Read full review
    Reliability and Availability
    SAP
    The SAP Business One software is up and running every time
    you need it as it was planned. In more than 6 years that we have been
    using the product, it has never been unavailable and if it ever was, it was because of a planned maintenance window scheduled in the company.
    Incentivized
    Read full review
    Microsoft
    No answers on this topic
    Performance
    SAP
    SAP Business One performance depends mostly on the speed of your internal servers, should you have the solution on premise as we do. Sometimes the system tends to be a little slower for some users when others are executing really big reports of performing some batch loads, but generally, the performance is acceptable to all the users.
    Incentivized
    Read full review
    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.
    Incentivized
    Read full review
    Support Rating
    SAP
    I rate my experience with SAP Business One's support team as excellent (10). They are easy to contact and effortless to work with on any issue or concern. I like the support SAP provides for any of their products. SAP has a great backing and I would recommend them to any of my colleagues.
    Incentivized
    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.
    Incentivized
    Read full review
    In-Person Training
    SAP
    The training I get was a consultant level training, so it's basically a 6 weeks training covering every aspect and every module of the system. It covered most common use cases and exercise training so you can get along with the software, as well as examples so there culd be a better understanding.
    Incentivized
    Read full review
    Microsoft
    No answers on this topic
    Online Training
    SAP
    Over the past two years SAP has added a great deal of new SAP Business One on-line training for version 9.0 and 9.1. Most of the training is very strong, but some is difficult to understand and follow. Additionally, SAP still has a few holes in their on-line training around Production, Bill-of-Materials, MRP and Service.
    Incentivized
    Read full review
    Microsoft
    No answers on this topic
    Implementation Rating
    SAP
    These implementations are not easy. Even a standard implementation can be difficult. With a never-been-done-before implementation, the implementation team and the user team need to be thorough with planning, make a decision on key points, and stick to them before any design happens. Our biggest challenge was not from StellarOne, rather it was from the mid-implementation decisions from our internal team. StellarOne did a great job warning us, implementing our decision, and then helping us adjust our SAP to handle the new direction we took.
    Incentivized
    Read full review
    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
    Incentivized
    Read full review
    Alternatives Considered
    SAP
    SAP provides the most robust solution, with modules available for all department managers and even options for customization according to the company's special needs. We especially used the Crystal reports options to provide reports for each module. Overall, even if it's not the least expensive option, it has the best value for money.
    Incentivized
    Read full review
    Microsoft
    I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer
    Incentivized
    Read full review
    Scalability
    SAP
    For most small businesses, the only way you outgrow SAP Business One is if the nature of your business changes radically. Going from 1 to 50 users is quite easy with SAP B1. Going beyond 50 may require moving to the Hana SAP B1 platform to maintain or improve performance, but the path is there.
    Add-ons to SAP B1 can also be added as specific needs are encountered that are not closely met by the standard product. These may be required early in the product life because of the nature of your business, or as you expand the use of SAP B1.
    Incentivized
    Read full review
    Microsoft
    No answers on this topic
    Return on Investment
    SAP
    • Employee efficiency has definitely increased with SAP Business One. This is attributed in a lot of ways to information visibility. Our employees are able to gather the data they need, quickly, and effectively.
    • Identifying inconsistencies in pricing has also been accomplished through use of reporting off individual tables. Previously, we weren't able to access our data in such a way as to enable us to write custom reports in-house.
    • We have also benefited greatly from having a single source of all business information. We utilize SAP Business One exclusively in-house. All documentation is attached to specific orders and Business Partners, as well as serialized equipment that has been sold.
    Incentivized
    Read full review
    Microsoft
    • Without this, we would have to manually update a spreadsheet of our SQL Server inventory
    • We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
    • We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
    Incentivized
    Read full review
    ScreenShots