Architecting, installing and maintaining your SAS environment

Import Data -> Server -> Oracle ?

Reply
Occasional Contributor
Posts: 9

Import Data -> Server -> Oracle ?

   Hi All ,

I am very new for SAS., right now i have installed a new server and trying to access my oracle database via SASVisualAnalyticHub.

But i really not able to find from which page i have to give the Oracle Credentials to download or pull the tables from our oracle server.

I have already installed Oracle Client  bit in my server and all the oracle database are in bit only

Now from this page i am trying to load the db after giving lasradm credentials   http://das.acs.ea:7980/SASVisualAnalyticsExplorer/index.jsp           

right side of Open Data Source page there is a option for import all the formats except for oracle , that is in the Import Data page under server i could not found any oracle except "SAS Data Set'.

Kindly some one explain me why the in the Server Page 'Oracle" is not showing !?

Expecting your immediate reply

Regards

Hamid


DATASOURCE.PNG
Super User
Posts: 5,437

Re: Import Data -> Server -> Oracle ?

Posted in reply to abdulh_Brit

First, do you have a license for, and installed SAS/ACCESS to Oracle?

Data never sleeps
Occasional Contributor
Posts: 9

Re: Import Data -> Server -> Oracle ?

Yes we have the licence for this product - " SAS Access to Oracle "


FYI, this is the first time i am installing SAS Visual Analytic. so i am fear did i made any mistake in configuration,..,i can import excel and other format files but except Oracle !!



Help me to identify this issue and guide me to get a solution for the same.


Regards

Hamid Smiley Sad



Occasional Contributor
Posts: 9

Re: Import Data -> Server -> Oracle ?

Hi,

Yes we having Licence for the SAS/Access to Oracle.

Kindly guide me to solve this issue.

Regards,

Hamid

Ask a Question
Discussion stats
  • 3 replies
  • 583 views
  • 0 likes
  • 2 in conversation