SQL Self Service is a productivity tool of Clonetab which helps converting execution of SQL scripts to Self Service. Non-DBA IT Support teams (Business support, Development teams etc.) will be able to run their SQLs themselves on databases like Oracle, HANA, MySQL, MS-SQL, etc., through a Self-Service portal. Clonetab’s SQL Self Service (CTS3) tool drastically reduces the wait times on DBAs for SQLs execution through an approval workflow.
Tightly integrated with Workflow for approvals and SQL execution. History of SQL execution maintained in the repository for compliance and future reference.
Control through Microsoft’s Active Directory (MSAD) integrated login. Allows access through MSAD groups. Inbuilt SODs- e.g. Requester can't be the approver
Allow approvers to approve from anywhere in the world (alternatively requests can be approved through CTS3 UI). Approvers can view the SQLs from the same emails before approving.
The SQL execution results can be downloaded from the UI in PDF/CSV formats.
Users can have a set of pre-approved, re-usable SQL scripts where users can instantly run themselves without waiting for approval
SSL enabled login, TLS support for the emails sent from the application
SQL Executions can be scheduled. After approval, CTS3 engine will execute the SQLs as per the requested schedule.
SQLs can be executed in parallel based on the options selected by users.
Allows user to validate SQL before execution.
CTVault allows IT teams to store the passwords in a secure encrypted format and retrieve them when needed. Passwords can be a team’s password (public) or an individual’s password (private). The passwords are stored in Clonetab’s metadata repository in an encrypted format.
A password can be retrieved using Clonetab’s UI which appear as asterisks but can be copied to clipboard and used where needed.
3 different types of passwords can be stored viz. application, database & Unix. They can be further segregated into Public & Private.
© 2024 Clonetab