MSSQL or Oracle based DevOps Demo

Deploy, refresh and delete an MSSQL instance based on github actions. Used the standard Delphix Cloudshare lab environment to support a DevOps focussed demo.

Pre-Reqs

Create a New Repository

• Click the green "Use this template" button at the top of this page and select "Create a new repository"
• Name the new repo whatever you would like in your own GitHub account
• Set to private unless you want to share it, the repo doesn't need to be public to work

Configure Scripts

Update the following files with the correct addresses for your environment:

• data_ops.sh - edit Variables section at the top fo the script as noted in the file
• Add in the username and password to the api call on lines 73 and 74, using the lab login details for the Virtualisation Engine
• dxtoolkit2/dxtools.conf - Update hostname and ip_address with the public URL of your Delphic engine e.g.:
  • "hostname": "uvo1ezo6orp6mrdjwzd.vm.cld.sr",
  • "ip_address": "uvo1ezo6orp6mrdjwzd.vm.cld.sr",
• Add in the username and password

Start CloudShare Environments

Inside the Cloudshare environment run the Datasource Sqlserver > Sqlserver_start pipeline in Jenkins to ensure MSSQL environments are available, or if using Oracle sources run Datasource Orac;e > Oracle_start.

Open lab environments

Ideally you want to have the following screens prepared for the runthrough:

• A terminal with this repository checked out and up to date
• This GitHub repository in a browser on the Actions tab (customer visible)
• This page in a browser to enable copy and paste of commands (not customer visible)
• Delphix Engine management interface
• Delphix Engine self service interface
• Developer VM with DBeaver open and SQL consoles pre-configured with SQL commands for the GH DB you will create
• Optionally the SQL Server or Oracle Target VM to show the drive mount process with the Disk Management MMC

DBeaver setup

Create a new connection under SQL Server or Oracle:

• Copy and paste the Dev DB connection
• Rename to GHvDB or similar
• Update Database/Schema to: GHvDB

Right click on new GHvDB connection and SQL Editor > Open SQL Console and enter the following lines for MSSQL:

• select * from contacts; Use to show contents are available
• drop TABLE contacts; Use to delete data to show refresh works Place cursor on either line and hit CTRL+ENTER to run

For Oracle use:

• select * from ANAGRAFE ;
• DROP TABLE ANAGRAFE ;

Demo Flow

Create new branch

• git branch DevBranch && git checkout DevBranch && git commit --allow-empty -m "Created DevBranch from main" && git push --set-upstream origin DevBranch
• Go to Actions in the GitHub repository and watch workflow kickoff
• Watch dataset get provisioned in Delphix Engine
• Show the Self Service container and highlight the operations available
• Optional: Watch database appear in SQL server / DevOps server
• Optional: Delete data to simulate issue/changes via DBeaver
• Optional: Create a bookmark and share with another SS container

Edit branch

• echo `date` > changefile
• git add . && git commit -m 'Refresh branch environment' && git push
• Goto github actions and see data refresh workflow take place
• Track in Delphix Engine & Self Service portal
• Optional: Show data restored in DBeaver

Delete Branch

• In Github, optionally create and finalise a merge request, then delete the branch.
• Watch workflows, engine and sever to see cleanup occur

Cleanup local git (or just delete it and checkout again for next demo)

• git checkout main && git pull && git fetch
• Optional: show the changefile update has rolled into main (if not doing this, the cleanup section can be done post demo)
• git remote prune origin
• git branch -d DevBranch