Attach data Infomart 8.5 process

[efrainclg95]

Hello friends, best regards to everyone, I have a problem and I need to make an attachment to the infomart universe, I have been reviewing the Genesys documentation but it is not clear to me the procedure, for example I need to add the DNI field (number of Identification of a customer) to a customized report, how could I do it? I thank you in advance for the considerations based on your experience, the client has sip server 8.1, infomart 8.5 (default installation), Oracle database.

I remain attentive to your kind contribution, thank you

[hsujdik]

First of all, you must configure your ICON adata_spec.xml file for ICON to store the required attached data into the IDB:
https://docs.genesys.com/Documentation/ICON/latest/Dep/cfgAdata
https://docs.genesys.com/Documentation/ICON/8.1.5/Dep/AdataSpec

ICON must be restarted once you change that file.


Then, you must have the high-cardinality table for attached data created on Info Mart schema (IRF_USER_DATA_CUST_1 table). It should be created by the userdata script on Info Mart schema, if you have run it:
https://docs.genesys.com/Documentation/GIM/8.5.0/Dep/GIMUDProcessStorage
https://docs.genesys.com/Documentation/GIM/8.5.0/Dep/GIMDBScripts#scrollNav-3

After that, you must map the userdata name for a table/column on those high-cardinality Userdata tables on the CTL_UD_TO_UDE_MAPPING table of Info Mart schema:
https://docs.genesys.com/Documentation/GIM/8.5.0/Dep/GIMUDMapping

Finally, you should enable those custom fields on Genesys Interactive Insights Universe, and rename them to whatever you want to appear:
https://docs.genesys.com/Documentation/GI2/latest/UG/UsingAttachedData

(see [b]Hidden User Data Objects in GI2_Universe[/b] and [b]Using the Predefined User Data Objects[/b] topics of the link above).
The high-cardinality data are those called [b]Detail[/b] 1 to [b]Detail 16[/b]


Note that the DNI (your customer ID) is a high-cardinality value and therefore it isn't and shouldn't be aggregated upon.

You can find about the difference of high-cardinality and low-cardinality data here:
https://docs.genesys.com/Documentation/GIM/8.5.0/Dep/GIMUDProcessStorage

HTH

[efrainclg95]

Hi hsujdik

Thank you for your prompt response, I have clarified the panorama with your contribution, I was investigating and they tell me that working at the ICON level is very delicate, a bad process can bring down this component, which will be your opinion friend

[cavagnaro]

If you just follow documentation you will only need to update one file, no big mistery. Just do it as documentation states, do a backup of your xml file before if you have doubts. This is a standand procedure, no need to create panic aside normal security considerations.

[hsujdik]

Ideally, you should have HA for ICONs. That being the case, the changes would occur smoothly as long as you performed in one of the HA pair, wait a few minutes and then change the other one.

The ICONs have an HTTP interface to monitor whether they are working properly or not. I suggest that you check that. If you haven't configured an http section on the ICON options, it accepts connections from your browser on the listening port you configured for the Genesys services