Unzip-Zip files and Send wiht FTP with Data Services

dataservices job design
1

Hi guys,
i have a project to do and i never done it before so i m asking help how to do it.
i must do these steps :

  1. i ll recieve a zipped file(encrypted) from an instance to my job server via ftp
  2. i need to unzip this file (btw file is *.csv)
  3. i need to write this *.csv file to database (this part is easy :))
  4. do stuff in database
  5. Select something from database and write it in *.csv file to job server location
  6. zip this last *.csv file and send it to that instance via ftp

i try o do zip-unzip file with java and call it from Data Services but i m not a master on java :slight_smile:

thanks for any idea…

Denso (BOB member since 2010-07-22)

2

You need to have winzip-unzip program installed on BODI/DS job server. Then, you will specify the complete path of this program and the files, which needs to be unzip/zip.

Some thing like :

exec('cmd','C:\\programfiles\\winzip.exe filename.zip',8)

You may want to double check the syntax…but it will be very similar to the above.

Ftp part is quite easy, you can write some batch script for the same. There are various script on the forum…

And remember BODI/DS is just mode for execution of third party programs…if your actual program itself is not working as expected, don’t blame good old BODI/DS for that… :smiley:

Hope this gets you started!

data_guy :us: (BOB member since 2006-08-19)

3

and once you have zipped the files you can ask the network guys to apply a n/w rule for file transfer or create a WF using pivot - reverse pivot to transfer the files.

Cheers,
Shazin

Shazin :india: (BOB member since 2011-07-19)

4

The Hard part of this project is zip or unzip files with password.
now i m trying to do whole part in java then call it from batch file or directly from DS.

thanks for advice…

Denso (BOB member since 2010-07-22)

5

Shazin,

Please elaborate, how can use Pivot-Reverse Pivot transformation to transfer the files?

data_guy :us: (BOB member since 2006-08-19)