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

Data Warehouse FTP

  • November 26, 2024
  • 1 reply
  • 1516 views

Hi,

 

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

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
    skatofiabahAuthor
    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?

    skatofiabah
    skatofiabahAuthor
    November 27, 2024

    You can access FTP through any client side FTP tool, I like Filezilla (you only need the "client", not the "server" version), and you can log into FTP using the same credentials that you used in your Data Warehouse Export.

     

    As others have said, FTP is legacy, but I still use it for quick and easy one time pulls... if you are creating a repeating process you might want to set up like a server to receive the files (but this you would have to work with your team to choose what fits best into your organization).

     

    As to your question about emailing the CSV to yourself... the answer is yes, but with caveats....  Data Warehouse exports can be large, and emails will reject files if they are too large...  So you might be able to email the files to yourself, if they are small enough... but if not, the export will fail with a "file too large" error.


    Hi @jennifer_dungan,

     

    If FTP is legacy, what is used now? I don't know if our organization will allow FileZilla.

    Terms & ConditionsAccessibility statement

    Loading footer...