In recent years, more and more compactifications have emerged whose existence depends crucially on the presence of internal sources to the supergravity fields, such as D-branes and orientifold planes. I will review some solutions of this type in various dimensions, and illustrate their applications to holography and potentially to the problem of finding de Sitter solutions.