itelligence and J2 Consulting have been working with Japanese bank Mizuho to successfully re-platform its system running SAP® Adaptive Server® Enterprise (SAP ASE). The project has involved migrating from SAP ASE on Solaris to SAP ASE on Linux VMWare and upgrading to the latest version of SAP ASE.
Mizuho Bank uses SAP ASE to drive its risk management systems at its London branch. The migration helps ensure that Mizuho is able to continue to meet high performance and efficiency requirements across its network.
The upgrade to the latest version of SAP ASE has given Mizuho additional benefits, including the ability to upgrade to the new SAP ASE license model, SAP Adaptive Server, platform edition. The platform edition offers businesses broad flexibility; rather than be restricted to one distinct product, it allows interchange between SAP products including SAP ASE, SAP Replication Server or SAP IQ software in response to business requirements. Other advantages of upgrading include unrestricted platforms and virtualisation.
David Hurley, Director of Mizuho Information & Research Institute Inc. London Branch, commented: “This upgrade gives us the flexibility to be able to respond to our ever-changing business needs, ensuring that database performance continues to meet the high levels we demand. The itelligence support package is a valuable part of this agreement.”
The collaboration between itelligence and J2 aims to offer significant benefits for customers running SAP software. Whilst J2 provides specialist experience and understanding of SAP technologies, itelligence provides strong support as an SAP platinum partner in the UK. The relationship itelligence and J2 have built with Mizuho is an ongoing partnership that is expected to continue to grow.
Justin Brading, Managing Director at itelligence UK, commented: “We are pleased to have worked in sync with J2 to help drive forward Mizuho’s requirements of a high-performance database and help keep risk management at the top of the agenda. We look forward to working with Mizuho. “
Mizuho, the leading Japanese financial services group with a global presence and a broad customer base, is committed to:
- Providing customers worldwide with the highest-quality financial services with honesty and integrity;
- Anticipating new trends on the world stage;
- Expanding its knowledge in order to help customers shape their future;
- Growing together with customers in a stable and sustainable manner; and
- Bringing together group–wide expertise to contribute to the prosperity of economies and societies throughout the world.
These fundamental commitments support Mizuho’s primary role in bringing fruitfulness for each customer and the economies and the societies in which it operates. Mizuho creates lasting value. It is what makes us invaluable.
Please visit: https://www.mizuho-fg.com/index.html
About itelligence UK
itelligence UK is a wholly owned subsidiary of itelligence AG. itelligence is one of the leading international full-service providers of SAP solutions, employing about 6,000 highly qualified employees in 24 countries. itelligence is a global SAP Pinnacle Award–winning SAP platinum partner. A full-service provider of SAP solutions, itelligence offers customers a broad range of consulting and support services from cloud and on-premise implementations to support, maintenance, managed services and SAP-certified training. itelligence customers are leading the way in exploiting new SAP technologies that are powering digital transformation, from big data and analytics to cloud computing, SAP Fiori® user experience (UX) and SAP S/4HANA® as the digital core.
Please visit http://itelligencegroup.com/uk/
SAP, Adaptive Server, SAP S/4HANA, SAP Fiori and SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. See http://www.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices. All other product and service names mentioned are the trademarks of their respective companies.
– See more at: https://itelligencegroup.com/uk/localprsrlss/itelligence-works-mizuho-bank-drive-risk-management/#sthash.AnQ0q4nr.dpuf
Webinar – 26 April 2017
SAP IQ delivers incredible speed and power for extreme-scale enterprise data warehousing and real-time Big Data analytics. Yet many Business Objects customers are not aware that this market-leading columnar database is an integral component of their Business Objects estate.
In this concise webinar, Chris Jones of data management specialists J2, will demonstrate how IQ can be used with Business Objects to deliver dramatic improvements in speed and efficiency. He will show how query response times can be up to 1000x faster than traditional row-based DBMS, even with heavy ad-hoc workloads. Highly scalable for both structured and unstructured data, SAP IQ is available on premise or in cloud and is easy to set up and administer.
The webinar will be of interest to both existing Business Objects customers and any organisation looking to improve its analytics provision.
Chris Jones has been working with SAP (previously Sybase) database technologies for 25 years. During this time, he has worked across numerous industries, gaining in-depth experience of design, systems integration, migration and support for products IQ, Adaptive Server Enterprise and Replication Server. With J2, he now works closely with SAP to help organisations realise the business benefits they seek from their technological investment.
Webinar hosted by itelligence UK
No longer purely “transactional”, modern businesses live or die by the availability of their data. A drop in database performance matters. Hugely. All the more so in complex, distributed environments where often the source of a problem can be frustratingly difficult to identify and even more difficult to prove.
Well, it used to be difficult. Query level monitoring changes all that.
Why is query level monitoring different?
SQL query level monitoring offers a business-focused perspective of database monitoring, with real-time problem identification and resolution. Whereas traditional database monitoring focuses on IT-centric metrics such as Disk I/O or CPU usage, query-level monitoring measures performance from the point of view of the application or end-user. This is achieved by capturing, analysing and monitoring every SQL ‘user’ interaction with your database. Yes, every one. Even if statements number tens of thousands per second, the best query-level monitors will capture them, storing and creating histories for comparative analysis. 24/7, in real time. With no database overhead.
For the business, this represents a sea change in business responsiveness. The holistic “capture all” approach gives the business an unparalleled picture of what is happening and why. Quickly. Trends in performance become incredibly easy to identify e.g. how does current performance compare to the same period last week, last month, last year? And because systems work in real time, alarms and alerts can be set to immediately identify a change in the performance, even when the request is still running.
Imagine a typical troubleshooting scenario…
Your DBAs have reported that your production system is experiencing a much higher load than normal. End users are reporting that your system is slow or unusable. What do you do? Query level monitoring gives you all the data you need to be able to quickly identify what has happened to change the performance profile: Are key SQL statements running more slowly? Are statements being run more frequently? Are new or modified statements being executed? How does this compare with previous periods? Guesswork becomes a thing of the past.
The beauty of this approach is the method of data capture. Whereas traditional monitoring works at an O/S or database level, Query level monitoring sits outside of the database, passively monitoring all network activity, in and out. As this process captures every interaction with the database, it also identifies (and proves) whether a problem is database-centric, or not. The effect of server-side delays, poorly constructed SQL, corrupt ad hoc queries and network anomalies are all plainly visible and fully documented. The confusion that can characterise a database outage is radically reduced. DBA team productivity on the other hand, is radically enhanced.
And the icing on the cake? It’s zero impact.
As it works without the use of polling processes or other intrusive operations, query level monitoring not only saves time but also capital outlay. Installed on a separate host, it has zero impact on database performance, eradicating 10-15% CPU utilisation associated for traditional monitoring systems. For critical applications, the importance of this saving cannot be understated.
Interested in finding out more?
At J2, we are so taken with this alternative approach to performance monitoring that we have added the leading iWatch query level monitoring tool to our range of solutions. Used widely in the US to monitor large-scale database environments, iWatch from performance specialists Exact Solutions, has an impressive customer base, particularly within the banking/financial services sectors. It works brilliantly with SAP Sybase ASE but also supports IBM DB2 and Informix, MS SQL Server and Postgre SQL. Easy to deploy without the need for configuration changes, iWatch is available to trial for free for 30 days.
iWatch is used worldwide to help improve performance of major databases including ASE, DB2 and SQL Server. Unlike traditional monitoring systems, iWatch captures a complete record of every SQL request in real-time – crucially without using polling or other intrusive methods that might interfere with performance and add overhead to critical applications.
The use of query-level logic offers the user many advantages in addition to non-intrusiveness. With iWatch, performance is measured from the perspective of the application or end user (rather than capturing IT-centric metrics), enabling organisations to quickly pinpoint areas where the most dramatic performance improvements can be made. In addition, comprehensive reporting features ensure that following an incident, iWatch can be used to immediately identify what has changed and why e.g. has user behaviour changed since this morning, yesterday, last week…? These are significant advantages in complex, distributed environments where critical time can be wasted simply determining which area of expertise within the IT organization can best be brought to bear to resolve a particular issue.
J2 are delighted to be able to add iWatch to their existing suite of solutions, which includes SAP (Sybase) database & technology tools and iReplay workload capture tool.
Jo Hughes, Marketing Manager at J2: “As specialists in both the implementation and on-going application of SAP database technologies, we are continually seeking technologies that will help our customers quickly improve performance and reduce costs. iWatch is one such tool – it deploys easily and offers extensive real-time metrics, comprehensive reporting and an intuitive, easy to use interface. We believe iWatch is an excellent monitoring choice for any user-driven organisation with a complex database environment that wants to maintain its performance edge.”
iWatch is available for a free 30 day evaluation:
More about iWatch
iWatch and iReplay are both developed by Exact Solutions, specialists in performance tools for large-scale database environments. www.exact-solutions.com
Phone: 08455 441683
Media contact: Jo Hughes
As any database manager or DBA will testify, the sentence “We need to do an upgrade” fills them with a sense of impending gloom. One DBA grumbled to me recently, “With major infrastructure changes you can’t win; migrations and upgrades are essential but no one cares if you do a good job, but of course everyone knows if something goes wrong.”
A bit harsh may be, but not far from the truth. I’ve completed my fair share of upgrades and yes, the process can be challenging – it’s the time consuming checking and re-checking that does it for me. But as we all know, it is a tedium that has to be endured to minimise the damage of the leap of faith that is infrastructure change, right? Well, no actually. On both counts.
Solutions designed to make the job easier
For some time, there have been a number of systems on the market that simultaneously do the heavy lifting of an upgrade and take the risk out of the change. They do this by capturing and replaying production database workloads in risk-free test environments, essentially eliminating the difference between simulated lab conditions and real production workloads. Perfect, it seems. So why doesn’t everyone use them?
Time is undoubtedly the major issue. Finding the time to forward plan is never easy for any support team, even for the implementation of core production systems. Finding the time to evaluate (and potentially justify the purchase of) add-on solutions is even more difficult – there may be a software purchase cost, hardware requirements and undoubtedly resource allocation costs until the team gets up to speed. Justification for any solution that is not core is never easy, even if it’s worth its weight in gold.
Compatible with all versions of ASE
Yet I firmly believe that these systems are well worth the time and effort. I first came across one such system iReplay, some years ago and was so impressed that I now promote it. Compatible with all major databases including SAP ASE, and applicable to any version, iReplay has numerous features that set it apart from other more generic tools typically used to lighten the upgrade load. Unlike scripting tools or load simulators, iReplay allows the capture of a full-scale image of the production SQL workload using Network traffic capture, and then recreates that traffic with all of its native concurrency, interleaving & complexity for detailed analysis in test environments. This approach is ideal for situations where simple scripting based efforts are not sufficient, such as Database Upgrade, underlying platform changes, or Testing effects of Database optimizations on a Production scale workload.
It is worth pointing out that iReplay reproduces the captured workload exactly as was observed during the original capture. There is no exception to the workloads replayed and different types of SQLs, be it Dynamic SQLs, Bulk Inserts, Scrollable Cursors, SQLs involving Binary data (BLOBs, CLOBs, etc.) can be replayed using this tool. SSL Encrypted sessions can also be replayed if the encryption key is available.
Rent rather than buy?
And what about cost? One huge advantage of iReplay is the fact that it can be either purchased or rented, with rental perfect for one-off upgrades or migrations. It also works without imposing any load on your Production Database systems; passive network data capture means there is no requirement for changes/connections/applications to be installed on your production database system.
And the benefits?
It is easy to measure the benefits of iReplay in savings in time and cost (development and test teams are expensive resources better off deployed elsewhere). However, the intangible benefits are harder to measure but more valuable. Use of iReplay results in a significantly streamlined & more accurate testing process with a degree of rigor that was previously thought impossible. Replicated runs can be tailored to meet a variety of test objectives, including regression testing, functional testing, performance testing, capacity planning etc. Coupled with precise SQL-level performance measurements, the technology also allows organisations to judge & calibrate proposed changes, without exposing their business operations to unnecessary risk — or the potential for costly rollbacks.
As a result, the risks associated with database or infrastructure changes can be assessed more quickly & easily, and with unprecedented accuracy. The possibility that disruptive bugs or unexpected interactions might “slip through the cracks” can be virtually eliminated. Test and deployment cycles can be reduced, while confidence improves. Changes can be effectively gauged by comparing the SQL response times giving an accurate Change Feedback. Strategic re-architecture or re-platform projects can be streamlined and accelerated. Anticipated benefits of proposed changes can be measured precisely, before significant resources are committed.
Find out more about iReplay
itelligence Business Solutions UK and J2 Consulting, data management specialists, have today announced a strategic partnership. The agreement will allow the complementary companies to further enhance the solutions to their respective customers. J2 customers will gain access to the extensive range of SAP® solutions provided by SAP platinum partner, itelligence, whilst itelligence customers will benefit from J2’s expertise in SAP database and technology products such as SAP IQ software, SAP Adaptive Server® Enterprise (SAP ASE) and SAP Replication Server.
David Searro, Sales Director, itelligence: “itelligence are now able to collaborate with a specialized niche in SAP solutions, which will enhance our capabilities, both in terms of solution architecture and extended Business Intelligence. We are delighted that our customers will be able to benefit from this collaboration, and are looking forward to working with J2 more closely on many of our projects”.
Chris Jones, Services Director, J2 Consulting said, “J2 are delighted to be able to work with itelligence. This agreement will allow our customers to benefit from itelligence excellence, both in terms of enhanced, partner-led support and solution provision, particularly in Cloud Services and BI. As a leading SAP partner in the UK, itelligence will also provide J2 with important support as we continue to grow our customer base.”
About J2 Consulting
J2 Consulting is a UK-based consultancy and reseller of data management technologies. With more than twenty years of experience with SAP solutions across a range of applications and industry sectors, J2 works to help organisations get the best out of their database solutions.
J2 Consulting is a reseller for SAP database and technology products (including those of Sybase, which was acquired by SAP in 2012) and iReplay from Exact Solutions. For more information, please visit https://j2consulting.co.uk
Phone: 08455 441683
Media contact: Jo Hughes
About itelligence UK
itelligence UK is a wholly owned subsidiary of itelligence AG. itelligence is one of the leading international full-service providers of SAP solutions, employing about 5,400 highly qualified employees in 24 countries. itelligence is a global SAP Pinnacle Award–winning SAP platinum partner. A full-service provider of SAP solutions, we offer our customers a broad range of consulting and support services from cloud and on premise implementations to support, maintenance, managed services and SAP-certified training. itelligence customers are leading the way in exploiting new SAP technologies that are powering digital transformation, from big data and analytics to cloud computing, SAP Fiori® user experience (UX) and SAP S/4HANA® as the digital core.
Please visit http://itelligencegroup.com/uk/
SAP, Adaptive Server, SAP Fiori, SAP S/4HANA and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. See http://www.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices. All other product and service names mentioned are the trademarks of their respective companies.
For more information, Press only:
itelligence Business Solutions
Phone: 07825 530402
Head of Corporate Public Relations itelligence AG
T: +49 (0) 521 / 9 14 48 – 107
– See more at: https://itelligencegroup.com/uk/localprsrlss/itelligence-form-strategic-partnership-j2-consulting/#sthash.r5iWWtcJ.dpuf