SAS Swat - Load Data to CAS from Database Directly

[mukaddes]

Hi, I would like to load a dataset to CAS Server from Oracle Database in Python with SAS Swat. When I use 'read_sql_query' cas action a table is pulled from database to my local machine in the form of a pandas.dataframe and then uploaded to CAS. So, this process is too slow for a large data.

I would like to pull the data from database to the CAS directly without stopping by my machine. Do I achive that and how?

[Sajid01]

Hello
You are using a long route to load data.
Have a look at the following if you want a faster data load. 
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0ujmhdp3hha0zn1poqbtkdnrj3y.htm

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/pgmdiff/p04wmq9r1z55s3n1s08fs102nb43.htm