That transducer is not compatible with the Humminbird 1197 to my understanding.
According to AirMar the P66-DT-HB is compatible with the 800, 900 and 1100 series. It is the P66 with
a Humminbird connector.
With this bit of information does that mean that I will be able to splice the cable and have it work?
Also if anyone has an old transducer that is not working I need the cable from it if possible.
It may be compatible with those series, but not for Side Imaging. The 1197 is a Side Imaging 1100 series. Do you intend to set the connected transducer to Dual Beam and not have Side Imaging or do you intend to use the transducer splitter cable and run SI transducer also?
The 1157 is a 1100 series also, but it is 2D only.
If it has a Humminbird connection, you don't need to splice any cable to it if the connection is the Humminbird 7 pin plug.
Edit, I looked up the #9 connector and it is the 7 pin plug.