Welcome to the forum!
You can't route a cable television signal through the Onkyo (nor any receiver that I know of). So, you'll want to do what you mentioned - connect the cable television feed directly to the TV, and then connect the optical audio output from the television to the receiver. That way, you can listen to the TV audio through your receiver.