Create, upgrade and validate a metadata repository

Available Sub Commands

create

Create a new metadata repository

Create Arguments

Argument

Description

-h [ --help ]

Display this message

--tdpid arg

Teradata only. The TDPID value to use when creating default connections.

--tns arg

Oracle only. The TNS name to use when creating default connections.

Metadata Repository Login Arguments

Argument

Description

--meta-dsn arg

ODBC DSN of the metadata repository

--meta-dsn-arch arg (=32)

The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified.

--meta-user-name arg

Username for the ODBC DSN

--meta-password arg

Password for the ODBC DSN

--meta-database arg

Database used by the ODBC DSN

--td-wallet

The supplied password will be treated as a TDWallet string

--dimension-space arg

A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2).

--index-space arg

A named area of the RDBMS to store the metadata (DB2 only).

--meta-space arg

A named area of the RDBMS to store the metadata.

--meta-index-space arg

A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL).

--meta-con-string arg

ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$.

--red-profile arg

Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use.

exists

Check whether or not a metadata repository exists

Exists Arguments

Argument

Description

-h [ --help ]

Display this message

Metadata Repository Login Arguments

Argument

Description

--meta-dsn arg

ODBC DSN of the metadata repository

--meta-dsn-arch arg (=32)

The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified.

--meta-user-name arg

Username for the ODBC DSN

--meta-password arg

Password for the ODBC DSN

--meta-database arg

Database used by the ODBC DSN

--td-wallet

The supplied password will be treated as a TDWallet string

--dimension-space arg

A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2).

--index-space arg

A named area of the RDBMS to store the metadata (DB2 only).

--meta-space arg

A named area of the RDBMS to store the metadata.

--meta-index-space arg

A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL).

--meta-con-string arg

ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$.

--red-profile arg

Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use.

meta-version

Retrieve the version of the metadata stored within a repository

Meta Version Arguments

Argument

Description

--from-disk

If supplied, the meta version that's contained in the meta info on disk will be returned, otherwise the version is read from the meta repository identified by the DSN supplied.

-h [ --help ]

Display this message

Metadata Repository Login Arguments

Argument

Description

--meta-dsn arg

ODBC DSN of the metadata repository

--meta-dsn-arch arg (=32)

The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified.

--meta-user-name arg

Username for the ODBC DSN

--meta-password arg

Password for the ODBC DSN

--meta-database arg

Database used by the ODBC DSN

--td-wallet

The supplied password will be treated as a TDWallet string

--dimension-space arg

A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2).

--index-space arg

A named area of the RDBMS to store the metadata (DB2 only).

--meta-space arg

A named area of the RDBMS to store the metadata.

--meta-index-space arg

A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL).

--meta-con-string arg

ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$.

--red-profile arg

Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use.

upgrade

Upgrade an existing metadata repository

Upgrade Arguments

Argument

Description

-h [ --help ]

Display this message

--input-file arg

If an input file is not supplied, the validate sub-command will be run prior to running the upgrade sub-command. If an input file is supplied, its content will be loaded and used as the validate state from which to base the upgrade. It is expected that this file was created from prior use of the validate sub-command.

--rebuild-indexes

Rebuild the indexes of all metadata repository tables. Used by all supported RDBMS platforms except Teradata.

--install-templates

Install the supplied template applications as part of the upgrade. SQL Server, Oracle and Teradata.

--reload-function-sets

If there's an error during function set validation then reload all function sets from the standard sets.

--recompile-meta-procedures

Recompile all metadata procedures as part of the upgrade. Applicable for all metadata repository types.

--recompile-non-meta-procedures

Recompile all invalid non-metadata procedures as part of the upgrade. Oracle only.

--recreate-views

Recreate all views as part of the upgrade. Teradata only.

Metadata Repository Login Arguments

Argument

Description

--meta-dsn arg

ODBC DSN of the metadata repository

--meta-dsn-arch arg (=32)

The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified.

--meta-user-name arg

Username for the ODBC DSN

--meta-password arg

Password for the ODBC DSN

--meta-database arg

Database used by the ODBC DSN

--td-wallet

The supplied password will be treated as a TDWallet string

--dimension-space arg

A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2).

--index-space arg

A named area of the RDBMS to store the metadata (DB2 only).

--meta-space arg

A named area of the RDBMS to store the metadata.

--meta-index-space arg

A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL).

--meta-con-string arg

ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$.

--red-profile arg

Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use.

validate

Validate an existing metadata repository

Validate Arguments

Argument

Description

-h [ --help ]

Display this message

--output-file arg

If supplied, the output of the validate will be written into this file. Subsequently, the upgrade sub-command will accept this file as an argument.

Metadata Repository Login Arguments

Argument

Description

--meta-dsn arg

ODBC DSN of the metadata repository

--meta-dsn-arch arg (=32)

The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified.

--meta-user-name arg

Username for the ODBC DSN

--meta-password arg

Password for the ODBC DSN

--meta-database arg

Database used by the ODBC DSN

--td-wallet

The supplied password will be treated as a TDWallet string

--dimension-space arg

A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2).

--index-space arg

A named area of the RDBMS to store the metadata (DB2 only).

--meta-space arg

A named area of the RDBMS to store the metadata.

--meta-index-space arg

A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL).

--meta-con-string arg

ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$.

--red-profile arg

Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use.

Repository Arguments

Argument

Description

-h [ --help]Displays This message

Common Arguments