How to upload Tables from Netezza to SAS Viya?

taninu — Tue, 28 Sep 2021 03:23:22 GMT

Hi,

My company just upgrade from SAS VA to SAS Viya.

My DBMS is IBM Netezza.

In SAS VA, I create a custom transformation in SAS DI by using proc metalib to upload data from Netezza tables to SAS VA.

proc metalib;
omr(library="&VA_MD_LNAM.");
update_rule=(delete);
select=(&VA_FILE);
folder="&VA_MD_LLOC.";
report=(type=detail);
run;

But if changed to be SAS VIYA. What is the best way to Automate Upload data from Netezza to SAS Viya?

Can we upload data from Netezza directly to SAS Viya. Or need to extract to be .csv file before upload to SAS Viya?

Thanks,

Re: How to upload Tables from Netezza to SAS Viya?

LinusH — Tue, 28 Sep 2021 11:09:09 GMT

You could use the Cloud Analytic Services Table Loader transformation.

It can load data either via your Workspace server, or via CASLIBS.