Introduction to Toad DevOps Toolkit

Hello, my name is John Pocknell. I'm the product manager for the Toad portfolio. Welcome to the session. Now in this session, I just want to introduce you to the challenges that we're seeing with our customers around bringing database development and deployment tasks into DevOps' pipeline. So the challenge we're seeing in the market is businesses are trying to become more agile in order to respond to changes in market dynamics and competitive threats and other challenges. Application development cycles need to be dramatically reduced without compromising the quality and performance of the application and the scalability in production. Most application teams typically follow some sort of agile process already and already have an agile infrastructure around a continuous integration, continuous deployment. But database teams don't. They have a big problem, in fact. And if we're going to focus on Oracle database teams, specifically. So what do you do to bring your database development teams into a DevOps process? Well, it is a challenge. If you look at this graphic, you'll see the challenge between getting a database process into an application process. So the application teams are already following agile. So application developers check their code and source control, which triggers a build. And that runs through a cycle composite code, tests the code, reviews the code. But they can't release changed into a target environment until the corresponding changes within that database catch up. And that is the bottleneck. So the database process is the bottleneck in what is otherwise a natural process. So let's talk about Toad for second. So if you're already using Toad for Oracle, Toad already helps you speed up some of things on the database side. It helps you integrate your access your source control system. It has features that help you simplify and streamline your unit testing and your code quality reviews. It also has features that help you deploy changes between the source and target. So things like database compare and sync and schema compare and sync. So that's great. But I'm using not on the desktop tool. How do I bring the power of Toad into an automated build and deploy process? And Toad DevOps Toolkit comes in. So in this graphic, you see on the left hand side, Toad developers using Toad to make code changes and object changes, checking those code changes into source control. And that initiated the build process in Bamboo. What Toad DevOps Toolkit does is enable somebody using Bamboo to leverage the power of Toad to do unit tests and code views on the database code that's in that build in the same way the application developers have those things run on the application changes. Once the build is complete, then, you can release manage the whole application database code into whichever target environment you want. So in summary, your leveraging the power of Toad during the build process by getting programmatic access to Toad functions that are inside Toad DevOps Toolkit. So the specific features that are available in Toad DevOps Toolkit, version 1 are PL/SQL unit testing, static code reviews, database schema, and data compare, as well as script execution, which gives you the capability to deploy build artifacts on the database side into a target environment. One thing I should also point out, as well, is there is a lot of documentation examples available to you in the installation folder. In addition to installation guide release notes, the help includes a full API documentation set. So that explains how all of the backen com pieces are constructed, if you need that level of detail. There are also example scripts, both in PowerShell, Visual Basic, and PL/SQL, and a ReadMe doc, which shows you how to access, leverage the scripts as part of an automated build process.