Change tracking in MDM.. can we have in a file??

[former_member283645]

Hi,

i have a requirement where i need to switch on change tracking (modify/delete/add) for 5 fields in my repository.

Can i get 1 file or many which has the change log for these fields??

If yes, my requirement is to send these files to BI via PI !!!

will it be possible??

I have some pdfs which explain me to connect to visual administrator, is this the only way i can see the data!!! Cant i get in a xml or flat file??

Did somebody see a similar situation??

Could somebody throw some light!!!

Kind Regards

Eva

[former_member205403 · Accepted solution]

If yes, my requirement is to send these files to BI via PI !!! will it be possible??

Eva,

I am not sure what your business requirement is, but technically this is very much POSSIBLE . As mentioned by other members, changes are tracked using table A2i_CM_History. If your requirement is to extract change history in file format using PI then this can be easily done.

You can configure Sender PI adapter as JDBC adapter and can fire select query on A2i_CM_History table from PI to extract data. Then you can configure receiver communication channel as FILE. this way PI interface will extract change history data MDM and will create file to feed your receiver system.

Below blog will clarify things:

/people/balas.gorla/blog/2006/09/08/change-tracking-in-mdm

Another option to achieve this is using JAVA APIs.

Kindly revert if you need any more information.

-Shiv

[former_member283645 · Accepted solution]

Hi all,

The end decision was to go for a PI interface which pulls from MDM DB.

Thanks for the Replies.

Kind Regards

Eva

[junwu]

change track has standard UI in portal, where you can export those change.

[Former Member]

Hi,

Change Tracker stores all change log in a table at DB level(A2i_CM_History).

To view and download we should use standard portal iViews. In the iView on execution it shows data in grid frow where we can download change history in a Spread sheet.

Regards,

J