Okay I did a camera track. Matchmoved in maya, exported to an FBX
imported the fbx into, Everything looks good. Just the image sequence doesn't play in viewport or does not render. Not sure, read some threads on this about using COP file node to read it and I was able to get it into viewport but it won't render so not sure what the hell I'm doing wrong.

Any suggestions.

Houdini, including COPs can only read a sequence of image files, not a movie. So you need convert your AVI / MP4 or whatever into a sequence: image.001.jpg, image.002.jpg and so on. A video editor such as Sony Vegas allows you to render to an image sequence, or you can use ffmpeg to covert your file into a image sequence. You can then use e.g. a file node in COPs with the filename set to image.$F3.jpg for example to bring in the successive frames.