Topic Thread

Expand all | Collapse all

IBM ITX for EDI File conversion

  • 1.  IBM ITX for EDI File conversion

    Posted Thu February 13, 2020 11:11 AM
    ​Hi Team,

    We got a request to Mask data in the EDI (834,835 & 837) files and the Data Masking Tool that we use doesn't support EDI files directly.

    We need to Covert EDI files into CSV/Flat files and input those files as source to Data Masking Tool and Mask the data.

    Post masking, we need to use the output CSV files and convert them back to EDI files.

    To perform above said conversions, we are trying to use IBM ITX Designer with Health care packs. Wondering if anyone use ITX for similar purpose and what was the experience.

    Any lessons learned and suggestions please.



    ------------------------------
    Harshavardhan Peddireddy
    ------------------------------


  • 2.  RE: IBM ITX for EDI File conversion

    Posted Mon February 17, 2020 09:53 AM
    Hi Team,
    Any advise to my question ?​

    ------------------------------
    Harshavardhan Peddireddy
    ------------------------------



  • 3.  RE: IBM ITX for EDI File conversion

    Posted Tue February 18, 2020 07:51 AM
    Hi Harsha,

    Does it need to be done by a separate Data Masking Tool.  Can the rules be set up in a Sterling Map instead?  I would think that would be the easiest approach - have an EDI --> EDI map with Extended Rules that undertake the data masking.

    Regards
    Vivek Mittal
    Archisage Pty Ltd
    Australia

    ------------------------------
    Vivek Mittal
    ------------------------------



  • 4.  RE: IBM ITX for EDI File conversion

    Posted Tue February 18, 2020 10:10 AM
    ​Hi Vivek,
    Thanks for your kind reply.
    As long as it masks all the sensitive fields ( Name, Address, SSN, Phone, Health care records ) I am good to use short paths.
    Please advise.
    Thank you

    ------------------------------
    Harshavardhan Peddireddy
    ------------------------------



  • 5.  RE: IBM ITX for EDI File conversion

    Posted Tue February 18, 2020 09:04 AM
      |   view attached
    I have an ITX map which I use to sanitise data.  You're welcome to try it with your EDI file.

    ------------------------------
    __________________________________________________
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Attachment(s)

    zip
    Sanitise.zip   3K 1 version


  • 6.  RE: IBM ITX for EDI File conversion

    Posted Mon February 24, 2020 11:57 AM
    Yes, ITX with the Pack for Healthcare EDI is a great way to mask PII and PHI and transform HIPAA EDI data.  You could do this as either one or two transformation steps. 

    If your goal is to start with an EDI file and end up with an EDI file where the only change is the masking of some data then a pass-thru type map will be easiest.  Earlier in this thread Paul Brett posted a simple example of one such map.  Variants of such a map can include rules that are as complex as you need them to be.

    If your goal is to retain intermediary CSV files than it is also possible to map from the EDI to the CSV then to the new EDI.  Your approach will be shaped by your requirements.  But yes, ITX is the right tool for such data masking and transformation, and the HIPAA pack provides artifacts to get you started.

    ------------------------------
    Stephanie Fetzer
    ------------------------------