Hi I need to do an ETL work from an encrypted *.dat file to a standard DB. Do any one have an idea on how to go with the decryption of encrypted *.dat file.
I am able to transfer data from flat file to DB, but in this case its a encrypted *.dat file, is there any one who can provide me with input, for decryption of dat file. what component can be used for this case.
The fundamental question is, how does the “encrypted” file looks like ?
What algorithm was/is used to encrypt the file and how can be decrypted …
Is it:
a) file where some of the fields are encrypted ? Then you might write your
own reformat class (in Java) which takes value of the encrypted field and decrypt it
b) the whole file is encrypted - then you first need to decrypt it using some algorithm - you may use SystemExecute component to run system command which takes the file and decrypts it. Then you have two options how to read it
I) - do this step in one phase, create a file and then read the file in next phase of a graph
ii) - send the result of such decrypting command to STDOUT and use the option of SystemExecute which allows you to directly parse result (STDOUT) from system command and just connect output port of the component and do whatever processing you need.
If above mentioned does not solve your problem, then consider describing it a bit more.
David.
Thank you, i was able to do that.
I dont have any prior experience with ETL. I felt a little complexity with this activity, though was comfortable after a little time. do all the ETL tools involves this much complexity.