topic Re: SAS Swat - Load Data to CAS from Database Directly in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-Swat-Load-Data-to-CAS-from-Database-Directly/m-p/766133#M242762 <P>Hello<BR />You are using a long route to load data.<BR />Have a look at the following if you want a faster data load.&nbsp;<BR /><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0ujmhdp3hha0zn1poqbtkdnrj3y.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0ujmhdp3hha0zn1poqbtkdnrj3y.htm</A></P> <P><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/pgmdiff/p04wmq9r1z55s3n1s08fs102nb43.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/pgmdiff/p04wmq9r1z55s3n1s08fs102nb43.htm</A>&nbsp;</P> <P>&nbsp;</P> Sun, 05 Sep 2021 17:28:16 GMT Sajid01 2021-09-05T17:28:16Z SAS Swat - Load Data to CAS from Database Directly https://communities.sas.com/t5/SAS-Programming/SAS-Swat-Load-Data-to-CAS-from-Database-Directly/m-p/764426#M242139 <P>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.</P><P>&nbsp;</P><P>I would like to pull the data from database to the CAS directly without stopping by my machine. Do I achive that and how?</P> Fri, 27 Aug 2021 10:06:11 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Swat-Load-Data-to-CAS-from-Database-Directly/m-p/764426#M242139 mukaddes 2021-08-27T10:06:11Z Re: SAS Swat - Load Data to CAS from Database Directly https://communities.sas.com/t5/SAS-Programming/SAS-Swat-Load-Data-to-CAS-from-Database-Directly/m-p/766133#M242762 <P>Hello<BR />You are using a long route to load data.<BR />Have a look at the following if you want a faster data load.&nbsp;<BR /><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0ujmhdp3hha0zn1poqbtkdnrj3y.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0ujmhdp3hha0zn1poqbtkdnrj3y.htm</A></P> <P><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/pgmdiff/p04wmq9r1z55s3n1s08fs102nb43.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/pgmdiff/p04wmq9r1z55s3n1s08fs102nb43.htm</A>&nbsp;</P> <P>&nbsp;</P> Sun, 05 Sep 2021 17:28:16 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Swat-Load-Data-to-CAS-from-Database-Directly/m-p/766133#M242762 Sajid01 2021-09-05T17:28:16Z