Data Management Tools in SAP EIM Portfolio - Part 2

162 results

  1. 24 BW Design and Data Modeling Tips for Optimal ETL

    In terms of performance, you get the biggest return on ETL optimization in the design and modeling stages. We give you tips in six categories: general design and data modeling, PSA design, InfoCube design, ODS design, Dimensions and characteristics design, and aggregates.   The extract, transform, and load (ETL) process is a key aspect of…...…
  2. SAP BusinessObjects Planning and Consolidation: Integrate Jobs into Your Existing Enterprise ETL

    See how to set up controlled batch jobs for SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform, with any corporate scheduling tool. This allows you to load end-to-end data from SAP NetWeaver BW to SAP BusinessObjects Planning and Consolidation and vice versa. Follow the steps for creating a batch file on the SAP…...…
  3. SAP BusinessObjects Planning and Consolidation: Integrate Jobs into Your Existing Enterprise ETL Jobs

    See how to set up controlled batch jobs for SAP BusinessObjects Planning and Consolidation with any corporate scheduling tool. This allows you to load end-to-end data from SAP NetWeaver Business Warehouse to SAP BusinessObjects Planning and Consolidation, and vice versa. Follow the steps for creating a batch file on the SAP BusinessObjects Planning and Consolidation…...…
  4. Another Way to Create an ETL Daily Run Report

    Reading time: 5 mins

    With so many reports that must be run daily, it can be difficult to determine the best way to track jobs in BW. The author shares her success with creating a custom table to track InfoPackages being transported to production. The table provides users with access to vital and accurate information about the status of…...…
  5. SAP Data Services Part 3: How to Extract, Transform, and Load Data into SAP HANA

    Examine and compare the classic SAP Data Services approach for extracting, transforming, and loading (ETL) processes to the functionality that is native to SAP HANA to determine optimal integration. Key Concept Certain extract, transform, and load (ETL) processes have been pushed to SAP HANA, which directly affects the integration with SAP Data Services. ETL is…...…
  6. Performance Tuning Strategies to Optimize Your SAP Data Services Environment

    Step beyond traditional database tuning concepts, such as indexing and partitioning, and get expert tips to move toward a parallel approach for code design and job construction. Examine parallel execution within SAP Data Services to see how it distributes operations and uses the strengths across your system. Get expert advice on leveraging the pushdown capabilities…...…
  7. SAP Data Services: How to Extract, Transform, and Load Data into SAP HANA

    Examine and compare the classic SAP Data Services approach for extracting, transforming, and loading (ETL) processes to the functionality that is native to SAP HANA to determine optimal integration. This content is for Basic Access, SAPinsider Monthly Subscription, SAPinsider Annual Subscription, and SAPinsider Premium Annual Subscription members only.Log In Join Now
  8. Lessons Learned from an SAP HANA Cloud Platform Implementation

    Key principles and facts are included in this overview of the design and implementation of a cloud application on SAP HANA Cloud Platform. Key Concept Applications consume and expose web service application program interfaces (APIs) that facilitate the re-usability of the capabilities of an application and support the integration into other applications. The following solution…...…
  9. Making Sense of ABAP-Based Interface Technologies in the Modern IT Landscape

    Survey modern ABAP-based interface technologies supported by SAP NetWeaver Application Server ABAP (AS ABAP). Look at the pros and cons of each technology and identify typical usage scenarios. Develop a decision table that can be used to determine when and where to apply specific interface technologies. Key Concept In the past several years, the SAP…...…
  10. 5 Best Ways to Import Non-SAP Data into BW

    Weigh the benefits and drawbacks of the five most popular ways of importing non-SAP data into your BW system. Key Concept Getting external data into BW is usually more challenging than retrieving data from SAP systems. A variety of different methods exists, such as flat files; DB Connect; Universal Data Connect; third-party extraction, transformation, and…...…