Main Tasks for Administrators - SAS Data Integration Studio 3.3 User's Guide - page 63

computer. For details about entering metadata for servers, see the Help for the Server
Manager plug-in to SAS Management Console.
OLE Libraries
OLE DB is a Microsoft API for access to different data sources. An OLE library uses
the SAS/ACCESS interface for OLE DB providers. Use OLE libraries when an interface
for a specific DBMS is not available and the DBMS complies with OLE DB.
Generic Libraries
When you display the New Library wizard from the SAS Data Integration Studio
desktop, the first page of the wizard enables you to select the type of library that you
want to create. If you cannot find an exact match for the kind of data that you want to
access, you can select a Generic library.
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, the Generic library
offers few hints as to what options should be specified for a particular engine.
Accordingly, the 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.
Note: SAS has several library templates for specific data formats. The specific
library templates will often give better results than the generic template, which has not
been optimized for particular data formats. Use the templates for a specific format
whenever possible. ￿
Microsoft Excel and Microsoft Access Files
See “Supporting HTTP or FTP Access to External Files” on page 72.
XML Files
To provide access to one or more tables that are defined in an XML file, you could
create a Generic library and specify options that are appropriate for the XML LIBNAME
engine and the XML file. After the Generic library (with the XML options) is registered
in a metadata repository, SAS Data Integration Studio users can use the Generic source
designer to generate metadata for the tables that are defined in the XML file.
Libraries for Enterprise Applications
Optional data surveyor wizards can be installed in SAS Data Integration Studio that
provide access to the metadata in enterprise applications such as PeopleSoft and SAP
R/3. See the documentation for these wizards for details about any servers and libraries
that must be defined to support the wizards.
Additional Information about Libraries
The Help for SAS Data Integration Studio contains additional information about
libraries. To display the relevant Help topics, follow these steps:
1 From the SAS Data Integration Studio menu bar, select Help ￿ Contents . The
Help window displays.
2 In the left pane of the Help window, select Prerequisites ￿ Specifying
Metadata for Libraries .