SmartExporter Simplifies Extraction of SAP data
Export data from SAP® and prepare it automatically
Analyzing SAP® data doesn’t have to be difficult. Leverage SmartExporter, an intuitive and user-friendly, Windows-based extraction tool, to pinpoint and export the precise SAP® data required for your analyses. Both SmartExporter and IDEA are easy to use, enabling any person in your organization, no matter the department, to pull an SAP® data report. By using this integration, you will streamline your workflow, reduce wait times, and boost operational efficiencies.
Get your data the simple way
SAP® is used by roughly 100,000 companies worldwide. However, users of the software face a number of special challenges when attempting to analyze SAP® data outside of their SAP® environment. Due to large volumes of data with complicated structures, complex workflows and diverse company specific entities it is extremely difficult to access SAP® data.The solution: Export the SAP® data required for your audits quickly and easily to any directory using SmartExporter. With SmartExporter you can access all transparent SAP® tables, Database Views, Pooled Tables and Cluster Tables and also archived data.
Unlike internal SAP® solutions which are managed centrally from within the SAP® system, SmartExporter is a Windows-based application. The Data Request is not created in SAP®, but on the user's computer. You work in the familiar Windows environment. This makes SmartExporter ideal for ad hoc analyses to reduce data analysis expenses.You can use SmartExporter in the following areas:
• Internal audits
• Finance and accounting
• Bookkeeping and taxes
• Accounting control
Not familiar with SAP®? No problem.
Make complex, time-consuming SAP® features a thing of the past. Thanks to SmartExporter you can create your Data Request where you are most comfortable — on your own computer. SmartExporter supports you in the complex task of selecting SAP® data: Once a Data Request specifying the required tables, joins, fields and filters is created you can save it as a favorite and reuse it anytime.It is also possible to integrate SmartExporter into IDEA and SmartAnalyzer. After selecting your audit steps, SmartExporter identifies the SAP® data you actually need. Once the export is complete, you can analyze the exported data directly in IDEA and SmartAnalyzer.
Prepare Data: Right here.
Use SmartExporter to overcome the tiresome process of data preparation. You can now define the required joins for the data to be extracted while you are creating a Data Request in SmartExporter. Thus SmartExporter enables you to reduce the data volume to exactly suit your needs. The join definitions are an integrated part of your Data Request and SmartExporter provides data that you can analyze straightaway. SmartExporter provides an Inner or Left Outer Join. Needless to say that using SmartExporter you can define joins for Pool and Cluster tables also.
Online? Offline? Both.
SmartExporter offers you two ways to export data: You can either connect to the SAP® system and export the SAP® data directly: Synchronous with small and asynchronous with large volumes of data.Or you can work offline without access to the SAP® system, which for instance is generally the case with external auditors.
You would then generate a Data Request with SmartExporter, transfer this XML file to the person in charge of the SAP® system who will provide the data you need. The SAP® data requested will be provided e.g. on a data carrier.Whether online or offline, SmartExporter allows you to run exports depending on the current system workload or to schedule them to a specific time during off-peak hours, e.g., at night or on weekends.
SmartExporter: Safe as can be!
SmartExporter is secure. User access to SAP® data is limited by the existing SAP® access authorizations. In addition, custom access authorizations can also be defined.The authorization concept is not restricted to table level, but can be expanded to detailed information, such as company code or fiscal year.Because access is restricted, data is displayed as read-only content.
The original SAP® data cannot be edited. All actions can be traced at any time, as they are recorded by a unique ID on the client and SAP® side. This ensures maximum transparency when using SmartExporter.A further benefit: With SmartExporter, you create files according to the GDPdU default data structure.
he SmartExporter flavors
SmartExporter is available in various editions – providing the suitable edition for your specific needs.The SmartExporter Desktop Edition is the full version of SmartExporter. Using the Desktop Edition you have access to all available features.The Client Edition was designed to provide a smooth and optimized workflow between auditor and client. The Client Edition offers the option to extract data from an SAP® system in a synchronous and asynchronous way.
This guarantees a maximum of flexibility because the client is able to decide when and how the data requested by the auditor is extracted.The licenses of the Desktop and the Client Edition are connected and the Client Edition can only import Data Requests or favorites created by the corresponding Desktop Edition.
The SmartExporter Server Edition is a separate installation which can be integrated into other processes, e.g. in IDEA Server or CaseWare Monitor, and provides a high potential for automation. The SmartExporter Starter Edition is a free SmartExporter version with limited functionalities which can be used for testing purposes and as a means of evaluation for the features and functions of SmartExporter Desktop.
“ Two years ago we didn’t expect that in this pandemic phase, IDEA and Pentana Audit software utility could really help in a remoted audit process, in term of the desk audit process as well as the reporting activity process. With IDEA data analytic, the process of the desk audit can save the field work & visit time up to 70%, this could happen because IDEA can analyzed and do the data processing to identify risks and spesific scoop at the beginning of the desk audit process. ”
“ Our audit teams use a data extraction and analysis tool, IDEA. This allows teams to analyse large amounts of financial data. Using IDEA, we can access such data in seconds, saving time and money for our clients. ”
“ I absolutely recommend IDEA. It lets us quickly analze 100% of our data using repeatable procedures. It’s also advanced enough to provide what I call a ‘one-click’ solution where it creates a dashboard populated with charts and field statistics that make it easy to see the outliers. Generating a result with just a couple of clicks is awesome. ”
“ We use data analytics in all phases of the audit. During the planning stage, we use it for scoping and sizing. During fieldwork, we use IDEA because we can analyze the entire population, which would not be possible with manual analysis. IDEA makes it easy to create new tests and narrow the population so we can focus on anomalies and exceptions. ”
“ Pentana Audit helps us understand our risk better which helps us be prepared for any type of event by enabling a continuous risk-based audit execution process. With Pentana Audit we are now more adaptable for changes and that makes us better prepared for emerging risks. ”
“ It’s been an incredibly effective way for us to build the risk culture within the organization. All of our lines of business now know the name Pentana! ”
“ With Pentana Audit we are saving approximately 100 working hours per audit and with an average of 12 audits every year that is an astounding saving. ”