This old thread seems like it might be a good place to start for connection issues:
The 4 pin ribbon cable is good news. If you’re a bit of a hardware hacker you may be able to confirm that it’s a USB camera and apply the ‘repurposed USB laptop camera’ strategy to run the camera.