Let your IT support teams execute their SQLs, securely, without sharing passwords.
SQL Self Service is a productivity tool of Clonetab which helps to convert the 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, SAP HANA 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.
Customer is a global leader in management consulting with presence in more than 60 countries.
Industry: Consulting
Environment: ERP: Oracle e-Business Suite, Oracle Databases on AIX, RAC, ASM,
multi-node.
Provide a solution where IT support teams can run their SQLs without any dependency on the
DBA team but without access to passwords and in a compliant and secure method.
Since users do not have access to most of the passwords of production databases and
non-production, they need to approach the DBA team through service-related tickets for
executing SQLs scripts. Users need to wait till the DBA team executes all the tickets
available in his/her queue and many times this gets delayed due to other ongoing tasks in
the DBA team. Many times execution of these SQLs is a top priority especially during
month-end and year-end closing.
For implementing Clonetab’s SQL Self Service product, below were the needs that need to be addressed.