P

2 Messages

 • 

905 Points

Tuesday, October 22nd, 2024 9:08 AM

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

5 Messages

 • 

100 Points

11 days 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

2 Messages

 • 

905 Points

Thanks a lot for both of you. @adamstanczak , I got the ID created by the admin and created connection, its working now. Thanks

I am trying to understand what should come under objects and Source configuration here. 

In objects as per your comment above I can take list of all taskflows, do we need anything else here? Could you please share the format for the same?

In Source Configuration, I am assuming it should same like PowerCenter where we prepare the JSON format properties to be used in Capability?

Thanks

Prerna

88 Messages

 • 

2.8K Points

25 days 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!

Loading...