This Document is to provide information on some of the new features of SAP Data Services 4.2 and 4.1 which could be useful while working on the DS.
New Features of BODS 4.1:
The major improvement of the 4.1 version is its integration with SAP and NON SAP systems.
Enhanced extraction capabilities for SAP Business Suite:
Hadoop integration: Data Services now offers connectivity to Hadoop sources including Hadoop distributed file systems (HDFS) and Hive data warehouses.
Monitor log enhancements: Time-based sampling.
SAP Solution Manager Improvements: Alerting and Heartbeat monitoring lets us use the SAP Solution Manager to check whether a component such as a Job Server or Access Server is up and running. We can also get information about real-time services for Access Servers.
Improved XML support through the XML_Map transform: This version of Data Services adds a new XML_Map transform that simplifies support for hierarchical data structures such as XML and iDocs. The new XML_Map transform provides a simplified interface for nesting and un-nesting hierarchical data and converting from one hierarchical structure to another without an intermediate flattened-data step.
Enhanced SAP HANA support:
Data Services Workbench: The Data Services Workbench is a new application that simplifies the migration of data and schema information between different database systems.The Data Services Workbench automates this migration process. Instead of creating many dataflow manually, we now provide connection information for the source and target databases and select the tables that we want to migrate. The Workbench automatically creates Data Services jobs, workflows, and data flows and imports them into a Data Services repository. We can execute and monitor these jobs from within the Workbench. In addition, the Workbench supports more advanced options such as bulk loading and delta loading.
In this version of Data Services, the Workbench supports migration from Data Services-supported databases and SAP applications to SAP HANA, Sybase IQ, and Teradata targets.
Design-Time Data Viewer: Previously in the SAP Business Objects Data Services Designer, we could view data for only static sources in the object library such as tables, files, XML, COBOL copybooks, and corresponding sources and targets. To view data going through transforms, you had to use the Debugger. Now, the Design-Time Data Viewer feature lets us view and analyze the input and output for a data set in real time as we design a transform. The dataflow does not need to be complete or valid, although it must use a valid, accessible source that contains data. We can display and configure Design-Time Data Viewer from the Debug menu.
New Features of BODS 4.2:
The major improvement of the 4.2 version is its usability. It’s highly simplified compared to the previous one.
A new Platform transform added in SAP Data Services 4.2 SP4:The Data Mask transform enables you to protect personally identifiable information in your data.
SAP LT Replication Server integration: Data Services has been enhanced to integrate with SAP LT Replication Server (SLT) by leveraging the new version of ODP API.
Retrieving the time zone of a Management Console machine: The new Get_MC_Machine_Timezone operation allows us to retrieve the time zone of the Management Console machine.
There are some new Built-in functions added in DS 4.2.
Expanded Designer search capabilities: Using SAP Data Services Designer, now we can search for a text string in every part of the object, such as table name and variable name.
Native Microsoft SQL Server support on UNIX: Data Services 4.2 provides native Microsoft SQL Server support on UNIX as a source or a target. When using the UNIX job server or engine to access the MS SQL Server datastore, the following functionality is available:
Batch Mode functionality added to the XML_Map transform: We can now use the XML_Map transform in Batch mode to accumulate data as a block
of rows instead of a single row. This block of rows is sent as a unit to the next transform.
Introduced Google Big Query application data store :
Included MongoDB support:
DS 4.2 supports HDFS data preview:
Additional database support for Replication Server real-time CDC: Replication functionality introduced
in SP03 has been extended in SP04 to include MS SQL Server, IBM DB2 and SAP ASE.
Harness the power of HANA:
Thanks,
Tanvi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |