How to upload Tables from Netezza to SAS Viya?

[taninu]

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,

[LinusH]

You could use the Cloud Analytic Services Table Loader transformation.

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

https://documentation.sas.com/doc/en/etlug/4.905/p0k42wyoble1hkn17mumd71syeej.htm