Toad DevOps Toolbox Release Notes

Toad^® DevOps Toolkit 1.1

Release Notes

4/20/2018

These release notes provide information about the Toad DevOps Toolkit release.

About this release

Toad DevOps Toolkit 1.1 is a minor release, with enhanced features and functionality.

About Toad DevOps Toolkit

Toad DevOps Toolkit exposes key Toad for Oracle functionality (such as Code Analysis and Unit Testing) as programmable objects that can be called from DevOps scripts such as PowerShell or Visual Basic. This enables you to include database-development steps into your Continuous Integration model through tools such as Jenkins or Bamboo. What this all really means is that the deployment of Oracle application and database upgrades is now made much easier, keeping your team more productive and your end users satisfied with their business tools.

Toad DevOps Toolkit is standalone and independent from Toad for Oracle. The only requirement is that a Code Tester for Oracle repository is installed on the same system as Toad DevOps Toolkit. For version requirements, see the System Requirements.

Toad resources

The parent site for all Toad family products is ToadWorld.com, where you will find videos, blogs and podcasts, and much more.

The home of the Toad DevOps Toolkit community is https://community.toadworld.com/products/toad-devops-toolkit. Keep checking this site as Toad DevOps Toolkit continues to grow and add features to help you increase your productivity.

Two of the most-often used features of Toad World are the Forums and the Idea Pond. Go to https://community.toadworld.com/products/toad-devops-toolkit, then click the Idea Pond or Forum tab.

• On the Idea Pond page, you can submit your ideas to improve Toad DevOps Toolkit and vote for or against other customers' ideas. The Toad team takes your suggestions seriously, and you may even hear back from one of our developers on the topic. We encourage all Toad users from new to experienced to let us know how we can improve Toad.
• On the Forum page, you can ask a question or start a discussion and view all other forums within the Toad community.

The Toad World blog pages feature a broad range of information, including topics of interest to our industry, as well as instructions from team members on how to use the latest Toad features.

System requirements

Hardware requirements

Database requirements

Additional requirements

• Microsoft Internet Explorer 9.0 is required to run the Toad DevOps Toolkit License Manager.
• Microsoft .NET 4.5 Framework is required to run the Quest Installer, which installs Toad DevOps Toolkit.
• If you want to run unit testing for database objects, a Code Tester repository (3.2 or greater) must exist on the system where Toad DevOps Toolkit is being used.

Windows Privileges

In order to run Toad DevOps Toolkit against the database, the following privileges are required:

New features

Version 1.1

A new Jenkins plugin is now available to automate certain tasks, rather than having to write a script. All of the required scripts are embedded in the plugin. To run the task, simply add it as a build step and complete the required information. The plugin supports Jenkins environment variables and credentials.

Available tasks are:

• Code Analysis
• Unit Testing
• Script Execution

To install the plugin

1. Open Jenkins.
2. Go to Manage Jenkins | Manage Plugins | Available, then search for Continuous Integration with Toad DevOps Toolkit.
3. Select the plugin, then finish the installation.

Version 1.0

The following Toad for Oracle features were introduced with the launch of Toad DevOps Toolkit.

• Code Analysis: This feature enables your team to ensure that the quality, performance, maintainability, and reliability of their code meets and exceeds their best practice standards. Toad DevOps Toolkit ships with a default RuleSet against which to compare your code. You can develop custom RuleSets in Toad for Oracle and call them from Toad DevOps Toolkit.
• Unit Testing: This feature enables your team to run the unit tests that they created in Toad for Oracle or Code Tester for Oracle as part of the automation.
• Database Compare: This feature enables your team to compare two databases and then create a script to synchronize them.
• Schema Compare: This feature enables your team to compare multiple schemas, with or without a snapshot, and then create a script to synchronize them.
• Table Compare: This feature enables your team to compare two or more tables and then create a script to synchronize them.
• Script Execution: This feature enables you to execute scripts.

Product licensing

Before you can use Toad DevOps Toolkit, you must add your license and then create an access key by running the License Manager utility. The License Manager utility enables you to add and manage your Toad World licenses and access keys. Both a valid license and an access key are required. Toad DevOps Toolkit licensing is term licensing, and you will be notified at runtime if the license is approaching the expiration

About access keys

Important! Read this before you run the License Manager.

Access keys are used by Toad DevOps Toolkit to validate licenses without the need to log in to Toad World every time you want to run the product. They are secret keys created and tied to your specific Toad World account. As a result, they should not be handed out, as that would allow other people to use the licenses that are tied to your account.

You can create as many access keys as you want, and you can revoke them at any time. You cannot reactivate an access key after you revoke it. You must create a new one.

You can create a single access key to be used by multiple devices or you can create a separate access key for each computer that will run Toad DevOps Toolkit. Best practice is to create separate keys for each computer, so that if any computer is ever compromised, you can simply revoke that key while leaving the other keys available for use.

Requirements

• The License Manager requires an active internet connection and at least Internet Explorer 9 installed on your machine. The Toad DevOps Toolkit installer performs a check to verify that this requirement is met.
• The License Manager requires a Toad World account. If you do not have an account, you can create one by clicking the link on the login page. Toad World accounts are free and allow you to get up-to-date help and information by viewing blogs, wikis and forum discussions for all Quest Software products.

Licensing options

• Commercial licenses are supplied by a Quest Software sales representative.
• Free 30-day trial licenses are available from within the License Manager application.

Run the license utility

These instructions run the License Manager utility to apply trial and commercial licenses.

To add a license and access key

1. Run the License Manager utility from the Toad DevOps Toolkit program folder in the Start menu. You are prompted to log into Toad World.

2. Log into Toad World using your Toad World account. The Licensing page of the utility is shown.

3. Click Add. The Add License dialog is shown.

4. Do one of the following:

   • To add a commercial license, select Commercial (the default), then enter the license and site message provided by your Quest representative or the Quest licensing team.
   • Select 30-Day Trial to get a free, temporary trial license. No license input is required for this option.

5. Click OK. The license is now shown under Your Licenses.

6. Click Next. The Access Keys page is shown.

7. Click Add. The Key Name dialog is shown.

8. Enter a unique name for the key, then click OK. The License Manager adds the access key to your Toad World account and installs it for use by Toad DevOps Toolkit on the local machine. It will then appear in the Access Keys page of the management window.
9. Click Next. The Resources page is shown. This page provides quick access to local and online resources for Toad DevOps Toolkit as well as contact information for both support and sales.
10. Click Next. The Feedback page is shown. Select either Yes or No to indicate your preference on participating in the Toad DevOps Toolkit improvement program. No personal information is collected during this process. For information regarding the Quest Privacy Policy, click the Privacy Policy link.
11. Click Done.

To revoke an access key

1. Run the License Manager.
2. Log on to Toad World.
3. Select Access Keys.
4. Select the license that you want to revoke.
5. Click Revoke.