We are a small shop and want to run, for data warehousing/reporting, 2016 standard across two boxes, a "db" server and an "etl" server. The db server would just have db engine installed and the etl server would have SSDT/SSIS/SSAS/SSRS.
Is this possible without installing an instance on both servers?
If we could get away with only installing an instance on the db server, where we also would publish ssis packages to the SSISDB and schedule them in SSA, what considerations do we need to take into account regarding the third party tools we need in SSDT (zappysys, zip, winscp, etc) and have installed on the etl server? If these tools are installed on the etl sever but ssis packages are deployed to the db server, how do we ensure they can be accessed by the published packages?
Any advice/direction/correction are much appreciated.