@Yaswantha001, Since you have the Web Infrastructure platform installed, you should also have SASWebInfrastructureDataBaseJDBCDrivers and SASWebInfrastructurePlatformDataServer. I believe they contain all that you need. If manually standing up a PostgreSQL server is not your cup of tea, then you can use the client software, especially pgAdmin3.exe to add a database and login. Once done, you can use SAS Management Console to setup your metadata. You need to add a SAS Client Connection for your database to the existing server and then create SAS Library metadata to read and write through. Of course you must have installed SAS/ACCESS to Postgres. SAS MC has some very good help pages. A couple of tips for the Library: a) in the advanced options Output tab, set "Preserve column names as in the DBMS to 'No'; b) on the Input/Output tab set Preserve DBMS table names to 'No'; c) the Database Schema Name is generally 'public'.
To setup access to the database, the easy path is to create a database user group in SAS MC. Add a login Account) to that group using the same Authentication Domain as in your SAS Client Connection. Add the name of the login you created for the database and the password. Make the SAS Administrators group as a member of your group for metadata access. Add any other external users as defined in metadata as member if they need to have access to the data.
One last bit is that you can right click on your library in the Data Library Manager plug in for SAS MC and have it display the libname statement you need to connect to your database. Quite handy.
This is absolutely the short course. Check with SAS Technical Support for any documentation you can access that may help you with this.
... View more