Summary

This document describes how to setup and configure a Meridix installation targeting a Zylinc system.

Meridix applications

Meridix web UI – MXWU

A Microsoft .NET 4.5.2 ASP.NET IIS hosted web application. Is installed and updated with a WebDeploy package.
This application will use the Zylinc Stat DB as the data source for statistics data and will therefor need to be able to access a couple of stored procedures (spmeridix_*) to get the data directly from the Stat DB.
It also make use of a dedicated system database that manages Meridix logins, saved reports etc. and will preferably be hosted side by side with the other Zylinc databases (in the same MSSQL instance) but can also be hosted on a different MSSQL instance if desirable.

Meridix backend service – MXBS

A Microsoft .NET 4.5 Windows service application that handles all scheduled tasks such as report distributions, maintenance, cache population etc.
Same database access requirements against the Zylinc database as MXWU.
Is installed and updated with a MSI package.

Meridix Zylinc catalog synchronization client – MXZSC

An application that handles the synchronization of catalog data from the Zylinc database (master) to the Meridix system (slave).
The application executes SQL commands against a pair of views in the Zylinc Stat DB (meridix_queues, meridix_users, meridix_ivrs) and interprets the data and converts it to a format that can be synchronized into MWU through its HTTP Web API. This application must be scheduled to run at desired times ex: with Windows task scheduler or any other means of scheduling execution of applications.
Is installed and updated with a xcopy operation (i.e. copy the files to a folder manually).

Meridix sys database – MXSDB

This MSSQL database contains all the Meridix application specific information like logins, saved reports etc. no actual report data is stored in this database.
The database and the sql server authentication login are created manually and the schema is created/updated automatically by the application.
The user need to have db_owner rights granted.

Prerequisites

MXWU, MXBS and MXZSC needs to be installed on a Windows Server 2012 or later with .NET Framework 4.5.2 installed. Recommended minimum hardware are 4 CPU Cores and 8 GB RAM. The server need to have network access to the Microsoft SQL Server-server that host the ZyProdDB and the ZyStatDB.

MXSDB needs to be hosted on an Microsoft SQL Server 2012 or later (Express, Web, Standard or Enterprise edition). The recommended approach is to host it on the same MSSQL server as ZyProdDB and ZyStatDB. If no existing database server exist it can be installed side by side with the other Meridix applications (Not recommended for production systems).

The target ZyProdDB need to contain the views meridix_queues, meridix_agents, meridix_ivrs and meridix_users. The ZyStatDB need to have the latest version of the meridix stored procedures and functions which currently is provided through the sql file Zylinc_statdb_meridix_database_objects.sql located in the release_base folder. (This will be handled included in Zylincs main distribution in the future).

How to get the Meridix software

The latest Meridix software is available on Meridix partner SFTP server sftp://partner-share.meridix.se:22

1. Log in on sftp://partner-share.meridix.se:22 with a SFTP client using Zylincs username and password.
2. Download all content from the sub folder with the latest release date (format release_20170101) and the folder release_base and transfer it to the target server(s).

Install a new system

1. Create an empty database named meridix_sys on the MSSQL server that should host the MXSDB. Also create a SQL Server Authentication login and user with db_owner rights on the meridix_sys database.
2. Install Internet Informations Service (IIS) with the Web Server (IIS) - Role 
   1. Make sure ASP.NET 4.5/4.6 Feature is installed.
3. Install Microsoft .NET 4.5.2 or later (https://www.microsoft.com/net/download/framework)
4. Install IIS Web Deploy 3.5 or later (included in the release_base folder or http://www.iis.net/downloads/microsoft/web-deploy)
5. Create an IIS Site named Meridix (can be named differently)
6. Unzip the file VERSION_AND_DATE_meridix_studio_webdeploy_package.zip into a folder on the server called _webdeploypackage.
7. Edit the BAT file included in release_base called deploy_webpackage.bat with a text editor (e.g. Notepad++/Notepad)
   1. Replace the placeholder PATH_HERE with the full rooted path to the _webdeploypackage folder created in step 6.
   2. Replace the placeholder NAME_HERE with the IIS Site name (default: Meridix) created in step 5.
   3. Save the updated bat file.

Upgrade an existing system

1. Create a page

• Click "Create" and select "Blank Page" to create your first page.
• New pages are created as children of the page you are currently viewing.

2. Add to your page

• Click "Edit" to enter the Confluence editor and use the page layouts feature to structure your content using sections and columns.
• Use headings to format your text and drag and drop images into your page to provide visual interest.
• Click "Insert" and select "Other Macros" to add macros for navigation, special formatting and other media.