SQL Data Warehouse from Sage 100 2018 ProvideX tables

SOLVED

I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver.
We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day.

Pulling FULL tables dumps is straight forward. Where I am hung up on is the delta tables. Restrict by update dates, record creation date, tran date, etc. With using the linked server, I have not had the best success including a where clause in the linked server statement using the ProvideX ODBC driver.

Thank you all,

Tony Callin

TLDR: Looking for what others have done to accomplish a SQL Data Warehouse from Sage100 PX tables.