Samuel.Udofia - Februar 1, 2016, 12:11 pm
This is amazing product
SESAPEDM allows you to extract/upload data from/to an SAP R/3 system to a spreadsheet or any Database Management System (DBMS).
This include Microsoft SQL Servers, Oracle SQL Servers, Microsoft Access, MySQL, Text Files, most ODBC driven databases, etc
|More Details| |Download Free Trial|
Share this:
Samsole SAP Data Miner is an affordable, simple, feature loaded and all in-a-box solution that allows you to extract data from an SAP System to a spreadsheet or conventional Database Management System (DBMS) in record time. Example of a DBMS is Microsoft SQL Server, Oracle, Microsoft Access, etc. It combines the power of EasyXT� (Easy Xtract), WYSIWYG and everything else you need to quickly extract data from unfamiliar SAP tables/environment to a familiar data storage destination where you already have the power to manipulate and analyze your data.
You already know how to work with Excel spreadsheets, MS Access databases, flat files, etc. Why meddle with ABAP, SAP Query, Report painter, and all the steep learning curves when you can grab the data and present it anyway you want?
SESAPEDM takes all the guesswork out of pulling data from SAP. All you need to know is the SAP table name and definitions of each fields, provide your logon credentials and few minutes later you have data in any format you want. You don't believe it? We challenge you to stop right here, read no further, and test drive the tool. We guarantee that you will be able to extract your first data without any help or training whatsoever. It is that EASY and you Do It yourself. No ABAPers or SAP Programming required.
Unlike other data extract tools that are too expensive but provide little value, SESAPEDM is the only tool that combines ease of use, flexibility, simplicity, friendliness and performance. In today's software environment, flexibility, simplicity, friendliness and performance sounds like contradictions in terms, but there's no other tool in the market that provides the lowest learning curve, more features, and pulls millions of rows of data from SAP system in minutes instead of hours. Surprised? Don't take our word for it. Get behind the wheels and see for yourself.
Download Now... it's FREE to try for 30 days!
What's new||Download full product documentation
With this tool you can:
create multiple data extract projects
extract from multiple SAP tables at the same time
define the SAP source system you need data from
define the SQL destination system you need to place the data
configure SAP/SQL tables and fields mappings
configure additional steps/processes to be carried out as part of the extraction process.
schedule your extract to occur at certain times using the integrated windows scheduler
manage security on who can use and administer the projects
configure ITO and administrative alerts.
integrate your extract project with Microsoft Data Transformation Services
Many more features...
With the extracted data:
You can create custom queries and reports. Normally, depending on your reporting or analysis requirements, it may be difficult or impossible to fulfill your requirements in SAP. However, once you are able to get the data you want, you can massage and use the data any way you see fit.
Any external system or application that can connect to a database can consume your data in any format you wish, something which is almost not feasible with a direct SAP interaction.
You can feed your legacy systems with SAP master or transactional data information.
The following is required to successfully install and run SESAPEDM
Standard PC or Server: Intel Pentium processor (recommended)
32 MB RAM minimum
10 MB free disk space (minimum) or more for setup components. Disk space required for data buffering/storage depends on your data volume.
Operating System: SESAPDMS will operate on Windows 98, Windows ME, Windows NT 4+, Windows 2000/XP, Windows 7, 8.1 and 10
Internet Explorer: Internet Explorer 4.01 or higher is recommended. Internet Explorer 5.5+ is highly recommended. The required version of Internet Explorer (currently) comes pre-installed on Windows
Microsoft Data Access Components (MDAC): The setup application for the SESAPDMS will install or upgrade your existing version of Data Access Components to version 2.6 or above. The tool will not function without MDAC 2.6 or greater. This data access component is required for data access to most of the destination databases supported by SESAPDMS.
MDAC comes preinstalled on Microsoft Windows. However, the least compatible version of MDAC is included with Samsole SAP Data Miner in case your system does not already have one.
User Account: User must have a valid license and logon to SAP. Full detail on authorization setup. The basis administrators would typically be the ones to setup authorization.
Samuel.Udofia - Februar 1, 2016, 12:11 pm
This is amazing product
No. You can do either or both at the same time.
The Samsole SAP Data Miner setup program comes bundled with multiple products: Samsole SAP Data Miner and Samsole SAP FI Posting, SDK and development tools, etc. Users can chose to install any of the products or all of them. The default registration process will provide the user with the option to register Samsole SAP Data Miner if they selected to install all products. If either one of the product was selected, the registration wizard for that product will be selected. Each products can be registered individually at user's convenience.
We encourage you to install all because they are great productivity and cost saving business and IT tools you don't want to do without. However, you can chose to install any or none of the applications. On the Setup Type screen of the Setup Wizard, select Custom button. Activate or deactivate features by selecting the drop-down button besides each feature.
If you are installing the suite, all packaged products are selected for you by default and installed as a bundle.
Security in SAP from external accesses is based on a simply model: If the user does not have access to the transaction/RFC within SAP, then the user cannot get to these transactions externally.
Samsole SAP Data Miner uses both standard SAP RFCs and BAPIs. In fact, the tools main goal is to be as non intrusive as possible to your SAP installation and operations, so everything is standard SAP and no custom BAPIs or RFCs are used which would allow you or a user to circumvent the customer's configured security within SAP.
Also, just because you can get to some tables via SE16/SE16N does not mean you can do the same with Samsole SAP Data Miner from a security perspective, unless of course you have the table level access granted to you. And this is because the authorization check for data access is enforced on the remotely enabled RFC that SAP provides. And this security goes several levels deep: SAP logon=>RFC access/execute=>Table level access. As you can see, user would be dead in the waters if they don't have all required access within SAP.
So the only way we can think of that would make an external SAP tool unsecured is to have the vendor install custom RFCs or BAPI in your SAP system and call that externally from SAP (that is assuming they do not provide authorization checks within the custom programs).
Samsole SAP Data Miner and suite of tools do not use any custom SAP programs. PERIOD! So it is as secure as your SAP system. In addition to the standard security provided by SAP, Samsole SAP data miner also has built-in security that allows extract projects created to be assigned to Windows user roles or names. You can assign "Read", "Change"," Execute" & "Administer" privileges.
So in summary: