SAP Data Services

... Acknowledgments ... 15



... Introduction ... 17



PART I ... Installation and Configuration ... 21



1 ... System Considerations ... 23



1.1 ... Building to Fit Your Organization ... 23

1.2 ... Operating System Considerations ... 36

1.3 ... File System Settings ... 41

1.4 ... Network ... 45

1.5 ... Sizing Appropriately ... 45

1.6 ... Summary ... 55



2 ... Installation ... 57



2.1 ... SAP BusinessObjects Business Intelligence Platform and Information Platform Services ... 57

2.2 ... Repositories ... 64

2.3 ... Postal Directories ... 74

2.4 ... Installing SAP Server Functions ... 82

2.5 ... Configuration for Excel Sources in Linux ... 84

2.6 ... SAP Information Steward ... 89

2.7 ... Summary ... 90



3 ... Configuration and Administration ... 91



3.1 ... Server Tools ... 91

3.2 ... Set Up Landscape Components ... 132

3.3 ... Security and Securing Sensitive Data ... 140

3.4 ... Path to Production ... 150

3.5 ... Operation Readiness ... 157

3.6 ... How to Troubleshoot Execution Exceptions ... 166

3.7 ... Summary ... 172



PART II ... Jobs in SAP Data Services ... 173



4 ... Application Navigation ... 175



4.1 ... Introduction to Data Services Object Types ... 175

4.2 ... Hypothetical Work Request ... 177

4.3 ... Data Services Designer ... 180

4.4 ... Data Services Workbench ... 190

4.5 ... Summary ... 205



5 ... Objects ... 207



5.1 ... Jobs ... 208

5.2 ... Workflow ... 217

5.3 ... Logical Flow Objects ... 222

5.4 ... Data Flows ... 223

5.5 ... Transforms ... 231

5.6 ... Datastores ... 299

5.7 ... File Formats ... 309

5.8 ... Summary ... 327



6 ... Variables, Parameters, and Substitution Parameters ... 329



6.1 ... Substitution Parameters ... 331

6.2 ... Global Variables ... 335

6.3 ... Variables ... 336

6.4 ... Local

Bing Chen leads the Advanced Analytics practice at Method360 and has over 18 years of experience in IT consulting, from custom application development to data integration, data warehousing, and business analytics applications on multiple database and BI platforms. He specializes in advanced analytics and data processing technologies such as in-memory SAP HANA, column-oriented and cloud databases, Apache Hadoop, predictive analysis, data visualization, and data integration platforms such as SAP Data Services. He speaks on a regular basis at SAP and other industry conferences. Bing lives in San Francisco, California, with his wife and two children. Hanck, JamesJames Hanck is co-founder of Method360 and currently leads the Enterprise Information Management practice. In this role he leads a team to analyze, design, and build integration and information governance solutions to improve businesses' data quality. James regularly speaks at conferences on integration and information governance. He brings over 20 years' experience ensuring that trusted information is delivered and available in the simplest manner possible. Prior to Method360, James worked at various consulting and software companies including General Electric Capital Consulting, Metamor Worldwide, and IBM. James is a licensed attorney with a doctorate in law and has his certificate in High Tech Law. Hanck, PatrickPatrick Hanck is a lead Enterprise Information Management consultant at Method360. He specializes in provisioning information, system implementation, and process engineering, and he has been recognized through business excellence and process improvement awards. Patrick has over 25 years of experience in consulting and program management, working in aerospace, IT management, finance, legal, services supply chain, distribution, and retail industries. Prior to entering the world of information technology, he was a rocket scientist. He has a degree in mechanical engineering and project management