Can a Smart Contract Connect Off-chain Data With On-chain Data?

I have an innovative idea in mind and cannot seem to find the right information to see if technologically, it is feasible. I understand data oracles can communicate off-chain data with on-chain data, but can this work in a smart contract?