Data Migration in SAP

3 Essential Tools for the Job

Just as important as any products you make or any services you deliver, your data is a byproduct of your business activities. Without precise inventory, accurate customer information, impeccable accounting, and other data driven information, you would be hard pressed to compete in today’s marketplace. So when you need to upgrade your systems, data migration must be done properly as well. Stated simply, data migration is the process of transferring data between computer storage types or file formats. You might need to transfer data from hardware to cloud-based systems; or from a non-SAP system to an SAP system; or upgrade from an older SAP format to the newest SAP HANA. In any event, data migration must be handled carefully. Be sure to call the experts at 1st Basis to deal with any data migration you might need.

Different Organizations, Different Needs

1st Basis understands that each company is unique and is committed to working with you to determine what kind of data migration best meets your needs. For instance, S/4HANA helps a business reduce its IT costs by streamlining its SAP landscape. Your business may prioritize financial data migration as essential to speed up your drive towards S/4HANA in a profitable way, then have other (legacy) data moved as well. 1st Basis will help you perform data evaluation in your current framework in order to plan the best way to move, maintain, and utilize data. With sound planning, your company can minimize risk, keep administrative consistency, and increase your return on investment.

Essential Considerations for Data Migration:

• Define the standards for the data quality, data mapping, and data conversion.

• Involve key data stakeholders throughout the data migration project.

• Use the appropriate tool to mechanize the execution of mapping of data, data transformation, and data quality responsibilities.

• Focus on 4 factors: comprehensiveness, consistency, compliance, and conformity.

• Meet the clear data standards and guidelines during the time of data entry in the system.

• Set up monitoring and reporting and establish action plan for data remediation.

Tools – Business Object Data Services (BODS)

BODS system is a tool used to extract, transform, and load data from one system (source) to another (target). It can be used with disparate systems and is tightly integrated into SAP, so it can acquire data from a variety of source systems, change it into readable data for SAP, and upload it into your SAP system. You are able to read business data at application level with BODS, and it has effective debugging and monitoring as well.

Tools – Batch Data Conversion (BDC)

With this kind of data migration, data is transferred using the batch input program. You can do it using a call transaction method or a session method. It helps to transfer a large amount of data entries related to the data entries from a legacy system to an SAP system. Only the data related to a single transaction is transferred initially with the help of a correct data format map. It automatically moves all the outstanding data entries that run in various lines using the same data format. This entire process happens in the background and the data are transferred one by one, just like they would be by hand (only a lot faster, of course).

Tools – SAP S/4HANA Migration Cockpit

This is a new migration data tool that uses preconfigured migration content. It is designed for SAP S/4HANA and was initially obtainable for cloud release only. There is now an on-premise version. This tool is made for improvements and modifications of already defined migration objects. It provides such capabilities as:

• Pre-configured content and mapping for each migration object, e.g. G/L open items.

• Predefined templates (Microsoft Excel XML files) for each object.

• Automated mapping between template and target structure.

• Migration programs are automatically generated – no programming required by the customer.

• Available for private and public cloud or on-premise.

 

These are the basic tools needed for successful data migration. There is also a Legacy System Migration Workbench (LSMW) system designed to take data from non-SAP systems to SAP R/3 systems. Contact us today to find out more.

SAP Security: Best Practices, Risk, and More

SAP Security is like an extraordinarily complex, multi-person juggling act. You may have seen performances where a couple people juggle several balls, throwing them between each other, while always keeping them in the air. Imagine if that were expanded to include every person in your business and all those balls represented every one of your customers, every item in your inventory, and, all of your financial information. With SAP Security in place, every person in your organization has access to the data needed to do their jobs, while restricting access to other areas. That means that there is limited possibility of accidentally damaging or deliberately misusing vital information. This post explores SAP Security, how it mitigates risk, best practices, and more.

Mitigating Risk

SAP Security works by analyzing the different kinds of information your company uses and the people who have access to them, and then building appropriate protections around them. In order to mitigate your risks, you need to establish a baseline. Review who has access to the company’s most sensitive information; what titles do they hold? Then examine your company’s standard operating procedure to determine where protections are most needed. This is where you create a Segregation of Duties (SoD) analysis. It’s also key to think about scenarios outside the norm and plan for those as well. It’s best to include SAP Security in the planning stage; it’s possible to do it after your SAP system is up and running, but security should be integrated from the start. Finally, SAP Security maintains its integrity by performing regular system-wide assessments which should also be included and planned for.

Best Practices – General

There are some basic best practices that should be employed with every SAP Security system, and some that apply to the different kinds of SAP systems and modules. With every SAP system, Admins create a standard role for a position (or title) and that can be assigned to anyone who fills it. For instance, your company may have account managers who deal with specific clients. There would be “keys” available for all account managers, and then more specific “keys” for each manager’s clients. That way, every account manager can access all the information necessary for their clients, but not for another account manager’s clients.

Best Practices – SAP HANA

SAP HANA security requires some adaptations from the standard SAP security system. Best practice here means that SAP HANA Security operates on a least access rights paradigm that diminishes the potential damage an employee could cause with access to more information. SAP HANA permissions work with different implementations than general SAP permissions, and it also handles objects differently, so it’s important to have someone with expertise in SAP HANA Security. If that is not part of your corporate structure, contracting with the professionals at 1st Basis is a wise choice.

Best Practices – SAP Fiori

Again, implementation of SAP Fiori varies from other SAP systems, and the most important best practice action you can take is to ensure that you are working with someone with a comprehensive understanding of SAP Fiori. There are 9 main security best practices that should be followed when using SAP Fiori. Most businesses are taken up with the actual work of the company, not the SAP system or its security. Employing the experts at 1st Basis is best practice.

 

When working correctly, SAP Security should be invisible, allowing each member of the company to access the needed information at the appropriate time so that productivity remains high. It’s a juggling act where the balls are always in the air or in the right person’s hands, never breaking the rhythm of the movement, never concealed in a juggler’s pocket, and never on the floor.

1st Basis provides hosting for our customers who want a total solution or have special SAP-centered hosting needs. We started by hosting our own equipment in a co-location (colo) but demand quickly outstripped our ability to focus on SAP Basis and managing our own hardware, so we searched for a hosting partner to fill the gap—one with our same commitment to customer service.

We picked FNTS because they were one of the first to specialize in SAP-certified hosting and because they provide multiple platforms (including AS400). They are a good fit because they have the same commitment to individualizedcustomer service. After a long vetting process, multiple meetings and joint ventures, they became our go-to hosting partnerand 1st Basisbecame the defacto, preferred, Basis provider for FNTS.

A Bit About FNTS:

FNTS has over 20 years of experience in the managed IT services industry. They are not afraid to think out of the “big box” and are known for their innovation and creative solutions (from giant flywheels that store energy or dumpster-diving to rescue a new customer’s discarded data)—they go the extra mile.

From the FNTS website:

Located in Omaha, Nebraska, the First National Data Center provides:

  • Fully redundant power (A+B) and components housed within a secured and protected environment
  • Flexible and efficient HVAC/air handling systems cooling with chilled water and backup chillers
  • 24/7 air handling monitoring for temperature, air quality and humidity
  • Dry pipe sprinklers and fire suppression systems controlled round-the-clock
  • Fully redundant Internet and failover for all Internet traffic
  • SSAE 16, SOC 2, 2N data center
  • Connection to all major communication carriers
  • More than 61,000 ft² of raised floor
  • On-site engineers 24/7

Local news story about FNTS

1st Basisis proud to be working with FNTS who, like us, “is dedicated to quality personal service.”

— David Beiswenger