BlueCielo Meridian Enterprise 2012 Administrator's Guide | BlueCielo ECM Solutions

Creating a repository

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

Before you begin

To use the BlueCielo Meridian Enterprise Database Wizard wizard, 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 the Meridian Enterprise 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 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 database on the database server:

  1. Open BlueCielo Application Manager  from the Windows Start menu. The BlueCielo Application Manager console appears.
  2. Expand BlueCielo Meridian Enterprise 2012 and select Repositories. The existing repository definitions appear in the right pane.
  3. In the right pane, click the New Repository button . The New Repository dialog box appears.
  4. Type a name for the repository in Name.
  5. Select a database option for Provider.
  6. Click Start the database wizard. The BlueCielo Meridian Enterprise Database Wizard appears.
  7. Read and confirm that you have met the database connection prerequisites.
  8. Confirm that the database server meets the requirements for the FILESTREAM option or clear the option.

Note    This option requires that the Windows authentication option be used to access the database server in the following steps.

  1. Click Next. The database connection options appear.
  2. Click options or type values using the descriptions in the following table.
Database connection options
Option Description

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 creates a default named instance when the software is installed, type the name of the database server and the SQL Server instance name, for example, MyServer\SQLEXPRESS or MyServer\MSSMLBIZ.

If you selected SQL Server in the Provider option in step 1, select your preference for Windows authentication or SQL Server authentication.

SID (Oracle only)

Type the name of the Oracle instance that will host the repository.

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 (SQL Server only)

Select an existing empty database where you want to store the repository or type the name of a new database for the repository.

  1. Click the Test connection button to test the current settings. The results will appear next to the button. If the test fails, correct the options that you selected in step 2 and retest.
  2. When the test succeeds, click Next. A summary of the current options appears.
  1. Confirm the database creation settings are correct and click Finish. The status of the database creation process is displayed until it is finished.
  2. Click Close. The resulting database provider and connection string appear in the corresponding options of the Edit Repository Connection dialog.
  3. Click OK. A new branch appears below Repositories with the name of the repository that you created.

 

After creating a repository and before vault synchronization with the repository can occur, at least one publishing job must be configured as described in About publishing jobs. Additional jobs for the same vault may be required to update the content index or to render thumbnail images.

Related tasks

Synchronizing a repository

Viewing synchronization status


Copyright © 2000-2012 BlueCielo ECM Solutions

www.bluecieloecm.com