cancel
Showing results for 
Search instead for 
Did you mean: 

BI to FTP server connection

Former Member
0 Kudos
537

Hi,

How to connect the seperate FTP server to BI system, my requirement is to access the seperate the FTP server from the BI system to upload files from the FTP server. End user will access the FTP server and he will put all the file there which are need to be uploaded to BI system.

To connect the seperate FTP server how to maintain the connection parameters from BI side, can it be possible through any Function module in the run time if we define the user parameters in the function module.

Please brief me the process, Step by Step (if possible)

Regards,

Prabhakar.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member181964
Active Contributor
0 Kudos

Hi,

Practically..

I'm working in the Reverse way.....

1. Dump the Files from FTP server to Application server of BW (AL11), I think you may have some function Modules in BW to load the data from FTP to App.Server.

or

You can run some batch jobs from FTP server to BW Server to load the file from FTP to BW application server.

2. Load data from ApplServer to DataTargets.

See in the reverseway I tested Yesterday only it is working fine, my requirement is..

1.Run the report in back ground and dump cvs file in Application server. (one path is maintained)

2.I need to keep the files from BW-app server to FTP (separate server, in tis I have one path).

3. we create a user id and password in BW (to access UNIX OS i.e. from BW application server).

4. Then written some batch program just 3 to 7 lines of code in FTP server and called that file, then the file is available in FTP server.

Note: You need your BW-Unix Administraors help, and FTP administraors help to do it.

Thanks

Reddy

Former Member
0 Kudos

Hi Prabhakar,

You can find this yseful.

Regards

Karthik