Powershell functions for DOS

This is not production ready code! This is currently for us to use in our developer machines.

These are Powershell functions that wrap the REST APIs of MDS and v2 engine. In addition there are functions that do some of the common developer tasks like showing permissions, logs, fixing discovery service url etc.

To bring up the main menu, just open PowerShell and paste:

Invoke-WebRequest -useb https://raw.githubusercontent.com/HealthCatalyst/dos.powershell/release/runengine.ps1 | Invoke-Expression;

This uses a library of functions that automate some parts of DOS. You can pull in the library only by pasting:

Invoke-WebRequest -useb https://raw.githubusercontent.com/HealthCatalyst/dos.powershell/release/doslibrary.ps1 | Invoke-Expression;

Here's some of the functions available in this Powershell library:

1. List all datamarts on your system: listdatamarts
2. List all batch definitions in your system: listBatchDefinitions
3. Get ID of DataMart by Name: getdataMartIDbyName
4. Create a batch definition for a datamart: createBatchDefinitionForDataMart
5. Get last batch execution for a datamart: getLastBatchExecutionForDatamart
6. Run a normal batch: executeBatch
7. Run a streaming batch: executeBatchAsStreaming
8. Run and wait for a datamart: runAndWaitForDatamart
9. Chain SAM runs. Call runAndWaitForDatamart for first SAM, then call runAndWaitForDatamart for second SAM etc etc
10. Cancel a batch: cancelBatch
11. Execute a JSON based datamart: executeJsonDataMart
12. Download the json for a data mart: downloaddataMartIDbyName

Other helpful developer stuff:

1. Show discovery service urls: showDiscoveryServiceUrls
2. Show user permissions: showDiscoveryServiceUrls
3. set ETLObjectAttributeBASE: setETLObjectAttribute
4. Show websites installed on my machine: listWebSites

Not completely working yet that you can feel free to make work:

1. Deploy a dacpac: DeployDACPAC
2. Download latest build from VSO: downloadArtifactFromLatestBuild

Feel free to just check in additional helpful stuff for developers.

Contributing

Branch and do your changes. Submit a pull request to master when ready.