Data perspective

Home

Data perspective

The Data perspective lets you access a set of relational database tools, where you can create and manipulate the database definitions for your projects.

The important views are as follows:

Data Project Explorer The main navigator view in the Data perspective showing only the data projects in the workspace. This view lets you work directly with data definitions and define relational data objects. It can hold local copies of existing data definitions imported from the DB Servers view, designs created by running DDL scripts, or new designs that you have created directly in the Workbench.
Data Source Explorer view This view provides a list of configured connection profiles. If the Show Category button is selected, you can see the list grouped into categories, for example, Databases and ODA Data Sources. Use the Data Source Explorer to connect to, navigate, and interact with resources associated with the selected connection profile. It also provides import and export capabilities to share connection profile definitions with other Workbenches.
Tasks view The Tasks view displays system-generated errors, warnings, or information associated with a resource, typically produced by builders. Tasks can also be added manually and optionally associated with a resource in the Workbench.
Navigator view The optional Navigator view provides a hierarchical view of all the resources in the Workbench. By using this view you can open files for editing or select resources for operations such as exporting. The Navigator view is essentially a file system view, showing the contents of the workspace and the directory structures used by any projects that have been created outside the workspace.
Console view The Console view shows the output of a process and allows you to provide keyboard input to a process. The console shows three different kinds of text, each in a different color: Standard output, standard error, and standard input.
SQL Results view The SQL Results view displays information about actions that are related to running SQL statements, stored procedures, and user-defined functions (UDFs), or creating database objects. For example, when you run a stored procedure on the database server, the SQL Results view displays messages, parameters, and the results of any SQL statements that are run by the stored procedure. The SQL Results view also displays results when you sample the contents of a selected table. The SQL Results view consists of a history pane and a details pane. The history pane displays the history for past queries. The details pane displays the status and results of the last run. Use the view pull-down menu to filter history results and set preferences.
SQL Builder/Editor This view shows specialized wizards for creating and editing of SQL statements.
Data Diagram Editor This view shows an Entity Relationship diagram of the selected database.

More details about using the Data perspective can be found in Chapter | 1, Developing database applications.

Data Project Explorer	The main navigator view in the Data perspective showing only the data projects in the workspace. This view lets you work directly with data definitions and define relational data objects. It can hold local copies of existing data definitions imported from the DB Servers view, designs created by running DDL scripts, or new designs that you have created directly in the Workbench.
Data Source Explorer view	This view provides a list of configured connection profiles. If the Show Category button is selected, you can see the list grouped into categories, for example, Databases and ODA Data Sources. Use the Data Source Explorer to connect to, navigate, and interact with resources associated with the selected connection profile. It also provides import and export capabilities to share connection profile definitions with other Workbenches.
Tasks view	The Tasks view displays system-generated errors, warnings, or information associated with a resource, typically produced by builders. Tasks can also be added manually and optionally associated with a resource in the Workbench.
Navigator view	The optional Navigator view provides a hierarchical view of all the resources in the Workbench. By using this view you can open files for editing or select resources for operations such as exporting. The Navigator view is essentially a file system view, showing the contents of the workspace and the directory structures used by any projects that have been created outside the workspace.
Console view	The Console view shows the output of a process and allows you to provide keyboard input to a process. The console shows three different kinds of text, each in a different color: Standard output, standard error, and standard input.
SQL Results view	The SQL Results view displays information about actions that are related to running SQL statements, stored procedures, and user-defined functions (UDFs), or creating database objects. For example, when you run a stored procedure on the database server, the SQL Results view displays messages, parameters, and the results of any SQL statements that are run by the stored procedure. The SQL Results view also displays results when you sample the contents of a selected table. The SQL Results view consists of a history pane and a details pane. The history pane displays the history for past queries. The details pane displays the status and results of the last run. Use the view pull-down menu to filter history results and set preferences.
SQL Builder/Editor	This view shows specialized wizards for creating and editing of SQL statements.
Data Diagram Editor	This view shows an Entity Relationship diagram of the selected database.