This site requires JavaScript to be enabled
Welcome Guest|
Recent searches
IE BUMPER

(Stonebranch) Learning Stonebranch: Sample Exercises

Number of views : 15
Article Number : KB0017451
Published on : 2021-01-07
Last modified : 2021-01-07 18:12:41
Knowledge Base : IT Public Self Help

Interested in becoming more familiar with Stonebranch? Here are some sample exercises you can try, in order of increasing complexity.

(To suggest more exercise ideas, email us at: workloadautomation-stewards@utlists.utexas.edu)

Exercise 1: Alert When A File Arrives

Goal: Send yourself an email when a file arrives on a file server.

Requirements:

  • An agent
  • A file transfer server (transfer.its, or JScape) and credentials for that file server
  • An email account

Types of Stonebranch objects involved:

Guide:

  1. Confirm outside of Stonebranch that you can reach your file transfer server (transfer.its or JScape) via SFTP. The SFTP bash utility is a good way to do this.
  2. Create an email task and fill in the required fields. This will be your email alert. Use the SHARED_EMC_default email connection for outgoing mail.
  3. Test the email task and make sure that you can receive the email alert.
  4. Create a credential object in Stonebranch with your SFTP credentials (remember that Stonebranch objects start with your six-character business area code followed by an underscore and CRD, like so: "EIS103_CRD_<nameofcredential>").
  5. We'll check for this file on the transfer server from a different location via the SFTP protocol. Create an FTP file monitor and fill out the required fields.
  6. Run this object on any agent that you have access to (a PyPE agent will work just fine).
  7. With the file monitor running, upload a test file to the transfer server. You should receive an email.

Exercise 2: Bundle A Set Of Variables And Promote Them To Qual/Prod 

Goal: Create a set of variables in Dev, bundle them, and send them to Qual and Prod

Requirements:

  • An agent, and credentials for that agent

Types of Stonebranch objects involved:

Exercise 3: Process A File With Multiple Steps

Goal: Process a file with multiple steps at regular intervals, and send yourself the output. Use a Workflow.

Requirements:

  • An agent, and credentials for that agent
  • A test file with some data to be modified
  • At least two scripts that modify data in your test file

Types of Stonebranch objects involved:

Exercise 4: Run A Task Via The Web API

Goal: Instead of starting a task from the controller interface or time/cron trigger, start a task using the web API.

Note: ITS-MCA supports a Python library for interacting with the Stonebranch Web API: https://github.austin.utexas.edu/eis1-mca/ut-stonebranch-rest

Requirements:

  • An agent, and credentials for that agent
  • A task

Types of Stonebranch objects involved:

Exercise 5: Query a SQL Database

Goal: Execute a query against an SQL database

Requirements:

  • An agent, and credentials for that agent
  • A SQL Database

Types of Stonebranch objects involved:

Exercise 6: Run A Mainframe Job And Send The Output Elsewhere

Goal: Execute a Natural Job on the Mainframe and receive output

Note: There are two different ways to do this, each with pros and cons.

Requirements:

  • An agent, and credentials for that agent
  • A mainframe job
  • A file transfer server (transfer.its, or JScape) and credentials for that file server

Types of Stonebranch objects involved:

Recommended reading:

Exercise 7: Run An Agent In A Docker Container

Goal: Run an agent in a container on your local machine, and send it jobs from the controller

Requirements:

  • The Docker desktop application
  • A Docker image with an agent inside (available here)
  • A task

Types of Stonebranch objects involved:

 

Thank You! Your feedback has been submitted.

Feedback