Toad World Blog

What’s Coming Soon in Toad DevOps Toolkit 1.1

Apr 23, 2018 6:08:00 AM by John Pocknell

We launched our first release of Toad DevOps Toolkit last November and we’ve already seen a huge amount of interest.

We’ve listened to feedback from our customers and it’s been extremely positive. However, one aspect of its usage; specifically the requirement to use scripts (PowerShell seems to be the most popular so far) in order to instruct Toad DevOps Toolkit which modules you want to use and how you want to use them has led us to develop a simpler way to incorporate and use Toad DevOps Toolkit within your Jenkins build process.

We’ve built a Jenkins plugin which, once incorporated into your Jenkins build console, will dramatically simplify the usage of Toad DevOps Toolkit.

For this 1.1 release, we have included the ability to use the following Toad DevOps Toolkit modules (the most popularly used) within the Jenkins plugin:

  • Static code review & analysis using Toad Code Analysis
  • PL/SQL unit testing using Toad Code Tester
  • Script execution

There is no dependency to use any scripting for these 3 modules because, based on the field values you enter, dynamic scripts are encapsulated in the plugin.

The Jenkins plugin for Toad DevOps Toolkit will be available from the Jenkins Index at: https://plugins.jenkins.io/

Once the plugin is installed into Jenkins, all you have to do to use it is to add a new build step.

TDT2.png-1280x960

Figure 1: Adding a new Toad DevOps Toolkit build step in Jenkins

The selection of the appropriate build step will open a new panel inside Jenkins where you can insert the necessary values. Once the build has been configured, starting the build process will initiate a call to Toad DevOps Toolkit which will run in the usual way.

TDT11.png-1280x960

Figure 2: Toad DevOps Toolkit Jenkins plugin in use inside the Jenkins build console performing a static code review

In the above example, I am selecting a static code review build step which will call the Code Analysis module in Toad DevOps Toolkit and perform a code review on all PL/SQL Stored Functions in my source control folder using the “Top 20” rule set, generate the output reports in both HTML and JSON formats and save them back in my source control folder.

You can perform a code review on files, database objects or both and you can use wildcards.

In the below example, I am performing an execution of a PL/SQL unit test called “SPARRING” in the “TKD_SCHOOL” schema and outputting the report in txt format into the “Unit Tests folder”.

In this case, a database connection is required in order to access the test definitions from the Code Tester repository.

TDT3.png-1280x960

Figure 3: Toad DevOps Toolkit Jenkins plugin in use inside the Jenkins build console performing a PL/SQL unit test execution

The use of this new plugin should greatly improve productivity and also speed up the learning process if you are evaluating Toad DevOps Toolkit as part of your DevOps initiatives.

So look out for the announcement on the release of Toad DevOps Toolkit 1.1 and I hope you enjoy the benefits.

For information on other solutions designed to help you bring you database operations into DevOps, please visit our DevOps Solutions page at: https://www.quest.com/solutions/devops/

Tags: Toad DevOps Toolkit DevOps

John Pocknell

Written by John Pocknell

John Pocknell is a senior product marketing manager at Quest Software. Based at the European headquarters in the U.K., John is responsible for the go-to-market strategy for the Toad portfolio of products worldwide. He has been with Quest Software since 2000, working in the database design, development and deployment product areas. John has spent over 17 years (including 12 years in Product Management) successfully evangelising Toad to customers at various conferences and user groups around the world and he writes blogs and produced many videos on the Toad user community, Toad World as well as technical papers about Toad on the Quest Software website.

John has worked in IT for more than 30 years, most of that time in Oracle application design and development. He is a qualified aeronautical engineer with more than 10 years of experience in provisioning IT consultancy services and implementing quality assurance systems to ISO 9001.