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:
- 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.
- 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.