SQL Self Service

Eliminate wait times between teams. Make IT more productive.

SQL Self Service

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.

workflows in SQL self services

Workflow

  • Tightly integrated with Workflow for approvals and SQL execution. History of SQL execution maintained in the repository for compliance and future reference.
 Role base access in SQL self services

Role Based Access

  • control through Microsoft’s Active Directory (MSAD) integrated login. Allows access through MSAD groups. Inbuilt SODs- e.g. Requester can't be the approver
email base approvals in SQL self services

Email based approvals

  • 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.
download results in PDF or xls in SQL self services

Download Results

  • The SQL execution results can be downloaded from the UI in PDF/CSV formats.
re-usable SQL script in SQL self services

Blanket Approved Scripts

  • Users can have a set of pre-approved, re-usable SQL scripts where users can instantly run themselves without waiting for approval
security in SQL self services

Security

  • SSL enabled login, TLS support for the emails sent from the application
SQL execution scheduled in SQL self services

Schedulable tasks

  • SQL Executions can be scheduled. After approval, CTS3 engine will execute the SQLs as per the requested schedule.
Parallel execution in SQL self services

Parallel Execution

  • SQLs can be executed in parallel based on the options selected by users.
preview mode before SQL execution in SQL self services

Preview mode

  • Allows user to validate SQL before execution.

Why SQL Self Service

  • • A major portion of DBA tickets are SQL execution requests
  • • Frequent delays in execution of SQL requests due to other DBA priorities
  • • With manual SQL execution methods there is no audit trail, history, compliance
clonetab SQL self services benefits
secure your password with CTvault

CTVault – Secure Password Vault

  • 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 retried 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.