Storage Methods for Repositories

Database Storage for Repositories

The Data storage section of a repository definition enables you to specify a storage method for the repository database. This database stores metadata for data explorations, profiles, and all objects in the Business Rule Manager (rules, tasks, custom metrics, sources, and fields). The Data storage section has two sets of controls: database file controls and database connection controls. You must use one or the other to specify a metadata storage method.

SAS Data Management Studio and SAS Data Management Server are installed with repositories that use an SQLite file for the repository database. File-based repositories are simple and reliable. They do not require a DBMS connection, and they may well suffice for testing and training. You can create new repositories in this format, as described in Adding a File-Based Repository for the Client. File-based repositories are not recommended for multi-user access, however, due to locking issues.

Sites usually create DBMS-based repositories for production systems, as described in Adding a DBMS Repository for the Client. To create a DBMS repository, you specify an ODBC DSN connection or a SAS Federation Server connection in the Data storage section of a repository definition. The following database management systems can be used for the Data storage section of a repository. For more information about creating ODBC connections in SAS Data Management Studio, see Working with Data Connections. See also Repository Usage Notes for details about some databases.

Database ODBC Driver
DB2 for Linux®, UNIX®, and Windows® Linux, UNIX, and Windows x
Informix Dynamic Server X
Microsoft SQL Server X
Oracle® X
Oracle X
PostgreSQL X
Sybase Adaptive Server X
SAS Web Infrastructure Platform Data Server (PostgreSQL)  X
Teradata X

See Supported Databases for Data Storage for information about the supported versions of these databases. Note that the following versions are among those that are supported:

 

File Storage for Repositories

The File storage section of a repository definition is used by SAS Data Management Studio only. It specifies a physical path where SAS Data Management Studio can store objects that are stored as files, such as data jobs, process jobs, queries, SAS code files (.SAS files), and Entity Resolution Output files (*.SRI files). Any file-based content can be stored in the file storage area of a repository, including your own content such as text files and graphics. You could store documentation files in a project folder, for example.

NoteNote: SAS Data Management Server ignores the File storage section of a repository definition. It puts jobs in the default location for the server or in a folder specified in the DMSERVER/JOBS_ROOT_PATH option in dmserver.cfg.

The file storage location can be any physical path that is accessible by SAS Data Management Studio. It is possible to specify a location that is remote from the SAS Data Management Studio host. However, the client might perform best when the file storage location is local to SAS Data Management Studio.

NoteNote: Use a UNC path, not a path with a mapped drive letter, to specify a file storage location that is remote from the SAS Data Management Studio host. Example: \\HostName.MyDomain.com\path.

SAS Data Management Studio is a Windows application, but it is possible to specify a UNIX location for file storage if this location is accessible to SAS Data Management Studio. The following versions of UNIX are supported: