This is a great new enhancement to SAP Replication Server. Automatic memory management in 16.0 SP03 PL04 supports replication of multiple databases (certificated with 20) in parallel, with simpler configuration steps than were previously possible.
Find out more

SAP are running a series of SAP ASE seminars looking at the 4 key strategic thrusts of development : XOLTP, Cloud & Virtualization, Data Center Operations (Security, Availability, etc.) and integration with SAP HANA.
SAP ASE 16 Feature Overview and Roadmap: May 16, 1500 HRS BST
Accelerate your ASE based data-driven insights to near real-time with HANA: June 21, 1500 HRS BST
ASE Cloud Overview including Subscription Model Support: July 11, 1500 HRS BST
More info and to book
SAP Adaptive Server Enterprise 16.0 SP03 is now available for SAP Business Suite and other SAP Applications. This release brings you an In-Memory Row-Store, a new Secure Store, MVCC, 3-note High Availability + DR and much more. More info.

We’ve been using SAP ASE on AWS, want to know what we think? Then read on…
This is a really compelling offering from SAP and AWS, with the promise of superb flexibility and significant reductions in licensing, infrastructure and administration costs. But is it the right move for everyone?
How easy is it to use?

Our initial test shows great ease of use – the solution is well designed and we were up and running in minutes. It is currently available in London (EU) and USA (East and West).
We used the m4.4xlarge (‘Vendor Recommended’) server. This is an 8 core 64Gb server. The operating system is Red Hat Enterprise Linux Server 7.4. The installation allowed for configuration of a user database as part of the installation process.
ASE configuration ‘out of the box’ is very good with the key parameters set to reasonable values with well designed caches (note we’ve not had time yet to review the other sizings so cannot comment at this time whether they are as optimally configured). Configuration changes will be required for many implementations however it seems SAP have provided, at the very least, an excellent starting point. And let’s not forget that most (if not, all) customers moving to this solution will also upgrade ASE in the process so we’d expect at least some configuration changes.

SAP DBA Cockpit is started automatically. SAP ASE has a rich set of performance metrics but we aren’t that keen on SAP’s GUI interface so we tend to use a third party solution. Asemon is our prefered solution for customers (note – it’s free and we will be reviewing Asemon online shortly). For detailed SQL monitoring we recommend iWatch which, sitting outside of the database, has the dual benefit of being able to capture the true origin of problem (whether it’s db centric, or not) whilst not eating up valuable CPU power.
So what are the advantages?
We are all aware of the generic benefits of moving to the cloud – flexibility, scalability, quicker implementations, lower TCO… and cost reduction is certainly a big benefit here. For the 8 core m4.4xlarge instance we used, licensing is $4 an hour (50 cents a core). Infrastructure costs for an M4.4xlarge is priced $1.058 an hour, giving a total hourly cost of $5.058 per hour. This appears to be extremely good value, even more so when you consider that you only pay for the system when it’s switched on. And of course, this fee also includes the costs of hardware and software ongoing maintenance.
However to my mind, the flexibility of this approach is the biggest benefit. This is a true “pay as you go” model with no caveats. You switch off the system and you stop paying immediately. Flexibility of usage is incredible – in a matter of minutes the system can be scaled up or down, allowing you to react quickly to your business requirements with no cost penalty.
So should you move?
The answer to this question is of course complex. Yes, on paper SAP ASE on AWS is a very workable financial no-brainer, at least for a one server setup. But cost is just one of the factors that you need consider here: what is your current landscape, what are your current needs, where do you want to be, what are your drivers, what is practical for your organisation? For some SAP ASE users, AWS will be ideal but the reality is that every customer’s needs are different – and requirements have a habit of changing through time…
What is certain is that this is a very welcome new model from SAP, offering its customers yet another level of business agility. SAP Licensing is already agile, offering a wealth of benefits e.g. all use outside of production is free, global usage, sub capacity licensing and of course there’s the very flexible ASE Platform Edition model which allows interchange between ASE, IQ and Rep Server, as requirements dictate. It is worth noting that ASE Platform Edition can also be delivered on AWS under a BYOL model.
All said, SAP ASE on AWS is well engineered and very well priced and definitely worthy of consideration. However, in my opinion, we need to think of as another feather in the bow of SAP’s already comprehensive suite of licensing options, rather than purely as a replacement. Some customers will move completely to the cloud but I see others, in the short term at least, exploiting the model’s flexibility to the full, using AWS to complement their existing SAP licenses as and when required.
Get in touch if you’d like to chat through your requirements.

SAP has launched extreme transactional processing capabilities on AWS marketplace with new hourly (on demand) pricing for SAP ASE. SAP ASE public cloud edition is the Enterprise Edition plus advanced options including: Security, Encryption, Compression, Partitioning and Workload Optimisation.
We are currently testing out the new service – watch this space for our reviews.
SAP has launched extreme transactional processing capabilities on AWS marketplace with new hourly (on demand) pricing for SAP ASE. SAP ASE public cloud edition is the Enterprise Edition plus advanced options including: Security, Encryption, Compression, Partitioning and Workload Optimisation.

We are currently testing out the new service – watch this space for our reviews.
Contact us to talk through how we could help you move to the cloud.
Recent research commissioned by SAP among leading IT decision makers has confirmed what we all know to be true: firstly, the majority of organisations aren’t getting the most out of their data and secondly, data landscapes are so fragmented and complex that they limit business agility. Source: Data 2020: State of Big Data Study
No shocks here but, as more and more Sybase users are discovering, it doesn’t have to be this way.
Those organisations who choose to convert Sybase estates to SAP (or indeed migrate from any other provider) access a level of technological flexibility and business agility that previously they could have only dreamed of. The game changer? The option to convert all licenses to SAP’s revolutionary Adaptive Server Platform Edition.
What makes Adaptive Server Platform Edition ground-breaking is its deployment flexibility. Using Platform Edition businesses can interchange deployment between cores of SAP ASE, SAP IQ or SAP Replication Server whenever required, giving the flexibility to re-architect landscapes in response to market conditions, peak periods or new business demands – without the need to invest in new licenses each time. Yes, you read this correctly, Platform Edition is, in essence, three different SAP Sybase data management technologies in one. This level of agility is unprecedented within the data management market. Highly efficient, Platform Edition eliminates technological waste, ensuring that every license within an estate can be used to the full.
Lower Future Costs and TCO
However, flexibility and increased business agility are not the only features that set Platform Edition apart. The license model includes as standard 15 otherwise chargeable specialist options, significantly reducing future TCO. Standard options are:
- SAP ASE – Partition, Encryption, Compression, High Availability, Security and Directory Services, Tivoli Storage Manager.
- SAP IQ – Advanced Security, In-Database analytics, Unstructured Data Access, Very Large Database Management.
- SAP RS – Replication to HANA and Hadoop, Change Data Capture, Real-time loading, Advanced Services, Data Assurance.
Extended Usage Rights to support Business Agility
What is also impressive is that this technological agility is mirrored by licensing flexibility. The business landscape is ever-changing and as a result, SAP offers its customers generous Extended Rights. As standard, non-production use comes at no additional cost so that “Full-Use” licenses are deployed 100% for operational usage. Licenses may also be used globally on any machine or any current or future supported platform, and cloud deployment is straightforward. As virtualisation moves up the business agenda with urgency, the inclusion of sub capacity rights allowing virtualisation of entire Sybase estates is yet another extremely valuable benefit.
As those customers who have already converted will testify, the move unlocks the massive potential of SAP Sybase technologies to fully exploit Big Data – with the superior speed of IQ data warehousing delivering powerful on-demand analytics capabilities across the entire organisation.
The end result is a simplified data environment that is efficient, agile and cost-effective.
As a leading UK SAP Sybase consultancy and reseller, J2 are experienced in helping Sybase customer evaluate the benefits of converting their estates to SAP. Get in touch if you would like to discuss how your organisation could benefit from a conversion.
The SAP® Advanced SQL Migration tool has been developed to meet one one of the key challenges of database application migration, SQL code Conversion. SAP® Advanced SQL Migration tool automatically converts SQL queries, stored procedures, and database schema to reduce the effort, complexity and risk of migrating your custom applications to SAP database platforms. More
Although it is not available for direct use by customers, it is available through SAP partners such as J2. Get in touch to find out how it could be used to help your conversion.
Save the date! Techselect 2017 will take place 17 October at the America Square Conference Centre, London.