I would like to pull data from SharePoint On-Premise (Custom List Data) to SharePoint Online. When searched on Internet most of the posts are suggesting like SQL Azure Connectivity between SharePoint On-Premise and SharePoint Online. I would like to know how to achieve this without using Azure as an interface. Is it Possible? If yes, how to achieve this task?
Since its pulling the list data and not replicating, you can configure Hybrid federated search between the environments and create a result source specific to on-premises. Use this result source in Content search or Search result WebPart query and show the items.