Layer 7 API Management

Expand all | Collapse all

DB relation mapping

  • 1.  DB relation mapping

    Posted 07-14-2018 08:33 AM

    Hi There,

    Could you pls share the diagram for SSG MySQL database table relation, essentially where the policy created objects, IDP, FIP info will be stored in tables.I am essentially looking to for a table where identity provides will be stored and will be retrived name of the IDP with the id/guid?



  • 2.  Re: DB relation mapping

    Posted 07-16-2018 03:48 AM

    Dear PopleysYsb ,

    I would not recommend you to retrieve info from database directly, as database schema could be changed between versions.

    You can use GMU, or restman to get the info you want.

     

    for example ,

    ./GatewayMigrationUtility.sh list  --type ID_PROVIDER_CONFIG -z <argument file>

    Regards,

    Mark



  • 3.  Re: DB relation mapping

    Posted 07-16-2018 10:01 PM

    Thanks for your response.what is the argument file, would mind elaborating it?



  • 4.  Re: DB relation mapping

    Posted 07-18-2018 07:38 AM

    The -z or --argFile argument takes GMU arguments from a property file. Read the manual for all arguments: Get Started and Run GMU - CA API Gateway - 9.3 - CA Technologies Documentation  (or just run the GMU command without any arguments to output the specific arguments for the command, e.g. './GatewayMigrationUtility.sh list')