Alan Baugher

Identity Suite vApp - IP & IG Deployment Model with external database (MS-SQL)

Discussion created by Alan Baugher Employee on Nov 23, 2017
Latest reply on Dec 21, 2017 by Enrique_L._Torres

Team,

 

I wanted to clarify some steps with regards to the external database for the Identity Suite vApp with regards to IP & IG deployment model.

 

We expect to see this deployment model heavily used for customer that have an urgency to kick off governance campaigns but not have any requirement or need for managed endpoints.

 

If the IP & IG model is deployed for production with an external database, there are three (3) notes that need to be reviewed.   I have collected these notes and attempted to clarify the value statement for the following items:

 

1.vApp Readme file for External Database

a) Outlines suggestive DB names for IP and IG

 

 

2.IG manual installation readme file “Manual_DB_installation.txt”

a)Defines the need for Case-Sensitive Collation for the DBs.

b)Other Collation Notes: https://support.ca.com/cadocs/0/g016411e.pdf

 

 

3.IG/IP Bookshelf(s)

a)Defines the XA requirement for both MS-SQL & Oracle (but only MS-SQL needs additional steps) for WPDS DB

b)https://docops.ca.com/ca-identity-governance/14-1/EN/release-notes/release-notes-14-1/installation-and-upgrade-considerations

c)https://docops.ca.com/ca-identity-suite/14-1/EN/upgrading/upgrading-ca-identity-suite-virtual-appliance

d)https://support.ca.com/cadocs/0/CA%20Identity%20Suite%2012%206%205-ENU/Bookshelf_Files/PDF/SIGMA_Installation_Guide.pdf

e)J2EE Datasource for IG demonstrates need for XA-datasource (see example) for WPDS DB.      XA not required for IP due to no WPDS DB

f)WPDS Database tables/stored procedures will NOT deploy to MS-SQL Database if XA Driver & Configuration is NOT enabled.   Review requirement if Workflow is required for IG use-cases.

 

 

 

Please review the enclosed attachment (PDF) and see if this has value for your lab or production deployment.

 

Note:  If you have a governance campaign of 100-1000's of applications, do not forget to engage CA Services to leverage CA AppXpress to speed up the rate of data collection from application business/technical owners.

Alan Baugher on LinkedIn: “Please stop by the Smart… 

 

 

Cheers,

 

A.

 

 

 

 

a.linkedin.com/feed/update/urn:li:activity:6336332918167793664

 

 

https://www.linkedin.com/feed/update/urn:li:activity:6336332918167793664

 

Outcomes