SAP HANA Cloud vs. SQL Server Integration Services

It is well organized. One can use it for the company's portfolio management. Various tasks can be done for managerial purposes. One can track the material from start to end product: for example, raw material, packing material & consumable material to formulated bulk and formulated drug product. This can help to manage spending as well as finding costing of the product.

Incentivized

Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.

Incentivized

• Real-time reporting and analytics on data: because of its in-memory architecture, it is perfect for businesses that need to make quick decisions based on current information.
• Managing workload with complex data: it can handle a vast range of data types, including relational, documental, geospatial, graph, vector, and time series data.
• Developing and deploying intelligent data applications: it provides various tools for such applications and can be used for machine learning and artificial intelligence to automate tasks, gain insights from data, and make predictions.

• Ease of use - can be used with no prior experience in a relatively short amount of time.
• Flexibility - provides multiple means of accomplishing tasks to be able to support virtually any scenario.
• Performance - performs well with default configurations but allows the user to choose a multitude of options that can enhance performance.
• Resilient - supports the configuration of error handling to prevent and identify breakages.
• Complete suite of configurable tools.

Incentivized

• Requires higher processing power, otherwise it won't fly. How ever computing costs are lower. Incase you are migrating to cloud please do not select the highest config available in that series . Upgrading it later against a reserved instance can cost you dearly with a series change
• Lack of clarity on licensing is one major challenge
• Unless S/4 with additional features are enabled mere migration HANA DB is not a rewarding journey. Power is in S/4

Incentivized

• SSIS has been a bit neglected by Microsoft and new features are slow in coming.
• When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
• While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.

Incentivized

At this moment we are not focusing on SAP, however would love to in the future. This is primarily because of our limited ability to generate more revenue to fund for SAP partnerships and products. Our initial tryst with SAP Partneredge open ecosystem didn't go as planned and we have shelved that for now. Hope we can revive in the future

Incentivized

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

In addition to the points described in the previous parts of the review, I believe that as I gain more experience with the product over time, I will be able to better describe my experience with this tool. Meanwhile, I can confirm that the possibilities presented to my organization by the change to SAP HANA, at the moment, have been very important to evolve the analytical and strategic field towards a new path.

Incentivized

SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.

Incentivized

Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.

Incentivized

One specific example of how the support for SAP HANA Cloud impacted us is in our efforts to troubleshoot and resolve technical issues. Whenever we encountered an issue or had a question, the support team was quick to respond and provided us with clear and actionable guidance. This helped us avoid downtime and keep our analytics operations running smoothly.

Incentivized

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

Professional GIS people are some of the most risk-averse there are, and it's difficult to get them to move to HANA in one step. Start with small projects building to 80% use of HANA spatial over time.

Incentivized

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

I have deep knowledge of other disk based DBMSs. They are venerable technology, but the attempts to extend them to current architectures belie the fact they are built on 40 year old technology. There are some good columnar in-memory databases but they lack the completeness of capability present in the HANA platform.

Incentivized

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.

Incentivized

Limitation of training deliverable by organization

Incentivized

• ROI has always been high in terms of the functionality that it offers and the security features it comes with.
• Managing large volumes of data in real-time is not an easy task, but it does it pretty well with faster data processing.

Incentivized

• 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

Incentivized