DB relation mapping

[SHARATH YERAMALLA]

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?

[Zhijun He]

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

[SHARATH YERAMALLA]

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

[Remco Dekker]

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')