Specify a database to store SAML data

Follow these steps to specify a database different from the default database for the Genero SAML implementation.

The Genero SAML implementation requires a database to store SAML data. By default, the database engine is SQLite, and the database file is $FGLDIR/web_utilities/services/saml/bin/saml.db.

  1. Create or identify the database to use for storing SAML data.

    A dedicated machine is recommended. If multiple Genero Application Server/JGAS instances are configured for load balancing, they must share a single database to centralize all SAML authentication data.

  2. Modify the DBase.4gl file to configure the database connection.

    Edit the BDConnect() and DBDisconnect() functions to handle the connection logic, then recompile DBase.4gl. The file is located in $FGLDIR/web_utilities/services/saml/src.

  3. Update the fglprofile file with the new database connection information.

    The fglprofile file is located in $FGLDIR/web_utilities/services/saml/res.

  4. Create the required SAML tables in the database.

    Run the CreateDatabase.4gl program from $FGLDIR/web_utilities/services/saml/src. Ensure the GAS/JGAS user has the database permissions required to modify SAML tables.

  5. Set environment variables if required to allow the Genero SAML service to load database client libraries.

    Define PATH (Windows®) or LD_LIBRARY_PATH (Linux®/UNIX™) in $FGLDIR/web_utilities/services/SAMLServiceProvider.xcf using ENVIRONMENT_VARIABLE elements.

    Note:

    If you use SQLite (the default), you do not need to set the path to any library because it is integrated into the ODI driver on most systems.

    The alternate database is now used for the Genero SAML implementation.