WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Creating objects to organize your work

You organize the tables, views, indexes, and stored procedures that you create in different containers within Classic Data Architect.

Show me!

About this task

Workspaces
When you first open Classic Data Architect, you create a workspace that will contain your work. All users who work in Classic Data Architect have their own workspaces and their own projects within those workspaces. Within a workspace, there are two types of objects that you must create: data design projects and physical data models.
Data design projects
Within a project, you design the tables and views that you eventually will create in the metadata catalog on the data server. The type of project that you create in Classic Data Architect is called a data design project. You can create any number of data design projects, using them to organize your physical data models, or you can put all of your physical data models into one project.
Physical data models
A physical data model is a collection of schemas that contain the tables that you create to map to the data in your data sources. Schemas can also contain views on those tables and stored procedures that you might want to use to perform operations on the result sets for queries. Instead of creating your tables directly in the metadata catalog on the data server and modifying them there, you create and modify your tables in the model and then promote them to a metadata catalog.
For example, you might have one data server for a test environment and another for a production environment. In a model, you can create a table and then run the DDL to create the table in the test data server to test the table. If you need to modify the table, you can drop the table from the metadata catalog in the test data server, modify the table in Classic Data Architect, then re-create the table in the metadata catalog and test it again. When you have a version of the table that you want to put into production, you can create the table in the production data server.

Procedure

To set up a work environment:

  1. Create a data design project. Open the New Data Design Project wizard by selecting File > New > Data Design Project from the menu bar at the top of Classic Data Architect. The data design project appears in the Data Project Explorer.
  2. Create a physical data model with the database type "Classic Integration." Open the New Physical Data Model wizard by right-clicking the data design project folder and selecting New > Physical Data Model. A new physical data model appears in the Data Models folder of your project. Close the Diagram1 tab because diagramming is a function in Eclipse but not a function in Classic Data Architect.
Related tasks
Configuring Classic Data Architect


Feedback

Update icon Last updated: 2007-10-09