This content has been marked as final. Show 8 replies
Bringing up my question again. ?:|
Have you tried adding a data server in topology?
How can I add it to Topology?
Bringing up my question again.
I'll appreciate anyone's reply.
Still having this problem.
Edited by: firstname.lastname@example.org on Mar 29, 2009 6:46 PM
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..
Randy1 person found this helpful
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.
which one should I choose? (JDBC3 or JDBC4)?
and where should I place this postgresql-9.0-801.jdbc4.jar?
I get +Could not load JDBC driver class [org.postgresql.Driver]+
when I test the Data server