# Encrypted \*.dat file

**URL:** <https://forum.cloverdx.com/t/encrypted-dat-file/209>\
**Category:** CloverDX Platform\
**Created:** [August 27, 2007, 12:00am UTC](https://forum.cloverdx.com/t/encrypted-dat-file/209 "2007-08-27T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![maniatindia](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@maniatindia](https://forum.cloverdx.com/u/maniatindia)\
**Post date:** [August 27, 2007, 12:00am UTC](https://forum.cloverdx.com/t/encrypted-dat-file/209/1 "2007-08-27T00:00:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [August 27, 2007, 1:02pm UTC](https://forum.cloverdx.com/t/encrypted-dat-file/209/2 "2007-08-27T13:02:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![maniatindia](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@maniatindia](https://forum.cloverdx.com/u/maniatindia)\
**Post date:** [October 3, 2007, 3:18pm UTC](https://forum.cloverdx.com/t/encrypted-dat-file/209/3 "2007-10-03T15:18:41Z")

</div>

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.