Clean-install Preparations

• A database server with an empty database already created - this would become the Izenda system database. Supported database servers include:

  Oracle MySQL Microsoft SQL Server

  PostgreSQL Microsoft Azure SQL Database

• An Izenda license key - email sales@izenda.com for a trial license.

Install the System Database

The first section is to input, verify and save the database connection information.

1. In browser, log in to Izenda as an Admin.

2. Click System DB & License in the left menu.

   
   

3. Select database server type from the drop-down box.

   

   All major database servers are already supported.
   

4. Click the Connection Builder icon (⚡) to help build the connection string easily.

   

   The Connection Builder.

   

   This step can be bypassed when user already knows the connection string. In this case, it can be copied and pasted straight into the Connection String box. Some connection string examples are also provided below.
   

   Example Connection Strings:

   • Oracle:

     • Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.45.37)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=user;Password=password;
     • Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.45.37)(PORT=1521))(CONNECT_DATA=(SID=xe)));User Id=user;Password=password;

   • Microsoft SQL Server:

     • Server=192.168.45.37,1433;Database=izendaconfig;User ID=user;Password=password
     • Server=HOST-PC;Database=izendaconfig;User ID=user;Password=password

   • MySQL:

     • Server=MY-PC;Port=3306;Database=izendaconfig;User ID=user;Password=password

   • PostgreSQL:

     • Server=mydomainname;Port=5432;Database=izendaconfig;User ID=user;Password=password

     Note

     • If using Izenda v3.0.0 or greater and a PostgreSQL connection string with “SslMode=Require”, the “Trust Server Certificate=true;” parameter will also need to be added.
     • Server=mydomainname;Port=5432;Database=izendaconfig;User ID=user;Password=password;SslMode=Require;Trust Server Certificate=true;

5. Click the Connect button to test database connection and all necessary permissions for Izenda to work.

   The Connection String box will be highlighted while the database is being set up for first use.

   

6. After the connection string has been verified successfully, it will be saved and user can move next to the License section.

   Note: Unless the Connection String has been verified successfully, user will not be able to perform any further action.

Validate and Store the License

  In this section user will input, validate and save the license.

1. Click the Offline/Online switch to specify the license mode.

   
   

2. Enter the license.

   • For Offline mode user needs to enter the license key and token.
   • For Online mode user needs to enter the license key.

3. Click Validate.

   Note: In Online mode, another connection will be initiated to Izenda License Server for key validation.

4. Upon successful validation, the license will be automatically saved in the database. The license details will also be displayed in the License Information section for review.

   

System Mode Settings

1. Select to use multi-tenant mode or not.

   This mode allows multiple clients on the same Izenda system.

   

2. If using multi-tenant mode, select to allow duplicated user id among different tenants or not.

Import Map Data

Optionally provision Map data. This is only needed if the report part type Map is to be used in reports and dashboards.

US zip codes match on first 5 number, and Canadian zip codes will match on the first 3 characters of the zip code.

To upgrade map data when any changes are made by Izenda please follow the instructions below. We do not automatically run these types of upgrades as map report parts will not work until the process is complete:

1. Update IzendaSystemSetting Table in your Izenda Configuration Database as below:
   

1
									2
								3

UpdateIzendaSystemSettingSetValue=0WhereName='ProvisionStaticDataStatus'

2. After making these changes, all API instances should be restarted.
3. Next you will need to log into the Izenda Application as a System Administrator and Run “Provision Map Data” on the Izenda DB & License Page to insert the new data.
   

Once this is complete, map report parts will be available again.

Modify the License

  The Database Connection and License Entry page allows modifying the license to either renew it or activate new modules.

1. In browser, log in to Izenda as an Admin.

2. Click System DB & License in the left menu.

3. Note the current license details in License Information section.

4. Click the Offline/Online switch to specify the license mode.

5. Enter the license.

   • For Offline mode user needs to enter the new license key and token.
   • For Online mode user needs to enter the new license key.

6. Click Validate.

   Note: In Online mode, another connection will be initiated to Izenda License Server for key validation.

7. Upon successful validation, the new license will be automatically saved in the database.

8. Please review the new license details in License Information section.

   

Select new System Database

Only select new system database if needed, since all current settings are not copied to the new database.

1. In browser, log in to Izenda as an Admin.

2. Click System DB & License in the left menu.

3. Use the Connection Builder to build the new connection string.

4. Click Connect.

5. Click OK in the confirmation pop-up to acknowledge that the license needs to be re-validated afterward.

   

   If there is an error with the new database connection, the current connection continues to be used. )

   

6. System will be installed to the new database.

7. Validate and store the license again.

Notifications

Email Support

Should a user have any further question, they can quickly ask for assistance via email by clicking the envelope icons (✉) in Database Connection and License sections respectively.