Which connector can be used in the below case:
We need to connect to the AWS RDS Postgresql system , AWS aurora Postgresql from sailpoint iiq. Do we have any OOTB connector for above integration or any recommendations would be helpful.
Kind Regards,
Sai Krishna L
Hi @sai_krishna_L,
at the end is a Saas DB and you can use JDBC connector. Obviously, you need all permission to the service user you will use and the DB instance need to be reachable from IIQ.
I’ve used the default JDBC connector for Postgres in AWS, no issues doing your typical CRUD use cases.
5 Likes
Hi @sunny_tsang,
Thank you for the information.
Could you please provide me the database URL and driver path.
kind regards,
Sai Krishna L
You don’t need to download and specify a driver path when creating an application object in IIQ for Postgres. The product comes bundled with a driver that will work. When you create a new Application Type
, just select JDBC
.
In your WEB-INF/config folder, you should see a file examplerules.xml to give you an idea of what to assign for your Create, Delete, Disable, Enable actions.
You should be able to find references to these:
- JDBC Disable Provision Rule
- JDBC Delete Provision Rule
- JDBC Enable Provision Rule
Hope this helps.
3 Likes
Hi @sunny_tsang,
Thank you for the information.