2 Messages
•
905 Points
Technical lineage through IICS
Hi All,
Has anyone tried data lineage through IICS. I am trying to create a connection, but it is asking me IICS userid and password. People in my organization uses single sign on for logging to IICS. Is there any way we can do this without having password?
Looking for suggestions.
Accepted Solution
adamstanczak
5 Messages
•
100 Points
2 months ago
Hi @prernaSin,
I work with IICS lineage for about 2 years now. It is not the easiest one, but when you manage some initial configuration problems, it produces quite useful output.
As far as I know, you need internally managed user. In IICS users are managed globally, so it means all user names must be unique, iics determines by user name to which instance and branch you connect. User must be able to do exports, this feature is used by lineage to extract objects. Not iics expert, out Informatica admin created user for me, but I can check required privileges for you.
Once you can access instance, you should prepare list of objects to be exported for lineage (json). I work mostly with a list of taskflows, no need to select any detailed elements below. IICS export functionality actually grabs all dependencies for you before push to collibra lineage cloud.
My suggestion is to start with only several at once, there is timeout for extraction (can be overwritten in capability params) and also limit of objects collibra can analyze at once (hard limit, the only workaround is to create multiple connections and capabilities).
Ok, this is just for start. Let me know if I can assist you somehow more .
Adam
1
SeanPyle
92 Messages
•
3.2K Points
2 months ago
Hi @prernaSin , I haven't tried IICS in particular, but I've dealt with similar situations using other data sources. It sounds like you (or your IICS administrators) might need to create a service account that you can use to authenticate with IICS. I did this with Snowflake and had to (1) create a public key file and associate it with the service account (2) create a private key file that I added to my Collibra Edge capability to authenticate the account. (3) Create a generic Edge capability in Collibra that does not require a password add the private key as a custom property in the capability configuration details.
Again, I don't know the ins and outs of IICS, but I would start looking here first. Let me know if it turns out to help!
0
0