--- title: "Zetaly Explorer - ZEX" slug: "zetaly-explorer" updated: 2023-08-04T12:56:59Z published: 2023-08-04T12:56:59Z canonical: "docs.zetaly.io/zetaly-explorer" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.zetaly.io/llms.txt > Use this file to discover all available pages before exploring further. # 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](/v1/docs/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: | Step | Description | | --- | --- | | 1 | Install the ZETALY EXPLORER on the server | | 2 | Creating database DinoDB | | 3 | DinoDB connection | | 4 | ZETALY Setup – Initialize Database | | 5 | ZETALY Explorer License | ### 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: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649665555476.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) Select the **Server** option. Installation directoryThe default directory is always “C:\Program Files (x86)\ZETALY Explorer" to avoid errors in automation scripts or in DinoMessaging service configurations because of directory changes from previous Zetaly Explorer installations 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](/v1/docs/zetaly-installer). You have to configure the config file with ZEX.* and Database.* elements. Use this following command : ```none .\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: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649665917992.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) On any interface Zetaly, you select on the Option menu, the Database Connection option: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649665945711.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649665955039.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) A panel is shown to you provide the information needed to create a connection to access the ZetalyDBdatabase: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649665999793.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) How to configure ZETALY database connection: | Field | Default Value | Description | | --- | --- | --- | | Database provider | MS-SQL Server | MS-SSL Server : Microsoft SQL Server Greenplum : PostgresSQL | | Server Name | Localhost | The Server name can be a computer name or an IP address. If the connection requires a different port address (default 1433/5432), inform the port address after server name followed by comma: 10.99.99.10\SQLEXPRES,50000 | | Authentification | Windows Authentification | Select Database authentication if you want to provide a database user and password | | User name | | If database authentication is selected, type here a valid ZETALY database user name | | Password | | If database authentication is selected, type here a valid password related to the ZETALY database user | | Database | zetalyDB | Type here the ZETALY database name to connect | When the parameters are ok and the connection has been established, the success message will be shown. ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666207368.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) ### Dino.config The configuration is saved on the Dino.Config file into the Program data directory for ZETALY Explorer (C:\ProgramData\ZETALY Explorer): ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666274799.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) The ProgramData folder is hidden by default, but you can type the address into File Manager and see and edit the Dino.Config: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666277464.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) If you prefer, you can distribute this file to your customers. The configuration file is shared by all ZETALY Explorer interfaces and utilities, so you just need do this configuration once per machine. If you remove the ZETALY Explorer application and install a new one, the configuration file is kept.  ### Connection troubleshooting If you get a message below like this: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666399780.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) #### 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: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666423108.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) #### 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 : ```none 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](https://postgresqlco.nf/doc/fr/param/listen_addresses/). ## 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: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666856984.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) After the process was completed the success message “Load database completed!!!” will be displayed. Normally when you update a ZETALY Explore version, you are required to run the DinoSetup again.   ## 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: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666951847.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D)![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666956075.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) 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. ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666976972.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666983134.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D)![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649666986989.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) 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: ![](https://cdn.document360.io/a74c9756-0e82-4b64-bffd-236c17c00cbd/Images/Documentation/image-1649667088985.png?sv=2026-02-06&spr=https&st=2026-10-26T13%3A15%3A13Z&se=2026-10-26T14%3A15%3A13Z&sr=c&sp=r&sig=Il7jxZ6zjMXrGribCpYXyhjpd4IB7koK2bxc%2FS5dGSw%3D) 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](/v1/docs/zetaly-server-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](/v1/docs/load-views).