SYMPLiK EXZELLENZ is a program to manipulate table data in Oracle database by using a Microsoft Excel file (xls or xlsx format). Unlike Oracle WebADI, More4Apps, or other Excel-driven solutions, this program does not use Office VBA (macros) to process the data. It is a pure Java solution incorporated with Apache POI and the Oracle JDBC driver to download, upload, insert, update, and delete data from Oracle database tables. It is Linux-friendly for Open Office users as long as the spreadsheet is in Excel formats.
Pool Table Viewer creates database views that allow access to pooled tables directly from Oracle. SAP stores lookup and reference tables in a format known as pooled tables. These keep the data stored in a COBOL/ABAP record format, and the data is not normally readable from Oracle directly. This viewer can be useful for integration software, where there would not be a requirement to write ABAP interface code to access the SAP data. This works with any SAP R3 system with an Oracle database backend.
SAP has three different types of tables: Pooled tables, direct tables, and clusters. Pooled tables pool together several smaller lists and lookups into one table. The format of the pooled tables is basically Cobol Record structure. SAP Pooled Table Viewer uses the SAP data dictionary to create Oracle views that allow easy querying of the SAP data. This makes it easier to integrate with SAP systems where you can use database connectivity and bypass the need for ABAP.
Oracletool is an interactive, Web-based application for Oracle Database administration. The advantage of Oracletool over non-Web-based tools is that nothing needs to be installed on the client-side machine or in your databases. All you need to use Oracletool, once installed, is a Web browser.