On this page:

This section explains how to package one or multiple live target database/schemas for subsequent analysis in the CAST Management Studio. The technologies that fall into this category are as follows:

  • Oracle PL/SQL
  • Microsoft T-SQL
  • Sybase T-SQL
  • IBM DB2 UDB

Introduction

Because of the way in which the CAST analyzers are built, the packaging mechanism (i.e. what actually gets packaged and delivered by the CAST Delivery Manager Tool) differs as explained below:

Packaging Oracle PL/SQL, Microsoft T-SQL and Sybase T-SQL databases/schemas

When packaging schemas/databases hosted on any of the above RDBMS, the CAST Delivery Manager Tool will do as follows:

Packaging IBM DB2 UDB

When packaging schemas hosted on an IBM DB2 UDB server, instead of extracting the target schemas to file, the CAST Delivery Manager Tool will only package:

No physical files are packaged and delivered. The CAST Delivery Manager Tool therefore requires network access to the target server to perform the packaging action from the CAST Delivery Manager Tool. You do NOT need to install a compatible client connection layer (for the target server) on the machine on which you are running the CAST Delivery Manager Tool. Instead, the CAST Delivery Manager Tool will use a JDBC connection to access the live target server so that you can select the schemas for analysis.

A note about what happens when the package is deployed in the CAST Management Studio

When the DB2 UDB package is deployed in the CAST Management Studio, the following is created:

When you run the analysis in the CAST Management Studio, network access to the live database to be analyzed is required, therefore the database must be available and online during the analysis process. The CAST Management Studio will no longer use the JDBC connection profile to access the target server, instead the analyzer will look for a 32bit ODBC User DSN entry referencing an alias containing the "host name" of the target server that was defined in the JDBC connection profile (configured in the CAST Delivery Manager Tool and then transferred to the CAST Management Studio). This ODBC entry needs to be created on the machine running the CAST Management Studio before the analysis is run or the snapshot is generated and will require the installation of a compatible 32bit DB2 UDB client connection layer on the same machine - this is explained in Validate and configure RDBMS connection for DB2 UDB Analysis Units.

Create and configure the package

As an example we are going to package an Oracle schema that forms the "server side" part of our Application "MEUDON", but the process is identical for all of the technologies mentioned above:

Field name
Description
Host name

Enter the internet host name (or machine name) of the machine on which the database is installed so that the CAST Delivery Manager Tool can access via a JDBC connection.

Note that when packaging DB2 UDB schemas, the contents of this field must match the name of the alias (the value "DBALIAS") defined in your ODBC connection entry on the machine where you will run the analysis from (i.e. the machine on which the CAST Management Studio is installed). For more information, please see Validate and configure RDBMS connection for DB2 UDB Analysis Units.
Port

Enter the port number on which your database runs. The default values are set as follows:

  • Oracle = 1521
  • Microsoft = 1433
  • Sybase ASE = 12500
  • DB2 UDB = 50000
DatabaseEnter the name of the database on which your required schemas are stored.
CredentialsPlease refer to Required RDBMS rights for packaging a database for more information about the user name and password you should use. You can find out more information about the Remember password option in the CAST Delivery Manager Tool help.

Note that if you intend to extract and analyze multiple schemas and you expect to be able to view inter schema links after the analysis, please ensure that all schema/databases from the same instance are included in the same CAST Delivery Manager package.