KonyOne Server Prerequisites _ MS SQL Server

(1)

KonyOne Server Prerequisites _ MS

SQL Server

(2)

January, 2013

This document contains information proprietary to Kony Solutions, 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 Solutions software without prior, express, written permission. Kony, KonyOne and Empowering Everywhere are trademarks of Kony Solutions, Inc. Microsoft, the Microsoft logo, Internet Explorer, Windows and Windows Vista are registered trademarks of Microsoft Corporation. Apple, the Apple logo, iTunes, iPhone, iPad, OS X, Objective-C, Safari and Xcode are registered trademarks of Apple, Inc.. Google, the Google logo, Android and the Android logo are registered trademarks of Google, Inc. Chrome is a trademark of Google, Inc. Blackberry, Research in Motion, and RIM are registered trademarks of Research In Motion Limited. All other terms, trademarks or service marks

(3)

Revision History

Date Document Version Description of Modifications/Release

9th_{Nov 2012} _1.0 _{Initial Release}

(4)

1. Overview

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

• KonyOne Studio: Used to design and develop the mobile applications. • KonyOne Server: Provides server side functionality for the applications,

common data integration, and device support services

• Client Runtime: A component for each major device platform that enables the same mobile application to execute directly on the device.

KonyOne Server

The KonyOne Server is an important component of the KonyOne Platform

installation. The KonyOne Server acts as a gateway for KonyOne applications to access the existing services and web sites in your organization. The application functionality developed and generated by the KonyOne Studio is enabled and delivered using the Application Server. The SMS and Mobile Web channels are hosted on the Application Server and the Native App binaries are deployed to the server, which can be downloaded to the device.

The Application Server has the following features:

• A sophisticated device database which enables it to detect and deliver the appropriate binary to a requesting device.

• Inbuilt backend data services integration capability, with out-of-the-box support for Web Services, XML feeds and HTML extraction.

• Integration with optional third party connector libraries that offer access to a large number of ERP, database and legacy systems.

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

Server Installation Guide

This document describes the installation and configuration of the KonyOne Server on a Windows host operating system, using an installer.

1.1 Intended Audience

(6)

1.2 Typographical Conventions

Following are the typographical conventions used throughout the document:

Convention Explanation

Monospace

 User input text, system prompts and responses  File Path

 Commands  Program Code  File Names

Italic _ _Emphasis

 Names of Books and Documents  New Terminology Bold _ _Windows  Menus  Buttons  Icons  Fields  Tabs

URL Active link to a URL

Note: Provides helpful hints or additional information

Important! Highlights actions or information that might cause problems to systems or data

1.3 Reference Documents

1. Kony Database Setup Guide (MSSQL) 2. KonyOne Studio Installation Guide 3. KonyOne Studio User Guide

4. KonyOne Widget User Guide 5. KonyOne API Reference Guide

1.4 Contact Us

We welcome your feedback on our documentation. Write to us at

[email protected].

(7)

2. MS SQL Server Database Pre-installation Steps

The steps to follow before executing the database scripts packaged along with the Installer for KonyOne Server are mentioned below:

1. Microsoft SQL Server database version 2008 or a higher version software needs to be installed with basic setup on the intended machine (use this machine IP address while providing inputs for the JDBC installer).

(8)

3. Use SQL Server Configuration Manager and set the SQL Browser service start mode to Automatic or Manual, and then start the service.

4. In TCP/IP properties enable TCP/IP protocols for a port in both Protocol/IP addresses tab (use this port on the installer while providing inputs for the JDBC installer) of the database server to accept the database connections.

Note: The intention is to make you familiar with installer pre-requisites for MS

SQL Server.

(9)

server authentication to connect to SQL Server instance with server role as dbcreator,public. At this point of time no databases are created and installer will create necessary databases, schemas and all other objects. The created user owns all of the KonyOne databases and schemas. The user is privileged to create databases and schemas, Tables, Indexes, Views, Procedures,

Sequences, Trigger and can also provide the respective grants. For example: dbclient. Use this user while providing inputs for the JDBC installer.

(10)

(11)

(12)

3. MS SQL Server Database Post-installation Steps

To verify the successful database configuration, follow these steps:

1. Use SQL Server Management Studio to check if the deployment is successful, and to check if all objects are created successfully.

2. Run the following query:

select name FROM master.sys.databases go

3. Run the entire statement as one full query as shown below: SELECT TABLE_schema ,'TABLE', COUNT(*) FROM

[KONYDB].[INFORMATION_SCHEMA].[TABLES] group by TABLE_schema union SELECT TABLE_CATALOG ,'TABLE', COUNT(*) FROM

[KONYDEVICEDB].[INFORMATION_SCHEMA].[TABLES] where table_type='BASE TABLE' group by TABLE_CATALOG union SELECT TABLE_CATALOG ,'VIEW', COUNT(*) FROM

[KONYDEVICEDB].[INFORMATION_SCHEMA].[VIEWS] group by TABLE_CATALOG union

SELECT TABLE_CATALOG ,'TABLE', COUNT(*) FROM

[KONYUSERDB].[INFORMATION_SCHEMA].[TABLES] group by TABLE_CATALOG order by 1

(13)

KonyOne Server Prerequisites _ MS SQL Server