As long as it matches the computer interface it should work.
Most new systems should use SATA dvd drives, while older systems tend to have IDE.
The cables are easy to spot. If the cable is flat and has a very wide plug it is IDE. If it is small plug and cable, It is SATA.