Kal-Admin

Kal-Admin, developed by Kalrom Systems Ltd, is a methodology-based software that aims to enhance database management for SQL Server and Elasticsearch. According to the vendor, Kal-Admin is specifically designed for small to medium-sized organizations and caters to professionals such as analysts, developers, quality assurance specialists, and database administrators. It is also widely used by public service organizations in Israel.

Key Features

Central management of Sql Server user Permissions: According to the vendor, Kal Admin offers a centralized approach to managing user permissions in Sql Server, ensuring enhanced security for organizations. Users can conveniently view and manage user permissions across all servers and databases, including the identification of users with admin or ownership privileges.

Data Dictionary: The vendor emphasizes that Kal Admin's Data Dictionary acts as a central repository where Business Analysts can store data element definitions and descriptions to meet end-user requirements. It also provides the capability to store business terminology, which can be later utilized for building tables in the database.

Tables Design: Kal Admin enables users to define tables without the need for physical implementation in the database. The Data Dictionary is utilized to define the columns within the table. Once the defined tables pass quality assurance, they can be effortlessly built in the database with a simple click, as per the vendor's claims.

Documentation: The vendor highlights Kal Admin's documentation feature, which allows users to comprehensively document every object within the database. Users can describe table columns and document business rules associated with them. Additionally, columns containing code content can be linked to a lookup table, streamlining code-to-text translation.

Version Control: According to the vendor, Kal Admin empowers users to set a version number when building their database, enabling effective association of subsequent changes with the designated version. This feature facilitates the assignment of different versions to different users, allowing simultaneous changes related to multiple versions and separate distribution.

Version Distribution: Users can seamlessly distribute version-related database changes from development to testing and then to production with just a click, as claimed by the vendor. The distribution history is readily available, and users can compare any two versions of an object to identify changes.

Distribution History: The vendor asserts that Kal Admin provides users with access to the distribution history of an object, offering crucial information such as distribution time, distributor, and destination. Users can also view the script of the distributed object.

Data Comparison: Kal Admin includes a robust data comparison feature, enabling users to compare and synchronize data from multiple tables. This feature ensures consistency and accuracy, according to the vendor.

Database Structure Comparison: The vendor states that Kal Admin's database structure comparison feature allows users to compare the structure of databases. The user-friendly and intuitive nature of this feature has made it a preferred choice among clients compared to similar tools from other vendors.

Change Management: According to the vendor, Kal Admin facilitates efficient tracking and management of changes made within the database. Users can easily identify the individuals responsible for changes, along with the timing and nature of the modifications. Changes can be filtered by version, dates, user, or object and can be distributed simultaneously to multiple databases.