SmartExporter Facts and Features
- New release of SmartExporter 2020 R1
The latest version offers numerous new features and enhancements. For example, SmartExporter now allows you to define storage location profiles to store files using an Azure File Service or on a WebDAV server.
Read the complete new features list here. - Export SAP® data simply, quickly, and reliably
SmartExporter allows you to pinpoint and export the precise SAP® data that you require for your analyses and audits. Fields of application include, for example, internal audits, digital tax auditing (GoBD), controlling, IT, and year-end audits. - Simple operation thanks to Windows application
Create your Data Requests in a familiar environment – on your own PC.
- Configure it once, use it again and again
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. - Integration into IDEA and IDEA apps
SmartExporter can be used as a standalone solution. However, when combined with an IDEA app SmartExporter identifies the precise SAP® data that you require to complete the selected audit tests. This means you do not need to be an SAP® expert. - Online and offline access
You are either connected to the SAP® system and export the SAP® data directly, or you are working offline without direct access to the SAP® system, which is often the case when completing the year-end audit for example. In such cases, you would generate a Data Request with your SmartExporter Desktop Edition and transfer it to your contact person at the company, who will provide you with the data you need. To evaluate the features and benefits of SmartExporter, especially the streamlined process when working in combination with IDEA and SmartAnalyzer, get an online demo of SmartExporter. - Schedule your data exports precisely
SmartExporter allows you to schedule a data export for a specific time and carry it out at off-peak hours, e.g. at night or on weekends. You can also scale the usage of SAP® system resources to fit your specific needs. - Extract DART segments using directDART
The directDART Additional Data Source enables you to extract SAP® data according to the segment definitions of the SAP® Data Retention Tool (DART), which means that directDART extracts the data in the same structure as SAP® DART. - Protect your data
SmartExporter enables you to comply with the General Data Protection Regulation (GDPR). To prevent unauthorized access SmartExporter observes all the settings specified in the SAP® authorization concept. SmartExporter considers all authorization objects, authorization profiles, user roles, etc. defined by your SAP® administrator at all times. Furthermore, SmartExporter allows you to encrypt and decrypt data to make sure that even if you have to extract sensitive data, you can protect it from unauthorized access or misuse. - Anonymization and pseudonymization of data
Using the Data Privacy feature of SmartExporter you can encrypt sensitive data on the SAP® system even before the extraction takes place. The anonymization and pseudonymization is done by implementing the Data Privacy feature as a separate transaction in the SmartExporter SAP® components. This way the SAP® administrator stays in full control and manipulation by the user is ruled out. Only users with the required authorizations can decrypt the data. - Access to archived data
With SmartExporter you can access and extract archived SAP® data. This feature comes as an additional component. - SmartExporter Server Edition
Furthermore a second scenario is supported: Automation of data extraction, e.g. in the environment of Alessa. - Manage Data Request activity
The status of the Data Requests placed in a queue can be managed and monitored. The status returns more detailed information concerning the progress of the Data Request like the date the Data Request was queued locally and on the SAP® server as well as the planned date when the Data Request will be run on the SAP® server, etc. - Extraction of reports and data from SAP® structures
In addition to the extraction of tables from databases and archives SmartExporter also supports the extraction of reports or data in so-called SAP® structures that are filled by means of SAP® business logic during runtime, such as payroll data.
Technical Specifications
- Output formats: IMD (IDEA), IDM (IDEA Unicode), CSV, TXT and Microsoft Access files, SAP® AIS format, ODBC and files formatted according to the default data structure.
- Access to all transparent SAP® tables, database views, pooled tables, and cluster tables.
- Communicates with SAP® systems via LIBRFC using RFC modules. The modules are installed in the SAP® system via transfer requests or add-ons.
- Read-only access: Data cannot be edited.
- Use of SAP® access privileges.
- Configure custom access privileges.
- Log all actions using unique IDs on the client and SAP® side: This ensures transparency and traceability.
- Supported SAP® release: 4.6C (Unicode/non-Unicode) or higher.
- Runs on Microsoft® Windows 8.1, Windows 10, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Microsoft .NET Framework 4.7.2
Comparison of the functions
SmartExporter comes with a variety of editions and licensing models tailored to suit the needs of your company or auditing firm. Find below an overview of the different editions available.
Functions
| SmartExporter Desktop | SmartExporter Client | |
|---|---|---|
| Create Data Request | ||
| Number of connections to SAP® systems | unlimited¹ | 3 |
| Selecting tables | ||
| Discarding tables | ||
| Edit Quick-Filters | ||
| Copy Quick-Filters | ||
| Select fields for tables (in Fields and Filters) | ||
| Discard fields for tables (in Fields and Filters) | ||
| Add/delete filters (in Fields and Filters) | ||
| Preview of data with filters applied | ||
| Add joins | ||
| Copy joins | ||
| Delete joins | ||
| Select fields in joins | ||
| Discard fields in joins | ||
| Select joined tables to download | ||
| Copy favorites | ² | |
| Add Data Request to favorites | ² | |
| Import favorites folders | ||
| Export favorites folders | ||
| Create, delete, rename favorites folders | ||
| Download Data Dictionaries | ||
| Choose different Data Dictionaries |
1 subject to the licensing terms
2 a maximum number of 10 favorites is allowed
Online Data Request
| SmartExporter Desktop | SmartExporter Client | SmartExporter Server | |
|---|---|---|---|
| Extract SAP® data online | |||
| Select data source (database or archive) | ¹ | ¹ | ¹ |
| Modify performance settings | |||
| Place Data Request in queue | |||
| Methods of synchronous data transfer from SAP® | |||
| Filter calculation method using ordering the records | |||
| Filter calculation method without ordering the records regarding primary key fields | |||
| Buffer table method |
1 access to archived data depends on license key
Offline Data Request
| SmartExporter Desktop | SmartExporter Client | SmartExporter Server | |
|---|---|---|---|
| Save an offline Data Request | |||
| Import a Data Request (favorite) | ¹ | ||
| Export a Data Request |
1 a maximum number of 10 favorites can be imported
Default file format (output)
| SmartExporter Desktop | SmartExporter Client | SmartExporter Server | |
|---|---|---|---|
| CSV files | ¹ | ||
| CSV files with header | ¹ | ||
| TXT files | ¹ | ||
| AIS SAP® | ¹ | ||
| Microsoft® Access files | ¹ | ||
| IMD-/IDM files (IDEA ASCII or Unicode) | ¹ | ||
| ODBC | ¹ | ||
| GoBD Format (according to default data structure) | ¹ | ||
| Field separator and text encapsulator for delimited file types | ¹ | ||
| Change the language settings |
1only file formats specified by the imported Data Request can be used
Integration in
| SmartExporter Desktop | SmartExporter Client | SmartExporter Server | |
|---|---|---|---|
| IDEA | |||
| SmartAnalyzer |