SAP BODS Implementation options
Below analysis has been done to implement SAP Data Service in SAP landscape where main purpose of data servcie is ETL . Data Service solely use for extraction data from non – sap ,flat file source to transform and load into SAP BW on HANA. It contain the information to setup Data Service infrastructure ,sizing and Licensing .
This information prepared with reference to Data Service 4.2 .
Why SAP Data Services ?
SAP Data Services delivers a single enterprise-class solution for data integration, data quality, data profiling, and text data processing that allows you to integrate, transform, improve, and deliver trusted data to critical business processes.
Data Services deployment prerequisites
In the typical SAP Data Services landscape, you must first install one of the following products. These products provide platform services such as security, scalability, and high availability for Data Services.
• SAP BusinessObjects Information Platform Services (IPS) if you only want to use
features of Data Services or Information Steward
• SAP BusinessObjects Business Intelligence platform (BI platform) if you also want to use Business Intelligence clients such as Web Intelligence documents or Crystal Report
Data Services deployment options
Below is the Best practice
SAP Data Services 4.2 compatibility with BIP and IPS
For more information please refer
SAP Note : 1740516 – SAP Data Services 4.x and SAP Information Steward 4.x compatibility with
SAP Business Intelligence platform and Information Platform Services for active releases
Data Services supported operating system
Data Services supported DBMS for Database Repository
for more information please visit http://service.sap.com/PAM
Data Services minimum Hardware requirements
This is the minimum hardware requirement to run data service in single machine and distributed environment .
The following are total requirements to install all BI/IPS and Data Services products in one system:
Minimum Hardware Requirements
•4 processors (or 2 dual core processors) with minimum 2 GHz recommended
•16-18 GB RAM Recommended
Disk Space Requirements (not including Operating System)
•20 GB for default installation with English language only installed
•23 GB for default installation with all languages
Data Services Designer (supported on Windows only)
•1 processor with a minimum of 1 GB RAM (4 GB recommended)
•4 GB free disk space
Data Services Job Server
• 2 processors with a minimum of 2 GB RAM (8 GB recommended)
• 4 GB free disk space
• Recommended minimum page able cache directory size: 4 GB (8 GB recommended)
Data Services Management Console
• 1 processor with at least 512 MB RAM (1 GB recommended)
• 150 MB free disk space
Note: Data Services Management Console must be deployed with
SAP BusinessObjects BI Web Application component
Data Services Adaptive Processing Server (APS) Services
• 1 processor with a minimum of 2GB free RAM
• 1 GB free disk space (plus additional disk space for referential data, 2.71 to 9.34 GB)
• Data Services APS Services requires SAP BusinessObjects BI or Information platform services to deploy.
Before sizing Data service you need to consider below list of point for successful sizing.
- Please reference the Product Availability Matrix (PAM) for information regarding minimum requirements.
- Please reference the Data Services Performance Optimization Guide in order to understand how you job design impacts the resources you need.
- Run some test jobs in a sandbox environment, bench-mark under different loads, and then make estimates for individual jobs.
- Carefully study your ETL needs. Your ETL window and how much data of what type and in which manner has to be integrated, cleansed and moved, as well as availability requirements of your system will impact appropriate sizing.
Data Services License
SAP BODS license available in different format ,few are listed below ,for more information please refer the SAP standard document .
SAP Data Services, enterprise edition
The total number of Cores licensed represents the maximum total cumulative Cores on which all of the Software included in SAP Data Services, enterprise edition may be installed and Used, excluding SAP Power Designer Enterprise Architect and SAP Replication Server which do not count against total Cores. SAP Data Services, enterprise edition includes ten (10) Concurrent Sessions of SAP Power Designer Enterprise Architect, and SAP Replication Server that may be deployed on a separate server with a maximum of two (2) Cores.
Note: Directories are not included and must be licensed separately.
SAP Business Objects Enterprise Information Management Solutions
•SAP Business Objects Data Services. The following is included in each license of the SAP Business Objects Data Services:
•Five Named Users of SAP Business Objects Data Insight (except for licenses bundled or otherwise provided in combination with or for use with a third party product)
• Runtime license for 2 CPU licenses of SAP Business Objects Information Steward. Use of the Business Objects Information Steward is limited to Cleansing Package Builder and the Basic and Advanced Profiling capabilities that are contained in Data Insight
•One license of each of Real Time Transactional Processing, Data Source Web Service Access, Multi-user Team Development and Grid Computing
•Database Interface licenses to an uncapped number of Types of databases
•Salesforce.com Technology Interface
•JMS Technology Interface
Note: For more information on License of Data service with combination of other software please refer SAP Standard document
Above information has been collected from BODS master guide ,various SAP Notes and BODS performance optimization guide