Creating a Metadata Repository: Linux

To create a metadata repository in Linux OS, start the RepoManager utility located in the folder with installed BI server: /opt/foresight/fp10.x-biserver/bin.

As a value of the --operation/-o parameter, specify the create-repo value. Then specify the type of the DBMS, to which connection is to be established and in which a repository is to be created. The parameter has the full name --dbms-type or short name -t, and it takes the following values:

Oracle PostgreSQL SQLite Microsoft SQL Server

Oracle parameters:

--archive-file=Path or -fPath - path to the current.rm4 file, which stores scripts for creating a repository.
--server=Server or -sServer - server name. This name should be defined in the TNS file located in the DBMS client folder.
--schema=Schema or -mSchema - name of the schema, in which a repository is to be created.
--user=Name or -uName - user name for connection.
--password=Password or -wPassword - use password for connection.

Example:

./RepoManager_start.sh -ocreate-repo -toracle -sserver -mRepository -uUser -wPassword -f/opt/foresight/fp10.x-biserver/bin/rm/current.rm4

./RepoManager_start.sh --operation=create-repo --type=oracle --server=Server --schema=Repository --user=User --password=Password --archive-file=/opt/foresight/fp10.x-biserver/bin/rm/current.rm4

PostgreSQL parameters:

--archive-file=Path or -fPath - path to the current.rm4 file, which stores scripts for creating a repository.
--server=Server or -sServer - name or IP address of DBMS server.
--database=Database or -dDatabase - database name on the server.
--user=Name or -uName - user name for connection.
--password=Password or -wPassword - user password for connection.
--schema=Schema or -mSchema - custom schema name in database. Optional parameter. If it is not set, the public schema is used by default.
--case-sensitive or -i - case sensitive database connection. When preparing PostgreSQL DMS back end, parameters should be set in upper case.

Example:

./RepoManager_start.sh -ocreate-repo -tpostgres -s10.10.10.10 -dRepository -uUser -wPassword -f/opt/foresight/fp10.x-biserver/bin/rm/current.rm4 -i

./RepoManager_start.sh --operation=create-repo --type=postgres --server=10.10.10.10 --database=Repository --user=User --password=Password --archive-file=/opt/foresight/fp10.x-biserver/bin/rm/current.rm4 --case-sensitive

There is also an alternative method for creating a repository on PostgreSQL server.

NOTE. It is recommended to use the RepoManager utility to create a repository in PostgreSQL DBMS.

SQLite parameters:

--archive-file=Path or -fPath - path to the current.rm4 file, which stores scripts for creating a repository.
--database=Path or -dPath - path to the file with SQLite DBMS

Example:

./RepoManager_start.sh -ocreate-repo -tsqlite -d/home/files/test.sqlite -f/opt/foresight/fp10.x-biserver/bin/rm/current.rm4

./RepoManager_start.sh --operation=create-repo --type=sqlite --database=/home/files/test.sqlite --archive-file=/opt/foresight/fp10.x-biserver/bin/rm/current.rm4

Microsoft SQL Server parameters:

--archive-file=Path or -fPath - path to the current.rm4 file, which stores scripts for creating a repository.
--server=Server or -sServer - name or IP address of DBMS server.
--database=Database or -dDatabase - database name on the server.
--user=Name or -uName - user name for connection.
--password=Password or -wPassword - user password for connection.
--schema=Schema or -mSchema - schema name in database. Optional parameter. If it is not set, the dbo schema is used.
--case-sensitive or -i - case sensitive database connection. Optional parameter. If it is not set, the case is not taken into account.

The example:

./RepoManager_start.sh -ocreate-repo -tmssql -sMSServer -dRepository -uUser -wPassword -f/opt/foresight/fp10.x-biserver/bin/rm/current.rm4

./RepoManager_start.sh --operation=create-repo --type=mssql --server=MSServer --database=Repository --user=User --password=Password --archive-file=/opt/foresight/fp10.x-biserver/bin/rm/current.rm4

Creating a Metadata Repository in Linux OS