Zetaly Explorer - ZEX

ZEX last version  (April 2023, "751")

The product will not have new update.

Introduction 

The Zetaly Explorer, which runs on Microsoft Windows platform, needs a Zetaly database properly installed and configured to function correctly. This document describes how to install the Zetaly explorer. For the database creation, please, refer to persistance documentation.

Zetly Explorer need to be installed on the server side to be able to collect data from the mainframe to the database.

Zetaly Explorer client side can be installed on the end user computer. It provides the ability to query the collected data.

Requirements 

In server side, ZETALY Explorer requires: 

• Microsoft .NET Framework 5 or superior
• Network access to mainframe
• Network access to the Zetaly database

In client side, the requirements are: 

• Windows 7 or higher
• Microsoft .NET Framework 5 or superior   
• Network access to the Zetaly database

Installing the Zetaly Server

The installation of the Zetaly Explorer Server on open platform is very simple tasks resumed as: 

Windowed installation

Execute the ZetalyExplorer_vsxxx.msi program that is supplied in the ZetalyExplorer suite package. Upon successful start, some screens will be appear showing the installation instructions. The most important is: 

Select the Server option. 

After completing the installation, we can see using windows explorer program, the folders and files installed on the server.

Silent installation

Zetaly Explorer can also be installed with the Zetaly Installer tool. For more information about the Zetaly Installer, see Zetaly Installer.

You have to configure the config file with ZEX.* and Database.* elements.

Use this following command :

.\zetalyinstall.ps1 zex

At the end of the execution, there will be a log file called zex.log in the logs folder where you can see the events. 

ZetalyDB Database Connection

The most important configuration in ZETALY Explorer is the configuration of the location of the ZetalyDB database. So, the first thing any ZETALY Explorer program does is to connect to the ZetalyDB database and if you have not created a connection before you are likely to get a message error like this one: 

On any interface Zetaly, you select on the Option menu, the Database Connection option: 

A panel is shown to you provide the information needed to create a connection to access the ZetalyDBdatabase:

How to configure ZETALY database connection: 

 When the parameters are ok and the connection has been established, the success message will be shown. 

Dino.config

The configuration is saved on the Dino.Config file into the Program data directory for ZETALY Explorer (C:\ProgramData\ZETALY Explorer): 

The ProgramData folder is hidden by default, but you can type the address into File Manager and see and edit the Dino.Config: 

If you prefer, you can distribute this file to your customers. 

Connection troubleshooting

If you get a message below like this: 

MS-SQL

You should enable TCP/IP connections on the SQL Server Configuration Manager. Click in SQL Server Network Configuration -> Protocols and enable the TCP/IP and Named Pipes protocols: 

PostgreSQL

You need to authorize the access to the database. 

Go to you pgsql installation folder, and open the file "pg_hba.conf". Add a new line and authorized the server ip. For example :

host    all             all             127.0.0.1/32            scram-sha-256

If it's not enough, please, verify that the pgsql instance are listening ports. Open the "postgresql.conf" file, and check the listen_adresses parameter. For more information, read the documentation.

DinoSetup – Initialize Database

DinoSetup is a programm include in the Zetaly Explorer software.

The DinoSetup utility loads configuration data from the Configuration folder files into the ZETALY Explorer application folder. 

To Initialize the Database, just click the init button: 

After the process was completed the success message “Load database completed!!!” will be displayed. 

ZETALY Explorer License

Now, we are going to start the application for the first time. 

In order to work, ZETALY Explorer requires a license key, so the first time or when your license is expired you will experience the following message: 

Also, some options will be disabled. 

To load the product license, you must run the data loader program, do not worry about the message, simply click on the OK button. 

To load the license file, click on the Options menu ->Product license, to enter a product license registration form. 

On left screen, click on the Load button and locate a xml file license that was send by the ZETALY Explorer support team, after the license is loaded the license information appears in the right screen. 

The message informing “License file loaded successfully” is send. 

If all was executed correctly, the ZETALY Explorer Server is installed, configured and ready to be used. 

Installing Zetaly Client

To install the ZETALY EXPLORER on the workstation, run the ZetalyExplorer_vsxxx.msi setup program and select Client type installation: 

You can also execute the installation in silent mode by following the instructions in Server instalation : Running the installer in silent mode and selecting MODE=1; 

And then next, next, next and Finish button to complete ZETALY Explorer software.  

The database connection and licence need to be launched to. Please, refer to the previous items.

Zetaly Server - Mainframe connection

In order to automatically collect data from the mainframe to the database, you need to configure the server side. Please see the following article on  Mainframe connection.

Zetaly Server - Load views

Zetaly Explorer provide the ability to aggregate data. This action is called "Load Views". Please see the following article on Load Views.