Skip Headers
Oracle® Health Sciences Mobile Clinical Research Associate Server Installation and Configuration Guide
Release 1.3

E38578-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Before you Begin

This section presents an overview of the Mobile Clinical Research Associate (CRA) Server requirements. It also describes the tasks that you must complete before you can install the Mobile CRA Server application. This section includes the following topics:

Starting with Mobile CRA 1.2, installing OBIEE and OCDA are optional. To install Mobile CRA without OBIEE and OCDA, you must select the Adaptive Site-at-a-Glance (ASAAG) option (see Section 1.1).

To install with OBIEE and OCDA, you can either select ASAAG or OBIEE, but not both.

1.1 Technology Stack and System Requirements

The requisite technology stack for Oracle Health Sciences Mobile CRA Server is provided in the media pack. It consists of the following products:

The following products are optional and is required only in installations that involve OCDA.

1.1.1 Other Software Requirements

The following are the software requirements:

  • Oracle Enterprise Linux 6

  • iOS 6.x and 7.0.x

  • Android 4.0.x

  • Java 1.6

1.2 Prerequisites

Before you install Mobile CRA Server:

Note:

OCDA and CTMS are not part of the Media Pack. You need to procure them separately.

1.3 Media Pack Contents

This media pack software section contains the following package:

Table 1-1 Media Pack Contents

File Name Contains

MobileCRA_Server.zip

Mobile CRA Server files

mobilecra_server\jdev\deploy\ oracle.hs.mobilecra.ear

Mobile CRA Server EAR file.

MobileCRA_Server_CDA_Adapter.zip

Mobile CRA Server CDA Adapter files

mobilecra_server/jdev/ExtDependency/deploy/ oracle.hs.mobilecra.cda.war

Mobile CRA Server CDA Adapter war file

MobileCRA_Server_CTMS_Adapter.zip

Mobile CRA Server CTMS Adapter files

mobilecra_server/jdev/ExtDependency/deploy/ oracle.hs.mobilecra.ctms.war

Mobile CRA Server CDA Adapter war file

MobileCRA_AdminUI.zip

Mobile CRA Administration UI

MobileCRA_AdminUI_v1.3.ear

Mobile CRA Admin UI ear file

MobileCRA_Server_Database.zip

Zip file containing Mobile CRA Server schema creation scripts

HSM_SchemaCreation.sql

Control script to create Mobile CRA Server Schemas (without OCDA install)

HSM_SchemaCreation_CDA.sql

Control script to create Mobile CRA Server Schemas (with OCDA install)

adapter\cda\database

Folder structure for below files:

HSMRE_1.0_Schema_ddl.sql

Control script to create schema object for Mobile CRA Server Rules Engine (MCRE) schema

HSMRE_1.0_tables_ddl.sql

Script to create table

HSMRE_1.0_synonyms_ddl.sql

Script to create synonym

HSMRE_1.0_views_ddl.sql

Script to create view

HSMRE_1.0_indexes_ddl.sql

Script to create index

HSMRE_1.0_constraints_ddl.sql

Script to create constraint

HSMRE_1.0_sequences_ddl.sql

Script to create sequence

HSMRE_1.0_comments_ddl.sql

Script to create comments

MCRA_RulesEngine_Seed.sql

Script for Rule Engine Seed data

MCRA_OBIEE_Kpi_Seed.sql

Seed data for CDA KPIs

HSMRE_1.0_ResetSeq_ddl.sql

Script for reset sequence (drop and create new sequence objects)

HSMRE_1.0_schemadrop_ddl.sql

Script to drop schema objects

HSMRE_1.0_refresh_mvw.sql

Script to create materialized view scheduler

mobile-admin\database

Folder structure for below files:

HSCTMS_1.0_Schema_ddl.sql

Control script to create schema object for Mobile CRA Server Trip Report (MCTR) schema

HSCTMS_1.0_Tables_ddl.sql

Script to create table

HSCTMS_1.0_Indexes_ddl.sql

Script to create index

HSCTMS_1.0_Constraints_ddl.sql

Script to create constraint

HSCTMS_1.0_Sequences_ddl.sql

Script to create sequence

TripReport_SeedData.sql

Script for Trip Report Seed data

HSCTMS_1.0_ResetSeq_ddl.sql

Script for reset sequence (drop and create new sequence objects)

mobilecra_xsl.dmp

Dump file for Trip Report Seed data

mobilecra_server\database

Folder structure for below files:

HSMAQ_1.0_Schema_ddl.sql

Control script to create schema object for Mobile CRA Server Advance Queue (MCAQ) schema

HSMAQ_1.0_tables_ddl.sql

Script to create table

HSMAQ_1.0_constraints_ddl.sql

Script to create constraint

HSMAQ_1.0_sequences_ddl.sql

Script to create sequence

HSMAQ_1.0_CreateQ_ddl.sql

Script to create Advance Queue (AQ)

HSMAQ_1.0_PurgeQ_ddl.sql

Script to purge AQ

HSMAQ_1.0_index_ddl.sql

Script to create index

HSMAQ_1.0_schema_ddl.sql

Control script to create schema object

HSMAQ_1.0_tables_ddl.sql

Script to create table

HSMAQ_triggers.sql

AQ triggers

HSMSV_1.0_schema_ddl.sql

Control script to create schema object for Mobile CRA Server (MCSV) schema

HSMSV_1.0_tables_ddl.sql

Script to create table

HSMSV_1.0_index_ddl.sql

Script to create index

HSMSV_1.0_constraints_ddl.sql

Script to create constraint

HSMSV_1.0_sequence_ddl.sql

Script to create sequence

HSMSV_1.0_customtypes_ddl.sql

Script to create custom types

HSMSV_1.0_comments_ddl.sql

Script to create comments

HSMSV_1.0_ResetSeq_ddl.sql

Script for reset sequence (drop and create new sequence objects)

HSMSV_1.0_schemadrop_ddl.sql

Script to drop schema objects

MobileCRA_OBIEE.zip

Zip file containing Mobile CRA Server repository and catalogs

cda\RPD\

Folder structure for below files:

MobileCRA_Server_01.rpd

Mobile CRA server repository

dummy.rpd

Dummy repository (empty), which is required for merge process

Mobile CRA Operations.catalog

Mobile CRA Server Operations catalog

Mobile CRA.catalog

Mobile CRA Server catalog (Rules Engine)

Site-At-A-Glance.catalog

Site-at-a-Glance reports

ASAAG_Server_Database.zip

Zip file containing ASAAG Server database script files

HSOSS_Create_Schema_User

Control script to create ASAAG Server Schema

HSOSS_schema_ddl

Script to create table

ASAAG_CONFIG

Script to update Configuration

ASAAG_Server.zip

ASAAG Server file

oracle.hs.oss.ear

ASAAG Server ear

TokenGeneratorService-1.0.jar

Token Generation jar file.

Config.zip

Contains config.xml

config\Config.xml

Mobile CRA Server configuration