topic Getting all hive tables as source to perform ETL in SAS VIYA in SAS Studio

Getting all hive tables as source to perform ETL in SAS VIYA

Rahul_SAS — Tue, 16 Oct 2018 20:46:21 GMT

Hi Experts,

This query is regarding performing ETL in SAS VIYA plateform.

I need to perform ETL in SAS VIYA(SAS Studio) using all the hive tables. Can I establish a connection between SAS VIYA and HIVE to use source tables which are physically not available in SAS VIYA.

Thanks

Re: Getting all hive tables as source to perform ETL in SAS VIYA

LinusH — Wed, 17 Oct 2018 06:14:09 GMT

Yes.
But you need a license for it (Data Connector).

Re: Getting all hive tables as source to perform ETL in SAS VIYA

Rahul_SAS — Wed, 17 Oct 2018 06:16:19 GMT

I have data connector, could you please explain the process. It will be great help for me.

-Thanks