Read file from outside the network using Data services

[Former Member]

Hi All,

can someone please help me,  we need to read the files from outside the network and load in Database using BODS?

can this be done using SFTP ? if yes, are there any windows scripts available to do this ?

Thanks for your help !

[former_member187605 · Accepted solution]

You can use any transfer program you want to access a remote file driectly from within a DS data flow. Set the Custom transfer program property of your input file to Yes and then specify the Custom Transfer properties:

[Former Member · Accepted solution]

Thanks Brian and Dirk.

This is nice.

[patty_marco · Accepted solution]

DS 4.2 SP5 has a new feature for setting up FTP, SFTP, and so on. Please look at the What's New Guide for information about file location objects (http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_whats_new_en.pdf ) section 2.2.

[Former Member]

from which file you want to add data ?I mean from XML,Excel or CSV

Thanks,
Swapnil

[Former Member]

Yes, you could use a Windows batch script to import a file via FTP/SFTP (either through Windows Task Scheduler or inside your DS Job), then use DS to read the file and load the data in a table.

The content of the script will vary depending on your specific situation (number/type of files being retrieved, file archiving, error control, etc.), but you can probably find examples out on the web.