Creating a Meridian Explorer repository

You are here: BlueCielo Meridian Enterprise Administrator's Guide > About the Data Library > Creating the Data Library > Creating a repository

Creating a Meridian Explorer repository

Meridian Enterprise Server helps you to create and test a connection to a database server where you want to store the repository. You can use the wizard to create connections to SQL Server or Oracle servers.

Before you begin

You must know the name of either a Windows user account or a database account with permissions to access the database server and create database tables, indexes, and stored procedures. You also need to know the account password.

If you have sufficient privileges to create a new database on the database server, you can create a repository by performing the following task. If you have access to the database server with another account that does not have access from the Meridian Explorer server, see SQL Server database creation script or Oracle database creation script. If you do not have sufficient privileges, a database administrator will have to create the database for you.

To create a repository:

In Meridian Enterprise Server PowerUser, in the REPOSITORIES group, click Repositories. The All Repositories page appears and lists the existing repositories and Meridian Enterprise vaults.
In the app bar, click NEW. The NEW REPOSITORY dialog box appears.
Select Explorer repository and then click NEXT.
(missing or bad snippet)

Database connection options
Option	Description
GENERAL group
Repository Name	Type a name for the repository as you want it to appear to users.
Provider	Select a database provider type from the list.
Server (SQL Server only)	Type the name of the SQL Server computer that will host the repository. Note If the database server is running SQL Server Express, SQL Server Small Business, or another edition that created a named instance when the software was installed, type the name of the database server and the SQL Server instance name, for example, MyServer\SQLEXPRESS or MyServer\MSSMLBIZ.
SID (Oracle only)	Type the name of the Oracle instance that will host the repository.
AUTHENTICATION group
Type	If you selected SQL Server in the Provider option in step 1, select your preference for WINDOWS or SQL AUTHENTICATION.
User name	SQL Server only: If you selected SQL AUTHENTICATION, type a SQL Server user account with permissions to access the database server and create database tables, indexes, and stored procedures. Oracle only: Type a valid Oracle user account with permissions to access the database server and create database tables, indexes, and stored procedures.
Password	Type the password for the user account.
DATABASE group
Database (SQL Server only)	To select an existing database or to create a new database: Click EDIT. The SELECT DATABASE dialog box appears. To create a new database: On the NEW DATABASE page, click options or type values using the descriptions in the following table: To select an existing database: On the EXISTING DATABASE page, select an existing database name and click OK. The name appears in the Database field.

Click REGISTER. A background task is started and you may continue working. Creating the repository can take several minutes. After the new database is created, the new repository name appears in the Repositories list.

After creating a repository and before vault synchronization with the repository can occur, at least one synchronization job must be configured.