Requirements

Operating System

DATPROF Subset requires:

• Microsoft Windows 7 or higher or Microsoft Windows Server 2012 or higher.

• NET Framework 4.8

• The user installing the software should have the permission to install software . 

Hardware

• CPU: x86 1GHZ or higher. 

• Memory:  at least 4GB RAM.

• Diskspace: at least 1GB.

Supported Databases

DATPROF Subset supports the following RDBMS vendors and versions:

^*_{Check the Powershell module remarks}

Oracle RDBMS

Permissions

Source Schema

Select permissions to read the data

Target Schema

If the Subset User is the TABLE_OWNER

Minimum System Privileges

• CREATE SESSION

• CREATE TABLE

• CREATE INDEX

• CREATE databaselink (or have one pre-created from the Target Schema to the Source Schema by your DBA)

Minimum Object privileges

• EXECUTE permission on dbms_random package

• EXECUTE permission on dbms_metadata package

Quota

• Unlimited tablespace

Multiple schemas

These privileges should be extended when using tables in multiple schemas.

In such a scenario, the Subset user also requires:

• to have been GRANTED the SELECT_CATALOG_ROLE

• CREATE ANY TABLE

• CREATE ANY INDEX

• DROP ANY INDEX

• DROP ANY TABLE

Subset uses the ALL_TAB_PRIVS view to get the list of objects across all selected schemas.

Sometimes it is necessary to grant select on one table in a schema to make the schema appear in Subset using the ALL_TAB_PRIVS.

If you have created your own procedure(s)/function(s), use sequences or reference views in your scripts, you should ensure that you grant the Subset user the appropriate permissions.

Microsoft Sql Server

Permissions

The user subsetting the database should have dbo permissions in the database targeted for Subsetting.

The Source database should allow for "Ad hoc distributied queries". 

If you have Views with Schemabinding ON it is not possible to run the Recreate scenario,

Powershell module dependency

To retrieve DDL information from Microsoft Sql Server, Runtime uses a Powershell module. 

Over time Microsoft has replaced the original "SQLPS" module with the "Sqlserver" module.

As of version 4.0 the SqlServer module is delivered with Subset and does not need to be installed manually.

Microsoft Powershell version 5 is required.

• Open a Powershell window on your system "as administrator"

• Check the Powershell version: $psversiontable.Psversion

• If the major version is lower then 5 upgrade your Powershell by downloading/installing "Windows Management Framework" version 5.x.
  (https://www.microsoft.com/en-us/download/details.aspx?id=54616)

Linux systems

When using Runtime on a Linux system, Powershell must be installed and also the "SqlServer" module needs to be installed manually.

For installing powershell on a Linux system see the Microsoft documentation: https://docs.microsoft.com/nl-nl/powershell/scripting/install/installing-powershell-core-on-linux.

To install the required Sqlserver module execute this:

• Open a Powershell window on your system, either as the user running Runtime or as root

• Install the module with the command: Install-Module -Name SqlServer

DB2 LUW

Requirements

To use DATPROF Subset for Linux, Unix, Windows (LUW) the following IBM software is required on the client PC: IBM DB2 Data server driver package.

After installation DATPROF Subset will use the 32bit dll’s in the subfolders netf40 or netf40_32.

Permissions

Source database

The user should have the permission to read (select) all tables to be subsetted in the source database. 

Target database

The user  should have dataaccess, createtab  permissions in the target database.

DB2 iSeries

Requirements

You should have the IBM i Access for Windows 7.1 or IBM i Access Client Solutions installed. This software is available on the IBM site.

Permissions

Source database

The user should have the permission to read (select) all tables to be subsetted in the source database.

Target database

The user  should have DBADM permissions in the target database.

DB2 for z/OS (Mainframe)

Requirements

In order to use Subset with DB2 for z/OS databases, the user must possess their own db2jcc_license_cisuz.jar file - This is the IBM Data Server for JDBC and SQLJ license file that allows access to the database through the JDBC protocol. This is a separate license that must be acquired through IBM. This file must then be placed in the Drivers sub-folder of the Subset installation folder. If this is not done, the user is greeted by the following error upon trying to test a connection to the database:

Permissions

Source database

The user should have the permission to read (select) all tables to be subsetted in the source database.

Target database

The user should have DBADM permissions in the target database.

PostgreSQL

Requirements

You should install the Postgres foreign-data wrapper (postgres_fdw) in each database that you will use as a target database. The following statement must be executed as a super user in each target database: 

CREATE EXTENSION postgres_fdw;

Permissions

Source database

The user should have the permission to read (select) all tables to be subsetted in the source database.

Target database

The user should have 'Super User' right to perform all necessary steps