The ODBC connector unfortunately doesnt allow direct query which is the mode im after, hence im in this spot to what capability the IRIS connector has. Hopefully their development team expand the connectors capability (I have a TRC logged internally as well). Good recommendation on the view - unsure if our hosted service allows this permissions but ill look into it more.