Tracked video not showing in the 3D viewport in rendered mode
To have a transparent background in the render layer, enable Film  Transparent.
I checked into the compositor and transparent render would have the checker background as shown here:


(For 2.7x)