Integration Service Database. Installation Guide - Oracle. On-Premises

(1)

Kony MobileFabric

Integration Service Database

Installation Guide - Oracle

On-Premises

Release 6.5

Document Relevance and Accuracy

This document is considered relevant to the Release stated on this title page and the document version stated on the Revision History page. Remember to always view and download the latest document version relevant to the software release you are using.

(2)

Integration Service Database Installation Guide - Oracle

Version 2.0

August, 2015

This document contains information proprietary to Kony, Inc., is bound by the Kony license

agreements and may not be used except in the context of understanding the use and methods of Kony Inc, software without prior, express, written permission. Kony, Empowering Everywhere, Kony

MobileFabric, Kony Modeler, and Kony Visualizer are trademarks of Kony, Inc. Microsoft, the Microsoft logo, Internet Explorer, Windows, and Windows Vista are registered trademarks of

(3)

Revision History

Date

Document

Version

Description of Modifications/Release

(4)

1. Preface

Kony Platform provides an integrated approach in the mobile application design, development and management. The Platform facilitates the design and development of mobile applications in a device independent manner and delivers them in different formats that run on all the major device platforms. The Kony Platform consists of three main components:

l Kony Studio: Used to design and develop the mobile applications.

l Kony Server: Provides server side functionality for the applications, common data integration

and device support services.

l Client Runtime component for each major device platform that enables the same mobile

application to execute directly on the device.

1.1 Kony Server

The application functionality developed and generated by the Kony Studio is enabled and delivered using the Application Server. TheSMS and Mobile Web channels are hosted on the Application Server and theNative App binaries are deployed to the server, to be downloaded by the device. The Application Server has the following features:

l A sophisticated device database that enables it to detect and deliver the appropriate binary to a

requesting device.

l Inbuilt backend data services integration capability, with out-of-the-box support for Web

Services, XML feeds and HTML extraction.

l Integration with optional third party connector libraries that offer access to a large number of

ERP, database and legacy systems.

l Built in usage tracking and analysis capability that provides a wide range of reports on system

(7)

1. Preface Integration Service Database Installation Guide - Oracle

Version 2.0

Kony Database Setup Guide

This document provides the database setup instructions for Kony Database.

1.2 Purpose

The Kony Database Installation Guide – Oracle is designed specifically to provide you with complete installation instructions when installing the Oracle database.

1.3 Intended Audience

This document is intended for engineers or system administrators who are responsible for installing and deploying Kony Server and its related databases. We assume that the reader of this document is familiar with deploying software on Java application servers/Tomcat application server. The reader of this document must understand how to install the Oracle Database software on the Sun Solaris/Unix platform.

1.4 Formatting Conventions Used in this Guide

Following are the formatting conventions used throughout the document:

Conventions

Explanation

Monospace l User input text, system prompts and responses

l File Path

l Commands

l Program Code

l File Names.

Italic l Emphasis

l Names of Books and Documents

l New Terminology.

(8)

1. Preface Integration Service Database Installation Guide - Oracle Version 2.0

Conventions

Explanation

Bold l Windows l Menus l Buttons l Icons l Fields l Tabs l Folders.

URL Active link to a URL.

Note:Note Provides helpful hints or additional information.

Important: Highlights actions or information that might cause problems to

systems or data.

1.5 Contact Us

We welcome your feedback on our documentation. Write to us [email protected].

For technical questions, suggestions, comments or to report problems on Kony's product line, contact

(9)

2. Prerequisites Integration Service Database Installation Guide - Oracle

Version 2.0

2. Prerequisites

Prerequisites for installing the Kony Database for Oracle:

1. Only a qualified Oracle Database Administrator (DBA) must handle the Oracle Database setup in order to successfully complete the Kony database deployment.

2. Customer with Oracle standard edition should install Oracle Locator feature. For more information, seehttp://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_locator.htm

3. Oracle software must be installed and basic database must have been already created either using Database Configuration Assistant (DBCA) or manually with necessary tablespaces, to continue with Kony database schema setup.

4. From Kony Platform 3.1 onwards, Device DB is used only for Mobile Web. It is not required if you are planning to develop the Native Applications only.

(10)

3. System Requirements for Kony Database Setup

Version 2.0

3. System Requirements for Kony Database Setup

Below are the system requirements for Kony Database setup:

3.1 Software Requirements:

Supported Components

Requirement

Databases Oracle 11g, Oracle 12c

Operating System Any variant of Linux, IBM AIX, Sun Solaris, HP-UX

3.2 Hardware Requirements:

For Proof of Concept/Proof of Technology/Demo:

l Any physical/logical/VM machine with minimum 1 CPU (either physical/logical).

l Minimum 2 GB RAM and storage up to 100 GB.

l No need to install Kony reporting modules for POC/POT.

For Development and QA Environments:

l Any physical/logical/VM machine with minimum 1 CPU (either physical/logical).

(11)

3. System Requirements for Kony Database Setup

Version 2.0

For Production:

Minimum Requirement:

l A machine with 2 CPU

l 4 GB RAM and 250 GB Storage

Recommended:

l A machine with 4 CPU

l 8 GB RAM and 500 GB Storage

Note:Storage is upto 500 GB (for medium business systems) / 2000 GB (for large business systems) with appropriate retention policies with regular purging/data movement to DW systems.

(12)

4. Database Sizing and Configuration

Integration Service Database Installation Guide -Oracle

Version 2.0

4. Database Sizing and Configuration

The following is the sample sizing information. You could also use it for standard setups. Storage sizing for Kony Database

Storage Elements

Space Required

System Tablespace 500 MB to 1000 MB

Sysaux Tablespace 550 MB to 1000 MB

Undo Tablespace: 500 MB to 4000 MB

USERS Tablespace Upto 500 GB (for medium business systems), 2000 GB (for large business systems) and Data files each of size 2 GB. Please use n*2 GB (where n is number of data files).

Temp Tablespace 500 MB to 2000 MB

Number of redo log groups 3

Number of members in each redo log group

2

Each redolog file size 50 MB

Oracle DB software installation space required

1.4 GB to 2 GB

CRS installation space required 600 MB to 1000 MB (only for Oracle RAC)

OCR size 2 files (100 MB to 200 MB)

(13)

Version 2.0

Memory sizing for Kony Database

RAM (MB) System Global Area

max size (MB)

System Global Area target size (MB)

No. of concurrent connections (numbers)

2048 1343.2 843.2 100

4096 2686.4 1686.4 200

8192 5372.8 3372.8 400

4.1 Kony Database Sizing Details

Database Growth

Each unique user request from a device logs approximately 2 KB of data into the database. For example, if the application has 60,000 user requests from device per week, then the database grows, approximately, at the following rate:

60,000 user requests from device per week = 2 KB * 60000 = 117 MB 60,000 * 4 weeks = 468 MB (approximate)

The above data does not include session error logging. For each device error/exception 2 KB data is generated.

2 GB of database space is used for initial database setup. From then on, the database grows as per the data volume that gets populated into it. To accommodate the data volume, it is ideal to set the storage allocation at 500 GB.

4.2 Scripts for Kony Database Setup

The Database (Oracle) scripts are available at the Kony Developer Portal:

http://developer.kony.com/KonyDBScripts

(14)

Version 2.0

Navigate to the relevant database section and click on Standard Database Scripts to download the scripts -

Kony_Database_Setup_Oracle_<version>.zip

.

The Device Data scripts are available at:

http://developer.kony.com/DeviceDB

Navigate to the Oracle section and download

devicestore_build_Ora.zip.

Approximate time for Kony database setup: 2 hrs (excluding Oracle software installation).

4.3 Approach for Kony Database Setup

You need to follow the "bottom>up" approach to perform the Kony database setup. It would be performed in the following order:

1. Operating System 2. Storage

3. Clusterware (if any)

4. Database software and Database

(15)

Version 2.0

4.4 Deployment Architecture

(16)

5. Database Setup Integration Service Database Installation Guide - Oracle

Version 2.0

5. Database Setup

You can perform the database setup by executing the following scripts provided by Kony.

l konyadmin-oracle.sql

l V1__konydevicedb-oracle-master.sql(available at flyway/devicedb_oracle)

Copy these scripts at some location on the system. Here after, the location where the files are copied is referred to as

<Files_Location>

. After the execution of the scripts, spool files are created at this location. You can use the spool files to verify the smooth execution of the script files.

5.1 Configure tnsnames.ora

Copy the following code into

tnsnames.ora

the file to the path of your database environment

-$ORACLE_HOME/network/admin

.

KONYDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = xxxx)) (CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = <database-service-name>) )

)

Edit the file and configure the following information:

l HOST - Provide the database server IP or host name.

l PORT - Provide the port number configured for the database connection.

l SERVICE_NAME - Provide the

Database Name

or

ORACLE_SID

or

Database

(17)

Version 2.0

Important:KONYDB is the connection string that is used to connect to the database while executing the scripts. It is used in the following way:

conn <username>/<password>@konydb

Make sure not to change the connection string name KONYDB.

Important:The scripts contain default values for the following items. Modify these default values with your DB environment specific values using find and replace.:

users for tablespace. This is the default tablespace name. default for profile-name. This is the default profile name.

kony123 for passwords of respective schemas. This is the default password.

If you want to change the default values, modify as mentioned above with the actual values as per your database setup before running the scripts.

5.2 Set up database

Perform the following tasks to set up the database: 1. Log on to Oracle Server as Sysdba.

2. Go to the file location where the scripts are copied. $ cd <Files_Location>

3. Open the konyadmin-oracle.sql script and add the following code at line number 6. conn konyadmin/kony123@konydb

4. Save the file and execute the script in following order.

sqlplus /nolog

sql> conn /as sysdba sql> set echo on;

(18)

Version 2.0

sql> spool spool_konyadmin.log sql> @konyadmin-oracle.sql sql> spool off

5. Open the V1__konydevicedb-oracle-master.sql script and add the following code at the beginning of the script.

conn konyadmin/kony123@konydb

CREATE USER konydevicedb identified by kony123 default TABLESPACE USERS PROFILE default;

ALTER USER konydevicedb QUOTA UNLIMITED ON USERS; GRANT CONNECT, RESOURCE TO konydevicedb;

conn konydevicedb/kony123@konydb

6. Save the file and execute the script in following order.

sqlplus /nolog

sql> conn /as sysdba sql> set echo on;

sql> spool spool_konydevicedb.log

sql> @V1__konydevicedb-oracle-master.sql sql> spool off

7. Verify both the spool files.

5.3 Database Setup Complete

(19)

Version 2.0

Once you are done with all the database setup procedures, you can now proceed with the installation of Kony Server. Please follow one of the following documents to install Kony Server. Use the

document relevant to the Application Server at your end. 1. Kony MobileFabric Installation Guide - WebLogic 2. Kony MobileFabric Installation Guide - WebSphere 3. Kony MobileFabric Installation Guide - JBoss 4. Kony MobileFabric Installation Guide - Tomcat

(20)

6. Kony Admin ER Diagram Integration Service Database Installation Guide - Oracle

Version 2.0

6. Kony Admin ER Diagram

(21)

7. Kony Reports ER Diagram Integration Service Database Installation Guide - Oracle

Version 2.0

7. Kony Reports ER Diagram

Click here for more details on Kony Reports ER Diagram

Integration Service Database. Installation Guide - Oracle. On-Premises

Kony MobileFabric