Analyze Cloud configuration

Installation of Analyze in the Cloud Configuration

This product is sold as a separate license. This is a named user license.





4.0.0 or higher (PREINSTALLED!!)

A database (SQL or MONGO)

MS SQL Server Express not supported

ConnectPlaza Analyze Adapter

4.0.0 or higher

Get your database driver

Another thing you need to have before installation is the specific JDBC driver for your database. For instance if you use MS SQL, you need a MS SQL driver, if you use Oracle DB or a Progress DB you need the JDBC driver for that type of database.

Before you can use the database, you must add your driver file, a .jar file, into the following directory: <ConnectPlaza agent install directory>/jars/endorsed. You have to restart your ConnectPlaza agent before this change will be active.

Check also your database specific connection string. You will need this in the agent settings to connect to your database together with a login and password. If you do not have these, contact your local system administrator.

Database installation

Before you start working with analyze, you have to create a VOID database. A void database is a database that exists just with a name, but not with any tables inside the database. This database can be a MongoDB or a SQL database. As you download your agent you can choose a database in the selection box:

These are not the only databases Analyze can work with. Analyze uses Hibernate to connect to the database, so if there is a Hibernate Dialect for your database available, Analyze probably will work with it. The selection box gives you the most used databases.

If your database is not there, just select another one, and add your configuration for your database in the Agent Configuration tab. Select Analyze for the correct properties. Add your settings to the configuration file.

In-memory database

Per default the software installs an embedded in memory database. This hyperSQL database is very useful for small test environments. NEVER use it in a production environment. You will suffer serious memory issues if you try to use it in a production environment.

Updating the ConnectAgent

Update your ConnectAgent with the ConnectPlaza Analyze Adapter. This interface will support MongoDB as well as MySQL as of version 3.4.0.

Install the following interface into your ConnectAgent:

ConnectPlaza Analyze Adapter

  • Install this interface using your Deploy environment. Open the System interfaces, you will see the next screen:

  • Double click on the interface of your choice and and the Details screen will open.

  • Double click on the latest system interface.

  • Normally we accept the default settings. So press the Install button and install the interface. The ConnectAgent will restart automatically.

Configuration settings

On the local machine we have to configure some properties for Analyze. To do this follow the next instructions.

Open the Agent Configuration tab and select Analyze.

Check the configuration for:


Check your configuration at Override SQL core:

Now open the Agent tab and check the part Override Analyze Database Engine.

The value must be set to SQL, not mongo.

Restart your ConnectAgent.


Select in the Analyze setting the part Override Mongo Core.


Check your MongoDB settings:

Now open the Agent tab and check the part Override Analyze Database Engine.

Set the value:

Restart the ConnectAgent.

Cleaning up your database

Remember that Analyze can create a lot of entries in your database. Databases can grow very fast. You can run automatic cleanup. To do this check the following parameters:

Apply the settings in the Override Mongo Core, as they also apply to SQL databases. This will be addressed in a future version of this screen.


The first parameter is to enable the cleanup procedure

The second parameter is to setup the Quartz Cron. There are 6 entries:

  • Seconds
  • Minutes
  • Hours
  • Day
  • Month
  • Year

The last parameter is the number of hours data may remain in the database. By default, it is 720 hours = 30 days.

First look at Analyze

Login in your ConnectPlaza Dashboard. If you have sufficient rights to use analyze, the analyze tab will appear on your screen after you logged in into the dashboard.

Select the analyze tab and you can use the cloud version of Analyze.

Uninstalling Analyze

To uninstall Analyze perform the next actions.

  • Uninstall the following interfaces via Deploy:
    • ConnectPlaza Analyze Adapter (MySQL)
  • Remove the connection settings with the Agent Configuration section in Deploy.

Keep in mind that Analyze is part of your license agreement. Uninstalling does not end the agreement.