Hi there: We have Viya 3.5 and we read tables from Oracle in 2 steps: Create a caslib to Oracle SAS Data Connector to Oracle We tested 2 ways: Use a proc cas; Query CAS Tables Using the FedSQL.execDirect Action Use a proc fedsql sseref=casauto; About the time (20min)... check the query execution plan (enable iptrace) and the logs (enable message level) to make sure the data is not going to the controller but to the worker nodes directly. If possible, use an explicit pass-through and compare the time (assuming no cross-datasources join). Best, Javier
... View more