IMan Database Setup

In this section, you will create the IMan database which will store the configuration settings for all integrations.

• If you do not have an SQL database:
  1. Download and install SQL Express:
     

     http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

  2. Otherwise use an existing SQL instance.
1. Open SQL Management Studio.
2. To create a database in SQL Server:
   1. Right-click database > select new database.
   2. Name it IMan.
3. Create an SQL User:
   1. Right-click Security > new > login.
   2. Set a password but ensure you disable ‘Enforce password policy’
   3. OK to close.

4. Assign the IMan user db_owner rights to the IMan database:
   1. Open the newly created user.
   2. In SQL 2012, open Membership on the left hand panel.
   3. Ensure 'db_owner' check box is set to True.

5. Open the IMan Administration Console:
   • Start > Programs > Realisable IMan > Administration Console.
     
6. Set the following fields as per the database created in step 2 of this section:
   1. Server/Instance
   2. Database
   3. Username
   4. Password

5. Press the Test to check the credentials are correct.  A message box will display the results from the connection attempt:

5. If the previous step was successful:
   1. The database is ready to be created.
   2. Press Save to create the database.
6. If the database was created successfully, press ‘Yes’ to create the sample integration jobs.

9. Press SAVE to save all the settings.