SAP Data Services 4.3 and SAP Information Steward ...

shibajee_dutta_gupta · ‎11-03-2023

Introduction

This document is for quick and easy updates on SAP Data Services 4.3 and SAP Information Steward 4.3. This post will be appended as and when new service packs or patches are released. The purpose of this blog is to help the SAP Data Services and SAP Information Steward users take a quick look on the enhancements applied by service pack levels in the respective products. Each of the features\enhancement is hyperlinked to the help documents for a convenient access to the details of the topic in product documentation. This blog also has the certifications information linked by each service pack.

Background

On April 29^th, 2022, SAP Data Services and SAP Information Steward did the minor release of 4.3 SP00 version ,which succeeded the last active version of SAP Data Services 4.2 and its service pack and related patches. In general, there have been two service packs per year, as GA, consisting of enhancements and fixes, periodically provided to the users. Some of the enhancements and functionalities that has high impact to our user base are listed below. Additionally, there has been major enhancements applied to the system libraries to make the products fully compliant for security requirements and made compatible with the latest and greatest of the third-party libraries. This also included addressing the compatibility of the supported versions of Information Platform Services.

To keep our large user base running their ETL and Data Integration infrastructure with enhanced integration and security needs into the major cloud providers and their prominent data systems, we have listed some of the highlights below. However, please refer to the SAP Data Services PAM and SAP Information Steward PAM for the latest compatibility information.

SAP Data Services 4.3 enhancements starting with latest SP

Sequence#	Features and enhancements - DS 4.3 SP02
1	Connect to Amazon Athena using Simba Athena ODBC driver
2	Connect to Snowflake using key pair authentication for server-based (DNS-less) connections. Data Ser...
3	Connect to Microsoft Azure AD with password authentication on the Azure PaaS repository and datastor...
4	SAP Data Services now supports importing metadata for OData V4 function operations to use in dataflo...
5	Support for the US Postal Service CASS Cycle O implementation. Both the national directories and the...
6	Support for JSON web token (JWT) single sign-on user authentication mechanism for SAP HANA on-premis...
7	Support for IAM (Identity and Access Management) authentication for Amazon Redshift as an alternativ...
8	Use the new option, Request Timeout (ms), when you configure connections in a file location object t...
9	Mandatory updates for address directories for USA Regulatory Address Cleanse (URAC) and Global Addre...
10	Deliverable street highrise default. CASS O requires that records that match both a street address a...
11	PBSA identifier directory. SAP Data Services supports a new DPV directory that lists all PBSA (PO Bo...
12	The DPV Drop indicator identifies delivery points that serve multiple businesses or families, such a...
13	Changes were made to the Military Addressing format (“Mail” was changed to “Postal”) for some specia...
14	CASS O Report updates. The USPS implemented changes to PS Form 3553 and new CASS O features to the U...
15	CASS O: CMRA/PMB DPV confirmation. CASS O requires that SAP Data Services processes records in the C...
16	To comply with CASS O changes to DPV, SAP Data Services updated applicable DPV status codes and foot...
17	CASS O: NCOALink: Mandatory File dhdr.txt for the Daily Delete Directory. You must download and inst...
18	CASS O: NCOALink and DSF2 Monthly Reports - Installation Considerations. Information about how and w...
19	CASS O directories allow for cross state addresses, which are addresses from multiple states that fa...
20	SAP Data Services 4.3 SP2 updated the single trailing alpha functionality based on updates by CASS O...
21	CASS O: Informed Addressing. SAP Data Services identifies addresses that are a part of the USPS Info...
22	CASS O: R777 and R779 carrier route matching. The USPS reserves the carrier routes R777 and R779 for...
23	The USPS has a new DPV No Stat Reason Code table with codes that represent the reason why an address...

Sequence#	Features and enhancements - DS 4.3 SP01
1	For DSN-less connections to your PostgreSQL databases, enable SSL/TLS with optional X509 authenticat...
2	Microsoft SQL Server repository support on Linux: Now you can create a SQL Server repository on Linu...
3	In SAP Data Services 4.3 SP1, a Request Timeout(ms) option was added to the Advanced options for all...
4	Added support for V2 or V4 and OAuth 2.0 authentication with the saml2-bearer grant type for the SFS...
5	Support of bulk loading blob and clob columns to SAP IQ and SAP HANA Data Lake databases.
6	Enabled, by default, the MultiSubnetFailover attribute to 'Yes' in the SQL Server connection string...
7	SAP BW/4HANA InfoObjects as targets. Enabled to load BW/4HANA InfoObjects (both Master data and Text...
8	SuccessFactors adapter support for OAuth 2.0. Added OAuth 2.0 based authentication with saml2-bearer...
9	Support for IBM DB2 repository with the SSL/TLS secure authentication and data encryption for server...
10	Create a database datastore to connect to your SAP HANA Cloud data lake database for both DSN and DS...
11	Support for the Data Services Global Suggestion List (GSL) transform is being deprecated in the Data...
12	Enabled OData V2 function import operations to use the entity (table) related operations in your dat...

Sequence#	Features and enhancements - DS 4.3 SP00
1	Enhanced the Google Cloud Storage file location object with a new option named Region (for new bucke...
2	SSL/TLS protocol is now supported when you connect to SAP IQ databases using a server-based (DSN-les...
3	Enable SSL/TLS protocol for an SAP HANA repository for both DSN and server-based (DSN-less) connecti...
4	Ezdeploy discontinued. Data Services 4.3 no longer supports the SAP Data Services rapid deployment p...
5	New built-in functions are available for loading data to Azure Synapse Analytics, formerly known as ...
6	Security enhancement SAP ASE sources and targets. Configure SSL/TLS communication for SAP ASE source...
7	Use the new OData URL suffix adapter option to add additional parameters to the end of all OData URL...
8	In SAP Data Services 4.3 SP00, Workbench is no longer available so you must use the Data Services De...
9	On creation of a datastore for Microsoft SQL Server databases, you can select either Kerberos or NTL...
10	OData V2 now supports server-side pagination and batch processing, which can improve performance whe...
11	Create an Oracle repository with TCPS (Transmission Control Protocol Secures) for either TSN or serv...
12	Secure your connection to Teradata 17.10 databases with SSL/TLS encryption configured in a Teradata ...
13	SSL/TLS protocol is now supported for your MySQL repository.
14	SSL/TLS protocol is now supported for your Microsoft SQL Server repository when you use a server-bas...
15	A new built-in function is available for loading data from files in Azure Cloud Storage or Amazon S3...