Configuring the Database Server

1Integrate requires access to an Oracle, PostgreSQL(WildFly only) or SQL Server database to store configuration data such as rule and session definitions, and conformance results. This is referred to as the "1Integrate repository".

     Note: Please refer to the relevant product documentation when installing your chosen database server.

     Note: If creating a SQL Server database, follow the process through Microsoft SQL Server Management Studio (MSSMS). The name should be "1Integrate" and all other defaults should be used.

Creating a Database User

A database user is required for the 1Integrate repository.

     Note: When deploying 1Integrate to multiple servers, one database user is required per environment.

Create an Oracle Database User

To create a database user, run the following SQL*Plus commands and specify the location of the datafile (including the full file name and extension) as recommended by your Database Administrator:

Prompt:> sqlplus [your_system_user_name]/[your_password]@[tnsname]

SQL> create tablespace [repository_tablespace_name] datafile '[datafile_location]' size 10m reuse autoextend on next 10m maxsize unlimited;

SQL> create user [repository_username] identified by [repository_password] default tablespace [repository_tablespace_name];

SQL> GRANT create procedure, create sequence, create session, create table, create view, create trigger, unlimited tablespace, create type TO [repository_username];

SQL> ALTER user [repository_username] quota unlimited on [repository_tablespace_name];

Create a SQL Server Database User

  1. Create a new user following the New Login process in MSSMS.

  2. Set the login name to rsuser.

  3. Select SQL Server Authentication, set the password to rsuser and de-select Enforce Password Policy.

  4. Set the default database to 1Integrate.

  5. In User Mapping, select 1Integrate.

  6. Specify the user as rsuser and select all database role memberships except db_denydatareader and db_denydatawriter.

  7. In the MSSMS, select the root node of SQL Server and change the security authentication to SQL Server and Windows Authentication mode.

     Note: To allow the application server to log in to the database, the TCP/IP protocol must be enabled. You can enable this in the SQL Server Configuration Manager in the SQL Server Network Communication section.

Create a PostgreSQL User

Create a user with the default properties.

When creating your repository, ensure your new user is the owner of this database. This will ensure the user has all required privileges.