Review My Database

Search This Blog

SQL Saturday Jax 2023 Updates

on August 22, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How To Connect to Octopus Deploy Local Instance

If you have a local instance of Octopus Deploy and need to connect for reporting purposes, you will need permission to access the SQL Server database Octopus Deploy is using. You will need read-only permissions to the table 'dbo.DeploymentHistory'. If you don't have access to the database and table, you can request it from your DBA. To test your access to your local instance, open up SQL Server Management Studio (SSMS). Enter in the server name, and select your authentication type and enter your username and password if necessary, then click 'Connect'. Once connected, you can then test querying the DeploymentHistory and RunbookHistory table. These two tables are the run history tables for Octopus Deploy. USE OctopusDeploy GO SELECT * FROM dbo.DeploymentHistory GO SELECT * FROM dbo.RunbookRunHistory GO If you have access, then you will see results from both of the tables, and you will see records below if any deployments or runbooks have been executed.

How to Connect To Your Octopus Deploy Cloud API

To start setting up your Octopus Deploy API connection you will need an API Key. First, you need to connect to your Octopus Deploy cloud instance and log into your app https://<yourapp>.octopus.app to create an API key. Once you have logged in, click on your 'Name' at the top right of the window. Next, click 'Profile'. Next, click 'My API Keys'. Next, click 'New API Key'. 'Type in your 'Purpose', I put in 'PowerBI Reporting', then click 'Generate New'. After the key is generated, be sure to copy it and keep it in a safe place. Then click 'Close'. You should now see your application listed in your 'API Keys'. Now that you have your API key, you will be able to connect to your cloud instance API. There are several ways of testing your API key. If you are familiar with the program called 'PostMan', you can use that, or if you want to, you can use the built-in 'swagger' comp...

How To Configure PowerBI Template for Octopus Deploy Cloud Reporting

Click here to download the SQL Server PowerBI Template - OctopusDeployCloud.pbt ( https://bit.ly/2ZAKLUr ) Once you have downloaded the OctopusDeployCloud template, open it up. You will see two text boxes. On the first one, enter the report history URL (https://<yoururl>.octopus.app/api/reporting/deployments/xml) . On the second enter your API key ( 'API-xxxxxxxxxxxxxx'.) . If you don't have an API Key, see my blog post on how to set one up: https://blog.reviewmydb.com/2020/06/how-to-connect-to-your-octopus-deploy.html Then click 'Load'.

Powered by Blogger

SQL Saturday Jax 2023 Updates

Comments

Post a Comment