|
The Metadata Manager
Metadata has been called "data about data". It is simply information stored in any system that describes the underlying data in which you are using. BlueSky Integration Studio gives you the capability to store metadata objects that describe your databases and tables that you access on a regular basis. This capability makes you more efficient when developing jobs because you don't have to re-enter that information every time you create a new job. You simply import it into your job from the repository. BlueSky Integration Studio also gives you the capability to import your metadata objects directly from the database or file you want to access.
The Metadata Manager is located on the Administrator window (View->Administrator). It breaks down the metadata objects into logical groups and also gives you the ability to create new group folders within the tree.
Importing Metadata directly from the database.
You must first selected a group folder in the tree where you want the metadata objects to go. Drill down through the tree and select a group folder location. You can also create new folders by clicking the first icon on the toolbar, which is Add Folder
Click the Import From Database menu icon from the toolbar and select the provider you would like to use to connect to the data source. Then, simply walk-through the wizard to import your tables and view schema definitions.
Creating and Editing Metadata objects manually
To create a new metadata object:
Click the Create New Metadata Object icon in the toolbar and give it a name.
The metadata viewer window will popup. Enter your custom column layout information.
Click the Save button.
You can Edit any metadata object by double-clicking it in the metadata manager window.
© 2003 - 2007 Relational Solutions, Inc. - All rights reserved