Hello, and welcome to this ApexSQL CI/CD toolkit web dashboard demo introduction. The ApexSQL CI/CD toolkit web dashboard is a customizable build agent with web-based user interface used for creating and executing continuous integration and delivery pipelines in SQL server. The ApexSQL CI/CD toolkit web dashboard enables users to create flexible CI and CD pipelines with highly customizable pipeline steps.
The dashboard utilizes the ApexSQL CI/CD toolkit PowerShell code, which resides under the hood via a web-based user interface and provides an easy method for database developers to build, review, document, and deploy changes for SQL server projects with full customization. Accessing the web dashboard can be done with any web browser, including the URL and the designated port on the host, where the web dashboard is installed.
After the initial login screen, which displays prompts for credentials, the dashboard will be displayed. There are five main sections of the ApexSQL CI/CD toolkit web dashboard. They include pipelines, activity, data sources, options, resources. The first section is the pipeline view. This view contains a list of the existing CI/CD pipelines for the current user with their most recent execution status.
From here, pipelines can be created, removed, or executed. Also, existing pipeline configurations can be accessed for editing. To create a new pipeline, use the Create new option. And the view for defining basic pipeline parameters like name, description, and trigger method will be shown. There are three methods available to trigger a pipeline's execution-- manually, on a new commit to the source control repository, and on a schedule with various types of scheduling settings.
It is also possible to use the Clone from existing option to use the configuration of a previously created pipeline. Once confirmed with the Create button, the main pipeline configuration view will open. This view has two major sections. The upper section displays created steps for this pipeline with their execution status and summary. The lower section contains icons for the available steps for the purpose of adding new steps.
To add a new step, simply drag and drop the desired step icon from the lower to upper section of this view. After choosing, for example, the Build step, this step configuration view will be immediately opened. Most of the available steps have designated fields for selecting data sources, adding previously created project files, and defining additional parameters. Project files are a convenient way to import a predefined set of options created and saved from an ApexSQL tool like ApexSQL Diff.
Data sources can take precedence over project files for data source information and will displace any database or credential information stored in projects. Additional options are CLI switches and values that will override any default automation behavior. For example, verbose of the toolkit and also any options that are supplied via the project file. There is an option to include output in the package. When selected, the output files, like summaries, reports, and scripts, will be included in the NuGet package.
Also, if the desired data source was not already created, a new data source can be created from the step configuration with the Add option. As an example, for the Build step, choose from the Source dropdown selection menu a data source that is the source control type for building. In the database dropdown menu, choose the destination database to build from source control. Select Include output in the package. And from the package dropdown menu, pick Package type data source.
Besides the usual set of options, some steps have more specific options. When the step is configured, save it with the OK button. And the view will switch back to the pipeline configuration view with the new step shown in the upper section. After the pipeline has been finished and all steps created, the pipeline steps can be reordered, removed, edited, or disabled. The completed pipeline can be executed manually with the Run pipeline option. While executing, every step will display its execution status and summary.
There are some additional options in the pipeline configuration view. From this point, it is possible to edit the initial properties of the pipeline. On the right, there are options-- clone from existing, remove pipeline, and run pipeline. The run pipeline option executes the pipeline manually, overriding the initial trigger settings. The next major dashboard view is the Activity view. This view contains an overview of the pipeline execution status history.
Pipelines can be easily recognized by their names. There are also options for customizing this view. The Filters option allows users to choose whether only successful or only failed executions will be displayed. View mode toggles between card and table views. The Data Sources view is a very useful feature for organizing data sources. It shows all of the defined data sources with their designated name and type.
From this view, users can edit existing or create and configure all of the data sources that are used throughout the various projects before using them in a pipeline. Options for this view are create new to add and configure a new data source, view mode to toggle the data source representation between cards and tables, and sort for sorting data sources by name or by type.
In the Create new data source view, there are several data source types available-- database, source control, SQL script, script folder, and NuGet. Data sources, once selected, can be configured. Click on the Save button and the configuration will be permanently saved as a data source and immediately available for future step configuration under the given name.
Next, main view is the options view, where users can set global options for the dashboard. It consists of three groups of options. The general Options view has the settings for the output folder path for the step execution output and the project folder path, where saved projects from ApexSQL tools are stored. Other options allow users to configure visual styles and to manage defaults.
The notification options is where the outgoing email