Configuring the Datastore

Top  Previous  Next

The Datastore node controls where all  JSCAPE MFT Gateway configuration settings are stored.  All configuration settings are stored in a relational database.  By default, a local H2 database is installed with JSCAPE MFT Gateway to store this information. However, you may optionally point this to any ANSI compliant relational database, like MySQL, Oracle, PostgreSQL, and Microsoft SQL Server.

 

Figure 92

 

clip092

 

 

To configure the Datastore, just click the Edit button.

 

Figure 93

 

clip093

 

 

 

JDBC URL - The JDBC URL of target database.

 

Username - The JDBC username of target database.

 

Password - The JDBC password of target database.

 

Pool size - The number of connections to keep in the connection pool for the target database.

 

Pool timeout - The amount of inactivity time before expiring a database connection from the pool.

 

Synchronize data every X seconds - Specifies how often GUI data is synchronized with the database. This is normally needed when you have two (2) or more instances of JSCAPE MFT Gateway connecting to a shared global datastore and you want to specify how often the configuration data on those servers are synchronized.

 

 

Test button - Click this to check whether settings can be stored in the database specified in the JDBC URL field

 

Migrate button - Click this button to migrate configuration settings from the current datastore to a new datastore. Before clicking this button, make sure that:

 

1.The values in the JDBC URL, Username, and Password fields have already been replaced with the settings for the new datastore, and
 
2.The new datastore is a clean database, i.e. it doesn't contain any tables

 

Save button - Click this to save all changes made to the Datastore settings

 

Cancel - Click this to cancel any changes made to the Datastore settings