I also use Adobe Sitacatalyst, ReportBuilder and Datawarehouse.
As far as I know while from Data Warehouse is possible to schedule report to FTP the same is not possible with ReportBuilder that works only at client level (as it is an Excel add-on).
Please let me know if I am wrong about this point
Concerning the connection between Tableau Server and remote datasources it seems that whatever is the data source , tableu desktop is always involved in the update process.
Data source (local file or ftp) > Tableau Desktop (local pc) > Tableau Server (cloud)
If this schema is correct the direct connection Data source > Tableau Server seems not possible unless you map a remote disk as local.
A possible solution was discussed in this post:can't(Tableau) we connect to FTP server with authenticated login credentials?
I have noticed now that your post is old so please let me know if you have already found a solution.
many thanks for the link provided.
The step-by-step guide in your blog is nothing short of brilliant.
I will apply it asap to my projects.
The only doubt I have is the step "Pushing to Tableau" in fact I do not see any login information in the Macro.
How do Tableau recognize that the pushing request is coming from a certain authanticated user?
May be I miss something ?