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, 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.
SQL Self Service is a database productivity and automation solution that allows authorized non-DBA teams, such as developers and business support users, to execute approved SQL scripts through a self-service portal. It reduces dependency on DBAs while maintaining governance, security, and compliance through approval workflows.
SQL Self Service automates routine SQL execution requests that typically consume a significant portion of DBA time. By enabling users to run approved SQL scripts themselves, organizations can drastically reduce SQL-related DBA tickets and free DBAs to focus on higher-value activities.
Enterprises often face delays when SQL requests depend on busy DBA teams. SQL Self Service eliminates these bottlenecks, improves productivity, accelerates issue resolution, reduces operational costs, and provides a secure framework for database changes.
Clonetab SQL Self Service supports multiple database platforms, including Oracle Database, SAP HANA, MySQL, and Microsoft SQL Server, enabling centralized SQL execution management across diverse environments
The platform introduces approval workflows, audit trails, execution history, role-based access controls, and scheduled execution capabilities, helping organizations standardize and govern database changes while reducing operational risks
Yes. Once appropriate approvals are obtained, developers and support teams can execute authorized SQL scripts through the self-service portal without waiting for DBA availability, significantly accelerating issue resolution and business processes.
The solution supports configurable approval workflows, including email-based approvals and portal-based approvals. Approvers can review SQL statements and approve requests directly from email or through the application interface.
Yes. The platform includes SSL-enabled access, TLS-secured email communication, Active Directory integration, role-based access control, segregation of duties, and comprehensive auditing to ensure secure SQL execution.
Â
Unlike manual processes, Clonetab SQL Self Service provides automated approvals, secure access controls, audit trails, execution history, scheduling, reusable approved scripts, and compliance-focused governance in a single platform.
Organizations can expect reduced DBA workload, faster SQL execution, improved productivity, better SLA adherence, enhanced compliance, reduced operational delays, and increased visibility into database activities.
SQL Self Service enables controlled and auditable SQL deployment through approval workflows, automation, execution scheduling, and governance controls, making it an effective component of database CI/CD processes