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:
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:
When packaging schemas/databases hosted on any of the above RDBMS, the CAST Delivery Manager Tool will do as follows:
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.
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:
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.
Enter the port number on which your database runs. The default values are set as follows:
|Database||Enter the name of the database on which your required schemas are stored.|
|Credentials||Please 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.|