topic Re: How to access Oracle DB tables in SAS Enterpeise Miner for Analysis in SAS Data Science

How to access Oracle DB tables in SAS Enterpeise Miner for Analysis

Ram4sas — Fri, 08 Jan 2016 03:44:21 GMT

Hi All,

I am new to SAS Enterprise Miner tool and need to work on EM 13.1. I want to access Oracle DB tables for Mining Analysis in SAS EM.

Can I access the Oracle library tables in SAS EM which I can see in SAS EG library list(SAS Admin Created for EG Access)? or

Do I need to create New Oracle Library in SAS EM tools?

Thanks,

Ram.

Re: How to access Oracle DB tables in SAS Enterpeise Miner for Analysis

M_Maldonado — Fri, 08 Jan 2016 11:21:37 GMT

I don't think that you can access oracle tables directly from Enterprise Miner.

A quick alternative would be to use Enterprise Guide to create a SAS data set you can use in Enterprise Miner to create predictive models.

The good news is that with SAS Scoring Accelerator you can deploy your model directly into Oracle if that is better for your business needs.

Good luck!

Re: How to access Oracle DB tables in SAS Enterpeise Miner for Analysis

Ram4sas — Fri, 08 Jan 2016 17:54:56 GMT

Hi MiguelMaldonado,

Thank you for yur reply. as you said that with "SAS Scoring Accelerator that i can deploy the model into Oracle".

Is SAS Scoring Accelerator seperate SAS Product with seperate License? or is this come with SAS EMiner?

If it some with SAS E Miner Prodcuct how to deply the model into oracle directly?

Thank you in advance.

Thanks,

Ram

Re: How to access Oracle DB tables in SAS Enterpeise Miner for Analysis

SASKiwi — Mon, 11 Jan 2016 03:10:46 GMT

According to the EM help, Oracle tables can be used as long as they are defined as pre-assigned data libraries in SAS metadata and each of the required tables is registered in SAS metadata. These tasks are usually done in SAS Management Console.

Re: How to access Oracle DB tables in SAS Enterpeise Miner for Analysis

Ram4sas — Thu, 14 Jan 2016 22:00:23 GMT

Hi All, I can see the Oracle DB Library tables under SAS Folder path,but until unless I create library as part of the project after project got created, we can not select the particular tables as source for data mining. Thanks, Ram