Using Universal Connector samples


(BMC.DB2.SPE2404) 

We provide ready-made samples for your reference and convenience. The SQL Assurance Sample Folder contains configurations to get you started with the Universal Connector in your deployment tool. You can customize or copy the available sample configurations instead of configuring new YAML files for the configuration, pipeline, and workflow.

To upload the sample files to Azure DevOps

  1. In the Azure DevOps supported repository, select the directory to upload the sample.
  2. Click the vertical ellipsis () at the top-right corner and then select Upload file(s).
  3. Click Browse to locate the sample files in your local SQL Assurance Sample Folder.
  4. Click Commit to upload the files. The sample files appear in the Azure DevOps supported repository.

To configure and run the sample files in Azure DevOps

  1. Update the property key values for the sample config YAML file based on your requirements. For more information, see Creating a configuration file.
  2. Update the pipeline artifacts in the sample pipeline YAML file based on your requirements. For more information, see Configuring the Azure DevOps pipeline.
  3. Run the pipeline. For more information, see Running the pipeline and workflow and reviewing its output.

To upload the sample files to GitHub Actions

  1. On the GitHub Code tab, click the .github/workflows directory to expand it to upload sample workflow YAML files.
  2. In the upper right-hand corner of the workflow directory, click Add file.
  3. Click Upload files.
  4. In the Upload files dialog box, drag the sample workflow YAML files, from your local SQL Assurance Sample Folder into the upload files dialog box, or click choose your files to select sample workflow YAML files and click Commit changes.
  5. On the GitHub Code tab, click the config directory to expand it to upload sample config YAML files.
  6. In the upper right-hand corner of the config directory, click Add file.
  7. Click Upload files.
  8. In the Upload files dialog box, drag the sample config YAML files, from your local SQL Assurance Sample Folder into the upload files dialog box, or click choose your files to select sample config YAML files and click Commit changes.

To configure and run the sample files in GitHub Actions

  1. Update the property key values for the sample config YAML file based on your requirements. For more information, see Creating a configuration file.
  2. Update the workflow artifacts in the sample workflow YAML file based on your requirements. For more information, see Configuring the GitHub Actions workflow.
  3. Run the workflow. For more information, see Running the pipeline and workflow and reviewing its output.

To upload the sample files to GitLab CI/CD

(BMC.DB2.SPE2501)

  1. On the GitLab Project dashboard, select Code > Repository.
  2. Select the branch directory to upload the sample.
  3. Click image (2).pngnext to the branch directory and select Upload file.
  4. In the Upload new file dialog, drag the sample config YAML files, from your local SQL Assurance Sample Folder into the Upload new file dialog box, or click Upload link to locate the sample files in your local SQL Assurance Sample Folder.
  5. Click Upload file to upload the file.
    The sample files are displayed in the GitLab repository.

To configure and run the sample files in GitLab CI/CD

(BMC.DB2.SPE2501)

  1. Update the property key values for the sample config YAML file based on your requirements. For more information, see Creating a configuration file.
  2. Update the pipeline artifacts in the sample pipeline YAML file based on your requirements. For more information, see Configuring the GitLab pipeline.
  3. Run the pipeline. For more information, see Running the pipeline and workflow and reviewing its output.

Where to go from here

For the full list of values that you can use in the Universal Connector application process steps and property keys, see Example property values for all SQL Assurance steps.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*