How to make a Custom table.
I pulling from a oracle DB, and one of the fields has a bunch of data that I would like to break up.
__65__RES_TK_TYPE=RSA SecurID Key Fob;;__65__RES_TK_NUM_DIGITS=6;;
What I need out of this string is;
the __65__RES_TK_ASSIGNED_TO=xxxxxxx, will need to be tied back to another table that when the data is updated in the parent table this table is updated also. Is there a way of doing this.
Unfortunately, each event can only parse data into one table, regardless of the number of fields.
Although it would be possible to modify the XML such that you could parse the "__65__RES_TK_ASSIGNED_TO=xxxxxxx" or "__65__RES_TK_LAST_LOGIN=20080812135300" data to specific fields, those fields must be within the table that the rest of the MESSAGE has been assigned to.