Much of the data being uploaded into SAP already exists in a digital format such as Microsoft Excel spreadsheets or Microsoft Access databases. Moving data out of these spreadsheets and databases requires either manual data entry or ABAP development resources.
Syniti has an easier solution. For a fraction of the cost of a regular inflexible custom-built ABAP upload program, SDW can be used to upload Excel files and Access files directly into SAP without any ABAP programming or technical expertise. Utilizing the Microsoft Office suite as the data management platform, users can manipulate and prepare data for upload without any additional training or software.
SDW is a desktop application that is installed directly onto the users’ workstation without any need for changes/installations to the SAP systems. The installation process is quick and simple, and the user-friendly interface can be mastered in a couple of hours. Most customers are creating their own templates and uploading data the very same day that SDW is installed.
SDW can be used for a variety of applications within the different SAP modules. Common uses are Mass Uploads of SAP data, Mass Maintenance of SAP data, SAP data migration and the automation of SAP data entry.
Why Syniti Data Workbench
Simple 3 Steps Process
The procedure to upload Excel or Access files into SAP is a simple three step process designed for even the most inexperienced of end-users. The user records the transaction by executing it from within SDW. Once the recording is complete an Excel or Access file is automatically created for the user to add the data to upload. The final and simplest step in the process is to return to SDW and select the file to upload the data.
Automatic Load File Generation
While navigating between SAP’s transaction screens, SDW does automatic mapping between spreadsheets/databases to fields automatically and a load file will be generated for mass data upload.
Error Handling
Simple to understand error handling separates the records that failed, facilitating quick corrections and upload procedures. User can take advantage of the step-through function where graphical view of every screens that SDW goes through to upload data will be displayed for diagnosis purpose.
Report Generation
Report can be generated as printer output or HTML file for audit purpose. Summary report displayed an overall success and error rate for each transaction and ROI summary in form of time saved by Syniti Data Workbench.
Respects SAP Security
No need to setup additional security and ensures users can only upload data that they could have done manually.
Data Validation
Ensures that data being uploaded into SAP is in the correct format so as to prevent errors even before uploading into SAP.
Additional Application Security
Allows the restriction of certain tasks in the application even if the user has sufficient SAP authorizations.
Broad Transaction Support
Allows uploads of data into SAP in all SAP functional areas as well as custom transactions.
Flexible Licensing & Pricing
Lets you choose from a licensing model that suits your individual requirements.
Transaction Stringing
Strings multiple transactions together that can be executed in one step rather than many.