These are not distinct things, but rather different side of the same notion.
More systematically dipole, quadrupole and other moments arise when performing Multipole expansion of a charge distribution. The dipole moment is the lowest term in this expansion, provided that the overall distribution is charge neutral.
Retaking the terminology introduced in the Q., classical dipole is but the simplest realization of a distribution that has a dipole moment and no other moments. In classical electromagnetism one often speaks of dipole radiation or dipole antenna, which is but a small piece of wire with a current oscillating with it, whose size is negligible compared to the distances to which the EM wave propagates - the only important feature here is the cylindrical symmetry due to the direction of the wire (dipole axis.)
In atom the electron wave function affected by electromagnetic radiation (and described by time-dependent Schrödinger equation) can be seen as a time-dependent charge density $|\psi(x,t)|$, and performing multipole expansion naturally leads to describing its interaction with EM field as that of a dipole.
If we limit the discussion to only two atomic levels - often referred to as the 'ground state' and the 'excited state' - we can expand this wave function in terms of the eigenstates (i.e., in the basis provided by the solutions of the time-independent Schrödinger equation):
$$
\psi(x,t) = c_g(t) \phi_g(x) + c_e(t) \phi_e(x)
$$
See also this post for the discussion of the dipole approximation for light-atom interaction (I do not reproduce it here, but it makes the logical continuation of this answer.)