This content has been marked as final. Show 8 replies
For adding a new Dataserver under postgresql :-
Go to the toplogy -> technology -> postgressql -
rigth click and add new dataserver (if postgresql technology is hidden , please unhide the unused technologies).
Also some questions regarding postgresql:-
I am using PostgreSql for the first time.
I tried to create master repository in Postgresql.
for me the Driver connection testing is successful.
but when i click create master repository its not performing any action.
What are the server settings we need to configure in postgresql (i mean tcp/ip, authentication etc...)
I am using Windows Vista
Thanks in Advance..
Take a look at this viewlet I built defining a new PostgreSQL data server, I hope it helps you.
[ODI PostgreSQL Data Server Viewlet (no voice)|https://s3.amazonaws.com/Ora/postgresqldataserver.swf]
[ODI PostgreSQL Data Server Video (with voice)|https://s3.amazonaws.com/Ora/PostgreSQLDataServerVideo.swf]
Edited by: CTS on Mar 30, 2009 7:40 PM
That was helpful, But I already added Postgres in Topology.
My problem now is how to create a Master Repository in Postgres?
Here are my settings;
Driver : org.postgresql.Driver
URL : jdbc:postgresql://localhost:5432/mydatabase
User : username
Password : password
I select PostgreSQL in the Technology, badluck I receives this error message.
Error Detected during Repository Installation com.sunopsis.tools.core.exception.SnpsRuntimeException: com.sunopsis.tools.core.exception.SnpsRuntimeException: Unable to find the XML file corresponding to your technology.
Please someone help me on this.