Oracle database cloning, Database Cloning, Oracle EBS Cloning, Oracle application cloning, Oracle apps cloning, Oracle DR and Backup, DBA Automation, database administration, rapid cloning, data scrambling, data masking, peoplesoft cloning
Get Appointment

Productivity Tools

  • Let your IT support teams execute their SQLs – SQL Self Service
  • Secure Password Wallet – CTVault

SQL Self Service

  • Let your IT support teams execute their SQLs – SQL Self Service
  • Secure Password Wallet - CTVault

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.

Eliminate wait times between teams

  • Frequent delays between teams can be avoided through self service of SQLs execution

Reduce DBA tickets

  • Reduce tickets to DBA team to enable DBAs to work on more complex tasks
  • Improves productivity of both DBA and support teams

Improved compliance and SQLs history

  • MS AD integrated access control
  • Approval workflow
  • History of SQLs execution with output

Customer Case Study

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.

Business Challenges:

  • 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.
  • Approval/Rejection workflow through emails (to allow the approver to act on requests on the go.)
  • Microsoft Active Directory integration is a must as there are about 300 registered users who will use this product.
  • There should be a way to provide blanket approvals (pre-approved) for certain SQLs where arguments can change but actual SQL will not. These are useful especially during routines like Month/Year end closings.
  • Validate the SQLs through preview mode.
  • Approver should know what he is approving. Also, send the completion results to requester, approver, etc.

Summary

Clonetab’s SQL Self Service helped the customer to

  • Eliminate wait times between teams.
  • Reduce DBA tickets drastically.
  • Improved compliance and productivity.
SQL self service protectivity tool
sql self service drastically reduces the wait times on DBAs for SQLs execution through an approval workflow.

Clonetab’s SQL Self Service implementation addressed all above requirements.

  • By eliminating the wait times, productivity drastically improved in IT business support & Development organizations. On the other hand, it helped to reduce the time spent by DBAs on routine mundane tasks and allowed them to work on more important tasks.
  • All the SQL executions were done in a secure and compliant way. The RUN SQL button is allowed only when all the necessary approvals were obtained. An audit trail is maintained for every request. This also helped in future reference (e.g. user can check how many rows were updated in the past for the same SQL).
  • CTS3 also provides features to download the output in PDF/CSV formats which will make it easy to validate the execution after execution of SQLs (Which is also sent through emails after execution).
Oracle database cloning, Database Cloning, Oracle EBS Cloning, Oracle application cloning, Oracle apps cloning, Oracle DR and Backup, DBA Automation, database administration, rapid cloning, data scrambling, data masking, peoplesoft cloning
1660 W Linne Road,
Suite J25 Tracy,
CA 95377
Clonetab Oracle Partner Logo

Contact Us

info@clonetab.com

+1 209 68CLONE

Quick Links

Blog

Resources

Contact Us

We Are Social

X-twitter Linkedin Facebook Youtube

© 2024 Clonetab

Privacy Policy   |    Terms & Conditions