https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404679#M12315 Implicit/explicit SQL pass through from SQL is possible. Need some care when designing DI Studio jobs. <BR />Other options are available but requires more licenses, like using SAS Grid on Hadoop. Tue, 17 Oct 2017 06:27:40 GMT LinusH 2017-10-17T06:27:40Z https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404374#M12307 <P>Can we store the SAS datasets and access the SAS datasets in cloudera or the hortonworks using the SAS DI ?</P><P>Is it can be accessed just by using the LIBNAME statements if proper connection is already established by refering the location ?</P><P>Can someone please provide any details around this if You worked on SAS with cloudera or hortonworks and how are You using them</P><P>&nbsp;</P> Mon, 16 Oct 2017 06:20:02 GMT https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404374#M12307 JoshuaHarris 2017-10-16T06:20:02Z https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404375#M12308 Yes<BR />Yes<BR />What is the status of your configuration at this point? If you have a working connection yes, define a library and then you go.<BR />Otherwise, go to the install/configuration doc on support.sas.com for details. Mon, 16 Oct 2017 06:25:03 GMT https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404375#M12308 LinusH 2017-10-16T06:25:03Z https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404518#M12314 Thanks. Configuration is yet to be started.<BR />Trying to get some ideas about the feasibility to set it up.<BR />One more question please..<BR />Can we use these cloud environment to run the SAS DI jobs itself like how am currently running the codes in unix or mainframe?<BR />If possible, please let me know the cloud environment which we good to use Mon, 16 Oct 2017 16:21:35 GMT https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404518#M12314 JoshuaHarris 2017-10-16T16:21:35Z https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404679#M12315 Implicit/explicit SQL pass through from SQL is possible. Need some care when designing DI Studio jobs. <BR />Other options are available but requires more licenses, like using SAS Grid on Hadoop. Tue, 17 Oct 2017 06:27:40 GMT https://communities.sas.com/t5/SAS-Data-Management/store-and-access-SAS-datasets-in-cloudera-Hortonworks-using-SAS/m-p/404679#M12315 LinusH 2017-10-17T06:27:40Z