Version Comparison

Data Governor Online vs. Data Governor V5/Server

Feature Support Matrix

V5/Server Exclusive Task Types

The following task types are currently supported only in DG 5/Server. Please note that this doesn’t mean that they will never be supported in Online and it is worth contacting Perspective ILM if you have any queries about certain task types support.

  • Master Data Services (MDS)
  • SQL Server Integration Services (SSIS)
  • Reconciliation
  • XMLA Command
  • Similarity
  • Persist

Online Exclusive Task Types

The following task types are only supported in Data Governor Online and will not be developed for Data Governor V5/Server.

  • Hive
  • Spark
  • Azure Data Factory
  • Azure Batch
  • Shipyard HPC
  • Microsoft Genomics Service

Data Migration Version Comparison

Feature V5/Server Online
SQL Server Source & Target Supported Supported
ODBC Source Supported Supported
Flat File Source & Target Supported Supported
Azure Blob Source & Target Supported Supported
Amazon S3 Source & Target Not Supported Supported
Google Cloud Bucket Source & Target Not Supported Supported
HDFS Target Not Supported Supported
DBFS Target Not Supported Supported
Parquet File Target Not Supported Supported
Xero Source Not Supported Supported
Google & Youtube Analytics as Source Supported Supported
CRM Applications Source Supported Partially Supported *
Incremental Configuration Supported Supported
Import Indexes & Keys Supported Supported
Query as Source Supported Supported
Column Level Migrations Partially Supported ** Supported
Parallel Data Migration Partially Supported *** Supported

* Some CRM sources may not be fully supported yet, please contact Perspective if you have a question about a CRM source’s availability in DG Online.

** Can be achieved using query as source, not supported through the Migration UI.

*** Parallel Data Migration in V5/Server can only be configured at the global level as opposed to Online where it is configured per-task.

Stored Procedure Version Comparison

Feature V5/Server Online
Execution of Stored Procedures Supported Supported
Manual Input of Stored Proc Name Supported Supported
Loading of available Stored Procs Supported Supported
In/Out Parameters Supported Supported
Incremental Config Supported Not Supported

SQL Statement Version Comparison

Feature V5/Server Online
Execution of SQL Statements Supported Supported
Execution of .sql files Supported Supported
In/Out Parameters Supported Supported

OS Command Version Comparison

Feature V5/Server Online
Execution of Shell Commands Supported Supported
Piping of Standard Output & Error Supported Supported
Cross Platform Not Supported * Supported

* Data Governor V5/Server only runs on Windows based operating systems.

PowerShell Version Comparison

Feature V5/Server Online
Write & Execute Powershell in DG Supported Supported
Execution of .ps1 files Supported Supported
Script Parameters Supported Supported
Source & Target Connections Not Supported Supported
Autocompletion for params in DG Not Supported Supported
Windows Powershell Module Support Supported Partially Supported *
Powershell Core Module Support Not Supported Supported
Cross Platform Not Supported Supported

* Only works when using the Windows Powershell task type, uses PSRemoting.