Permission Record Information Machine (PRIM) delivers database connectivity via a web browser. Users can have different database permissions (e.g. create tables, modify tables, etc.). PRIM has built-in database analytical tools such as graph displays, reporting, etc. English and Chinese (Big5) language support.
C-Cramp (the C-Cramp College Radio Audio Management Program) is a Web-based frontend to MySQL for managing the types of things that small radio stations might need: audio files, data, and "metadata"; DJ and staff information, schedules, live music and program logs, and all sorts of other data. Currently, a cross-platform PHP application is the focus of the project, but more features and types of programs are planned that will hopefully enable easier playback, storage, loading, and entering for all types of applicable data.
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.
SELTA@Etersoft enables programs that store data in MS SQL Server to work with PostgreSQL. It translates SQL queries from the T-SQL dialect (used in MS SQL Server) to pl/pqSQL (used by PostgreSQL). Though SELTA@Etersoft is universal, it needs improvement to support concrete applications. At the moment, the translator is oriented to the popular Russian accounting system «1С:Предприятие 7.7». If your application can store data only in MS SQL, and you want it to be compatible with PostrgreSQL, support for your application can be implemented.
AGENCY is software that allows non-profit organizations to track data and manage operations. It is a fork and continuation of CHASERS. AGENCY aims to become a collectively-maintained and developed project that puts organizations in charge of their data systems. There are currently two “flavors” of AGENCY: one for managing clients and services, case management, and such (think “social service”); and one for managing donations and volunteers (think “fundraising”). Features include a report generator, permissions and access control, the ability to merge reports to OpenOffice documents, a log system, and real-time alerts with email notification. In the client version, many tables and data structures are already set up for organizations doing human service, homeless services, or HMIS. The donor version is set up to track donors, addresses, gifts (cash and inkind), flags, volunteers, volunteer activities, and more.
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.
OraRep is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.