GAM Deploy Tool

GAM Deploy Tool is a tool which has multiple purposes, all of them related to the deployment of applications using GeneXus Access Manager.

The GAMDeployTool can be executed from inside Genexus (Tools > GAM > Create Deploy File) or in stand alone mode (see the Download below).

The tool is aimed at taking into production the information which needs to be updated in the GAM database.
It is not an export / import utility as it is known, but it represents a tool that has the knowledge of the GAM database structure and relations and gives the possibility to import data in a gradual way keeping the consistency of the GAM data model.

After exporting data from the GAM database, a package is obtained containing all or some of the entities which are going to be taken into the production database (which can use a different DBMS).

The end user has the ability to select the desired entities that are going to be imported into the database (Applications, Roles, Users, etc).
Although records of some table could not be present in the export package and may be present in the production database, the import process does not remove those records.

The data is not removed in general, but it is updated if neccessary (which makes the difference with the usual import / export utilites of the DBMS).

The tool does not remove relations between records, but it adds or updates relations. For example, if a role is exported with its permissions, it can happen that this role already exists in the production database. In this case if some of the permissions are not related to the role, the relation to these permissions is created, but the other relations to the permissions table of this role (which existed prior to the import) are not removed.

During the import, the hierarchy of permissions and roles is considered so as it keeps the same relation as it exists in the database from where the data was exported.

GAM Users are entities related to one or more GAM repositories and when imported, this fact is taken into consideration, see Import Users - GAM Deploy Tool for more information.

The following are the different options that can be executed using the GAMDeployTool.

  • Export data - Export data from any existing repository, see GAM Deploy Tool: Export Data
  • Import data - Import data to a new or existing repository, see GAM Deploy Tool: Import Data
  • Create GAM database - In order to create GAM database from outside GeneXus and initialize its metadata you can select "Create GAM Database" option in the first window of the GAMDeployTool wizard.
  • Update GAM schema - Update the GAM database structure.
  • Generate connection file - See GAM Deploy Tool : Creating connection.gam file

Its supports all platforms (SQL Server, Mysql, Postgresql, Oracle, DB2). The tool uses ADO to connect to the database, so you need the corresponding ADO client of the DBMS you want to connect to, in case of Iseries, the client V6R1 is required.

When executing the tool a log file (GamLog.log) is saved in the temporary directory of the user.

Download

You can download the GAMDeployTool for GAM database version 4.0.2 and lower versions from here.

See Also

GAM deploy tool command line