Set up a new configuration on SQL Server or Oracle

If you are setting up Ellucian Mobile for the first time, you can choose to use SQL Server or Oracle for your database. This also applies if you are upgrading from an earlier version of Ellucian Mobile and do not need to keep any previous configurations.

Procedure

  1. Create an instance of the SQL Server or Oracle database that you want to use.
  2. Define a database user with the following permissions:

    In SQL Server, the user needs to have db owner permissions.

    In Oracle (server sharing with Banner), give the user permissions as follows (where MOBILEDEV represents the username that you create):

    GRANT CREATE SESSION TO MOBILEDEV;

    GRANT BAN_DEFAULT_M TO MOBILEDEV;

    GRANT BAN_DEFAULT_Q TO MOBILEDEV;

    ALTER USER MOBILEDEV DEFAULT ROLE BAN_DEFAULT_M;

    ALTER USER MOBILEDEV DEFAULT TABLESPACE DEVELOPMENT;

    ALTER USER MOBILEDEV TEMPORARY TABLESPACE TEMP;

    GRANT CREATE TABLE TO MOBILEDEV;

    GRANT UNLIMITED TABLESPACE TO MOBILEDEV;

    GRANT CREATE SEQUENCE TO MOBILEDEV;

    In Oracle (for a server that is not sharing Banner) GRANT create procedure, create session, create table, create type, create view, create synonym, create trigger, resource to MOBILEDEV;

  3. Add the following code to your <sis>-mobileserver-config.groovy file, replacing the highlighted text with the correct values for your institution. You can also adjust the properties if necessary:

    For SQL Server

    dataSource.driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"

    dataSource.url = "jdbc:sqlserver://server:port;databaseName=mobile_server_db"

    dataSource.username = "mobiledev"

    dataSource.password = "MyPasswd99"

    dataSource.properties.maxActive = 5

    dataSource.properties.minIdle = 1

    dataSource.properties.maxIdle = 2

    dataSource.properties.maxWait = 10000

    dataSource.properties.minEvictableIdleTimeMillis=60000

    dataSource.properties.timeBetweenEvictionRunsMillis=60000

    dataSource.properties.testWhileIdle=true

    dataSource.properties.validationQuery = 'select 1'

    grails.plugin.databasemigration.updateOnStartFileNames = ['changelog-mssql.groovy']

    For Oracle

    dataSource.driverClassName = "oracle.jdbc.OracleDriver"

    dataSource.url = "jdbc:oracle:thin:@server:port:SID"

    dataSource.username = "mobiledev"

    dataSource.password = "MyPasswd99"

    dataSource.properties.maxActive = 5

    dataSource.properties.minIdle = 1

    dataSource.properties.maxIdle = 2

    dataSource.properties.maxWait = 10000

    dataSource.properties.minEvictableIdleTimeMillis=60000

    dataSource.properties.timeBetweenEvictionRunsMillis=60000

    dataSource.properties.testWhileIdle=true

    dataSource.properties.validationQuery = 'select 1 from dual'

    grails.plugin.databasemigration.updateOnStartFileNames = ['changelog-oracle.groovy']

  4. Stop and restart Tomcat to populate the database.

What to do next

Continue with Create a configuration.