Pragmatic Workbench

This is not the latest version of Pragmatic Workbench available.

2016.4.4 | Updated: 01 Nov 2016

Downloads:

7,525

Downloads of v 2016.4.4:

251

Software Author(s):

  • Pragmatic Works Software

Pragmatic Workbench 2016.4.4

This is not the latest version of Pragmatic Workbench available.

All Checks are Passing

2 Passing Test


Validation Testing Passed


Verification Testing Passed

Details

To install Pragmatic Workbench, run the following command from the command line or from PowerShell:

>

To upgrade Pragmatic Workbench, run the following command from the command line or from PowerShell:

>

To uninstall Pragmatic Workbench, run the following command from the command line or from PowerShell:

>

NOTE: This applies to both open source and commercial editions of Chocolatey.

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

  • Open Source or Commercial:
    • Proxy Repository - Create a proxy nuget repository on Nexus, Artifactory Pro, or a proxy Chocolatey repository on ProGet. Point your upstream to https://chocolatey.org/api/v2. Packages cache on first access automatically. Make sure your choco clients are using your proxy repository as a source and NOT the default community repository. See source command for more information.
    • You can also just download the package and push it to a repository Download

3. Enter your internal repository url

(this should look similar to https://chocolatey.org/api/v2)

4. Choose your deployment method:


choco upgrade pragmaticworksworkbench -y --source="'STEP 3 URL'" [other options]

See options you can pass to upgrade.

See best practices for scripting.

Add this to a PowerShell script or use a Batch script with tools and in places where you are calling directly to Chocolatey. If you are integrating, keep in mind enhanced exit codes.

If you do use a PowerShell script, use the following to ensure bad exit codes are shown as failures:


choco upgrade pragmaticworksworkbench -y --source="'STEP 3 URL'"
$exitCode = $LASTEXITCODE

Write-Verbose "Exit code was $exitCode"
$validExitCodes = @(0, 1605, 1614, 1641, 3010)
if ($validExitCodes -contains $exitCode) {
  Exit 0
}

Exit $exitCode

- name: Ensure pragmaticworksworkbench installed
  win_chocolatey:
    name: pragmaticworksworkbench
    state: present
    version: 2016.4.4
    source: STEP 3 URL

See docs at https://docs.ansible.com/ansible/latest/modules/win_chocolatey_module.html.

Coming early 2020! Central Managment Reporting available now! More information...


chocolatey_package 'pragmaticworksworkbench' do
  action    :install
  version  '2016.4.4'
  source   'STEP 3 URL'
end

See docs at https://docs.chef.io/resource_chocolatey_package.html.


Chocolatey::Ensure-Package
(
    Name: pragmaticworksworkbench,
    Version: 2016.4.4,
    Source: STEP 3 URL
);

Requires Otter Chocolatey Extension. See docs at https://inedo.com/den/otter/chocolatey.


cChocoPackageInstaller pragmaticworksworkbench
{
   Name     = 'pragmaticworksworkbench'
   Ensure   = 'Present'
   Version  = '2016.4.4'
   Source   = 'STEP 3 URL'
}

Requires cChoco DSC Resource. See docs at https://github.com/chocolatey/cChoco.


package { 'pragmaticworksworkbench':
  provider => 'chocolatey',
  ensure   => '2016.4.4',
  source   => 'STEP 3 URL',
}

Requires Puppet Chocolatey Provider module. See docs at https://forge.puppet.com/puppetlabs/chocolatey.


salt '*' chocolatey.install pragmaticworksworkbench version="2016.4.4" source="STEP 3 URL"

See docs at https://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.chocolatey.html.

5. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

Private CDN cached downloads available for licensed customers. Never experience 404 breakages again! Learn more...

This package was approved by moderator gep13 on 01 Nov 2016.

Description

Pragmatic Workbench

BI xPress, DBA xPress, and DOC xPress are all included in this package, our three most popular products. All of the included products come with a 14-day full featured trial or enter your product key for total access (separate download is not needed).

BI xPress

BI xPress speeds up BI development and administration by giving you the ability to quickly build packages, install robust auditing frameworks and helps DBAs deploy packages. See more about BI xPress at https://www.pragmaticworks.com/Products/Bi-xPress.

DBA xPress

DBA xPress provides next-generation SQL tools tailored for performance and ease of use when architecting or administering Microsoft SQL Server database systems of all sizes. See more about DBA xPress at https://www.pragmaticworks.com/Products/DBA-xPress.

DOC xPress

Offering complete documentation for SQL Server instances, DOC xPress also enables documentation for SSAS, SSIS and SSRS. See more about DOC xPress at https://www.pragmaticworks.com/Products/Doc-xPress.


tools\chocolateyinstall.ps1
$ErrorActionPreference = 'Stop';


$packageName= 'pragmaticworksworkbench'
$toolsDir   = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
$url        = 'http://download.pragmaticworks.com/release/2016.4/Pragmatic_Workbench_2016.4.4.1024.exe'

$packageArgs = @{
  packageName   = $packageName
  unzipLocation = $toolsDir
  fileType      = 'EXE'
  url           = $url

  silentArgs    = "/quiet /norestart"
  validExitCodes= @(0, 3010, 1641)

  softwareName  = 'Pragmatic Workbench*'
  checksum = 'CE62E601D0389A6D7A58AA57AA0AC4B1F5B24C65982AECE8F31D0BECA3BE5F21'
  checksumType = 'sha256'
  checksum64 = 'Q0U2MkU2MDFEMDM4OUE2RDdBNThBQTU3QUEwQUM0QjFGNUIyNEM2NTk4MkFFQ0U4RjMxRDBCRUNBM0JFNUYyMQ=='
  checksumType64 = 'sha256'
}

Install-ChocolateyPackage @packageArgs
tools\chocolateyuninstall.ps1
$ErrorActionPreference = 'Stop';

$packageName = 'pragmaticworksworkbench'
$softwareName = 'Pragmatic Workbench*'
$installerType = 'EXE' 

$silentArgs = '/quiet /norestart'
$validExitCodes = @(0, 3010, 1605, 1614, 1641)

$uninstalled = $false
$local_key     = 'HKCU:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*'
$machine_key   = 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\*'
$machine_key6432 = 'HKLM:\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\*'

$key = Get-ItemProperty -Path @($machine_key6432, $machine_key, $local_key) `
                        -ErrorAction SilentlyContinue `
         | ? { $_.DisplayName -like "$softwareName" }

if ($key.Count -eq 1) {
  $key | % { 
    $file = "$($_.UninstallString)"

    if ($installerType -eq 'MSI') {
      $silentArgs = "$($_.PSChildName) $silentArgs"

      $file = ''
    }

    Uninstall-ChocolateyPackage -PackageName $packageName `
                                -FileType $installerType `
                                -SilentArgs "$silentArgs" `
                                -ValidExitCodes $validExitCodes `
                                -File "$file"
  }
} elseif ($key.Count -eq 0) {
  Write-Warning "$packageName has already been uninstalled by other means."
} elseif ($key.Count -gt 1) {
  Write-Warning "$key.Count matches found!"
  Write-Warning "To prevent accidental data loss, no programs will be uninstalled."
  Write-Warning "Please alert package maintainer the following keys were matched:"
  $key | % {Write-Warning "- $_.DisplayName"}
}

Log in or click on link to see number of positives.

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Version Downloads Last Updated Status
Pragmatic Workbench 2018.2.4.503 185 Thursday, May 3, 2018 Approved
Pragmatic Workbench 2018.2.3.412-beta 184 Thursday, April 12, 2018 Exempted
Pragmatic Workbench 2018.2.2.302-beta 161 Friday, March 2, 2018 Exempted
Pragmatic Workbench 2018.1.4.208 213 Thursday, February 8, 2018 Approved
Pragmatic Workbench 2018.1.4.129-beta 181 Monday, January 29, 2018 Exempted
Pragmatic Workbench 2018.1.3.122-beta 182 Monday, January 22, 2018 Exempted
Pragmatic Workbench 2018.1.2.1206-beta 187 Wednesday, December 6, 2017 Approved
Pragmatic Workbench 2018.1.1.1030-beta 193 Monday, October 30, 2017 Approved

BI xPress version 2016.4.4

New Features

1044: Users can now apply / remove the audit framework from packages deployed to the SSIS Catalog using Workbench
  • When Audit Framework is launched from inside Workbench, users have the option of choosing the SSIS Catalog as the source for packages.
4653: Auditing Framework within Workbench now includes Warning Filtering
  • Warning filtering enables users the ability to exclude specific warnings from logging. Excluding warnings improves package execution times and lower database use. It also reduces logging clutter by only logging messages important to the user.
6758: The scan variable dependency, expression editor, and expression library are now available within SSDT for Visual Studio 2015

Updated Features

4731: Auditing Framework's package password and version selector dialog is easier to use.
  • The package password and version selector dialog now only shows the password column if it is needed.

Fixes

1402: Data Generation doesn't include a "Done" option when editing an existing data provider.
6277: An erroneous tooltip no longer appears when hovering over variables within the SSIS Monitoring Console.
6730: When reapplying the Auditing Framework, if necessary, BI xPress now correctly re-applies configuration files
6760: Within SSDT for Visual Studio 2015, the Expression Window can again edit package-level variables.
6761: Within SSDT / BIDS, the Auditing Framework's connection name no longer changes when a different database is selected.
6762: 'Video Help' link within BI xPress' package builder wizard now displays 'Product Help'
6780: Control Flow Tasks and Data Flow Components that appear jumbled or stacked while using Auto Layout can now turn off Auto Layout.
6817: Using the SSDT/BIDS Add-in/Extension and specifying a SQL Server 2016 database for use with the Auditing Framework no longer issues a warning
7358: Within SSDT for Visual Studio 2015, applying / removing the notification framework throws error attempting to find SSISAlerts.DataFile.txt file
7359: BI xPress' Auditing Framework applies the group name(s) to all groups instead of just the selected ones
7366: Variable Usage Scanner ignores selected variables when attempting scanning
7798: SSRS Database Connection dialog for Reporting Monitoring Console throws too many error messages when attempting to connect
7815: Within SSDT for Visual Studio 2015, "License Not Found" error thrown when running Package Deployment

DOC xPress version 2016.4.4

New Features

1911: Added permission requirements for snapshotting the SSIS Catalog to the documentation
1933: Tableau Provider now includes Lineage Analysis for SQL Server Data Sources
6247: Snapshot Timestamp does not update when no changes detected
  • Updated the history to show all snapshots without regard to whether the snapshot had any changes or not.
  • If no changes are detected, the view will show "All items up-to-date". Otherwise it will show the items that were updated in the solution.

Updated Features

7320: Tableau Provider now downloads and extracts additional information from Worksheets and Datasources
7829: Tableau Provider now supports Tableau Server 10.0 and Rest API Versions 2.3, 2.2 and 2.1

Fixes

6207: DOC xPress no longer issues an error when trying to add an SSIS item in some scenarios.
6230: Calculated measures missing from SSAS documentation
7335: Out of Memory errors when generating documentation

Workbench version 2016.4.4

Fixes

6009: Pragmatic Works' Error Reporting is unable to send error
6788: Upgrade older version of Workbench to latest does not install DOC xPress


This package has no dependencies.

Discussion for the Pragmatic Workbench Package

Ground Rules:

  • This discussion is only about Pragmatic Workbench and the Pragmatic Workbench package. If you have feedback for Chocolatey, please contact the Google Group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or Pragmatic Workbench, or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.
comments powered by Disqus