Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
1,349
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.
















Feature Description
RepAgent support for the sysimrslogs scanner

The sysimrslogs scanner reads logs of IMRS-enabled databases.

See Monitoring the Scanners.
System table support for the sysimrslogs scanner The following system tables provide diagnostic data for the sysimrslogs scanner:

 





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.