Data Warehouse FTP | Community
Skip to main content
skatofiabah
Level 5
November 26, 2024
Solved

Data Warehouse FTP

  • November 26, 2024
  • 1 reply
  • 1527 views

Hi,

 

We just ran a Data Warehouse Request and FTP. It says it's CSV but how do we access it?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by MandyGeorge

That will depend on the destination that you set up. When you created the data warehouse job, one of the pages asked for an account and location. 

 

Under report destination it asks for an account and location. The account is the type of destination that you're going to send it to. It sounds like you're using an FTP. It should ask you for the account properties. Then you need to set up the location, this will be the exact spot where it will send the file. 

 

Just a note, FTP for data warehouse is considered legacy, although you can still use it. What is it that you're planning to do with the file? If it's a one time drop, you could have it sent to your email (or anyone's email). 

1 reply

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
November 26, 2024

That will depend on the destination that you set up. When you created the data warehouse job, one of the pages asked for an account and location. 

 

Under report destination it asks for an account and location. The account is the type of destination that you're going to send it to. It sounds like you're using an FTP. It should ask you for the account properties. Then you need to set up the location, this will be the exact spot where it will send the file. 

 

Just a note, FTP for data warehouse is considered legacy, although you can still use it. What is it that you're planning to do with the file? If it's a one time drop, you could have it sent to your email (or anyone's email). 

skatofiabah
Level 5
November 26, 2024

Hi @mandygeorge,

 

How do you open an FTP with a location path and port? Also, can you send a Data Warehouse Request to your email to open a CSV file via email?

Level 2
November 26, 2024

Not sure if this helps, but we used Azure Synapse pipeline to copy data from the FTP server with path and port, and stored data into Azure data lake. But then this become unavailable since 11/05/2024 because the data warehouse is deprecated. so now we are trying to look for new options.