Version 8.4
Hi All,
We are planning to migrate from Oracle database to RDS Postgres database. Anyone has any established pattern or best practices for migrating IdentityIQ schema with few TB data to Postgres DB?
Does Sailpoint recommend any guidelines for the data migration from Oracle to Postgres for IdentityIQ?
Thanks,
Rajan
@rajan_jethva I see from 8.4 Sailpoint starts supporting PostgreSQLversion15
More if you stuck :
PostgreSQL permissions/accounts/steps? - Compass (sailpoint.com)
You are planning to just do schema migration or even data that are in those schema ?
Schema and data migrations both. Schema migration is easy because we can generate DDL from IIQ console but data migration is unexplored area.
Hello,
@vishal_kejriwal1 @rajan_jethva
were you able to achieve this ? We are trying to do that now in our dev environment. We were able to migrate the schema and the data but receiving the below error while trying to login to IIQ Console.
org.postgresql.util.PSQLException: Bad value for type long
Any idea on this ?
I think it’s more of the database thing . DBA team should be able to help .
I am doing the same kind of migration and this error happened to me. You’ll need to export the BLOB objects as large objects, and BYTEA.
If you are using Ora2Pg, try to read about the --blob_to_lo parameter during the export.
Now I am stuck in a different issue, I had to export also the CLOB types in the same way as large files, but IIQ in the Postgres schema stores all as TEXT type, but IIQ expects some as large object and some as explicit text, both using the same data type in the db. It’s being trick to identify which Oracle CLOB needs to be exported as large object.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
