SAP Adaptive Server Enterprise 16.0 SP03 PL04 releases quite a number of valuable new features. We will introduce the following major enhancements to you in this blog:
- aseuserstore utility
- backup server with SSL
- automatic memory management in HADR
- IMRS enabled for HADR
aseuserstore
Secure user store allows you to automate database administration tasks without compromising data confidentiality by connecting to an SAP ASE server without entering a username and password in the command line. With secure user store, you can establish the connection between a client application and an SAP ASE server using a user-generated key that retrieves the connection information (username, password, host, and port number) from the secure store.
You can use the
aseuserstore utility to insert, list, and delete the connection information in the form of user keys in the secure store. The utility supports ADO.NET, ODBC, jConnect, and SAP ASE native client applications, as well as the SAP ASE utilities
isql,
bcp, and
defncopy.
The following properties are added to each client to support this feature:
- For CT-Library – Connection property CS_SECSTOREKEY
- For JDBC/jConnect – Connection property SECURE_STORE_KEY
- For ODBC – Connection property SecStoreKey
- For ADO.NET – Connection property SecStoreKey
See
Securely Automate Database Administration Tasks Using Secure User Store.
Backup Server with SSL
Backup server supports SSL for communication with SAP ASE, and for data transfer with other backup servers, when using remote dumps and/or loads.
See
Enabling SSL in the Backup Server, and
backupserver.
Automatic Memory Management in HADR
With SAP Replication Server automatic memory management, you can replicate multiple databases (certificated with 20) at the same time with low total cost of ownership (TCO) and simple configuration steps, which makes it easier to deploy and manage multiple pairs of databases in the HADR environment.
See
Automatic Memory Management for more details.
IMRS Enabled for HADR
HADR supports the replication of databases enabled for in-memory row storage (IMRS). The following changes are introduced to support IMRS.
Want to know about more features in SAP ASE 16.0 SP03 PL04 release? Take a look at our
What’s New guide on the SAP Help Portal.