§... 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 Variables ... 337§§6.5 ... Parameters ... 339§§6.6 ... Example: Variables and Parameters in Action ... 340§§6.7 ... Summary ... 342§§7 ... Programming with SAP Data Services Scripting Language and Python ... 343§§7.1 ... Why Code? ... 343§§7.2 ... Functions ... 345§§7.3 ... Script Object ... 349§§7.4 ... Coding within Transform Objects ... 352§§7.4.1 ... User-Defined Transforms ... 352§§7.4.2 ... SQL Transform ... 356§§7.5 ... Summary ... 357§§8 ... Change Data Capture ... 359§§8.1 ... Comparing CDC Types ... 360§§8.2 ... CDC Design Considerations ... 362§§8.3 ... Source-Based CDC Solutions ... 363§§8.4 ... Target-Based CDC Solution ... 372§§8.5 ... Timestamp CDC Process ... 376§§8.6 ... Summary ... 379§§PART III ... Applied Integrations and Design Considerations ... 381§§9 ... Social Media Analytics ... 383§§9.1 ... The Use Case for Social Media Analytics ... 384§§9.2 ... The Process of Structuring Unstructured Data ... 387§§9.3 ... The Entity Extraction Transform ... 394§§9.4 ... Approach to Creating a Social Media Analytics Application ... 404§§9.5 ... Summary ... 411§§10 ... Design Considerations ... 413§§10.1 ... Performance ... 414§§10.2 ... Simplicity ... 426§§10.3 ... Summary ... 427§§11 ... Integration into Data Warehouses ... 429§§11.1 ... Kimball Methodology ... 430§§11.2 ... Hadoop and SAP HANA ... 451§§11.3 ... Summary ... 454§§12 ... Industry-Specific Integrations ... 455§§12.1 ... Retail: Facilitating Customer Loyalty ... 455§§12.2 ... Distribution: SAP BW/SAP APO Integration with SAP ECC ... 465§§12.3 ... Summary ... 473§§PART IV ... Special Topics ... 475§§13 ... SAP Information Steward ... 477§§13.1 ... Match Review ... 477§§13.2 ... Cleansing Package Builder ... 490§§13.3 ... Metadata Management ... 496§§13.4 ... Summary ... 498§§14 ... Where Is SAP Data Services Headed? ... 499§§14.1 ... The Key Themes for SAP Data Services ... 500§§14.2 ... The State of the State ... 501§§14.3 ... Beyond SP03 ... 504§§14.4 ... Help Shape the Future of Data Services ... 505§§14.5 ... Summary ...