How to load Flat file from external server in SAP BODS

[former_member383962]

Hello Experts,

I have .CSV file in one server example (xxx.xxx.xx.10) and my SAP BODS Job server is xxx.xxx.xx.20. How to get the data of that CSV file in the SAP BODS.

Note: File residing server is different from the BODS job server. And that the file is updated automatically for every 2 minutes

[former_member231328]

Great question! However it's not clear on the method of file transfer you have available.

[akhileshkiran]

Hi Kabilarasan R,

If you have a file on a server \\xx.xx.xx.xxx\SomeFolderPath\Filename.ext. The directory path need have a full permissions to read and write.

File Path : \\xx.xx.xx.xxx\SomeFolderPath\Filename.ext

Then you can use the path directly in the File Formats or else you can create a Substitution Parameter. For the path and provide the parameter in your file formats path. Here my job server is running on the diffrent server.

As mentioned by the Bon Omaiso, I request you to please go through the technical manual for the more detail explanation on the file formats extractions.

Regards,

Akhilesh Kiran N.

[former_member208402]

Hello Kabilarasan,

use file location object. Please refer below link on how to create file location object.

https://blogs.sap.com/2016/04/14/use-file-location-object-to-readimport-and-writeexport-files-in-ftp...

And then you can also use function "copy_from_remote_system"

This function used to transfer files from remote system to your local system. syntax is below

---copy_from_remote_system(“<file_location_object name>”, “<remote_file_name>”)---

[former_member231328]

Hey Kabilarasan,

With this scenario, you want to utilize the File location object, essentially when working with flat files (csv, xml, json) as long as the job server file system has access to the remote system then you will have no problem with loading to flat files.

The only question remaining is the method of file transfer? File location objects supports SFTP(SSH), FTP and local (mounting file system).

For more details on File location object capabilities read the chapter located in the Designer guide:

SAP Data Services Designer Guide - File location objects(new tab)

regards

Bon

SAP Product Support

[former_member383962]

Hi @Bonbon.omaiso,

As per your guidance, I created File Location objects. But I don't know how to get flat file from that location. can you provide the brief details.

[former_member559864]

Create Flat File format, using this File Location and provide file name there.