Registering Tables and Cubes
Problem
You want to work with
a table or a cube that is not visible in the tree view on the SAS
Data Integration Studio desktop.
Solution
Register the table or cube. To register an object means to save metadata about that object to a SAS Metadata Server. After
you register an object, its metadata is displayed in the tree view. You can then work
with that object in SAS Data Integration Studio. See Register Tables or Cubes. See also Usage Notes for Register Tables Wizards and the New Table Wizard.
Tasks
Register Tables or Cubes
Use the methods in the
following table to add metadata for tables or cubes in SAS Data Integration
Studio.
Note: The Register Table wizard
and the New Table wizard use a SAS library to access the tables that
you want to register. It is simpler if any required libraries are
registered before you run these wizards. See Registering SAS Libraries.
|
Objects to be Registered
|
Method for Specifying
Metadata
|
|---|---|
|
A set of table metadata
in Common Warehouse Metamodel (CWM) format or in a format that is
supported by a SAS Metadata Bridge.
|
Select File
 ImportMetadata from the menu bar to import
the metadata. See Working with SAS Metadata Bridges. |
|
A set of table metadata
exported from SAS Data Integration Studio as a SAS Package File.
|
Select an appropriate
destination folder in the tree view, and then select File
ImportSAS Package from the menu bar to import
the metadata. See Working with SAS Package Metadata. |
|
One or more SAS tables
or database management system tables (DBMS) tables that exist in physical
storage.
|
Select File
Register Tables from the menu bar, select the appropriate format,
and then respond to the Register Table wizard. Alternatively, right-click
the library that contains the tables to be registered, and then select Register Tables. See Registering Existing Tables with the Register Tables Wizard. |
|
A table that is specified
in a comma-delimited file or in another external file.
|
Select File
NewExternal
FileDelimited from
the menu bar, select the appropriate external file format, and then
respond to the external file wizard. See Working with External Files. |
|
A new table that is created when a SAS Data Integration Studio job is executed. Or, a new table that reuses column metadata from one or more registered
tables.
|
Select New
Table from the menu bar, and then respond to the New Table wizard. See Registering New Tables with the New Table Wizard. |
|
One or more tables that
are specified in an XML file.
|
Select File
Register Tables from the menu bar, select the XML format, and then
respond to the Register Tables wizard. For more information, administrators
should see the sections about XML in the chapters about common data
sources in the SAS Intelligence Platform: Data Administration
Guide.
|
|
A Microsoft Excel spreadsheet.
|
Select File
Register Tables from the menu bar, select the Excel or ODBC format,
and then respond to the Register Tables wizard. For more information,
administrators should see the sections about ODBC in the chapters
about common data sources in the SAS Intelligence Platform:
Data Administration Guide.
|
|
One or more tables that
exist in physical storage and that can be accessed with an Open Database
Connectivity (ODBC) driver.
|
Select File
Register Tables from the menu bar, select the ODBC format, and then
respond to the Register Tables wizard. For more information, administrators
should see the sections about ODBC in the chapters about common data
sources in the SAS Intelligence Platform: Data Administration
Guide.
|
|
A table in a format
that does not appear in your Register Tables wizard. (Your site might
not have licensed all of the formats that are available from SAS.)
|
Select File
Register Tables from the menu bar, select the Generic format, and then respond to the Register Table wizard.
The Generic format in
the Register Tables wizard uses a Generic Library to access tables.
A Generic library enables you to manually specify a SAS engine and
the options that are associated with that engine. Because it is general
by design, a Generic Library offers few hints as to what options should
be specified for a particular engine. Accordingly, a Generic Library
might be most useful to experienced SAS users. For details about the
options for a particular engine, see the SAS documentation for that
engine.
|
|
A SAS cube.
|
Select File
NewCube from the menu bar, and then respond to the New Cube
wizard.
|
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 16, 2018